Wednesday, March 20, 2013

Resolve cPanel Update Now Failing MySQL RPM Dependancies

If cPanel is failing nightly UpdateNow based on RPM errors:
error: Failed dependencies:
MySQL conflicts with mysql-5.0.77-4.el5_5.3.i386
W Exit Code: 254
***** FATAL: Test install failed: error: Failed dependencies:
MySQL conflicts with mysql-5.0.77-4.el5_5.3.i386
You can easily fix it using the following:
[~]# rpm -qa | grep mysql-5
mysql-5.0.77-4.el5_5.3

[~]# rpm -e --nodeps --allmatches --justdb mysql-5.0.77-4.el5_5.3

[~]# /scripts/upcp --force

This essentially does the following:
1) Determines the RPM package causing the conflict
2) Removes RPM database entry for package
3) Forces an update of the control panel