cPanel update fails on MySQL-client and MySQL-server

While cPanel updates can fail for a multitude of reasons, this is one reason for its failure that is very common recently with 11.42 and MariaDB.

If your cPanel update from 11.40 to 11.42 is failing, you can check your cPanel update logs in # /var/cpanel/updatelogs/ for the errors. You will want to make sure you scroll down passed the part where it’s syncing packages, and look for errors. If you see this:
[20140318.120345] Testing if the newly downloaded RPMS can be installed without conflict
[20140318.120345] Testing RPM transaction
[20140318.120345] error: Failed dependencies:
[20140318.120345] MySQL-client is needed by cpanel-php54-horde-5.1.4-1.cp1142.noarch
[20140318.120345] MySQL-server is needed by cpanel-php54-horde-5.1.4-1.cp1142.noarch
[20140318.120345] MySQL-client is needed by cpanel-php54-webmail-5.1.1-1.cp1142.noarch
[20140318.120345] MySQL-server is needed by cpanel-php54-webmail-5.1.1-1.cp1142.noarch
[20140318.120345] W Exit Code: 188
[20140318.120345] ***** FATAL: Test install failed: error: Failed dependencies:
[20140318.120345] MySQL-client is needed by cpanel-php54-horde-5.1.4-1.cp1142.noarch
[20140318.120345] MySQL-server is needed by cpanel-php54-horde-5.1.4-1.cp1142.noarch
[20140318.120345] MySQL-client is needed by cpanel-php54-webmail-5.1.1-1.cp1142.noarch
[20140318.120345] MySQL-server is needed by cpanel-php54-webmail-5.1.1-1.cp1142.noarch
[20140318.120345] The Administrator will be notified to review this output when this script completes
[20140318.120345] ***** FATAL: Error testing if the RPMs will install: Died at /usr/local/cpanel/scripts/updatenow.static-cpanelsync line 14041.
[20140318.120345] see http://go.cpanel.net/rpmcheckfailed for more information
[20140318.120345] The Administrator will be notified to review this output when this script completes
[20140318.120345] E Detected events which require user notification during updatenow. Will send iContact the log

That means that you likely are using MariaDB. There is a conflict with upgrading cPanel to 11.42 when running Maria DB. MariaDB and CloudLinux have pushed out an update for anyone hitting this error. You can see the full details for MariaDB’s update here, and CloudLinux here.

The directions there are quite simple, but you might run into this error:

root@hosting [~]# yum update governor-mysql --enablerepo=cloudlinux-updates-testing
Loaded plugins: fastestmirror, rhnplugin
Error getting repository data for cloudlinux-updates-testing, repository not found
root@hosting [~]#

If you do, check your CloudLinux repo file:

root@hosting [~]# ls -la /etc/yum.repos.d/cloudlinux.repo
-rw-r--r-- 1 root root 0 Jul 29 2013 cloudlinux.repo
root@hosting [~]

If your repo file is empty, like this one is, you need to correct that first. If you can’t find it anywhere else, here is a copy of the repo that is current as of September ’14.

Once you get that file corrected, you should be able to get your RPMS updated, and you should be able to update cPanel to 11.42 without a problem at all.