Migration from DirectAdmin: Unable to assimilate database

Created:

2017-03-17 14:27:09 UTC

Modified:

2017-08-16 17:08:29 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Migration from DirectAdmin: Unable to assimilate database

Applicable to:

  • Plesk for Linux

Symptoms

Different remote MySQL database servers connected to Plesk and DirectAdmin have the same hostnames.

The error appears in migration logs:

[17 Mar 17 14:17:32] [Migration] Unable to assimilate database 'database_name' in subscription 'example.com': Command execution failed on the local server with non-zero exit code.
command: /usr/local/psa/bin/database --register database_name -domain example.com -skip-webspace-checking -type mysql -server remote.mysql_server.com:3306 -ignore-nonexistent-options
exit code: 4
stdout:
stderr: Database with such name does not exist on target database server.
[17 Mar 17 14:17:32] [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 --register-dbuser user -passwd 'hidden' -domain example.com -any-database -type mysql -server remote.mysql.com:3306 -ignore-nonexistent-options
exit code: 4
stdout:
stderr: Database user with such login does not exist on target database server.

remote.mysql_server.com name is specified in /usr/local/directadmin/conf/mysql.conf on the source (DirectAdmin) server.

remote.mysql_server.com and remote.mysql_server.net names are specified for a remote database server on the destination server.

Cause

MySQL database assimilation detected if source and target database hostnames are resolving to the same IP addresses from target server.

This is Plesk Migrator bug with ID #PMT-3557 which will be fixed in future product updates.

Resolution

Only during a migration process perform one of the following changes:

1. Replace remote mysql server hostname with its IP address in /usr/local/directadmin/conf/mysql.conf file.

OR

2. Add/modify a record in /etc/hosts file on a destination server in the this way:

192.0.2.2 remote.mysql_server.com

where 192.0.2.2 - is the IP address of the source remote database server.

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