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

Mysql keeps going down after upgrade

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by JillW, Aug 25, 2009.

  1. JillW

    JillW Guest

    0
     
    Last week we upgraded Plesk and now every day the mysql server keeps going down. Server support people haven't been much help.

    How can we tell where the problem is and how to fix it?
     
  2. Denis Sirochenko

    Denis Sirochenko Guest

    0
     
    Hello,

    Could you provide more details of the issue? What messages you receive, was the upgrade alright or not and so on.

    Regards,
    Denis.
     
  3. JillW

    JillW Guest

    0
     
    The upgrade all seemed to go fine at first. But then the server kept "going down" every few hours.

    Error on main part of the site is:

    Cannot connect to the database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)

    And our Invision Board Forum error is their usual:

    IPS Driver Error

    It seems to me (as someone who doesn't know much about this stuff) that there's some sort of problem or incompatibility with the mysql as that is what keeps going down.
     
  4. Maa

    Maa Guest

    0
     
    Check error logs:

    # grep -i error /etc/mysql/my.cnf
    # Error logging goes to syslog. This is a Debian improvement :)

    # grep -i error /etc/my.cnf
    log-error=/var/log/mysqld.log

    In the tail of errorlog/syslog you can find something useful.
     
  5. JillW

    JillW Guest

    0
     
    Here's the Plesk error:

    ERROR: PleskFatalException
    Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)

    0: common_func.php3:108
    psaerror(string 'Unable to connect to database: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)')
    1: auth.php3:93

    Is there a way to get plesk support for this? My server company can't seem to figure anything out.
     
  6. JillW

    JillW Guest

    0
     
    All I get is "No Such File or Directory" (when I try your grep stuff above.)
     
    Last edited by a moderator: Aug 27, 2009
  7. Geoff Winans

    Geoff Winans Guest

    0
     
    Are you on a virtual dedicated server, by chance?
     
  8. JillW

    JillW Guest

    0
     
    It's a dedicated server.
     
  9. Michael neese

    Michael neese Guest

    0
     
    you must correctly locate the my.cnf file on your server, then run the "grep stuf" with the correct file path!

    command line "locate my.cnf"

    If this is so foreign to you, why are you being so accusatory and nasty! Fewer people will want to jump in and help.
     
Loading...