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.

Cpanel and MYSQL in big mess up??

Discussion in 'General Discussion' started by Frankc, Jun 1, 2011.

  1. Frankc

    Frankc Well-Known Member

    Joined:
    Jun 18, 2005
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    16
    Our production server ran on automatic updates for cpanel etc.

    Mysql 4.1 and WHM 11.30 (build 23)

    Migrated to new server and ran into a lot of problems.

    MySQL 5.1 and WHM 11.30 (build 23)

    Except for of course many client scripts that now don't work with the MYSQL 5.1 the problem with cpanel is that it don't sync properly with whm/cpanel.

    Go to cpanel, click on mysql databases but get answer tht mysql is currently offline it's NOT)

    Try to go to phpmyadmin but it won't accept the password. Changed the password for client account in WHM and go back and try connect to phpmyadmin, #1045 Cannot log in to the MySQL server.

    Any ideas please?
     
  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 :)

    Could you post the output of the cPanel error log when when you receive the "mysql is currently offline" message in cPanel:

    Code:
    /usr/local/cpanel/logs/error_log
    For more immediate assistance, please feel free to open a support ticket up via:

    Submit A Ticket

    If you choose to open a ticket, please post the ticket number here.

    Thank you.
     
  3. Frankc

    Frankc Well-Known Member

    Joined:
    Jun 18, 2005
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    16
    Also have other messages similar to

    Interesting

    I actually WORK on things that require database access and it's fine, but every now and then get cannot connect to mysql error (but if I click refresh immediately, the page loads so it couldn't be that mysql was really down as it won't restart so quickly)
     
  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
    I have seen several different causes for the error messages you have posted. You may find more information in the MySQL error log itself, which is found at:

    Code:
    /var/lib/mysql/$hostname.err
    Simply replace "$hostname" with the hostname of your server.

    I suggest opening a ticket so we may access your server to check further:

    Submit A Ticket

    Thank you :)
     
  5. Frankc

    Frankc Well-Known Member

    Joined:
    Jun 18, 2005
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    16
    We get our servers from Netdepot and submitted a ticket (refered to this forum)

    The error log show the following over and over again about every 2 minutes.

     
  6. Frankc

    Frankc Well-Known Member

    Joined:
    Jun 18, 2005
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    16
    Some databases and users are not mapped correctly. Tried to user database map tool in WHM

     
  7. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,458
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    This suggests the stored password used by the cPanel & WHM utilities is incorrect. This password is stored in /root/.my.cnf. if you know your root password for MySQL, you can visually inspect it for correctness. if it is not correct changing it in /root/.my.cnf should resolve the matter.

    You might also resolve this by executing /usr/local/cpanel/scripts/mysqlconnectioncheck
     
  8. Frankc

    Frankc Well-Known Member

    Joined:
    Jun 18, 2005
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    16
    Your Request id is: 1560934

    This fixed several issues thanks Kenneth.

    I however opened a support ticket because there are still some errors that seems like sync between mysql and cpanel and it's perhaps better if your guys have a look.

    Regards
     
Loading...

Share This Page