#19730 [Opn->Fbk]: PHP --with-mysql reports the wrong client API version

ID: 19730 Updated by: sniper@php.net Reported By: shane@sell.com -Status: Open +Status: Feedback Bug Type: Apache related Operating System: debian linux potato PHP Version: 4.2.3 New Comment: If you use '--with-mysql' with php configure, it will use the bundled mysql client libs which are of version 3.23.39 in 4.2.3. You must use the prefix with which you installed the mysql to get the correct libs and headers. Also, make sure you don't have some older mysql libs in your system's default libpath.. Previous Comments: ------------------------------------------------------------------------ [2002-10-03 00:10:52] shane@sell.com I am using the latest sources for apache 1.3.26, mod_ssl 2.8.10, and php-4.2.3. Additionally, I am doing a build from source of MySQL 4.0.4. *Every* time I build a new binary, I rm -rf each of the source directories, tar -zxvf each tarball, and rebuild from scratch. Below are the directives I am using to build apache, in order: cd mod_ssl-2.8.10-1.3.26 ./configure --with-apache=../apache_1.3.26 cd ../apache_1.3.26 ./configure --prefix=/usr/local/apache cd ../php-4.2.3 ./configure --with-apache=/usr/local/src/apache_1.3.26 \ --disable-magic-quotes \ --disable-short-tags \ --disable-debug \ --without-gd \ --enable-url-fopen-wrapper \ --enable-track-vars \ --enable-memory-limit \ --enable-inline-optimization \ --with-config-file-path=/usr/local/php/ini \ --with-mysql \ --enable-ftp \ --enable-sockets \ --enable-xml \ --enable-wddx \ --enable-bcmath \ --with-zlib=/usr \ --with-snmp \ --enable-ucd-snmp-hack \ --with-openssl \ --with-xmlrpc make -j15 make install cd ../apache_1.3.26 ./configure --prefix=/usr/local/apache \ --enable-module=ssl \ --activate-module=src/modules/php4/libphp4.a \ --enable-module=rewrite \ --enable-module=proxy \ --enable-module=so make make install ------------------------------------------------------------------------ [2002-10-02 20:59:12] sniper@php.net Please do a clean build of Apache next time. You should do 'make clean' in the apache sources at least, better yet, get fresh sources and do the build from scratch. ------------------------------------------------------------------------ [2002-10-02 20:09:41] shane@sell.com I have MySQL 4.0.4-beta installed. I configured php as follows: './configure' '--with-apache=/usr/local/src/apache_1.3.26' '--disable-magic-quotes' '--disable-short-tags' '--disable-debug' '--without-gd' '--enable-url-fopen-wrapper' '--enable-track-vars' '--enable-memory-limit' '--enable-inline-optimization' '--with-config-file-path=/usr/local/php/ini' '--with-mysql=/usr/local' '--enable-ftp' '--enable-sockets' '--enable-xml' '--enable-wddx' '--enable-bcmath' '--with-zlib=/usr' '--with-snmp' '--enable-ucd-snmp-hack' '--with-openssl' '--with-xmlrpc' the php binary reports: mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 4.0.4-beta apache (mod_php installed) reports: mysql MySQL Support enabled Active Persistent Links 0 Active Links 0 Client API version 3.23.35 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19730&edit=1