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.sock file not found *new* error

Discussion in 'General Discussion' started by d00t, Nov 10, 2005.

  1. d00t

    d00t Member

    Joined:
    Sep 13, 2004
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    Yes I searched and read every post from the 32 threads matching this error, and also on ev1servers and wht and no solution works for me.

    THis is a brand new server.

    WHM error:
    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").

    SSH error:
    root@rock [/var/lib/mysql/mysql]# service mysql restart
    No mysqld pid file found. Looked for /var/lib/mysql/rock.mydomain.com.pid.

    There is no user 'mysql' and I've tried everything in other threads.

    While I have no idea if it ever worked, the only things I can think of that may have affected this since first logging in 1 hour ago is a hostname change and mysql root passwd modification.

    Any ideas?
     
  2. aby

    aby Well-Known Member

    Joined:
    May 31, 2005
    Messages:
    638
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India

    I think mysql is not properly installed.

    any errors when running

    /scripts/mysqlup --force
     
  3. d00t

    d00t Member

    Joined:
    Sep 13, 2004
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    you have to be fucking shitting me
     
  4. d00t

    d00t Member

    Joined:
    Sep 13, 2004
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    it worked :eek:
     
  5. d00t

    d00t Member

    Joined:
    Sep 13, 2004
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    in between my post and the cpanel gods looking down upon me, I updated everything, ./fixedeverything and rebooted.

    Thank you so so much dude :cool:
     
  6. ruraltowns

    ruraltowns Member

    Joined:
    Apr 20, 2005
    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    1
    IT WORKED......update

    We had this problem on a lot of servers and had to force updates OFTEN!

    Happened on our BSD 5.1, 5.2, 5,4 and CentOS 4.2 servers............

    Pain in the hinney to reset it every so often........IF you even KNOW it went DOWN!! ..lol

    Solved this by installing SIM package built into Xtra WHM Cpanel addon........

    It watches all services, system loads, CPUS loads, and restarts ANYTHING monitored that dies every 5 minutes from Cron, and emails admin about what went wrong! It checks for and then blocks system hackers permanently using ssh logins by IP. NO MORE 3 page secuirty logs to read..lol

    It even reboots the box if things get too far out of hand...

    Kinda hard to set up conf file....You MUST know WHAT services are running, where they start from, your dir structures, and how/where they restart from....But an auto conf walkthrough file included makes it pretty simple...lol

    IF you don't want all the goodies in Xtra ($35.00 a year RENTAL FEE)(including Anvanced Firewall Protection) to secure the server for you automatically, then just go get SIM (System Intergration Manger) online and install it alone to cure mysql sock deaths!

    Xtra ROCKS for dummies like me, in my opinion........
    This IS NOT a paid advertisment for WHM Xtra...........lol
    It just takes a LOT of admin load off someone who isn't qualified to be one !!..lol

    BTW...I never owned/operated a Linux based server until 2 weeks ago...
    What's Windows....I forget now!
     
Loading...

Share This Page