Applicable to:
- Plesk 12.5 for Linux
- Plesk 11.x for Windows
- Plesk 11.x for Linux
- Plesk 12.0 for Windows
- Plesk 12.0 for Linux
Symptoms
Domain database is not being migrated, migration completes with the following warning:
Warning: domain "domain.com"
Failed deployment of database domain_com_lp (domain domain.com)
Warning:
Failed to attach existing remote database domain_com_lp (domain domain.com). For security reasons data management does not supported for databases, which has no database users assigned
However the
domain_com_lp
database is located on the local server.
The following error can be observed in the
/usr/local/psa/PMM/logs/pmmcli.log
Unable to connect to database using supplied credentials
Cause
Database is not migrated due to credentials issue.
Also such warning may occur if there is no any user created under this database on the source server.
Resolution
First of all check if at least one user exists under this database. If it does then follow the steps below.
-
Create database backups on both source and destination servers:
mysqldump -uadmin -p` cat /etc/psa/.psa.shadow ` psa > /tmp/psadump.`date +%F_%H.%M`.sql
mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` mysql > /tmp/mysqldump.`date +%F_%H.%M`.sql
mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` --all-databases > /tmp/all.`date +%F_%H.%M`.sql -
On the source server change user credentials of the
domain_com_lp
database: go to Subscriptions > domain.com > Websites & Domains > Databases > domain_com_lp > domain_com_lp_user -
On the destination server drop the database in question:
mysql> drop database domain_com_lp
-
Try to migrate one more time.
Comments
0 comments
Please sign in to leave a comment.