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.

"running unsupported mysql version" even after upgrade

Discussion in 'Database Discussions' started by Railander, Nov 4, 2014.

  1. Railander

    Railander Member

    Joined:
    Oct 21, 2013
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Last night I upgraded mysql from 5.1 to 5.5 and then 5.6 and now some of my clients are having problems connecting to their DBs.
    For instance, when I try to force-change their passwords through WHM and sync their DB password, i get the following error:

    Code:
    Password for “XXXX” has been changed.
    Updating FTP passwords for XXXX
    FTP password files updated.
    FTP vhost passwords synced
    Error from MySQL query: DBD::mysql::db do failed: Lost connection to MySQL server during queryError from MySQL query: DBD::mysql::db do failed: MySQL server has gone away
    I checked my.cnf and for what google tells me, it seems like I shouldn't be getting that error.

    Code:
    [mysqld]
    innodb_file_per_table=1
    innodb_buffer_pool_size = 384M
    innodb_additional_mem_pool_size = 20M
    innodb_log_file_size = 10M
    innodb_log_buffer_size = 64M
    innodb_flush_log_at_trx_commit = 1
    innodb_lock_wait_timeout = 180
    open_files_limit=50000
    max_connections=500
    max_allowed_packet=128M
    wait_timeout=600
    Trying to open the mysql databases through the client's cPanel shows the following error.

    Code:
    This server is running an unsupported MySQL version (Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 136 Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/MysqlUtils/Connect.pm line 136 ...caught). Ask your system administrator to upgrade MySQL to improve security and features.
    But mysql seems to be running correctly with newest version.

    Code:
    mysql -V
    mysql  Ver 14.14 Distrib 5.6.17, for Linux (x86_64) using  EditLine wrapper
    I've tried both /scripts/check_cpanel_rpms --fix and /scripts/upcp --force but the problem still persists.

    Also, some client's domain doesn't seem to be resolving the DNS at all, even though every DNS entry seems to be fine and unaltered.

    Code:
    >ping XXXXX
    Ping request could not find host XXXXX. Please check the name and try again.
    Google hasn't been of much help so far. Any suggestions?
     
    #1 Railander, Nov 4, 2014
    Last edited by a moderator: Nov 4, 2014
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  3. Railander

    Railander Member

    Joined:
    Oct 21, 2013
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    CentOS 5 running under Xen.
    Not sure about the MySQL Governor, but if I had to guess I'd say no.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Feel free to 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.
     
  5. Railander

    Railander Member

    Joined:
    Oct 21, 2013
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Ticket ID 5658101
    I've been awaiting for a representative for about 5 hours now, hope I get a response soon. All the clients on the server are down in the meantime.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    675
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    To update, the following command was ran to address this issue by ensuring tables were compatible with the new version of MySQL:

    Code:
    mysql_upgrade -s
    Thank you.
     
  7. Railander

    Railander Member

    Joined:
    Oct 21, 2013
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Yes that solved it, thank you very much.
    Domain names still weren't being resolved, but restarting nsd did the trick.
     
Loading...

Share This Page