Migration fails: Unable to add database user: Database user name is invalid

Symptoms

• Unable to migrate a database in Tools & Settings > Migration & Transfer Manager > source server with a database username more that 16 characters:

  PLESK_ERROR: Unable to create database user 'usernamewith16characters' in subscription 'example.com': Command execution failed on the local server with non-zero exit code.
  command: /usr/local/psa/bin/database --create-dbuser usernamewith16characters -passwd 'hidden' -domain example.com -any-database -type mysql -server localhost:3306 -ignore-nonexistent-options
  exit code: 1
  stdout:
  stderr: Unable to add database user: Database user name is invalid.

• On the target server limit for length of a database username in MariaDB was increased.

Cause

Support for database or user names longer than 16 characters is not implemented. A feature request with id #PPM-1889 was created.

Resolution

As a workaround:

1. Connect to the server via SSH.

2. Download the attached archive Checker.zip and extract it:

   # wget https://support.plesk.com/hc/en-us/article_attachments/115000725194/Checker.zip
   # unzip Checker.zip

3. Create a backup of the original Checker.php :

   # cp -a /usr/local/psa/admin/plib/Checker.php{,_backup}

4. Replace original file with the fixed:

   # mv Checker.php /usr/local/psa/admin/plib/

5. Open Tools & Settings > Migration & Transfer Manager > source server > example.com > Re-synk.

6. Select Business objects and Database data:
   
   

7. Click OK.