ERROR: PleskFatalException

[Nestor Velazquez]

Greetings I have this problem and i can't find solutions related in the knowledge base.


ERROR: PleskFatalException

Components::componentUpdate() failed: Unable to exec utility packagemng: packagemng: Unable to update Components in DB: Lost connection to MySQL server during query

0: /usr/local/psa/admin/auto_prepend/auth.php3:524

From the console the error is as follows:

[root@servidor201 ~]# /etc/init.d/psa start
Starting xinetd service... done
Starting named service... done
Starting mysqld service... done
Starting qmail service... done
Starting courier-imap service... done
Starting postgresql service... not installed
Starting psa-spamassassin service... done
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2013 (HY000) at line 1: Lost connection to MySQL server during query
Starting Plesk... done

And the errors continue

ERROR: PleskFatalException
Components::componentUpdate() failed: Unable to exec utility packagemng: packagemng: Unable to connect to Plesk Database: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
System error 2: No such file or directory
packagemng: Unable to connect to the mysql database

System error 2: No such file or directory

0: /usr/local/psa/admin/auto_prepend/auth.php3:524


ERROR: PleskMainDBException
MySQL query failed: Lost connection to MySQL server during query

0: /usr/local/psa/admin/plib/common_func.php3:214
db_query(string 'select `id`,`name`,`place` from Skins where `id`=8')
1: /usr/local/psa/admin/plib/class.Table.php:180
Table->select()
2: /usr/local/psa/admin/plib/skin/Skin.php:63
Skin->Skin(integer '8')
3: /usr/local/psa/admin/plib/common_func.php3:2886
objectMaker(string 'Skin', integer '8')
4: /usr/local/psa/admin/auto_prepend/auth.php3:508


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: /usr/local/psa/admin/plib/common_func.php3:154
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: /usr/local/psa/admin/auto_prepend/auth.php3:87


The file mysql.sock

Please help me.

 

[Nataliya Zagr]

Hello,

Please, make sure that MySQL is running and you can access it from the command line:

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa

If it works, try to increase maximum connection number for MySQL server. By default the number of simultaneous connections is limited to 100, if MySQL is highly used on your server, you need to increase this limit in /etc/my.cnf in section [mysqld]:

[mysqld]

set-variable=max_connections=200

Then restart MySQL.

Also, please, make sure that the /tmp/mysql.sock file exists. If not, create the link:

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

 

[Nestor Velazquez]

Hello Nataliya Zagr thanks.
This information was very useful to me

 

[Nestor Velazquez]

Plesk Fatal Exception MySQL

Remeber if the hard disk don't have free space MySQL don't run!!!