Re: Upgrade to PHP5 and having issues with mysql

Robert Cummings wrote:

On Tue, 2008-01-22 at 12:42 -0500, Tom Ray [Lists] wrote:

Robert Cummings wrote:

    
On Mon, 2008-01-21 at 18:01 -0500, Tom Ray [Lists] wrote:
        
Hey-

I'm trying to install PHP5 with mysql support and I keep running into the same problem over and over again. I run the configuration with this: --with-mysql=/usr/local/mysql and without fail I get this every time: ext/mysql/php_mysql.o: In function `zif_mysql_create_db': /home/tech/upgrades/php-5.2.5/ext/mysql/php_mysql.c:1227: undefined reference to `mysql_create_db' ext/mysql/php_mysql.o: In function `zif_mysql_drop_db': /home/tech/upgrades/php-5.2.5/ext/mysql/php_mysql.c:1266: undefined reference to `mysql_drop_db' collect2: ld returned 1 exit status make: *** [sapi/cgi/php-cgi] Error 1 What am I doing wrong here? I'm running mysql 5.0.45 located at /usr/local/mysql which would my my lib directory at /usr/local/mysql/lib I have updated my ld.so.conf file to point to that and I'm still running into issues here. Any thoughts or pointers on what I am doing wrong here? I've never had an issue before but I never had to compile PHP with mysql support since it was always part of the install.

What's your ld.so.conf pointing to for MySQL? It should be pointing to:

    /usr/local/mysql/lib/mysql

And not:

    /usr/local/mysql/lib

Presuming that /usr/local/mysql/ contains the following directories as expected:

    bin/  include/  info/  lib/  libexec/  man/  mysql-test/
    share/  sql-bench/

Cheers, Rob.

ARUGH! I fixed my ld.so.conf file and tried again and I'm still dying in the make process at the same spot. Here's what I have: ld.so.conf mx02:~:# cat /etc/ld.so.conf /usr/kerberos/lib /usr/X11R6/lib /usr/local/ssl/lib /usr/local/opensrs-client/lib /usr/local/lib/perl5/site_perl/5.6.1/i686-linux /usr/local/freetds/lib /usr/lib/libmcrypt/lib /usr/local/mhash0-9-3/lib /usr/local/mysql/lib/mysql Here's my mysql structure: (var softlinks to data) mx02:~:# ls /usr/local/mysql

bin        COPYING  docs               include  INSTALL-BINARY  libexec  mysql-test  scripts  sql-bench      tests
configure  data     EXCEPTIONS-CLIENT  info     lib             man      README      share    support-files  var
    

This looks like the MySQL source tree and not the installation tree. Please provide your ./configure line for building MySQL. Cheers, Rob. This is how I setup mysql: #upgrades: cd mysql tar -zxf mysql-version-x.tar.gz cp -R * /usr/local/mysql cd /usr/local/mysql chown -R mysql:mysql * scripts/mysql_install_db --user=mysql /usr/local/mysql/bin/mysqld_safe & mysql starts/runs just fine. This server has been upgraded from 3.x to 4.x to 5.0.45 currently. Is there something I'm missing?