• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

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