The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

RPM error MySQL55-server.5.5.31-1.cp1136

Discussion in 'Database Discussions' started by activa, Jun 13, 2013.

  1. activa

    activa Well-Known Member

    Joined:
    May 23, 2006
    Messages:
    204
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Morocco
    cPanel Access Level:
    Root Administrator
    i have upgraded mysql to latest versiob of 5.5 .

    today i recieved this email norification error


    Code:
    root@srv1 [~]# /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:
    root@srv1 [~]# rpm -qf /etc/init.d/mysql
    MySQL55-server-5.5.30-4.cp1136.x86_64

    Code:
    root@srv1 [~]# 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 .
     
    #1 activa, Jun 13, 2013
    Last edited: Jun 13, 2013
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. activa

    activa Well-Known Member

    Joined:
    May 23, 2006
    Messages:
    204
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Morocco
    cPanel Access Level:
    Root Administrator
    Hello Sir ,


    Code:
    root@srv1 [~]# 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
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

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

    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.
     
  5. activa

    activa Well-Known Member

    Joined:
    May 23, 2006
    Messages:
    204
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Morocco
    cPanel Access Level:
    Root Administrator
    that databases and users/privilige will not deleted ?
     
  6. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,146
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    You should not face any issues with the MySQL user privileges and user databases after following commands

     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,723
    Likes Received:
    660
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
Loading...

Share This Page