Help compiling php-mysql

[80skeys]

Hi everyone!

I'm building a Zabbix server and I've ran into a stumbling block. I'm using mysql-5.5.9 compiled from source. This installs libmysqlclient.so.16.

As per Rihard's nice book, I would like to install php-mysql. So I downloaded the rpm. But it installs a shared object called mysql.so which looks for libmysqlclient.so.15 and does not work with libmysqlclient.so.16.

So I figured I would download the source for php-mysql and recompile it against mysql-5.5.9. I cannot find a standalone php-mysql source; instead only the php source. Which is okay.

But I'm having a heck of a time compiling it to produce the mysql.so file. I get a "php-mysql.lo" and "php-mysql.o" object files (which I assume is correct?) but I can't get libtool to generate a shared library.

Furthermore, it fails totally on the "mysqli" complaining about missing "replication headers" and such...

Any thoughts and help?

Thanks!

[80skeys]

Update

I made a valiant effort to get php-mysql compiled against mysql-5.5.9. I could probably get it to work, given enough time, but it's not crucial to use the latest version of mysql and time is something I don't have enough of to pursue it at the moment.

In a nutshell, there are a great slew of compile-time issues getting this to work. Each time I encountered one, I patiently worked at it until I found a solution and moved to the next. But there seemed to be a never-ending supply of them, so I quit.

There are several things that have changed between php-5.1 --> php-5.3.6, and mysql-5.0 --> mysql-5.5. Here's a couple of the important changes:

* mysql_rpl_type removed from mysql (see http://forums.freebsd.org/showthread.php?p=63484 and http://bugs.mysql.com/bug.php?id=31952) but still referenced in php source code
* undefined use of gptr in php (see http://bugs.mysql.com/bug.php?id=29994)
* SElinux causing failure of modules to load (see http://groups.google.com/group/phusi...b945a854fe3648)

I probably won't continue working on this. It would be nice to bring it up to date - mysql-5.0 is getting old - so if anybody else has the urge to work on it, let me know and I'll share whatever notes I have.