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.

Server Died

Discussion in 'General Discussion' started by fanturex, Jun 4, 2005.

  1. fanturex

    fanturex Member

    Joined:
    Oct 19, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Hello

    One of our servers died today due to HDD failure, the DC replaced the HDD and reinstalled CPanel.

    We now have the following problem?

    mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").

    Is there a script to reinstall mysql and all associated componets.

    Many Thanks
     
  2. aby

    aby Well-Known Member

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

    didi you try

    /scripts/fixmysql ?

    -
    :) Aby
     
  3. fanturex

    fanturex Member

    Joined:
    Oct 19, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    Cheers,

    yep does not do anything

    Chris
     
  4. aby

    aby Well-Known Member

    Joined:
    May 31, 2005
    Messages:
    638
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    Do you have a mysql.sock file in the following locations

    /var/lib/mysql/mysql.sock
    /usr/local/lib/mysql.sock

    also a sym link at /tmp amd /var/tmp ........

    if there are no mysql.sock file then you may try
    /scripts/fixmysql --force

    then it will create a mysql.sock file at /var/lib. Then you have to manually copy it to /var/lib/


    if that is not working then
    /scripts/mysqlup

    if still not working then you may need to manulaly re-install the mysql
     
  5. fanturex

    fanturex Member

    Joined:
    Oct 19, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    yep it looks that way, I get the following when trying to use the scripts in cpanel:

    Ow along night ahead me thinks
     
  6. aby

    aby Well-Known Member

    Joined:
    May 31, 2005
    Messages:
    638
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    http://forums.cpanel.net/showthread...t=mysql+mirrors

    this should sort out your mirror list issue

    try these things too

    cp -fr /var/lib/mysql /var/lib/mysql.old

    rm -fr /var/lib/mysql

    rm -f server.pid

    rm -f /usr/sbin/mysqld

    /scripts/mysqlup --force

    restart mysql





    Also check
    /etc/my.cnf

    and make sure you have the following entries

    [mysqld]
    [mysqld] skip-innodb

    socket=/tmp/mysql.sock << or path to your .sock file



    if socket entry was already there

    then try removing it . Then restart it one or two times.

    Also verify if there are any mysql proceses running. if so kill it before you restart

    Also reseting the mysql password can help too .sometimes


    Good luck :)

    ------
    Aby
     
  7. fanturex

    fanturex Member

    Joined:
    Oct 19, 2003
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cheers have managed to install the required rpm's installed now all hell has broken looseeeee

    oww getting better now only gives the following error:

    Starting eximstats: DBI connect('eximstats:localhost','eximstats',...) failed: Access denied for user: 'eximstats@localhost' (Using password: YES) at /usr/local/cpanel/bin/eximstats line 262
    Can't Connect at /usr/local/cpanel/bin/eximstats line 265.

    Oww this will be a long night
     
    #7 fanturex, Jun 4, 2005
    Last edited: Jun 4, 2005
  8. bijo

    bijo Well-Known Member

    Joined:
    Aug 21, 2004
    Messages:
    475
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India

    Hello,

    Please have a look at this thread

    http://forums.cpanel.net/showthread...ng+eximstats:+DBI+failed:+Access+denied+user:
     
  9. cyanide

    cyanide Well-Known Member

    Joined:
    Aug 11, 2003
    Messages:
    106
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Toronto, Canada
    Sometimes just setting or re-setting the mysql root password will fix your initial problem.
    In WHM under Mysql, click the first link (MySQL Root Password), if that doesn't work, try the second link
     
Loading...

Share This Page