Cannot Open Plesk CP

[Kevin Medri]

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.

 

[IgorG]

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.

 

[Kevin Medri]

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

 

[IgorG]

https://www.atomicorp.com/forum/viewtopic.php?f=1&t=4248

 

[Kevin Medri]

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?

 

[Kevin Medri]

Solved

Hi found link:

http://www.atomicorp.com/wiki/index.php/Mysql

Following this wiki solved all my problems!
Thanks parallels team, I found the link here!