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.

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

Discussion in 'Database Discussions' started by Lordemma, Dec 19, 2013.

  1. Lordemma

    Lordemma Member

    Joined:
    Dec 19, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    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
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,478
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    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!
     
  3. Lordemma

    Lordemma Member

    Joined:
    Dec 19, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    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
     
  4. Lordemma

    Lordemma Member

    Joined:
    Dec 19, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    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 ?
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  6. Lordemma

    Lordemma Member

    Joined:
    Dec 19, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    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
     
  7. Lordemma

    Lordemma Member

    Joined:
    Dec 19, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    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 ?
     
  8. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,478
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
  9. Lordemma

    Lordemma Member

    Joined:
    Dec 19, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    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 - - -

    I have gone through that thread but no useful post. Please help.
    Thanks
     
  10. Lordemma

    Lordemma Member

    Joined:
    Dec 19, 2013
    Messages:
    11
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    root@bestservers [/]# 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
     
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    The primary error message I see is:

    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.
     
Loading...

Share This Page