1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

ERROR 2002: Can't connect to local MySQL server through socket

Discussion in 'Plesk for Linux - 8.x and Older' started by teknovision, Jun 1, 2007.

  1. teknovision

    teknovision Guest

    0
     
    Hi all!

    I hope someone can help me because I am in a little bit of a pickle!!

    I tried to update from 7.5.x to the next version. I chose only to update 'Base Plesk' and 'Backup' - trying to backup and move to Plesk 8.1.0 on another provider but kept on getting errors relating to MySQL.

    Got the email to say it was being updated, then got email errors so tried to login and got the following error:

    ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

    So I followed some links and tried to restart PSA and MySQl with the following results:

    # /etc/init.d/psa restart
    ===> Reading /etc/psa/psa.conf ...
    /usr/local/psa/admin/bin/httpsdctl restart: httpd not running, trying to start
    db_connect: failed to connect to database: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    db_connect: failed to connect to database: Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    Key register failed
    /usr/local/psa/admin/bin/httpsdctl: line 227: 23995 Terminated $HTTPD
    /usr/local/psa/admin/bin/httpsdctl restart: httpd could not be started
    ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)


    # /etc/init.d/mysqld restart
    Stopping MySQL: [FAILED]
    Timeout error occurred trying to start MySQL Daemon.
    Starting MySQL: [FAILED]


    Not really sure what to do next, any ideas would be muchly appreciated as I currently can't get mail or do any of the backups I intended to do! Any help would be muchly appreciated!!

    Many thanks,

    Philippe
     
  2. rembrandt

    rembrandt Guest

    0
     
    check mysqld.log

    check your /var/log/mysqld.log MySQL isn't started and thus you can't do anything untill MySQL is up and running again.
     
  3. teknovision

    teknovision Guest

    0
     
    Thanks for your response unfortuntaely, this require SWSoft to get involved.

    It later transpires that database was corruptyed during upgrade, this occured because MySQL had been uprgaded to un unsupported version prior to me starting upgrade.

    Couple of things worth sharing 1) read compatibility/supported notes before upgrading and 2) backup should you ignore 1), it will save the day!!
     
Loading...