• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

Resolved Migration from Azure error

srpulpo

New Pleskian
Server operating system version
Ubuntu 22.04
Plesk version and microupdate number
Versión 18.0.58 Actualización 2
I can't start a migration from Azure to my new server on Strato.

When I filled all the data (root user, ssh file, etc...) and start the process I have this error:

Failed to fetch basic information about resellers, clients and domains data from source servers
Cause: Failed to execute SQL query on Plesk database: failed to parse JSON returned by SQL script.
Query:
SELECT Subscriptions.id as subscription_id, clients.id, login, pname
FROM clients
LEFT JOIN Subscriptions ON
Subscriptions.object_id = clients.id
AND Subscriptions.object_type = 'client'
WHERE clients.type = 'reseller'

Command's exit code: 255
Command's stdout:
Command's stderr: Died at AgentConfig.pm line 23.

That is a critical error, migration was stopped.

I tried to do this query on my Azure SQL but doesn't work.

Please, help. Thanks!!
 
It might just be caused by a missing root login permission on the source server. The error message shown is misleading that it is a database issue. It is more likely a root login issue. Is "root" user login permitted on the source server and are the credentials correct?
 
This is an Azure Ubuntu server, root ssh login is disabled and it can’t be enabled… only can access via .pem keys

If I make that query in psa db on source server I have this error: fields doesn’t exist

What can I do? I need to migrate more than 15 subscriptions and 25 domains… :,(
 
Back
Top