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.

Help MYSQL is dead and refuses to restart

Discussion in 'General Discussion' started by Snowman30, Jul 4, 2007.

  1. Snowman30

    Snowman30 Well-Known Member
    PartnerNOC

    Joined:
    Apr 7, 2002
    Messages:
    681
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    I have a problem with MySQL refusing to restart:

    root@colin [/var/tmp]# /scripts/restartsrv mysql
    Waiting for mysql to restart..............finished.



    /usr/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'
    Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
    mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").
    root@colin [/var/tmp]#
    [/quote]

    Im running mysql 5.0.27 on WHM 11.1.0 cPanel 11.4.19-R14378
    CENTOS Enterprise 3.8 i686 - WHM X v3.1.0

    Ive tried /scripts/upcp --force
    /scripts/mysqlup --force

    nothing works

    heres the error log for mysql:

    ive also tried to lodge a cpanel ticket and their system is bugging out with an error\

    can anyone assist?
     
  2. rpmws

    rpmws Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    1,824
    Likes Received:
    5
    Trophy Points:
    38
    Location:
    back woods of NC, USA
    just for the hell of it do this:
    /scripts/restartsrv mysql

    if that fails ..
    rm /etc/my.cnf
    /scripts/mysqlup --force
    then
    /scripts/restartsrv mysql


    what ya get?
     
  3. Snowman30

    Snowman30 Well-Known Member
    PartnerNOC

    Joined:
    Apr 7, 2002
    Messages:
    681
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    same error, already tried that
     
  4. rpmws

    rpmws Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    1,824
    Likes Received:
    5
    Trophy Points:
    38
    Location:
    back woods of NC, USA
    you removed the my.cnf file?

    do you have a link in /tmp ?
    mysql.sock -> ../../var/lib/mysql/mysql.sock=

    I guess you could try touching a mysql.sock file in /var/lib/mysql/mysql.sock or delete it if one is there. ??

    I have seen this before and this is what I managed to do to get it working.
     
  5. rpmws

    rpmws Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    1,824
    Likes Received:
    5
    Trophy Points:
    38
    Location:
    back woods of NC, USA
    so it complains if can't find the sock? or it shows the errors you posted? I am wondering if you could get it to run if you move all your databases out just for now from the /var/lib/mysql/ folder .. keep them safe. see if will run. I suppose it could be a perms issue?
     
  6. Snowman30

    Snowman30 Well-Known Member
    PartnerNOC

    Joined:
    Apr 7, 2002
    Messages:
    681
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    yes my.cnf file was removed and a orced mysqlup has been done

    ive tried it with and without a link to mysql.sock in tmp and i have tried toucing mysql.sock in /var/lib/mysql

    no joy same errors:
     
  7. rpmws

    rpmws Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    1,824
    Likes Received:
    5
    Trophy Points:
    38
    Location:
    back woods of NC, USA
    my sock file by the way is owned by mysql ..check perms

    srwxrwxrwx 1 mysql mysql 0 Jul 5 01:17 mysql.sock=
     
  8. rpmws

    rpmws Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    1,824
    Likes Received:
    5
    Trophy Points:
    38
    Location:
    back woods of NC, USA

    i didn't read all those errors before. you have some crashed db's i suppose and the sock never gets created cause it knows it can't run yet.

    did you see this?
    http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
     
  9. Snowman30

    Snowman30 Well-Known Member
    PartnerNOC

    Joined:
    Apr 7, 2002
    Messages:
    681
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider

    ive reviewed the mysql docs and sadly they are completely useless when mysql and mysqladmin refuse to start
     
  10. Snowman30

    Snowman30 Well-Known Member
    PartnerNOC

    Joined:
    Apr 7, 2002
    Messages:
    681
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    DataCenter Provider
    InnoDB seems to have been the problem so i have added skip-innodb to my.cnf and ive got it back online
     
Loading...

Share This Page