• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • 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.

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