Hello Everyone,

Running Plesk 8.6 on CentOS5.

[root@live modules]# rpm -qf /usr/lib/php/modules/mysql.so
php-mysql-5.2.11-2.el4.art

phpinfo Returns:
Client API version 4.1.22

I've got a client trying to use some DECIMAL tables for mysql, and 4.x doesn't know about it, only 5.x. Just wondering if theres anything I can do from here, as php-mysql is updated to the latest and it didn't change the mysql.so module.

Any help is appreciated!

Thank you,

Josh

Yeah what you need to do is recompile the php src.rpm against the mysql 5 client libraries. By default I stick with the mysql 4 libs so you arent forced to upgrade to mysql 5 when you upgrade php

I've got the same problem on RHEL4.8. Using pretty much all the standard ART RPMs. I've not recompiled PHP from a src RPM before so a bit of a newbie here.
I've got into dependency hell! I installed most of the -deve rpms it was asking me for but I'm getting these failures:
sqlite-devel >= 3.0.0 is needed
pcre-devel >= 6.6 is needed
libpng-devel is needed
libXaw-devel is needed

Can I disable the requirements for these (and how would I do that) if I just need to recompile mysqli.so?
TIA

You would need to modify the spec file to do that. If you're using yum from centos on your system, you should also have access to the yum-utils package. This will automatically install all the dependencies specified by a src.rpm:

yum-builddep <src.rpm filename>