Database is not being migrated: "For security reasons data management is not supported for databases, which have no database users assigned"

Created:

2016-11-16 12:59:24 UTC

Modified:

2017-06-09 09:17:44 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Database is not being migrated: "For security reasons data management is not supported for databases, which have no database users assigned"

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.0 for Windows
  • Plesk 11.5 for Windows
  • Plesk 11.5 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.

  1. 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
  2. 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

  3. On the destination server drop the database in question:

    mysql> drop database domain_com_lp
  4. Try to migrate one more time.

Have more questions? Submit a request
Please sign in to leave a comment.