Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

RPM error MySQL55-server.5.5.31-1.cp1136

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

  1. activa

    activa Well-Known Member

    Joined:
    May 23, 2006
    Messages:
    207
    Likes Received:
    0
    Trophy Points:
    166
    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:
    43,928
    Likes Received:
    1,819
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. activa

    activa Well-Known Member

    Joined:
    May 23, 2006
    Messages:
    207
    Likes Received:
    0
    Trophy Points:
    166
    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:
    43,928
    Likes Received:
    1,819
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  5. activa

    activa Well-Known Member

    Joined:
    May 23, 2006
    Messages:
    207
    Likes Received:
    0
    Trophy Points:
    166
    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,813
    Likes Received:
    84
    Trophy Points:
    78
    Location:
    India
    cPanel Access Level:
    Root Administrator
    You should not face any issues with the MySQL user privileges and user databases after following commands

     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,928
    Likes Received:
    1,819
    Trophy Points:
    363
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice