Error during migration: Unable to add database user: Password hash should be a 41-digit hexadecimal number

Created:

2017-01-12 16:50:45 UTC

Modified:

2017-08-17 14:55:18 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error during migration: Unable to add database user: Password hash should be a 41-digit hexadecimal number

Applicable to:

  • Plesk Onyx for Linux

Symptoms

The following errors appear during migration:

Unable to create database user 'user' in subscription 'example.com': Command execution failed on the local server with non-zero exit code. command: /usr/local/psa/bin/database --create-dbuser user -passwd '***hidden***' -domain example.com -database db -type mysql -server localhost:3306 -ignore-nonexistent-options exit code: 1 stdout: stderr: Unable to add database user: Password hash should be a 41-digit hexadecimal number

or

Plesk restore report problem: Execution of /usr/local/psa/admin/plib/api-cli/domain.php --update example.com -guid 938ccbdf-7592-445b-b3f4-8364c6ed1a95 -creation-date 2011-04-04 -hosting true -hst_type phys -do-not-apply-skeleton -ip 203.0.113.2 -www-root httpdocs -login user -passwd '' -passwd_type sym -hard_quota 1048576000B -shell /usr/local/psa/bin/chrootsh -ignore-nonexistent-options failed with return code 1.

or

Plesk restore report problem: Failed deployment of database user user of database db

or

Plesk restore report problem: Execution of /usr/local/psa/admin/plib/api-cli/database.php --update db -add_user user -server localhost:3306 -type mysql -print-id -default -set-acl % -passwd '' -passwd_type sym -ignore-nonexistent-options failed with return code 1.

Cause

The issue caused by several bugs with IDs: #PMT-3429 , #PMT-3431 which are planned to be fixed in future Plesk updates.

Resolution

As a workaround:

  1. Remove affected additional FTP user from the source server.
  2. Perform migration of the affected subscription.
  3. Create the FTP user on the target server manually.
Have more questions? Submit a request
Please sign in to leave a comment.