rpm library dependancy trap

[Jim B.]

Installing the percona mysql rpm's from here:
http://www.percona.com/mysql/5.1.34-5/RPM/rhel5/

The shared rpm provides a libmysqlclient library...
[root@blade2 ~]# rpm -ql MySQL-shared-percona
/usr/lib64/libmysqlclient.so
/usr/lib64/libmysqlclient.so.16
/usr/lib64/libmysqlclient.so.16.0.0
/usr/lib64/libmysqlclient_r.so
/usr/lib64/libmysqlclient_r.so.16
/usr/lib64/libmysqlclient_r.so.16.0.0

...that doesn't satisfy the dependency of other packages built for RHEL/CentOS5 that are expecting version 15. Here's one from the core repo:

[root@blade2 ~]# yum install perl-DBD-MySQL
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * epel: ftp.linux.ncsu.edu
 * base: centos.aol.com
 * updates: centos.secsup.org
 * addons: centos.aol.com
 * extras: mirror.skiplink.com
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package perl-DBD-MySQL.x86_64 0:3.0007-2.el5 set to be updated
--> Processing Dependency: libmysqlclient.so.15(libmysqlclient_15)(64bit) for package: perl-DBD-MySQL
--> Processing Dependency: libmysqlclient.so.15()(64bit) for package: perl-DBD-MySQL
--> Running transaction check
---> Package mysql.x86_64 0:5.0.45-7.el5 set to be updated
--> Processing Conflict: mysql conflicts MySQL
--> Finished Dependency Resolution
mysql-5.0.45-7.el5.x86_64 from core-0 has depsolving problems
  --> mysql conflicts with MySQL-server-percona
Error: mysql conflicts with MySQL-server-percona

And here's the sysbench rpm available in EPEL:

[root@blade2 ~]# yum install sysbench
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * epel: ftp.linux.ncsu.edu
 * base: mirror.skiplink.com
 * updates: centos.secsup.org
 * addons: styx.biochem.wfubmc.edu
 * extras: mirror.skiplink.com
epel | 2.1 kB 00:00
core-0 | 1.1 kB 00:00
base | 1.1 kB 00:00
updates | 951 B 00:00
addons | 951 B 00:00
extras | 1.1 kB 00:00
Setting up Install Process
Parsing package install arguments
Resolving Dependencies
--> Running transaction check
---> Package sysbench.x86_64 0:0.4.10-3.el5 set to be updated
--> Processing Dependency: libmysqlclient_r.so.15(libmysqlclient_15)(64bit) for package: sysbench
--> Processing Dependency: libmysqlclient_r.so.15()(64bit) for package: sysbench
--> Running transaction check
---> Package mysql.x86_64 0:5.0.45-7.el5 set to be updated
--> Processing Conflict: mysql conflicts MySQL
--> Finished Dependency Resolution
mysql-5.0.45-7.el5.x86_64 from core-0 has depsolving problems
  --> mysql conflicts with MySQL-server-percona
Error: mysql conflicts with MySQL-server-percona

[Jim B. (jim-bartus)]

Said this in another ticket system, but it looks like upstream solves this via having distro specific "-compat" packages with extra library versions:

<code>
[root@sql-twit jim]# rpm -qlp MySQL-shared-compat-5.1.39-0.rhel5.x86_64.rpm
/usr/lib64/libmysqlclient.so
/usr/lib64/libmysqlclient.so.12
/usr/lib64/libmysqlclient.so.12.0.0
/usr/lib64/libmysqlclient.so.14
/usr/lib64/libmysqlclient.so.14.0.0
/usr/lib64/libmysqlclient.so.15
/usr/lib64/libmysqlclient.so.15.0.0
/usr/lib64/libmysqlclient.so.16
/usr/lib64/libmysqlclient.so.16.0.0
/usr/lib64/libmysqlclient_r.so
/usr/lib64/libmysqlclient_r.so.12
/usr/lib64/libmysqlclient_r.so.12.0.0
/usr/lib64/libmysqlclient_r.so.14
/usr/lib64/libmysqlclient_r.so.14.0.0
/usr/lib64/libmysqlclient_r.so.15
/usr/lib64/libmysqlclient_r.so.15.0.0
/usr/lib64/libmysqlclient_r.so.16
/usr/lib64/libmysqlclient_r.so.16.0.0
</code>

[Aleksandr Kuzminsky (akuzminsky)]

There is a Percona yum repo. It provides MySQL-shared-compat.x86_64 package which has onboard necessary libs.
Before installing perl-DBD-MySQL (or any other libmysqlclient dependant application) install MySQL-shared-compat.x86_64
# yum install MySQL-shared-compat.x86_64

The repo is:
# cat /etc/yum.repos.d/Percona.repo
[percona]
name=CentOS-$releasever - Percona
baseurl=http://repo.percona.com/centos/$releasever/os/$basearch/
gpgcheck=0

[Vadim Tkachenko (vadim-tk)]

Fix is available in 5.1.42-XtraDB9