Migration from DirectAdmin failed

[maarten]

Hi,

Currently trying to migrate some sites from DA to Panelica but failing.

[22:11:23] [success] [file_transfer] Step File Transfer completed in 9.287s
[22:11:23] [info] [file_transfer] Skipping step: Subdomain Migration
[22:11:23] [info] [database_import] Executing step: Database Import
[22:11:23] [info] [database_import] Discovering source MySQL authentication method...
[22:11:23] [success] [database_import] Found MySQL root password from DirectAdmin config
[22:11:23] [info] [database_import] Importing 1 database(s)
[22:11:23] [info] [database_import] Using Enterprise Database Migration Agent
[22:11:23] [info] [database_import] Priority: CONFIG_BASED → HASH_BASED fallback
[22:11:23] [info] [database_import] Importing database: prive_WP ()
[22:11:23] [info] [database_import] Querying source MySQL for user with access to prive_WP...
[22:11:23] [info] [database_import] Starting enterprise database user discovery...
[22:11:23] [info] [database_import] Method 0: 1 username(s) from site discovery: [prive_WPU]
[22:11:23] [info] [database_import] Method 0: no grant-verified user from site discovery, continuing to authoritative methods
[22:11:23] [info] [database_import] No user in mysql.db, trying alternative discovery methods...
[22:11:24] [info] [database_import] No user found by pattern, trying config file discovery...
[22:11:24] [success] [database_import] Found credentials in config file: user=prive_WPU
[22:11:24] [info] [database_import] User not in mysql.user, will create with password from config
[22:11:24] [success] [database_import] Found MySQL user: prive_WPU@localhost (plugin: mysql_native_password)
[22:11:24] [info] [database_import] Hash: ...
[22:11:24] [info] [database_import] Dump method available: mysqldump (/usr/bin/mysqldump)
[22:11:24] [success] [database_import] Detected 2 dump methods: [mysqldump sql_export]
[22:11:24] [info] [database_import] Attempting dump with mysqldump for database prive_WP
[22:11:24] [info] [database_import] MariaDB detected - skipping --set-gtid-purged (not supported)
[22:11:24] [warn] [database_import] Dump with mysqldump failed: dump failed: Process exited with status 2, stderr: mysqldump: Got error: 2002: "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" when trying to connect , trying next method...
[22:11:25] [info] [database_import] Attempting dump with sql_export for database prive_WP
[22:11:25] [warn] [database_import] Using SQL export fallback - this may be slower and miss some objects
[22:11:25] [warn] [database_import] Dump with sql_export failed: failed to get table list: Process exited with status 1, trying next method...
[22:11:25] [error] [database_import] Failed to dump prive_WP: failed to get table list: Process exited with status 1
[22:11:25] [info] [database_import] Database migration summary: 0 succeeded, 1 failed
[22:11:25] [error] [database_import] All 1 database(s) failed to migrate
[22:11:25] [error] [database_import] Step Database Import failed: all databases failed to migrate: failed to dump prive_WP: failed to get table list: Process exited with status 1
[22:11:25] [warn] [database_import] Starting rollback...

The DA setup consists of 2 servers, DA01 which hosts files and DA and DB01 which hosts only the MariaDB.
They both have external addresses but the DB connection runs over a second network with IP's 192.168.1.145 and 146, could this be the issue?

Best regards,
Maarten

 

[admin]

Hi Maarten,

Thank you for the detailed report and the log, that made it easy to find the cause.

Your guess is right. Your MariaDB runs on a separate server (DB01, reached over the internal network at 192.168.1.146), but the migration tool currently assumes the database is on the same server as DirectAdmin. It reads only the password from /usr/local/directadmin/conf/mysql.conf and ignores the host line, so it tries the local MySQL socket on DA01, finds nothing there, and the database step fails. The file transfer itself worked fine, and nothing on your setup is wrong.

This is a limitation on our side, and we will fix it so that DirectAdmin setups with a separate database server are supported. We cannot give a date yet, but we will post an update in this thread when it is available.

We have also answered your support ticket, where we can help you further.

Best regards,
Panelica Support Team