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 Server Restart Fail :(

Discussion in 'Database Discussions' started by semetrex, Mar 2, 2005.

  1. semetrex

    semetrex Member

    Joined:
    Jul 3, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Hi I have just had my server built and an reveiving the following error when restarting the SQL Server.

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

    mysql status


    DBI connect('mysql:localhost','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /scripts/restartsrv_mysql line 75 mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").

    Anybody any clues?

    Thanks

    Stuart
     
  2. chirpy

    chirpy Well-Known Member

    Joined:
    Jun 15, 2002
    Messages:
    13,475
    Likes Received:
    20
    Trophy Points:
    38
    Location:
    Go on, have a guess
    Check that you have a symlink in /tmp for:

    mysql.sock -> ../../var/lib/mysql/mysql.sock
     
  3. semetrex

    semetrex Member

    Joined:
    Jul 3, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Thanks for that reply

    Yip i got that in there....but still the same.

    Thanks

    Stuart
     
  4. germanette

    germanette Active Member

    Joined:
    Jul 26, 2003
    Messages:
    28
    Likes Received:
    0
    Trophy Points:
    1
    Is var/lib/mysql/mysql.sock there?
     
  5. semetrex

    semetrex Member

    Joined:
    Jul 3, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Resolved :)

    Hi,

    Just an update for anybody who has a similar problem, spoke to the hosting company who supplied the server they said that there was a bug in the Cpanel update tool and had to use the WGET command to get the SQL to install as it did not install the SQL Server when CPanel was initially installed onto the server.

    All working fine now.

    Hope this help anybody out.

    PLEASE NOTE: I am not saying you should request a reinstall if this is a problem on your server you should check it out first or pay try out a couple of things first.

    Thanks

    Stuart
     
  6. AndyReed

    AndyReed Well-Known Member
    PartnerNOC

    Joined:
    May 29, 2004
    Messages:
    2,222
    Likes Received:
    3
    Trophy Points:
    38
    Location:
    Minneapolis, MN
    I am not sure but I think that was a system administrator bug and not CPanel bug. Any way, problem solved and that's good.

    CHEERS :)
     
Loading...

Share This Page