Re: Upgrade to PHP5 and having issues with mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

Here's my configuration setup:
mx02:~:# ./configure --prefix=/usr/local/php5 --with-apxs2=/usr/local/apache-dev/bin/apxs --with-mysql=/usr/local/mysql

Compiles just fine but when I run make I get the errors previously listed. I've run ldconfig, I rebooted the machine...I just don't know what I'm doing wrong here.

Thanks!

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux