Re: Upgrade to PHP5 and having issues with mysql

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. -- ........................................................... SwarmBuy.com - http://www.swarmbuy.com Leveraging the buying power of the masses! ...........................................................