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.

SQL Stopping.

Discussion in 'Database Discussions' started by BlazeHost, May 15, 2012.

  1. BlazeHost

    BlazeHost Member

    Joined:
    May 4, 2012
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    My MySQL Keep going off, it wont let me connect but its still running. I'm running the newest version of cpanel on centos.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    You can check the MySQL error log for any specific error messages. By default, it's located at:

    /var/lib/mysql/hostname.err

    Replace "hostname" with the hostname of your server.

    Thank you.
     
  3. BlazeHost

    BlazeHost Member

    Joined:
    May 4, 2012
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    It says
    root@nl [~]# /var/lib/mysql/**.****.net.err
    -bash: /var/lib/mysql/**.****.net.err: Permission denied
     
  4. BlazeHost

    BlazeHost Member

    Joined:
    May 4, 2012
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Also

    root@nl [~]# service httpd restart
    Warning: DocumentRoot [/home/techover/public_html] does not exist
    Warning: DocumentRoot [/home/techover/public_html/teamvirus] does not exist

    I can no longer start httpd...
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You will need to browse the MySQL error log using a command such as "tail". EX:

    Code:
    # tail -f /var/lib/mysql/hostname.err
    As for the Apache service, the warnings you pasted should not prevent Apache from starting. Check to see if the "httpd" process is active with a command such as:

    Code:
    # pidof httpd
    You can also submit a ticket if you want us to take a closer look:

    Submit A Ticket

    Thank you.
     
  6. BlazeHost

    BlazeHost Member

    Joined:
    May 4, 2012
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Code:
    120516 22:14:07 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and should be repaired
    120516 22:14:08 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and should be repaired
    120516 22:14:21 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and should be repaired
    120516 22:14:21 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and should be repaired
    120516 22:14:21 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and should be repaired
    120516 22:14:21 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and should be repaired
    120516 22:14:24 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and should be repaired
    120516 22:14:34 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and should be repaired
    120516 22:14:41 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and should be repaired
    120516 22:14:41 [ERROR] /usr/sbin/mysqld: Table './eximstats/smtp' is marked as crashed and should be repaired

    That's what it gives me.
     
  7. krec

    krec Registered

    Joined:
    Dec 18, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Minsk
    myisamchk -r /var/lib/mysql/eximstats/smtp.MYI
     
Loading...

Share This Page