Mysql Client API version

[jmitchell]

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

[scott]

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

[liquorvicar]

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

[scott]

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>