RPM error MySQL55-server.5.5.31-1.cp1136

activa

Well-Known Member
May 23, 2006
212
0
166
Morocco
cPanel Access Level
Root Administrator
i have upgraded mysql to latest versiob of 5.5 .

today i recieved this email norification error


Code:
[email protected] [~]# /scripts/check_cpanel_rpms --list-only --notify
[20130614.034743]
[20130614.034743]   Problems were detected with cPanel-provided files which are RPM controlled.
[20130614.034743]   If you did not make these changes intentionally, you can correct them by running:
[20130614.034743]
[20130614.034743]   > /usr/local/cpanel/scripts/check_cpanel_rpms --fix
[20130614.034743]   The following RPMs are missing from your system:
[20130614.034743]   MySQL55-server.5.5.31-1.cp1136
the mysql is well upgraded


Code:
[email protected] [~]# rpm -qf /etc/init.d/mysql
MySQL55-server-5.5.30-4.cp1136.x86_64

Code:
[email protected] [~]# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 6894750
Server version: 5.5.30-cll MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

i'm running centos6.4 + cloudlinux .
 
Last edited:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,912
2,241
363
Hello :)

Based on the error message you provided, it looks like there may be multiple versions of MySQL installed. Please post the output of the following command:

Code:
rpm -qa|grep -i mysql
Thank you.
 

activa

Well-Known Member
May 23, 2006
212
0
166
Morocco
cPanel Access Level
Root Administrator
Hello Sir ,


Code:
[email protected] [~]# rpm -qa|grep -i mysql
MySQL55-test-5.5.31-1.cp1136.x86_64
MySQL55-server-5.5.30-4.cp1136.x86_64
MySQL55-shared-5.5.31-1.cp1136.x86_64
cpanel-mysql-5.0.96-1.cp1136.x86_64
cpanel-mysql-libs-5.0.96-1.cp1136.x86_64
cpanel-perl-514-DBD-mysql-4.021-1.cp1136.x86_64
MySQL55-client-5.5.31-1.cp1136.x86_64
MySQL55-devel-5.5.31-1.cp1136.x86_64
cpanel-perl-514-MySQL-Diff-0.43-1.cp1136.x86_64
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,912
2,241
363
Hello :)

Yes, it looks like you have an invalid MySQL RPM installed:

MySQL55-server-5.5.30-4.cp1136.x86_64
Notice how the version does not match the other MySQL55 RPM versions. Please try removing this RPM, and then executing the cPanel RPM check script:

Code:
rpm -e --nodeps MySQL55-server-5.5.30-4.cp1136.x86_64
/usr/local/cpanel/scripts/check_cpanel_rpms --fix
Keep in mind that this essentially is a reinstall of MySQL so only run these commands if you are prepared for a few minutes of downtime for the MySQL service.

Thank you.
 

24x7server

Well-Known Member
Apr 17, 2013
1,896
91
78
India
cPanel Access Level
Root Administrator
You should not face any issues with the MySQL user privileges and user databases after following commands

rpm -e --nodeps MySQL55-server-5.5.30-4.cp1136.x86_64
/usr/local/cpanel/scripts/check_cpanel_rpms --fix
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,912
2,241
363
that databases and users/privilige will not deleted ?
That is correct. However, you are always encouraged to maintain a backup of your databases or the entire MySQL directory as a precaution.

Thank you.