WHM taking too much time to respond restoring backups and terminating accounts

Lordemma

Member
Dec 19, 2013
11
0
1
cPanel Access Level
Root Administrator
I noticed this recently. My whm is taking too much time restoring cpanel backups as well as terminating accounts.
I recieved a cron mail with this info
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Lost connection to MySQL server at 'waiting for initial communication packet', system error: 95'

Please help.
what could be wrong and what can I do to fix this ?
Thanks
 

Infopro

Well-Known Member
May 20, 2003
17,113
507
613
Pennsylvania
cPanel Access Level
Root Administrator
Twitter
Your post reads like you've got 3 different issues. Restoring takes too long, Terminating takes too long, and your MySQL connection is dropping for some reason.

How big of an account are you restoring, and how are you restoring it? Explaining your steps and providing more Info that leads to the issue might be helpful.

Thanks!
 

Lordemma

Member
Dec 19, 2013
11
0
1
cPanel Access Level
Root Administrator
The last thing I can remember I did was editing my etc/my.cnf file adding some lines.
I guess the problem is with my sql.
I tried restarting it ang got this error
"Waiting for mysql to restart....................................................................finished.


mysql has failed, please contact the sysadmin (result was "mysql is not running").
Please what can I do to resolve this ? sorry for my nob question please
 

Lordemma

Member
Dec 19, 2013
11
0
1
cPanel Access Level
Root Administrator
I tried checking the error log on /var/lib/mysql/$(hostname).err via SSH but got an error
"Permission Denied"
please how can I access the log file ?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,912
2,241
363
I tried checking the error log on /var/lib/mysql/$(hostname).err via SSH but got an error
"Permission Denied"
please how can I access the log file ?
You can not enter a log file name directly into the command line. You have to use a utility such as "cat" or "tail -f" to view it. EX:

Code:
tail -500 /var/lib/mysql/$hostname.err
Thank you.
 

Lordemma

Member
Dec 19, 2013
11
0
1
cPanel Access Level
Root Administrator
Thanks for that! it works well now.
But I guess my problem is with the etc/my.cnf file I edited.
Can someone please provide me with a Good etc/my.cnf file I can just use to replace mine ?
please help if you can please with probably the one you are using.
Thanks
 

Lordemma

Member
Dec 19, 2013
11
0
1
cPanel Access Level
Root Administrator
mysql is not running

please my mysql is not running. I tried restarting it but got this error

"Waiting for mysql to restart....................................................................finished.


mysql has failed, please contact the sysadmin (result was "mysql is not running").
The error log is not giving me any tip as to whyy it's failing and I just edited my /etc/my.cnf file if that will fix it but to no avail.
Please help. How do I resolve this ?
 

Lordemma

Member
Dec 19, 2013
11
0
1
cPanel Access Level
Root Administrator
here is what is in my cnf file


[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 2M
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 64M

open_files_limit=12048
[mysqldump]
quick
max_allowed_packet = 16M


The log is not giving me any clue...I'm just getting fraustrated now..please help please

- - - Updated - - -

This comment may be of some use to you:
Re: MYSQL Configuration - cPanel Forums

HTH! :)
I have gone through that thread but no useful post. Please help.
Thanks
 

Lordemma

Member
Dec 19, 2013
11
0
1
cPanel Access Level
Root Administrator
[email protected] [/]# tail -f /var/lib/mysql/$(hostname).err
131223 00:47:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
131223 0:47:34 [Warning] The syntax '--log-slow-queries' is deprecated and will be removed in a future release. Please use '--slow-query-log'/'--slow-query-log-file' instead.
131223 0:47:34 [Note] Plugin 'InnoDB' is disabled.
131223 0:47:34 [Note] Plugin 'FEDERATED' is disabled.
131223 0:47:34 [ERROR] Unknown/unsupported storage engine: InnoDB
131223 0:47:34 [ERROR] Aborting

131223 0:47:34 [Note] /usr/sbin/mysqld: Shutdown complete

131223 00:47:34 mysqld_safe mysqld from pid file /var/lib/mysql/bestservers.gurushost.com.pid ended
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,912
2,241
363
The primary error message I see is:

[ERROR] Unknown/unsupported storage engine: InnoDB
Are you sure there are no InnoDB references in your /etc/my.cnf file, and that there are no additional issues in your MySQL error log related to InnoDB? What version of MySQL is installed?

Thank you.