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

Cannot Open Plesk CP

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by Kevin Medri, Jul 28, 2010.

  1. Kevin Medri

    Kevin Medri Guest

    0
     
    Hi I have just run a yum upgrade on php and mysql from the atomicorp repository and now recieve this error message:
    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' (2)

    0: common_func.php3:146
    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' (2)')
    1: auth.php3:93
    Also in ssh i cannot seem to start the service mysql, I am using command:
    service mysqld start
    This returns failed.
    Also my sites cannot connect to database.
    Any help would be great. Thank you.
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Try to enable logging for MySQL in /etc/my.cnf if it is not enabled and try to find a reason why mysql cant be started in mysql log.
     
  3. Kevin Medri

    Kevin Medri Guest

    0
     
    This is the error log when trying to start mysql:

    100729 19:54:18 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] option 'innodb-additional-mem-pool-size': signed value 512000 adjusted to 524288
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
    100729 19:54:18 [Note] Plugin 'ndbcluster' is disabled.
    /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
    100729 19:54:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
    100729 19:54:18 InnoDB: Started; log sequence number 0 24297565
    100729 19:54:18 [ERROR] /usr/libexec/mysqld: unknown option '--skip-bdb'
    100729 19:54:18 [ERROR] Aborting

    100729 19:54:18 InnoDB: Starting shutdown...
    100729 19:54:24 InnoDB: Shutdown completed; log sequence number 0 24297565
    100729 19:54:24 [Note] /usr/libexec/mysqld: Shutdown complete

    100729 19:54:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
  5. Kevin Medri

    Kevin Medri Guest

    0
     
    Thank you, another error is:
    can't connect to local mysql server through socket 'var/lib/mysql/mysql.sock'

    the mysql.sock file is not there, is it possible to recreate it?
     
  6. Kevin Medri

    Kevin Medri Guest

    0
     
Loading...