yum update missing dependencies - libmysqlclient_r.so.16()(64bit)

gbh

Active Member
Sep 17, 2004
31
0
156
Sydney
cPanel Access Level
Root Administrator
WHM 11.32.5 (build 11)
CENTOS 6.2 x86_64
PHP 5.4.5
2.6.32-220.23.1.el6.x86_64
Apache/2.2.22
Server version: 5.5.27-cll MySQL Community Server (GPL)


Hi All,

Hopefully someone can point me in the right direction.

After running: yum update
I get the below....

Code:
Total size: 628 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
ERROR with rpm_check_debug vs depsolve:
libmysqlclient_r.so.16()(64bit) is needed by qt-mysql-1:4.6.2-24.el6.x86_64
libmysqlclient_r.so.16(libmysqlclient_16)(64bit) is needed by qt-mysql-1:4.6.2-24.el6.x86_64
** Found 11 pre-existing rpmdb problem(s), 'yum check' output follows:
bandmin-1.6.1-5.noarch has missing requires of perl(bandmin.conf)
bandmin-1.6.1-5.noarch has missing requires of perl(bmversion.pl)
bandmin-1.6.1-5.noarch has missing requires of perl(services.conf)
exim-4.80-0.x86_64 has missing requires of perl(SafeFile)
frontpage-2002-SR1.2.i386 has missing requires of libexpat.so.0
perl-DBD-MySQL-4.013-3.el6.x86_64 has missing requires of libmysqlclient.so.16()(64bit)
perl-DBD-MySQL-4.013-3.el6.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit)
1:qt-mysql-4.6.2-20.el6.x86_64 has missing requires of libmysqlclient_r.so.16()(64bit)
1:qt-mysql-4.6.2-20.el6.x86_64 has missing requires of libmysqlclient_r.so.16(libmysqlclient_16)(64bit)
redland-1.0.7-11.el6.x86_64 has missing requires of libmysqlclient.so.16()(64bit)
redland-1.0.7-11.el6.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit)
Your transaction was saved, rerun it with: yum load-transaction /tmp/yum_save_tx-2012-10-25-02-02zlVtxP.yumtx
I'm having real trouble tracking down suitable packages that have libmysqlclient.so.16()(64bit) that are suitable for my system.

I do have the below already:
Code:
[email protected] [/usr/local/apache/conf]# locate libmysqlclient_r.so
/usr/lib64/libmysqlclient_r.so
/usr/lib64/libmysqlclient_r.so.18
/usr/lib64/libmysqlclient_r.so.18.0.0
/usr/lib64/mysql/libmysqlclient_r.so
[email protected] [/usr/local/apache/conf]#
also would like to get these cleaned up if possible
Code:
bandmin-1.6.1-5.noarch has missing requires of perl(bandmin.conf)
bandmin-1.6.1-5.noarch has missing requires of perl(bmversion.pl)
bandmin-1.6.1-5.noarch has missing requires of perl(services.conf)
exim-4.80-0.x86_64 has missing requires of perl(SafeFile)
frontpage-2002-SR1.2.i386 has missing requires of libexpat.so.0
have removed the perl exclusion from yum.conf and ran the update again then added perl back in to the exclusion but still no joy..

Thanks in advance, all thoughts and help are greatly appreciated.
Have searched and found many similar threads but no solutions have yet worked for me.
 
Last edited:

gbh

Active Member
Sep 17, 2004
31
0
156
Sydney
cPanel Access Level
Root Administrator
also fyi

Code:
[email protected] [/usr/local/apache/conf]# locate libmysqlclient
/usr/lib64/libmysqlclient.so
/usr/lib64/libmysqlclient.so.16
/usr/lib64/libmysqlclient.so.18
/usr/lib64/libmysqlclient.so.18.0.0
/usr/lib64/libmysqlclient_r.so
/usr/lib64/libmysqlclient_r.so.18
/usr/lib64/libmysqlclient_r.so.18.0.0
/usr/lib64/mysql/libmysqlclient.a
/usr/lib64/mysql/libmysqlclient.so
/usr/lib64/mysql/libmysqlclient_r.a
/usr/lib64/mysql/libmysqlclient_r.so
/usr/local/cpanel/lib/libmysqlclient.so.14
/usr/local/cpanel/lib64/libmysqlclient.so.14
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,243
463
Hello :)

The following package exists on your system per the output you provided:

qt-mysql

Have you installed this package manually? If so, I suggest uninstalling it because it's not a standard package that comes with cPanel. Upon doing this, you should update MySQL via:

# /scripts/mysqlup --force

If you did not install this package, check to see if the CentOS CR (continuous release) repo is enabled in your YUM configuration. This should not be enabled on a production server with cPanel and can sometimes it result in the installation of this type of software.

Thank you.
 

gbh

Active Member
Sep 17, 2004
31
0
156
Sydney
cPanel Access Level
Root Administrator
Thanks for your reply Michael.

Code:
[email protected] [~]# rpm -qa | grep -i qt-mysql
qt-mysql-4.6.2-20.el6.x86_64
[email protected] [~]#
Code:
[email protected] [~]# rpm -e qt-mysql-4.6.2-20.el6.x86_64
error: Failed dependencies:
        qt4-mysql is needed by (installed) akonadi-1.2.1-2.el6.x86_64
[email protected] [~]#
So I decided to run a forced update anyway (did not continue/remove qt-mysql-4.6.2-20.el6.x86_64)

/scripts/mysqlup --force
it went fine/no problems.

decided to try a yum update again and it made no difference, right back at the same issue. output is below

Code:
Install      28 Package(s)
Upgrade     336 Package(s)

Total size: 628 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
ERROR with rpm_check_debug vs depsolve:
libmysqlclient_r.so.16()(64bit) is needed by qt-mysql-1:4.6.2-24.el6.x86_64
libmysqlclient_r.so.16(libmysqlclient_16)(64bit) is needed by qt-mysql-1:4.6.2-24.el6.x86_64
** Found 11 pre-existing rpmdb problem(s), 'yum check' output follows:
bandmin-1.6.1-5.noarch has missing requires of perl(bandmin.conf)
bandmin-1.6.1-5.noarch has missing requires of perl(bmversion.pl)
bandmin-1.6.1-5.noarch has missing requires of perl(services.conf)
exim-4.80-0.x86_64 has missing requires of perl(SafeFile)
frontpage-2002-SR1.2.i386 has missing requires of libexpat.so.0
perl-DBD-MySQL-4.013-3.el6.x86_64 has missing requires of libmysqlclient.so.16()(64bit)
perl-DBD-MySQL-4.013-3.el6.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit)
1:qt-mysql-4.6.2-20.el6.x86_64 has missing requires of libmysqlclient_r.so.16()(64bit)
1:qt-mysql-4.6.2-20.el6.x86_64 has missing requires of libmysqlclient_r.so.16(libmysqlclient_16)(64bit)
redland-1.0.7-11.el6.x86_64 has missing requires of libmysqlclient.so.16()(64bit)
redland-1.0.7-11.el6.x86_64 has missing requires of libmysqlclient.so.16(libmysqlclient_16)(64bit)
Your transaction was saved, rerun it with: yum load-transaction /tmp/yum_save_tx-2012-10-26-13-107M3_pJ.yumtx
should I be trying a different approach?
 

gbh

Active Member
Sep 17, 2004
31
0
156
Sydney
cPanel Access Level
Root Administrator
Just wondeirng if anyone has any further thoughts on this at all? Should I be lodging a ticket for investigation? (I'm CentOS/non Cloud Linux).