Problem: Trying to install php-mysql on a Fedora2 opteron box.

error: Failed dependencies:
libmysqlclient.so.10()(64bit) is needed by php-mysql-4.3.8-2.1

BUT,
rpm -qa | grep -i mysql

returns:

MySQL-client-4.1.5-0.glibc23
MySQL-shared-compat-4.0.21-0 <<---
MySQL-server-4.1.5-0.glibc23
MySQL-devel-4.1.5-0.glibc23
MySQL-shared-4.1.5-0.glibc23
php-mysql-4.3.8-2.1

ie, I have the backwards compat libmysqlclient.so.10 libs. They are here:
/usr/lib/libmysqlclient.so.10.0.0
/usr/lib/libmysqlclient_r.so.10.0.0
/usr/lib/libmysqlclient.so.10
/usr/lib/libmysqlclient_r.so.10
/usr/lib64/mysql/libmysqlclient.so.10.0.0
/usr/lib64/mysql/libmysqlclient_r.so.10.0.0
/usr/lib64/mysql/libmysqlclient.so.10
/usr/lib64/mysql/libmysqlclient_r.so.10

I modified /etc/ld.so.conf to be:
include ld.so.conf.d/*.conf
/usr/X11R6/lib
/usr/X11R6/lib64
/usr/lib64/qt-3.3/lib
/usr/lib64/mysql

and
/sbin/ldconfig -v | grep libmysqlclient

returns

libmysqlclient_r.so.10 -> libmysqlclient_r.so.10.0.0
libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
libmysqlclient_r.so.10 -> libmysqlclient_r.so.10.0.0
libmysqlclient.so.12 -> libmysqlclient.so.12.0.0
libmysqlclient_r.so.12 -> libmysqlclient_r.so.12.0.0
libmysqlclient.so.10 -> libmysqlclient.so.10.0.0
libmysqlclient_r.so.14 -> libmysqlclient_r.so.14.0.0
libmysqlclient.so.14 -> libmysqlclient.so.14.0.0

mysql -V
mysql Ver 14.6 Distrib 4.1.5-gamma, for unknown-linux (x86_64)
is the mysql version i am running. (Which works fine)

Basically what I am asking is, how do I tell the php rpm where to find the libmysqlclient.so.10.0.0?
Thanks guys...

Philip.

Did you ever sort this problem as I am currently stuck on the same thing?

Phoebe.

Hi Phoebe,

The answer is no. I never did. Eventually I gave up, and am still running mySQL ver 3.X. It is a pretty poor show, because it is not clear to me how this works. I spent a long time at this, and I have other things to do. Its hurting me too, since I need some of the newer MySQLs functionality, and have to run it out on an old slower box. We have a sys admin person here, who I set on the job, but he never got back to me either.

Maybe if you do a compile of the whole thing you will have something working that will talk to perl/php etc. I am not in the mood to do this at the moment. If I find out to do this I will post up what I did. Likewise, would you mind doing the same?

Philip.

Am currently pursuing ldconfig which seems to be the thing that points to libraries and will let you know if I have any luck.

Why is this so hard!!!!!!!!!!

Phoebe.

I mean, basically, what you should be able to do then is:
get the source for the libmysqlclient.10 libs only, ie the shared libs, and compile that,
then use the RPM installation that otherwise works,
point to the new compiled libmysqlclient.10 lib, and everyone is happy.

Maybe post up a new thread, reffer to this thread and the other threads with this problem, and say it still doesnt seem right. Someone might see it.

Philip.

Progress (or lack of it) report:

First I found that I hadn't actually go libmysqlclient.10 installed, the locate database was out of date. So downloaded the package in 4.0 downloads in mysql that has the library, so now I could compile the php-mysql package.

BUT the api client for mysql in phpinfo now show mysql 3.23 so that was no good. I don't understand what the php-mysql package does. Do you need a new one each time you update php and it works with any version of mysql, or visa versa? Or is there a separate version for each combination of PHP/MySQL.

After trying to install a binary - no joy.

Trying to install from source using these instructions http://fedoranews.org/contributors/tony_smith/mysql/
and getting an error error: line 356: Package does not exist: %post Max
I have given up and am trying to reinstall 3.23.....

By the way - to tell builds where to look for libraries, you can add paths to this file: ld.so.conf which is in /etc on my system.

I will have to give this another go sometime and will post any progress.

Phoebe.