The database connection error occurs when a bunch of database files importing or exporting in Plesk by the user. The user will face the below error on the above activity.

Code:
Internal error: [Account::getPassword] cannot decrypt password to be plain
“Error establishing a database connection”- this error will be viewed if the user shifts a domain from a non-Plesk server.

Here are the errors if the debug option is enabled:

Code:
ERR [panel] Task failed: id=130, pid=111288, type=database-download, error=Internal error: [Account::getPassword] cannot decrypt password to be plain.
DEBUG [panel] PleskFatalException: Internal error: [Account::getPassword] cannot decrypt password to be plain.
file: /usr/local/psa/admin/plib/Account.php
line: 73
Furthermore, when the database user password got encoded will be unable to export or import the database. Hence the following error will appear.

Code:
# pleskdb "select * from db_users where login=hoststud;"
+-----+-----------------+------------+-------+--------+--------+--------------+--------+-------------+-----------+
| id | login | account_id | db_id | status | dom_id | db_server_id | passwd | external_id | role |
+-----+-----------------+------------+-------+--------+--------+--------------+--------+-------------+-----------+
| 10 | hoststud | 15 | 0 | normal | 12 | 1 | | NULL | readWrite |
+-----+-----------------+------------+-------+--------+--------+--------------+--------+-------------+-----------+
# pleskdb "select * from accounts where id='15';"
+-----+-------+-------------------------------------------+
| id | type | password |
+-----+-------+-------------------------------------------+
| 15 | crypt | *ED642519186D3D29C6089E1D01B592D76B1EEC12 |
+-----+-------+-------------------------------------------+
These errors are occurred due to design defect and will be resolved in Plesk Obsidian. And to overcome this error, updating Plesk using either the Command line or Plesk interface can be used.

Plesk Interface:

With the help of the Plesk panel, the updation can be made.
  • The user must make sure that the firewall is opened for port 8447 and select setting on tools.
  • Click on the update and upgrade option and select update components on the upgrade page.
  • The Pleskupdation process will get started after clicking on continue.

Command-line interface:
  • The user must get connected to the Plesk server with the help of Linux (SSH) or Windows server (RDP) to run below command:
Code:
Plesk installer update
  • Sometimes, the Plesk will be offline while updating and it will stay online if it requires a restart.
  • Every time the service will get restarted if the service component is updated.
  • By clicking on System Overview on the homepage, the user can know which Plask update is installed at present. Or run below command on the command-line interface to know the current updation of Plesk.
Code:
Plesk version
  • The user can reset the DB password if updation cannot be done due to any issues.
Resetting the Password:

Login to Plesk then in Domains click on example.com, then click Databases,

database.png


later User Management.

database1.png


Then, click on the username and update the password.
Author
kumkumsharma
Views
83
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from kumkumsharma

Top