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.

mysql has failed, please contact the sysadmin

Discussion in 'General Discussion' started by promak, Feb 5, 2004.

  1. promak

    promak Well-Known Member

    Joined:
    Oct 6, 2001
    Messages:
    248
    Likes Received:
    0
    Trophy Points:
    16
    Waiting for mysql to restart.... . . . . . . . . . . finished.

    mysql status


    mysql has failed, please contact the sysadmin (result was "/usr/bin/mysqlshow: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)").

    What can i do?

    also imap and DNS died!
     
  2. icehosting

    icehosting Well-Known Member

    Joined:
    Dec 22, 2002
    Messages:
    60
    Likes Received:
    0
    Trophy Points:
    6
    same problem here

    cPanel.net Support Ticket Number: 38424
     
  3. shann

    shann Well-Known Member

    Joined:
    Jul 5, 2002
    Messages:
    366
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Website Owner
    HI,

    Same problem here as well any solution?
     
  4. evolver

    evolver Well-Known Member

    Joined:
    Apr 14, 2003
    Messages:
    83
    Likes Received:
    0
    Trophy Points:
    6

    Same problem on our server... cPanel/WHM 9.0.0 R44...
     
  5. muse.mu

    muse.mu Registered

    Joined:
    Jul 1, 2004
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Any idea how to solve this problem?
     
  6. ricoche

    ricoche Well-Known Member

    Joined:
    Feb 7, 2003
    Messages:
    108
    Likes Received:
    0
    Trophy Points:
    16
    Yep, Just did an upgrade to Cpanel Release 64 from 55 and got this error. This potentially is a major problem it seems. Hopefully a solution will be found shortly. Our server was working flawlessly for quite some time until this upgrade.

    Thanks.
     
  7. ricoche

    ricoche Well-Known Member

    Joined:
    Feb 7, 2003
    Messages:
    108
    Likes Received:
    0
    Trophy Points:
    16
    I just upgraded to Stable 65 from Release 64 and the Mysql error is still there. Looks like I'm stuck now. :confused:
     
  8. richy

    richy Well-Known Member

    Joined:
    Jun 30, 2003
    Messages:
    276
    Likes Received:
    1
    Trophy Points:
    16
    Try /sbin/service mysql stop", "ps auxwww | grep mysql", then kill -9 all the MySQL processes still running and then /sbin/service mysql start - does it work?
     
  9. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    the basic problem is that the link for /var/lib/mysql.sock to /tmp/mysql.sock is broken.

    create it and it should work.

    also as richy has said; killing all the zoombie or orphan mysql processes will also help.
     
  10. Finkinstein

    Finkinstein Well-Known Member

    Joined:
    Mar 21, 2003
    Messages:
    131
    Likes Received:
    0
    Trophy Points:
    16
    I have the same problem and no mysql.sock linking crap is working. Nor is resetting the password or restarting mysql in any format you can give me... that I've tried (my disclaimer to looking stupid).

    Anywho... mysql is down.. eximstats is down.. bind is down.

    And I can't update..

    root@host [/var/lib/mysql]# /scripts/updatenow
    rsync: getaddrinfo: rsync.cpanel.net 873: Temporary failure in name resolution
    rsync error: error in socket IO (code 10) at clientserver.c(83)

    An Interesting predicament.
     
  11. linux-image

    linux-image Well-Known Member

    Joined:
    Jun 8, 2004
    Messages:
    1,192
    Likes Received:
    1
    Trophy Points:
    38
    Location:
    India
    cPanel Access Level:
    Root Administrator
    ====================
    pstree -ap | grep mysql
    ====================
    kill all the processes that are displayed. And then try a restart.


     
  12. Doctor

    Doctor Well-Known Member

    Joined:
    Apr 26, 2003
    Messages:
    180
    Likes Received:
    0
    Trophy Points:
    16
    Ever since I upgraded to STABLE-65, MySQL has become very unstable. The load climbs to the roof and then crashes MySQL. Like now... it is doing to all of us here. Has any of you issued a ticket to CPanel?
     
  13. energiserve

    energiserve Member

    Joined:
    May 31, 2003
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    I'm having exactly the same problems here.
     
  14. Sinewy

    Sinewy Well-Known Member

    Joined:
    May 15, 2004
    Messages:
    367
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Sydney, Australia
    cPanel Access Level:
    DataCenter Provider
    im on edge 124. absolutely no problems on fedora core 1.

    give bind a restart, if that still fails, edit /etc/resolv.conf so it uses external nameservers temporarily.

    then /scripts/updatenow it should update ur mysql.

    after that, service cpanel restart or the /etc/init.d/ equivalent. (that should restart eximstats)

    otherwise post here anymore problems :)
     
  15. Doctor

    Doctor Well-Known Member

    Joined:
    Apr 26, 2003
    Messages:
    180
    Likes Received:
    0
    Trophy Points:
    16

    No effect.... read my other post

    http://forums.cpanel.net/showthread.php?t=27024
     
Loading...

Share This Page