Missing Dependency: libmysqlclient.so.18(libmysqlclient_16)

GraFfiX · **Posted:** Thu Mar 22, 2012 2:14 pm

I have been running ASL and all has been well for the past few months. I have been able to update fine, and the system allows me to combat attacks on a more thorough level. I have, however, recently ran into a problem. I noticed my logs showing failed updates, upon further inspection, here is the content.

Code:

Loaded plugins: downloadonly, fastestmirror
Loading mirror speeds from cached hostfile
 * atomic: www4.atomicorp.com
 * base: mirrors.tummy.com
 * extras: centos-mirror.jchost.net
 * updates: centos.mirrorcatalogs.com
Excluding Packages in global exclude list
Finished
Reducing Dag ClamAV RPM to included packages only
Finished
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package asl-php.x86_64 0:5.4.0-0.6.el5.art set to be updated
---> Package asl-php-cli.x86_64 0:5.4.0-0.6.el5.art set to be updated
---> Package asl-php-common.x86_64 0:5.4.0-0.6.el5.art set to be updated
---> Package asl-php-gd.x86_64 0:5.4.0-0.6.el5.art set to be updated
---> Package asl-php-mysql.x86_64 0:5.4.0-0.6.el5.art set to be updated
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: asl-php-mysql
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) for package: asl-php-mysql
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: asl-php-mysql
---> Package asl-php-pdo.x86_64 0:5.4.0-0.6.el5.art set to be updated
--> Finished Dependency Resolution
asl-php-mysql-5.4.0-0.6.el5.art.x86_64 from asl-3.0 has depsolving problems
  --> Missing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) is needed by package asl-php-mysql-5.4.0-0.6.el5.art.x86_64 (asl-3.0)
asl-php-mysql-5.4.0-0.6.el5.art.x86_64 from asl-3.0 has depsolving problems
  --> Missing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by package asl-php-mysql-5.4.0-0.6.el5.art.x86_64 (asl-3.0)
asl-php-mysql-5.4.0-0.6.el5.art.x86_64 from asl-3.0 has depsolving problems
  --> Missing Dependency: libmysqlclient.so.18()(64bit) is needed by package asl-php-mysql-5.4.0-0.6.el5.art.x86_64 (asl-3.0)
Error: Missing Dependency: libmysqlclient.so.18()(64bit) is needed by package asl-php-mysql-5.4.0-0.6.el5.art.x86_64 (asl-3.0)
Error: Missing Dependency: libmysqlclient.so.18(libmysqlclient_16)(64bit) is needed by package asl-php-mysql-5.4.0-0.6.el5.art.x86_64 (asl-3.0)
Error: Missing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) is needed by package asl-php-mysql-5.4.0-0.6.el5.art.x86_64 (asl-3.0)
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest

Edit:
Thought I would post some more information. This is a Centos/WHM box running Centos 5.8 (64)

Code:

[root@server1 /]# uname -a
Linux server1.xxxxxxxxxxxxxxxxx.com 2.6.32.57-14.art.x86_64 #1 SMP Fri Feb 24 12:12:07 EST 2012 x86_64 x86_64 x86_64 GNU/Linux
[root@server1 /]#

Any ideas as to what may be going on?

mikeshinn · **Posted:** Thu Mar 22, 2012 4:02 pm

Was this upgrade done via "yum upgrade" or "yum update", and do you have anything excluded in your yum repo configuration?

GraFfiX · **Posted:** Thu Mar 22, 2012 4:19 pm

Was done via yum update:
Here is my repolist

Code:

[root@server1 log]# yum repolist
Loaded plugins: downloadonly, fastestmirror
Loading mirror speeds from cached hostfile
 * atomic: www4.atomicorp.com
 * base: bay.uchicago.edu
 * extras: centos-mirror.jchost.net
 * updates: mirror.nexcess.net
addons                                                                                                                                       | 1.9 kB     00:00
asl-3.0                                                                                                                                      | 1.9 kB     00:00
atomic                                                                                                                                       | 1.9 kB     00:00
Excluding Packages in global exclude list
Finished
Reducing Dag ClamAV RPM to included packages only
Finished
repo id                                            repo name                                                                                               status
addons                                             CentOS-5 - Addons                                                                                               0
asl-3.0                                            Atomicorp -  - Atomic Secured Linux 3.0                                                                    463+20
atomic                                             CentOS / Red Hat Enterprise Linux 5 - atomicrocketturtle.com                                              692+552
base                                               CentOS-5 - Base                                                                                         3,467+124
dag                                                Dag ClamAV RPM                                                                                          61+11,022
extras                                             CentOS-5 - Extras                                                                                          236+32
updates                                            CentOS-5 - Updates                                                                                         118+13
repolist: 5,037

I haven't disabled anything that I am aware of.

scott · **Posted:** Fri Mar 23, 2012 8:02 am

Check all your configs, that output means its being excluded

mikeshinn · **Posted:** Fri Mar 23, 2012 10:38 am

And make sure you use "yum upgrade" and not "yum update" for upgrading ASL components.

GraFfiX · **Posted:** Fri Mar 23, 2012 12:32 pm

I tried running yum upgrade, same errors.

I don't see any disabled repos, all repos in /etc/yum.repos.d are listed in yum repolist. I am stumped...anyone have any other suggestions.

mikeshinn · **Posted:** Fri Mar 23, 2012 1:19 pm

Do you have any packages excluded from your yum repos, like mysql, php, kernel, etc.?

GraFfiX · **Posted:** Fri Mar 23, 2012 2:00 pm

From cat etc/yum.conf

exclude=apache* bind-chroot courier* dovecot* exim* filesystem httpd* mod_ssl* mysql* nsd* perl* php* proftpd* pure-ftpd* ruby* spamassassin* squirrelmail*

So I see they are being excluded, however, aren't these packages being excluded due to WHM/CPanel?

I would hope it would be as easy as removing the excludes for php* and mysql*, then replacing them after the update, I fear it may not be that simple though, any input?

mikeshinn · **Posted:** Fri Mar 23, 2012 2:34 pm

Yep, thats why you are having these issues. You need to remove those excludes.

I recommend you open a case with cpanel about this and insist they use software management properly. They may just close out the case, but they have asked us in the past what we thought and we've been stead fast that its important they use package management. If they hear it from other customers it may put them over the edge to finally make their software use the built in software management system in the OS.

Package management is standard practice in Linux and has been for decades now. Without it you can't prevent incompatibilities, you can't easily tell if you have old vulnerable software installed and as you just saw hacking it up unnecessarily breaks software.

GraFfiX · **Posted:** Sat Mar 24, 2012 7:51 pm

Thanks a lot for the solution. I have to say I am a little leery of just disabling the excludes and installing the new versions of php/mysql, I'm almost sure it would break something within cpanel/whm. Is the reasoning behind the update a security issue? Surely these updates must be specific to ASL and staying current? You'll have to forgive my paranoia, I have had a bit of trouble with whm/cpanel installs. I also do not have a testing server, so everything is done live...I know it's bad practice but it is what it is. I'm just trying to cover all my bases, I assume since php is being updated, it would also need to be recompiled? I really appreciate your assistance.

mikeshinn · **Posted:** Sat Mar 24, 2012 9:20 pm

If I understand you correctly, if you are concerned that packages you are trying to install that start with "asl-php" are going to replace the PHP on your system they will not. Those packages are part of ASL, it has its own internal version of PHP that only it uses. It does not touch, replace or do anything with the PHP on your system, so upgrading ASL components is safe. Nothing else on the system uses those packages except ASL and it will not replace or interact with the php you are likely referring to.

The libmysqlclient* packages are compatability packages, they are also not part of the mysql server on your system. These libraries are used by client applications to give them the capability to speak SQL to a mysql server. They will also not replace the mysql on your system.

Cpanel has broken the software management system on your machine by incorrectly configuring yum to exclude anything with "mysql" in its name.

We always recommend that you use the latest version of ASL as it includes all of the latest security enhancements as well as any bug fixes.

GraFfiX · **Posted:** Sun Mar 25, 2012 2:01 am

Thank you very much kind sir, I removed the excludes and performed the update, all went well.

mikeshinn · **Posted:** Tue Mar 27, 2012 5:04 pm

Added an FAQ for this:

https://www.atomicorp.com/wiki/index.ph ... ysqlclient

Highland · **Joined:** Mon Apr 10, 2006 12:55 pm **Posts:** 656

I am surprised you're not directing people towards php-mysqlnd instead. Removes the need for any MySQL libs.

scott · **Posted:** Wed Mar 28, 2012 10:05 am

Its on the list, but there are other places the native mysql libraries get used. Like in ossec-dbd for example

Missing Dependency: libmysqlclient.so.18(libmysqlclient_16)

Who is online