Applicable to:
- Plesk Onyx for Linux
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. This is a Plesk bug with id #PPM-1889 which will be fixed in future Plesk versions.
Resolution
As a workaround:
-
Connect to the server via SSH.
-
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 -
Create a backup of the original
Checker.php
:# cp -a /usr/local/psa/admin/plib/Checker.php{,_backup}
-
Replace original file with the fixed:
# mv Checker.php /usr/local/psa/admin/plib/
-
Open Tools & Settings > Migration & Transfer Manager > source server > example.com > Re-synk.
-
Select Business objects and Database data:
-
Click OK.
Comments
0 comments
Please sign in to leave a comment.