ID: 19730
Updated by: [EMAIL PROTECTED]
Reported By: [EMAIL PROTECTED]
-Status: Open
+Status: Feedback
Bug Type: Apache related
Operating System: debian linux potato
PHP Version: 4.2.3
New Comment:
I hope you're aware that the 'beta' text in that version for mysql
really means that it's not ready for production..
Anyway, the api version shown in phpinfo() output comes from
mysql function called 'mysql_get_client_info()' and that is provided by
the mysql client libs and in the bundled mysql lib sources it's like
this:
mysql_get_client_info(void)
{
return (char*) MYSQL_SERVER_VERSION;
}
Try grepping your whole system for that incorrect version and you'll
find where it's defined..
Previous Comments:
------------------------------------------------------------------------
[2002-10-03 09:26:40] [EMAIL PROTECTED]
Apologies, I copy and pasted the wrong build script. As you can see
from my first post to this bug, I did use a prefix of "/usr/local" when
configuring php.
Since the shipped version of the mysql libs are 3.23.39 (not 3.23.35),
it is obvious that the binary is built against other libs.
Additionally, the box has never had a version of MySQL installed on it
lower than 3.23.37, so the 3.23.35 version string has to be in error.
Additionally, there are no other copies of the mysql libs and includes
other than the 4.0.4 set. I verified this over lunch one day when I
left one of our boxen doing a recursive grep of /usr looking for old
versions.
Have you attempted to reproduce this? It should be exceedingly easy for
anyone to prove.
------------------------------------------------------------------------
[2002-10-03 07:17:18] [EMAIL PROTECTED]
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..
------------------------------------------------------------------------
[2002-10-03 00:10:52] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
