Mysql 5.x Upgrade - version `libmysqlclient_15' not found

[teckyhead]

I've done a few mysql 4.x -> 5.x upgrades and never had a problem.

I know about the issues that can happen if you don't run the easyapache and perl update script afterwards, but this time the problem is a little different. The mysql server (5.0.45) is running fine but it appears that the client programs haven't been updated or there is some mismatch between them and the shared libraries. Here is the output of a few programs in order to provide some info...


===========================================
# cat /etc/redhat-release
CentOS release 4.6 (Final)

# yum info MySQL-devel
Installed Packages
Name : MySQL-devel
Arch : x86_64
Version: 5.0.45
Release: 0.glibc23
Size : 24 M
Repo : installed
Summary: MySQL - Development header files and libraries

# yum info MySQL-client
Name : MySQL-client
Arch : x86_64
Version: 5.0.45
Release: 0.glibc23
Size : 791 k
Repo : installed
Summary: MySQL - Client

# /scripts/mysqlup
MySQL Setup Script Version 7.0
Loaded cPPkgs::MySQL ok!
This is the cPPkgs::MySQL 5.0.45 installer for Linux.
MySQL 5.0.45 is up to date
Install Complete
===========================================

WHM is WHM 11.15.0 cPanel 11.18.1-R20683

So, yum and WHM are telling me Mysql is v5.0.45 and all up to date. However, when I run a client program such as mysqladmin I see this:

# mysqladmin
mysqladmin: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by mysqladmin)

The _15 libs are there. Here's the file listing from /usr/lib64

==================================
# ls -al /usr/lib64/libmy*
lrwxrwxrwx 1 root root 26 Mar 2 06:09 /usr/lib64/libmysqlclient_r.so -> libmysqlclient_r.so.15.0.0
lrwxrwxrwx 1 root root 26 Mar 2 06:09 /usr/lib64/libmysqlclient_r.so.15 -> libmysqlclient_r.so.15.0.0
-rwxr-xr-x 1 root root 2599067 Jul 17 2007 /usr/lib64/libmysqlclient_r.so.15.0.0
lrwxrwxrwx 1 root root 24 Mar 2 06:09 /usr/lib64/libmysqlclient.so -> libmysqlclient.so.15.0.0
lrwxrwxrwx 1 root root 20 Mar 2 05:55 /usr/lib64/libmysqlclient.so.14 -> libmysqlclient.so.15
lrwxrwxrwx 1 root root 24 Mar 2 06:09 /usr/lib64/libmysqlclient.so.15 -> libmysqlclient.so.15.0.0
-rwxr-xr-x 1 root root 1343616 Sep 26 2006 /usr/lib64/libmysqlclient.so.15.0.0
==================================


PHP seems to have compiled fine ... I can get into phpMyAdmin without a problem. It seems that it's just those pesky Mysql client utilities that have a problem.

Gary

[cpanelkenneth]

I've done a few mysql 4.x -> 5.x upgrades and never had a problem.

I know about the issues that can happen if you don't run the easyapache and perl update script afterwards, but this time the problem is a little different. The mysql server (5.0.45) is running fine but it appears that the client programs haven't been updated or there is some mismatch between them and the shared libraries. Here is the output of a few programs in order to provide some info...


===========================================
# cat /etc/redhat-release
CentOS release 4.6 (Final)

# yum info MySQL-devel
Installed Packages
Name : MySQL-devel
Arch : x86_64
Version: 5.0.45
Release: 0.glibc23
Size : 24 M
Repo : installed
Summary: MySQL - Development header files and libraries

# yum info MySQL-client
Name : MySQL-client
Arch : x86_64
Version: 5.0.45
Release: 0.glibc23
Size : 791 k
Repo : installed
Summary: MySQL - Client

# /scripts/mysqlup
MySQL Setup Script Version 7.0
Loaded cPPkgs::MySQL ok!
This is the cPPkgs::MySQL 5.0.45 installer for Linux.
MySQL 5.0.45 is up to date
Install Complete
===========================================

WHM is WHM 11.15.0 cPanel 11.18.1-R20683

So, yum and WHM are telling me Mysql is v5.0.45 and all up to date. However, when I run a client program such as mysqladmin I see this:

# mysqladmin
mysqladmin: /usr/lib64/libmysqlclient.so.15: version `libmysqlclient_15' not found (required by mysqladmin)

The _15 libs are there. Here's the file listing from /usr/lib64

==================================
# ls -al /usr/lib64/libmy*
lrwxrwxrwx 1 root root 26 Mar 2 06:09 /usr/lib64/libmysqlclient_r.so -> libmysqlclient_r.so.15.0.0
lrwxrwxrwx 1 root root 26 Mar 2 06:09 /usr/lib64/libmysqlclient_r.so.15 -> libmysqlclient_r.so.15.0.0
-rwxr-xr-x 1 root root 2599067 Jul 17 2007 /usr/lib64/libmysqlclient_r.so.15.0.0
lrwxrwxrwx 1 root root 24 Mar 2 06:09 /usr/lib64/libmysqlclient.so -> libmysqlclient.so.15.0.0
lrwxrwxrwx 1 root root 20 Mar 2 05:55 /usr/lib64/libmysqlclient.so.14 -> libmysqlclient.so.15
lrwxrwxrwx 1 root root 24 Mar 2 06:09 /usr/lib64/libmysqlclient.so.15 -> libmysqlclient.so.15.0.0
-rwxr-xr-x 1 root root 1343616 Sep 26 2006 /usr/lib64/libmysqlclient.so.15.0.0
==================================


PHP seems to have compiled fine ... I can get into phpMyAdmin without a problem. It seems that it's just those pesky Mysql client utilities that have a problem.

Gary

What does

which mysqladmin

show?

[teckyhead]

What does

which mysqladmin

show?

[root@194 ~]# which mysql
/usr/bin/mysql


[root@194 ~]# which mysqladmin
/usr/bin/mysqladmin


Regards,

Gary

[viraj]

Try running the following from SSH as root :
/scripts/mysqlup --force
Hope that fixes the issue...

[teckyhead]

Yep...already tried that. It says that MySQL is up to date. That's correct too...the mysql server and PHP are working fine. It's just the client binaries that aren't working.

Gary

[viraj]

Can you try reinstalling the RPMs for those binaries ?

[parvaz1355]

where run scripts/mysqlup --force
get err:

This is the cPPkgs::MySQL 5.0.45 installer for Linux.
Fetching http://httpupdate.cpanel.net/mysqlin...ibc23.i386.rpm (0)....@216.144.237.225......connected......receiving...1%...2
%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%..
.32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...6
0%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%
...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
error: failed to stat (deleted) /var/tmp: No such file or directory
Preparing... ##################################################
MySQL-shared ##################################################
Fetching http://httpupdate.cpanel.net/mysqlin...ibc23.i386.rpm (0)....@216.144.237.225......connected......receiving...1%...2
%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%..
.32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...6
0%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%
...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
error: failed to stat (deleted) /var/tmp: No such file or directory
Preparing... ##################################################
error: install: %pre scriptlet failed (2), skipping MySQL-server-5.0.45-0.glibc23
Fetching http://httpupdate.cpanel.net/mysqlin...ibc23.i386.rpm (0)....@216.144.237.225......connected......receiving...1%...2
%...3%...4%...5%...6%...7%...8%...9%...10%...11%...12%...13%...14%...15%...16%...17%...18%...19%...20%...21%...22%...23%...24%...25%...26%...27%...28%...29%...30%...31%..
.32%...33%...34%...35%...36%...37%...38%...39%...40%...41%...42%...43%...44%...45%...46%...47%...48%...49%...50%...51%...52%...53%...54%...55%...56%...57%...58%...59%...6
0%...61%...62%...63%...64%...65%...66%...67%...68%...69%...70%...71%...72%...73%...74%...75%...76%...77%...78%...79%...80%...81%...82%...83%...84%...85%...86%...87%...88%
...89%...90%...91%...92%...93%...94%...95%...96%...97%...98%...99%...100%......Done
error: failed to stat (deleted) /var/tmp: No such file or directory
Preparing... ##################################################
MySQL-shared ##################################################
This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.



howt o fix it?

[WebScHoLaR]

Please provide the output of these two commands:

mount
df -h

[cpanelkenneth]

It looks like something deleted /var/tmp, but because files therein are still held by other applications (e.g. courier-authlib) the directory still appears available. Check the output of:

lsof /var/tmp

and shutdown services that own files therein. Once that is done try mysqlup again.