2013-01-15

Created page with "== Plesk Fatal Exception == === Password File Deleted === If this errors come up in Plesk:

The Plesk password file /etc/psa/.psa.shadow has been removed thus causing the inability for Plesk to connect to MySQL. Recreate the file and reset the Plesk password.

==== saved admin password is incorrect (MySQL Entry) ====

If you receive ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES) or:

===== Saved admin password fix =====

Check if there is a psa database. The fix When going into MySQL or to Plesk do the following:

'''Copy the password including == ''' (This is the Encrypted_Password used later)

Copy password beginning with * just in case

Refresh Plesk. If the server does not have the psa database or the fix does not work, rebuild it.

=== Can't connect to MySQL Database ===

''ERROR: PleskFatalException''

''Unable to connect to database: mysql_connect() [function.mysql-connect]:''

''Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)''

''0: common_func.php3:93''

''psaerror(string 'Unable to connect to database: mysql_connect() [function.mysql-connect]:''

''Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)')''

''1: auth.php3:127''

''The MySQL service did not load when the server was started.''

'''Solution: stop/start or restart the MySQL service. If you get the below error:'''

''ERROR: PleskFatalException''

''Unable to connect to database: mysql_connect() [function.mysql-connect]:'' ''Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)''

''0: common_func.php3:150''

''psaerror(string 'Unable to connect to database: mysql_connect() [function.mysql-connect]:'' ''Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)')''

''1: auth.php3:107''

''ERROR: PleskFatalException''

''Unable to connect to database: mysql_connect() [function.mysql-connect]:'' ''Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)''

''0: common_func.php3:150''

''psaerror(string 'Unable to connect to database: mysql_connect() [function.mysql-connect]:'' ''Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)')''

''1: auth.php3:107''

Check the error log /var/log/mysql/error.log to see if you can see:

This generally means a large amount of data is being written to MySQL. Try to confirm which databases use large BLOB or Text fields and if you are importing lots of records.

Increase the innodb_buffer_pool_size entry in my.cnf from 2M to 20M. The ibdata file can be large in size (5-20GB+) however any larger can cause issues. Altering query_cache_size may help too. Restart MySQL.

You may also get the below error when accessing emails:

=== Disabling Crontab ===

Show more