Applicable to:
- Plesk Onyx 17.5 for Linux
Symptoms
-
Unable to import/export a database dump:
PLESK_ERROR: Internal error: [Account::getPassword] cannot decrypt password to be plain.
-
Errors in
/usr/local/psa/admin/logs/panel.log
with debug mode enabled:CONFIG_TEXT: 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
... -
Password of the domain database user is encrypted:
# plesk db "select * from db_users where login=johndoe;"
+-----+-----------------+------------+-------+--------+--------+--------------+--------+-------------+-----------+
| id | login | account_id | db_id | status | dom_id | db_server_id | passwd | external_id | role |
+-----+-----------------+------------+-------+--------+--------+--------------+--------+-------------+-----------+
| 10 | example | 15 | 0 | normal | 12 | 1 | | NULL | readWrite |
+-----+-----------------+------------+-------+--------+--------+--------------+--------+-------------+-----------+# plesk db "select * from accounts where id='15';"
+-----+-------+-------------------------------------------+
| id | type | password |
+-----+-------+-------------------------------------------+
| 15 | crypt | *ED642519186D3D29C6089E1D01B592D76B1EEC12 |
+-----+-------+-------------------------------------------+ -
The domain was migrated from non-Plesk hosting and website is not working:
CONFIG_TEXT: Error establishing database connection
Cause
Product issue:
-
#PPPM-7968 "A database user whose password is encrypted can now import and export the domain database after providing the database password."
Fixed in:- Plesk Obsidian 17 March 2020
Resolution
Workaround
If update is not possible for some reason you may try the following
Reset the database user password:
- Log into Plesk
- Go to Domains > example.com > Databases > User Management and click the user name
- Update the password (it is possible to use the same password):
Comments
0 comments
Please sign in to leave a comment.