php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #12831 4.0.6 won't work with mySQL (built in support or mySQL's support)
Submitted: 2001-08-18 23:23 UTC Modified: 2001-08-19 14:43 UTC
From: mfurdyk at takingitglobal dot org Assigned:
Status: Not a bug Package: MySQL related
PHP Version: 4.0.6 OS: Linux 2.214
Private report: No CVE-ID: None
View Developer Edit
 [2001-08-18 23:23 UTC] mfurdyk at takingitglobal dot org 
Here's my first configure:

./configure --with-mysql --with-apxs=/usr/local/apache/bin/apxs --with-gd --with-sablot --with-expat --with-jpeg-dir=/usr/local/bin --with-imap

It stops during 'make' with this error:
/bin/sh /usr/local/src/php-4.0.6/libtool --silent --mode=link gcc  -I. -I/usr/local/src/php-4.0.6/ -I/usr/local/src/php-4.0.6/main -I/usr/local/src/php-4.0.6 -I/usr/local/apache/include -I/usr/local/src/php-4.0.6/Zend -I/usr/local/include -I/usr/local/src/php-4.0.6/ext/mysql/libmysql -I/usr/local/src/php-4.0.6/ext/xml/expat/xmltok -I/usr/local/src/php-4.0.6/ext/xml/expat/xmlparse -I/usr/local/src/php-4.0.6/TSRM  -DLINUX=22 -DUSE_HSREGEX -DUSE_EXPAT -DSUPPORT_UTF8 -DXML_BYTE_ORDER=12 -g -O2   -o libphp4.la -rpath /usr/local/src/php-4.0.6/libs -avoid-version -L/usr/local/bin/lib -L/usr/local/lib  -R /usr/local/bin/lib -R /usr/local/lib stub.lo  Zend/libZend.la sapi/apache/libsapi.la main/libmain.la regex/libregex.la ext/gd/libgd.la ext/imap/libimap.la ext/mysql/libmysql.la ext/pcre/libpcre.la ext/posix/libposix.la ext/sablot/libsablot.la ext/session/libsession.la ext/standard/libstandard.la ext/xml/libxml.la TSRM/libtsrm.la -lpam -lc-client -ldl -lexpat -lsablot -lpam -lgd -ljpeg -lcrypt -lresolv -lm -ldl -lnsl -lresolv
/usr/bin/ld: cannot open -lmysqlclient: No such file or directory
collect2: ld returned 1 exit status
make[1]: *** [libphp4.la] Error 1

If I instead configure specifying mySQL's Path:

./configure --with-mysql=/usr/local/mysql --with-apxs=/usr/local/apache/bin/apxs --with-gd --with-sablot --with-expat --with-jpeg-dir=/usr/local/bin --with-imap

It doesn't hiccup on the first error, but instead stops during apache restart with this error:
Syntax error on line 118 of /usr/local/apache/conf/httpd.conf:
Cannot load /usr/local/etc/httpd/libexec/libphp4.so into server: /usr/local/etc/httpd/libexec/libphp4.so: undefined symbol: mysql_field_count

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-08-19 03:30 UTC] sniper@php.net 
The first problem, you must have configured PHP before
WITH the path. Otherwise this doesn't make any sense.
Have you tried with fresh sources? ie. delete all the sources and gunzip/untar the source package ??

And what is this: --with-jpeg-dir=/usr/local/bin ???
It should be /usr/local only. Or have you really installed
jpeg libs/headers with that prefix??

You second problem, the external mysql libraries.
You haven't got the path to them in /etc/ld.so.conf , have you? If you don't add it, and run /sbin/ldconfig
and then you should be able to start Apache.

--Jani
 [2001-08-19 14:43 UTC] cynic@php.net 
From: "Michael Furdyk" <mfurdyk@takingitglobal.org>
To: "'Bug Database'" <php-dev@lists.php.net>
Date: Sun, 19 Aug 2001 13:01:31 -0400
Subject: [PHP-DEV] RE: Bug #12831 Updated: 4.0.6 won't work with mySQL (built in support or mySQL's support)

After deleting sources and re-untarring the source, problem #1 was
fixed.

Re: Problem #2, I checked /etc/ld.so.conf, and
/usr/local/mysql/lib/mysql was listed there, so I'm not sure about this.

Thanks so much for your help -- I feel bad, I should have refreshed the
source first. You guys are awesome!

-- Michael
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Mon May 05 23:01:28 2025 UTC