ID: 41410
User updated by: jesse at eonstreet dot com
Reported By: jesse at eonstreet dot com
Status: Bogus
Bug Type: MySQL related
Operating System: Linux FC3
PHP Version: 5.2.2
New Comment:
Possibly. But that was what came installed.
rpm -e php-mysql
error: Failed dependencies:
php-mysql is needed by (installed)
psa-7.5.4-fc3.build75050824.12.i586
php-mysql is needed by (installed)
psa-horde-3.1.1-fc3.build75060413.11.noarch
php-mysql is needed by (installed)
Sitebuilder-2.1.2-fc3.build051222.05.i386
Since I have upgraded and compiled the PHP src and installed the rpms
for MySql what you are saying perplexes me.
Why wouold php -i return "PHP Version => 5.2.2" as does phpinfo() on
Apache?
You can see from make install that both the CLI and SAPI are being
recompiled and installed.
make install returns this:
Installing PHP SAPI module: apache2handler
/usr/lib/httpd/build/instdso.sh SH_LIBTOOL='/bin/sh
/usr/lib/apr/build/libtool' libphp5.la /usr/lib/httpd/modules
/bin/sh /usr/lib/apr/build/libtool --mode=install cp libphp5.la
/usr/lib/httpd/modules/
cp .libs/libphp5.so /usr/lib/httpd/modules/libphp5.so
cp .libs/libphp5.lai /usr/lib/httpd/modules/libphp5.la
libtool: install: warning: remember to run `libtool --finish
/usr/src/php/php-5.2.2/libs'
chmod 755 /usr/lib/httpd/modules/libphp5.so
[activating module `php5' in /etc/httpd/conf/httpd.conf]
Installing PHP CLI binary: /usr/bin/
Installing PHP CLI man page: /usr/share/man/man1/
Installing shared extensions: /usr/lib/20060613/
Installing build environment: /usr/lib/build/
Installing header files: /usr/include/php/
Previous Comments:
------------------------------------------------------------------------
[2007-05-17 11:40:27] [EMAIL PROTECTED]
> php-mysql-4.3.11-2.8
You have two different PHP versions installed: PHP4 (cli) and PHP5
(apache).
------------------------------------------------------------------------
[2007-05-17 11:32:17] jesse at eonstreet dot com
Maybe this will help:
rpm -qa | grep -i mysql
MySQL-server-5.0.41-0
MySQL-shared-5.0.41-0
perl-DBD-MySQL-2.9003-5
MySQL-client-5.0.41-0
MySQL-devel-5.0.41-0
MySQL-shared-compat-5.0.41-0
php-mysql-4.3.11-2.8
mod_auth_mysql-20030510-5
------------------------------------------------------------------------
[2007-05-17 11:12:26] jesse at eonstreet dot com
Hello,
That is what I thought too but my box has never had mysql 3 installed.
(It came with Mysql 4)
I have installed the Mysql rpms for devel, shared, shared-compat,
client and server.
I would like to point out that the CLI and the sapi are being compiled
at the same time with the same headers.
How is it possible that the compiler uses one set of headers for the
cli api and another for the sapi?
This is why I think there is a bug in this version of php. Php 5.1.4
used the correct header.
The process of my upgraded was as follows:
1) Upgrade to php 5.2.2 with the same configure command as was used
with php 5.1.4 ( due to session variable problems in 5.1.4)
2) Tried to use phpMyAdmin but it failed to be able to browse any table
with a result set (error of some sort that is not reported in any log
file)
3) MySql Client Api with phpinfo() shows version 3.xx
4) Upgraded from Mysql 5.0.21 to 5.0.41 hoping that this would solve
the problem
5) Recompiled many many times trying to get php to find the correct
Mysql headers
6) CLI api is compiled correctly SAPI is compiled incorrectly
I am not a master C programmer but I have a feeling that the Include
command is not correct when sapi is compiled. I believe that it is
using libmysqlclient.so.10.0.0 instead of libmysqlclient.so.15.0.0 or
even libmysqlclient.so which links to the lastest version.
I would remove libmysqlclient.so.10.0.0 or link it to just .so but I am
afraid of breaking the system.
Please advise on how to fix this.
Thank you for taking the time to look at this ;)
------------------------------------------------------------------------
[2007-05-16 18:31:50] [EMAIL PROTECTED]
CLI and apache SAPI were built with different MySQL headers.
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/41410
--
Edit this bug report at http://bugs.php.net/?id=41410&edit=1
