#41410 [Opn->Bgs]: php -i shows a different mysql api than phpinfo()

ID: 41410 Updated by: tony2001@php.net Reported By: jesse at eonstreet dot com -Status: Open +Status: Bogus Bug Type: MySQL related Operating System: Linux FC3 PHP Version: 5.2.2 New Comment: CLI and apache SAPI were built with different MySQL headers. Previous Comments: ------------------------------------------------------------------------ [2007-05-16 17:40:48] jesse at eonstreet dot com PS: Php is loaded in apache with LoadModule php5_module /usr/lib/httpd/modules/libphp5.so ------------------------------------------------------------------------ [2007-05-16 17:35:41] jesse at eonstreet dot com Description: ------------ Hello, I hope that is easy to fix, I'm not sure if it is bogus or not but after 2 days of searching and trying all different options I could use professional help. I have upgraded to MySql 5.0.41 and upgraded to php 5.2.2 with out any difficulties. The problem is that ' shell> php -i ' shows that the Mysql Client Api is 5.0.41 but with <? phpinfo(); ?> it shows Mysql Client Api 3.23.58 This did not happen with php 5.1.2. It seems that that the apache handler is the only difference between the two outputs is: Server API Apache 2.0 Handler [phpinfo()] Server API => Command Line Interface I have a feeling that this is related to Apache somehow. I have tried many differeny types of compiles but I alway get the same result. Below is a copy of the configure command. The version of Apache is 2.0.53. The server is definately 5.0.41 as I use phpMyAdmin for db stuff. The problem is having an effect on phpMyAdmin as I can't browse any tables with this application. There is some major error as nothing appears in the apache error log nor the php error log. After two days of unrelenting recompiles and endless searches I could really use some expert help. Thank you. Reproduce code: --------------- ./configure --build=i386-redhat-linux --host=i386-redhat-linux --target=i386-redhat-linux-gnu --program-prefix= --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --cache-file=../config.cache --with-config-file-path=/etc --enable-force-cgi-redirect --disable-debug --enable-pic --disable-rpath --enable-inline-optimization --with-bz2 --with-db4=/usr --with-curl --with-exec-dir=/usr/bin --with-freetype-dir=/usr --with-png-dir=/usr --with-gd-dir=/usr/lib --enable-gd-native-ttf --without-gdbm --with-gettext --with-ncurses-dir=/usr/lib --with-gmp --with-iconv --with-jpeg-dir=/usr --with-openssl --with-png --with-pspell --with-libxml=/usr/include/libxml2 --with-expat-dir=/usr --with-dom-dir=/usr/lib,/usr --with-xsl --with-dom-xslt=/usr --with-dom-exslt=/usr --with-xmlrpc=shared --with-pcre-regex-dir=/usr/lib,usr/include --with-zlib-dir=/usr/lib --with-layout=GNU --enable-bcmath --enable-exif --enable-ftp --enable-magic-quotes --enable-sockets --enable-sysvsem --enable-sysvshm --enable-track-vars --enable-trans-sid --enable-yp --enable-wddx --with-pear=/usr/share/pear --with-imap-dir=/usr/lib --with-imap-ssl --with-kerberos --with-ldap-dir=/usr/lib --with-mysql=/usr -with-mysql-sock=/var/lib/mysql/mysql.sock --with-pgsql-dir=/usr/lib --with-snmp-dir=/usr/lib,/usr --enable-ucd-snmp-hack --with-unixODBC-dir=/usr/lib,/usr --enable-memory-limit --enable-shmop --enable-calendar --enable-dbx --enable-dio --enable-mbstring --with-mcrypt-dir=/usr/lib,/usr/include --enable-mbstr-enc-trans --enable-mbregex --with-mime-magic=/usr/share/file/magic.mime --enable-soap --with-pic --with-apxs2=/usr/sbin/apxs ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=41410&edit=1