Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

SQL Server Restart Fail :(

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

  1. semetrex

    semetrex Member

    Joined:
    Jul 3, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    151
    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,460
    Likes Received:
    21
    Trophy Points:
    463
    Location:
    Go on, have a guess
    Check that you have a symlink in /tmp for:

    mysql.sock -> ../../var/lib/mysql/mysql.sock
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. semetrex

    semetrex Member

    Joined:
    Jul 3, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    151
    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:
    151
    Is var/lib/mysql/mysql.sock there?
     
  5. semetrex

    semetrex Member

    Joined:
    Jul 3, 2004
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    151
    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:
    4
    Trophy Points:
    193
    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 :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice