[CentOS] MySQL 5.5, PHP and other tools still use 5.0 client drivers

Matthew B. Brookover

mbrookov at mines.edu
Mon Oct 28 20:10:23 UTC 2013


I upgraded a web server from CentOS 5.9 to 5.10.  The instructions also
indicate that MySQL 5.0 is no longer supported so I followed the
instructions to upgrade to 5.5.  Everything seems to be working so I
tried to remove MySQL 5.0 and MySQL 5.1.  It seems there are still
dependencies on MySQL 5.0:

[root at w3 ~]# rpm -e mysql51-mysql-libs-5.1.70-1.el5 mysql-server-5.0.95-5.el5_9 mysql51-build-1-9.el5 mysql51-mysql-5.1.70-1.el5 mysql51-mysql-server-5.1.70-1.el5 mysql51-mysql-test-5.1.70-1.el5 mysql-devel-5.0.95-5.el5_9 mysql-5.0.95-5.el5_9 mysql-test-5.0.95-5.el5_9 mysql51-runtime-1-9.el5 mysql51-1-9.el5 mysql51-mysql-bench-5.1.70-1.el5 mysql51-mysql-libs-5.1.70-1.el5 mysql51-build-1-9.el5 mysql51-mysql-5.1.70-1.el5 mysql51-mysql-server-5.1.70-1.el5 mysql51-mysql-test-5.1.70-1.el5 mysql51-runtime-1-9.el5 mysql51-1-9.el5 mysql51-mysql-bench-5.1.70-1.el5
error: Failed dependencies:
libmysqlclient.so.15 is needed by (installed) perl-DBD-MySQL-3.0007-2.el5.i386
libmysqlclient.so.15 is needed by (installed) mod_auth_mysql-3.0.0-3.2.el5_3.i386
libmysqlclient.so.15 is needed by (installed) mysql-connector-odbc-3.51.26r1127-2.el5.i386
libmysqlclient.so.15 is needed by (installed) cyrus-sasl-sql-2.1.22-7.el5_8.1.i386
libmysqlclient.so.15 is needed by (installed) dovecot-1.0.7-8.el5_9.1.i386
libmysqlclient.so.15 is needed by (installed) php53-mysql-5.3.3-21.el5.i386
libmysqlclient.so.15(libmysqlclient_15) is needed by (installed) perl-DBD-MySQL-3.0007-2.el5.i386
libmysqlclient.so.15(libmysqlclient_15) is needed by (installed) mod_auth_mysql-3.0.0-3.2.el5_3.i386
libmysqlclient.so.15(libmysqlclient_15) is needed by (installed) mysql-connector-odbc-3.51.26r1127-2.el5.i386
libmysqlclient.so.15(libmysqlclient_15) is needed by (installed) cyrus-sasl-sql-2.1.22-7.el5_8.1.i386
libmysqlclient.so.15(libmysqlclient_15) is needed by (installed) dovecot-1.0.7-8.el5_9.1.i386
libmysqlclient.so.15(libmysqlclient_15) is needed by (installed) php53-mysql-5.3.3-21.el5.i386
libmysqlclient_r.so.15 is needed by (installed) mysql-connector-odbc-3.51.26r1127-2.el5.i386
libmysqlclient_r.so.15 is needed by (installed) MySQL-python-1.2.3-0.1.c1.el5.i386
libmysqlclient_r.so.15(libmysqlclient_15) is needed by (installed) mysql-connector-odbc-3.51.26r1127-2.el5.i386
libmysqlclient_r.so.15(libmysqlclient_15) is needed by (installed) MySQL-python-1.2.3-0.1.c1.el5.i386
mysql = 5.0.95-5.el5_9 is needed by (installed) mysql-bench-5.0.95-5.el5_9.i386
[root at w3 ~]# find /usr/lib -name libmysqlclient.so.15 -ls
721332 0 lrwxrwxrwx 1 root root 24 Jan 23 2013 /usr/lib/mysql/libmysqlclient.so.15 -> libmysqlclient.so.15.0.0
[root at w3 ~]# find /usr/lib -name libmysqlclient.so.15.0.0 -ls
721556 1424 -rwxr-xr-x 1 root root 1452764 Jan 22 2013 /usr/lib/mysql/libmysqlclient.so.15.0.0
[root at w3 ~]# rpm -qf /usr/lib/mysql/libmysqlclient.so.15.0.0
mysql-5.0.95-5.el5_9
[root at w3 ~]#

I started up httpd, mysql, etc, and used lsof to see which library was
in use:
[root at w3 csm-vhosts]# lsof -p 4552  | grep mysql
httpd   4552 apache  mem    REG  253,1    43032   593822 /usr/lib/php/modules/mysql.so
httpd   4552 apache  mem    REG  253,1   113324   593824 /usr/lib/php/modules/mysqli.so
httpd   4552 apache  mem    REG  253,1    24460   593835 /usr/lib/php/modules/pdo_mysql.so
httpd   4552 apache  mem    REG  253,1  1452764   721556 /usr/lib/mysql/libmysqlclient.so.15.0.0
[root at w3 csm-vhosts]# 

As I understand it, there is no longer any support for
mysql-5.0.95-5.el5_9, but it looks like it is still in use.  Is there
any plan to move Perl DBD, mod_auth_mysql, ODBC, SASL, Dovecot, and PHP
from the 5.0 MySQL drivers to the 5.5 drivers?

Is there something that I missed in the upgrade process?

thanks

Matt
mbrookov at mines.edu



More information about the CentOS mailing list