Difference between revisions of "Plesk Fatal Exception"

From Server Knowledge Base
Jump to navigationJump to search
(Created page with "== Plesk Fatal Exception == === Password File Deleted === If this errors come up in Plesk: <pre>ERROR: PleskFatalException Unable to connect to database: get_admin_passwor...")
 
 
(3 intermediate revisions by the same user not shown)
Line 52: Line 52:
<pre>ERROR 1049 (42000): Unknown database 'psa'
<pre>ERROR 1049 (42000): Unknown database 'psa'
/etc/init.d/psa: line 269: /opt/psa/admin/sbin/websrvmng: No such file or directory</pre>
/etc/init.d/psa: line 269: /opt/psa/admin/sbin/websrvmng: No such file or directory</pre>
The fix is below:


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


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


<pre>cat /etc/psa/.psa.shadow</pre>
<pre>cat /etc/psa/.psa.shadow</pre>
'''Copy the password including == ''' (This is the Encrypted_Password used later)
'''Copy the password including == ''' (This is the Encrypted_Password used later)
<pre>/etc/init.d/mysql stop (/etc/init.d/mysqld stop for CentOS)
<pre>/etc/init.d/mysql stop (/etc/init.d/mysqld stop for CentOS)
ps aux | grep mysql
ps aux | grep mysql | grep -v grep
kill <process_ID>
kill <process_ID>
mysqld_safe --skip-grant-tables &
mysqld_safe --skip-grant-tables &
mysql -uadmin -p
mysql -uadmin -p</pre>
*Press enter*
 
use mysql
Press enter
 
<pre>use mysql
select password from mysql.user where user="admin";</pre>
select password from mysql.user where user="admin";</pre>
Copy password beginning with * just in case
Copy password beginning with * just in case
Line 163: Line 167:
   UIPointer->access(string 'GET')
   UIPointer->access(string 'GET')
2: plesk.php:52</pre>
2: plesk.php:52</pre>
== Domain cannot be opened ==
SysUser: unable to select: no such row in the table
<pre>Internal error: Unable to load object of type SysUser with id=1: SysUser: unable to select: no such row in the table
Message    Unable to load object of type SysUser with id=1: SysUser: unable to select: no such row in the table
File    common_func.php3
Type    PleskFatalException</pre>
<pre>Unable to create SysUser object: SysUser: unable to select: no such row in the table
0: /usr/local/psa/admin/plib/class.DomainControlForm.php:168
    DomainControlForm->assign(object of type BsDomain)
1: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:149</pre>
http://kb.parallels.com/en/6661

Latest revision as of 09:51, 23 April 2013

Plesk Fatal Exception

Password File Deleted

If this errors come up in Plesk:

ERROR: PleskFatalException
Unable to connect to database: get_admin_password() failed: file_get_contents() failed: Constant PRODUCT_MODE already defined

0: common_func.php3:93
   psaerror(string 'Unable to connect to database: get_admin_password() failed: file_get_contents() failed: Constant PRODUCT_MODE already defined')
1: auth.php3:125
ERROR: PleskFatalException
Unable to connect to database: get_admin_password() failed: file_get_contents() failed: Constant PRODUCT_MODE already defined

0: common_func.php3:93
   psaerror(string 'Unable to connect to database: get_admin_password() failed: file_get_contents() failed: Constant PRODUCT_MODE already defined')
1: auth.php3:125

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:

ERROR: PleskFatalException
Unable to connect to database: saved admin password is incorrect.

0: common_func.php3:139
	psaerror(string 'Unable to connect to database: saved admin password is incorrect.')
1: auth.php3:125
ERROR: PleskFatalException
Unable to connect to database: saved admin password is incorrect.

0: common_func.php3:139
	psaerror(string 'Unable to connect to database: saved admin password is incorrect.')
1: auth.php3:125
ERROR: PleskFatalException
Unable to connect to database: saved admin password is incorrect.

0: common_func.php3:150
psaerror(string 'Unable to connect to database: saved admin password is incorrect.')
1: auth.php3:107
ERROR: PleskFatalException
Unable to connect to database: saved admin password is incorrect.

0: common_func.php3:150
psaerror(string 'Unable to connect to database: saved admin password is incorrect.')
1: auth.php3:107
ERROR 1049 (42000): Unknown database 'psa'
/etc/init.d/psa: line 269: /opt/psa/admin/sbin/websrvmng: No such file or directory

The fix is below:

Saved admin password fix

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

cat /etc/psa/.psa.shadow

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

/etc/init.d/mysql stop (/etc/init.d/mysqld stop for CentOS)
ps aux | grep mysql | grep -v grep
kill <process_ID>
mysqld_safe --skip-grant-tables &
mysql -uadmin -p

Press enter

use mysql
select password from mysql.user where user="admin";

Copy password beginning with * just in case

update user set password=password('Encrypted_Password') where user="admin";
flush privileges;
quit
/etc/init.d/mysql stop (/etc/init.d/mysqld stop for CentOS)
kill <process_IDs>
/etc/init.d/mysql start (/etc/init.d/mysqld start for CentOS)

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() [<a href='function.mysql-connect'>function.mysql-connect</a>]: 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() [<a href='function.mysql-connect'>function.mysql-connect</a>]: 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() [<a href='function.mysql-connect'>function.mysql-connect</a>]: 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() [<a href='function.mysql-connect'>function.mysql-connect</a>]: 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() [<a href='function.mysql-connect'>function.mysql-connect</a>]: 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() [<a href='function.mysql-connect'>function.mysql-connect</a>]: 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:

120724 10:30:15InnoDB: Warning: difficult to find free blocks from
InnoDB: the buffer pool (2299 search iterations)! Consider
InnoDB: increasing the buffer pool size.
InnoDB: It is also possible that in your Unix version
InnoDB: fsync is very slow, or completely frozen inside
InnoDB: the OS kernel. Then upgrading to a newer version
InnoDB: of your operating system may help. Look at the
InnoDB: number of fsyncs in diagnostic info below.
InnoDB: Pending flushes (fsync) log: 0; buffer pool: 0
InnoDB: 130 OS file reads, 0 OS file writes, 0 OS fsyncs
InnoDB: Starting InnoDB Monitor to print further
InnoDB: diagnostics to the standard output.

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:

Database Connection Error

DB Error: connect failed
Verify the SQL database is running
Check the SQL server is listening to the specified socket, IP address
Check the global configuration file (/var/www/atmail/libs/Atmail/Config.php) for the correct database details
Verify the database server is running correctly
Verify the MySQL /etc/my.cnf file has the correct settings for the number of database connections

Disabling Crontab

ERROR: PleskFatalException
Crontab->export() failed: crontabmng failed:
crontabmng syntax:
   list
      to list all users that have modifiable crontab
   get <username>
      to show crontab of <username>
   set <username> <filename>
      to set crontab of <username> from <filename>
   allow <username>
      to allow crontab of <username>
   deny <username>
      to deny crontab of <username>
   remove <username>
      to remove crontab of <username>

System error: crontab execution error

Additionally, an exception has occurred while trying to report this error: PleskObjectNotFoundException
Object not found: Scheduled tasks

0: CrontabTaskToggleUIPointer.php:51
   CrontabTaskToggleUIPointer->accessItem(string 'GET', NULL null)
1: UIPointer.php:595
   UIPointer->access(string 'GET')
2: plesk.php:52

Domain cannot be opened

SysUser: unable to select: no such row in the table

Internal error: Unable to load object of type SysUser with id=1: SysUser: unable to select: no such row in the table
Message    Unable to load object of type SysUser with id=1: SysUser: unable to select: no such row in the table
File    common_func.php3
Type    PleskFatalException
Unable to create SysUser object: SysUser: unable to select: no such row in the table

0: /usr/local/psa/admin/plib/class.DomainControlForm.php:168
    DomainControlForm->assign(object of type BsDomain)
1: /usr/local/psa/admin/htdocs/domains/dom_ctrl.php3:149

http://kb.parallels.com/en/6661