Ok major breakthrough!
I have installed all the RPMs generated by theese SRPMs:
mysql-4.1.9-1.src.rpm php-5.0.3-2.src.rpm mysqlclient10-3.23.58-4.src.rpm sqlite3-3.0.8-3.src.rpm
Now, I will post the phpinfo output so that you can see something that is important.
For those who don't know this, php uses "mysqli" extension to manage mysql-4.1.x queries. THIS MODULE IS NOT INCLUDED... so i can't use mysql 4.1 with php5
I have noticed that the extensions are loaded dynamically. you just have to make a x.ini in a directory listed in the phpinfo file (i think is /etc/php.h/modules).
There, you can find the mysql.so extension but not the mysqli.so. I would like to try and build the mysqli.so extension to see if it works. I know i can't use mysql and mysqli at the same time, so it doesn't matter anyway.
For the rest (php5), so far works great!
one more thing. In the directory "/usr/src" there was only the "redhat" directory... now i can see anotherone called "debug" and it contains the following dirs:
mysql-3.23.58 php-5.0.3
any suggestions or ideas?
You can safely get rid of these directories.
phpinfo output file: http://www.woralelandia.com/build-output/phpinfo().html
You will notice that this shows that your PHP is built against the Client API version 3.23.58 for mysql, which is probably not what you wanted. The reason for this is that you built your PHP packages before you installed your updated MySQL packages. You might not like hearing this, but I would rebuild your PHP package if I was you.
Once built, you'll be able to install them using: # rpm -Uvh --replacefiles --replacepkgs php*.rpm
If you want to build the mysqli extension too, then you'll need to modify the spec file for the PHP SRPM, which is beyond the scope of this email...
Paul.
