• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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