PS: Php is loaded in apache with 
LoadModule php5_module        /usr/lib/httpd/modules/libphp5.so

CLI and apache SAPI were built with different MySQL headers.

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 ;)

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

> php-mysql-4.3.11-2.8

You have two different PHP versions installed: PHP4 (cli) and PHP5 (apache).

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/

I have done the following:

1) rpm -e --nodeps  php-mysql

2) 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-shared-compat-5.0.41-0
MySQL-devel-5.0.41-0
mod_auth_mysql-20030510-5

3) rpm -Uvf --replacepkgs MySQL-devel-5.0.41-0.i386.rpm

I have removed the installation src file for php and untarred them again

I configure, make, make install

Still phpinfo() shows the wrong api...

Still think that this is bogus?