Skip to main content

cPanel showing msg - The MySQL server is currently offline.

delfinparis
This is happening for all the accounts in WHM. MySQL server is definitely online and working. I've reset the MySQL password (this sometimes fixes it, apparently). I've rebuilt MySQL. Restarted the server. Manually stopped/started MySQL. Nothing is working. Again, all my sites are up and running fine. Any thoughts on how to troubleshoot this problem? Thanks!

Comments

11 comments

Date Votes
  • Sreejit
    You should check the mysql logs /var/lib/mysql/hostname.err for the exact reason.
    0
  • delfinparis
    Thanks - here's what the .err file says... 100605 20:34:08 mysqld started InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 100605 20:34:08 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 100605 20:34:09 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 100605 20:34:09 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 100605 20:34:09 InnoDB: Started; log sequence number 0 0 100605 20:34:09 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.90-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 100605 20:34:13 [Note] /usr/sbin/mysqld: Normal shutdown 100605 20:34:13 InnoDB: Starting shutdown... 100605 20:34:13 InnoDB: Shutdown completed; log sequence number 0 43655 100605 20:34:13 [Note] /usr/sbin/mysqld: Shutdown complete 100605 20:34:13 mysqld ended 100605 20:34:14 mysqld started 100605 20:34:14 InnoDB: Started; log sequence number 0 43655 100605 20:34:14 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.90-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 100605 20:46:07 [Note] /usr/sbin/mysqld: Normal shutdown 100605 20:46:07 InnoDB: Starting shutdown... 100605 20:46:08 InnoDB: Shutdown completed; log sequence number 0 43655 100605 20:46:08 [Note] /usr/sbin/mysqld: Shutdown complete 100605 20:46:08 mysqld ended 100605 20:46:08 mysqld started 100605 20:46:08 InnoDB: Started; log sequence number 0 43655 100605 20:46:08 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.0.90-community' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL) 100605 20:46:12 [Note] /usr/sbin/mysqld: Normal shutdown
    0
  • cPanelMichael
    Hello :) Please check the cPanel error log (/usr/local/cpanel/logs/error_log) when you notice this error and let us know the output. Thank you.
    0
  • delfinparis
    [quote="cPanelMichael, post: 1559032">Hello :) Please check the cPanel error log (/usr/local/cpanel/logs/error_log) when you notice this error and let us know the output. Thank you.
    Here's the entirety of the error_log - it looks like old errors from 2010, though. [2010-06-05 20:10:21 -0700] info [realadduser] No password specified for cpanel [2010-06-05 20:10:21 -0700] info [realadduser] User cpanel added [2010-06-05 20:10:21 -0700] info [realadduser] No password specified for cpanelhorde [2010-06-05 20:10:21 -0700] info [realadduser] User cpanelhorde added [2010-06-05 20:10:21 -0700] info [realadduser] No password specified for cpanelphpmyadmin [2010-06-05 20:10:21 -0700] info [realadduser] User cpanelphpmyadmin added [2010-06-05 20:10:21 -0700] info [realadduser] No password specified for cpanelphppgadmin [2010-06-05 20:10:21 -0700] info [realadduser] User cpanelphppgadmin added [2010-06-05 20:10:21 -0700] info [realadduser] No password specified for cpanelroundcube [2010-06-05 20:10:22 -0700] info [realadduser] User cpanelroundcube added [2010-06-05 20:11:07 -0700] info [restartsrv_named] BSD::Resource not available. Resource Limits not adjusted [2010-06-05 20:11:07 -0700] info [restartsrv_named] BSD::Resource not available. Resource Limits not adjusted [2010-06-05 20:11:07 -0700] info [restartsrv_named] BSD::Resource not available. Resource Limits not adjusted [2010-06-05 20:11:13 -0700] info [mailperm] BSD::Resource not available. Resource Limits not adjusted [2010-06-05 20:11:27 -0700] warn [vps_optimizer] Unable to determine MySQL data directory from mysqladmin variables. at /scripts/cPScript/MysqlUtils.pm line 75 cPScript::MysqlUtils::getmysqldir() called at /scripts/vps_optimizer line 70 [2010-06-05 20:11:27 -0700] warn [vps_optimizer] Failed to determine MySQL data directory. Please check the MySQL installation. at /scripts/cPScript/MysqlUtils.pm line 83 cPScript::MysqlUtils::getmysqldir() called at /scripts/vps_optimizer line 70 [2010-06-05 20:33:06 -0700] info [cPScript::Config::LoadWwwAcctConf] Creating default /etc/wwwacct.conf at /scripts/cPScript/Config/LoadWwwAcctConf.pm line 84 cPScript::Config::LoadWwwAcctConf::loadwwwacctconf() called at /scripts/cPScript/HttpUtils/Conf.pm line 60
    0
  • cPanelPeter cPanel Staff
    Hello, Please provide the output of /etc/my.cnf # cat /etc/my.cnf Thank you
    0
  • quietFinn
    [quote="delfinparis, post: 1559151">Here's the entirety of the error_log - it looks like old errors from 2010, though.
    Your mySQL error log is from the same date, June 5. 2010. Is your server's date & time correct?
    0
  • delfinparis
    [quote="cPanelPeter, post: 1559192">Hello, Please provide the output of /etc/my.cnf # cat /etc/my.cnf Thank you
    Here you go! [mysqld] open_files_limit=22536 character-set-server=utf8 innodb_file_per_table=1 default-storage-engine=MyISAM [client] character-set-server=utf8
    [COLOR="silver">- - - Updated - - - [quote="quietFinn, post: 1559201">[quote="delfinparis, post: 1559151">Here's the entirety of the error_log - it looks like old errors from 2010, though. Your mySQL error log is from the same date, June 5. 2010. Is your server's date & time correct?
    Yes, the server time shows Wed Jan 29 10:02:49 CST 2014
    0
  • cPanelMichael
    How are you viewing your log files? Are you using a command such as "tail"? The date in your log files snippets do not match your server's date/time. Thank you.
    0
  • delfinparis
    [quote="cPanelMichael, post: 1559362">How are you viewing your log files? Are you using a command such as "tail"? The date in your log files snippets do not match your server's date/time. Thank you.
    Hi Michael, No I was using VIM. Oops! Here is the error_log file using "tail" main::domysql('initcache', ARRAY(0xae1f470)) called at cpanel line 1827 eval {...} called at cpanel line 1827 main::real_exectag('') called at cpanel line 4094 main::dotag_finished_headers(0) called at cpanel line 3914 main::cpanel_parseblock('\x0A\x0A\x0A\x0A\x0A\x09\x0A\x09 \x0A\x09\x0A\x09\x0A\x09 \x0A\x09\x0A\x0A\x0A
    \x09 \x0A\x0A\x0A \x0A\x0A\x0A\x0A

    \x0A\x0A\x0A
    \x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A\x0A
    \x0A\x09\x0A\x0A') called at cpanel line 3828 main::y(GLOB(0xab3c91c)) called at cpanel line 5183 main::run_standard_mode() called at cpanel line 769 [2014-01-30 11:15:40 -0600] warn [Mysql::initcache] Encountered error in Mysql::initcache: The mysql server is offline. /usr/bin/mysqladmin: unknown variable 'character-set-server=utf8'
    0
  • cPanelMichael
    Please remove the following line from the "Client" section of your /etc/my.cnf file and then restart MySQL: character-set-server=utf8
    This is a server value under the "Client" section, so it's not valid. Thank you.
    0
  • delfinparis
    You ROCK! That fixed it. Well done!
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post