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.

Failed MySQL Upgrade From 5.0 to 5.1

Discussion in 'Database Discussions' started by traxweb, Feb 17, 2014.

  1. traxweb

    traxweb Registered

    Joined:
    Feb 17, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    I tried to upgrade mYSQL from 5.0 to 5.1 and got an error:

    Problems were detected with cPanel-provided files which are RPM controlled.
    [20140216.215108] [22188] [20140216.215107] If you did not make these changes intentionally, you can correct them by running:
    [20140216.215108] [22188] [20140216.215107]
    [20140216.215108] [22188] [20140216.215107] > /usr/local/cpanel/scripts/check_cpanel_rpms --fix
    [20140216.215108] [22188] [20140216.215107] The following RPMs are missing from your system:
    [20140216.215108] [22188] [20140216.215107] MySQL51-client.5.1.70-1.cp1136
    [20140216.215108] [22188] [20140216.215107] MySQL51-devel.5.1.70-1.cp1136
    [20140216.215108] [22188] [20140216.215107] MySQL51-server.5.1.70-1.cp1136
    [20140216.215108] [22188] [20140216.215107] MySQL51-shared.5.1.70-1.cp1136
    [20140216.215108] [22188] [20140216.215107] MySQL51-test.5.1.70-1.cp1136

    So I went ahead and ran /usr/local/cpanel/scripts/check_cpanel_rpms --fix and it appeared to download everything for 5.1 but when I try and upgrade again it says the same thing that those RPM's are missing and the upgrade fails so not sure how to proceed. When I tried to update WHM I could see in it's pretest run that the 5.1 files were "already downloaded" but then it discovered MySQL was still 5.0 and failed.

    So the system does not know that the files were downloaded when I ran /usr/local/cpanel/scripts/check_cpanel_rpms --fix

    Any ideas on how to resolve this?

    Thanks

    Greg Chadwick
     
  2. vanessa

    vanessa Well-Known Member
    PartnerNOC

    Joined:
    Sep 26, 2006
    Messages:
    817
    Likes Received:
    22
    Trophy Points:
    18
    Location:
    Virginia Beach, VA
    cPanel Access Level:
    DataCenter Provider
    Check /var/cpanel/cpanel.config, and make sure mysql-version is set to "5.1". Not sure which cPanel version you're updating to but if it's 11.42, I believe you'll need to go to MySQL 5.5 first.
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    Please post the output from the following commands:
    Code:
    grep mysql-version /var/cpanel/cpanel.config
    mysql_config --version
    Thank you.
     
  4. traxweb

    traxweb Registered

    Joined:
    Feb 17, 2014
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    First Command: mysql-version=5.1
    Second Command: 5.0.67
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,834
    Likes Received:
    672
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
Loading...

Share This Page