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 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?

--
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