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@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@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@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@w3 ~]# rpm -qf /usr/lib/mysql/libmysqlclient.so.15.0.0 mysql-5.0.95-5.el5_9 [root@w3 ~]#

I started up httpd, mysql, etc, and used lsof to see which library was in use: [root@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@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@mines.edu