Resolved Migration from 12.5.30 to AWS Plesk Onyx error

[RickandRoll]

Hi Community,
I stuck with Migration Manager error on my t2.micro instance. I'm using trial Plesk Onyx license for it.
The goal is evaluate migration process from dedicated server to Amazon EC2
Migration fails with following error
===========================
Failed to perform action: Check connections
Cause: Command execution failed on the source server 'source' (216.122.144.170) with non-zero exit code.
command: /bin/grep -m1 -E '^\s*PRODUCT_ROOT_D' /etc/psa/psa.conf
exit code: 1
stdout:
stderr: LANG=en_US.utf-8: Command not found.

That is a critical error, migration was stopped.
============================



'/bin/grep -m1 -E '^\s*PRODUCT_ROOT_D' /etc/psa/psa.conf' works perfectly from command prompt on target site like ssh [email protected] "/bin/grep -m1 -E '^\s*PRODUCT_ROOT_D' /etc/psa/psa.conf" and on source server as well.
See attached file for migration parameters.
Thank you


debug.log
===========================================================
+|2017-02-22_14:14:35,538|D|MT|core.workflow.runner.base|||MIGRATOR START: /usr/local/psa/admin/sbin/modules//panel-migrator/plesk-migrator generate-migration-list /usr/local/psa/var/modules/panel-migrator/sessions/20170222141435/config.ini --migration-list-format=json --migration-list-file=/usr/local/psa/var/modules/panel-migrator/sessions/20170222141435/migration-list-raw.json --skip-services-checks --include-existing-subscriptions --overwrite --reload-source-data
+|2017-02-22_14:14:35,547|D|MT|core.workflow.runner.by_subscription|||Enter common action block
+|2017-02-22_14:14:35,548|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2017-02-22_14:14:35,548|D|MT|core.workflow.runner.by_subscription|||START: Check if migration list file already exists
+|2017-02-22_14:14:35,548|D|MT|core.workflow.runner.by_subscription|||FINISH: Check if migration list file already exists
+|2017-02-22_14:14:35,548|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2017-02-22_14:14:35,548|D|MT|core.workflow.runner.by_subscription|||Check that command line options are correct
+|2017-02-22_14:14:35,548|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2017-02-22_14:14:35,549|D|MT|core.workflow.runner.by_subscription|||No need to execute action, continue to the next one
+|2017-02-22_14:14:35,549|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2017-02-22_14:14:35,549|D|MT|core.workflow.runner.by_subscription|||No need to execute action, continue to the next one
+|2017-02-22_14:14:35,549|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2017-02-22_14:14:35,549|I|MT|core.workflow.runner.by_subscription|||START: Check connections
+|2017-02-22_14:14:35,549|D|MT|core.migrator|||Check connections to target servers
+|2017-02-22_14:14:35,549|D|MT|core.connections.checker|||Check API connection for target Plesk server.
+|2017-02-22_14:14:35,550|D|MT|core.runners.base|||Execute command on the local server: /bin/grep -m1 -E '^\s*PRODUCT_ROOT_D' /etc/psa/psa.conf
+|2017-02-22_14:14:35,553|D|MT|core.runners.base|||Command execution results:
=|2017-02-22_14:14:35,553|D|MT|core.runners.base|||stdout: PRODUCT_ROOT_D /usr/local/psa
=|2017-02-22_14:14:35,553|D|MT|core.runners.base|||
=|2017-02-22_14:14:35,553|D|MT|core.runners.base|||stderr:
=|2017-02-22_14:14:35,553|D|MT|core.runners.base|||exit code: 0
+|2017-02-22_14:14:35,553|D|MT|core.utils.plesk_utils|||Unix product root directory: /usr/local/psa
+|2017-02-22_14:14:35,553|D|MT|core.runners.base|||Execute command on the local server: /usr/local/psa/bin/secret_key --list
+|2017-02-22_14:14:35,718|D|MT|core.runners.base|||Command execution results:
=|2017-02-22_14:14:35,718|D|MT|core.runners.base|||stdout: ***hidden***
=|2017-02-22_14:14:35,718|D|MT|core.runners.base|||stderr: ***hidden***
=|2017-02-22_14:14:35,718|D|MT|core.runners.base|||exit code: 0
+|2017-02-22_14:14:35,722|D|MT|core.utils.common.http_xml_client|||API request to https://10.199.1.132:8443/enterprise/control/agent.php:
=|2017-02-22_14:14:35,722|D|MT|core.utils.common.http_xml_client|||<?xml version="1.0" encoding="utf-8"?>
=|2017-02-22_14:14:35,722|D|MT|core.utils.common.http_xml_client|||<packet version="1.5.2.1">
=|2017-02-22_14:14:35,722|D|MT|core.utils.common.http_xml_client||| <server>
=|2017-02-22_14:14:35,722|D|MT|core.utils.common.http_xml_client||| <get>
=|2017-02-22_14:14:35,722|D|MT|core.utils.common.http_xml_client||| <stat/>
=|2017-02-22_14:14:35,722|D|MT|core.utils.common.http_xml_client||| </get>
=|2017-02-22_14:14:35,722|D|MT|core.utils.common.http_xml_client||| </server>
=|2017-02-22_14:14:35,722|D|MT|core.utils.common.http_xml_client|||</packet>
=|2017-02-22_14:14:35,722|D|MT|core.utils.common.http_xml_client|||
+|2017-02-22_14:14:35,827|D|MT|core.utils.common.http_xml_client|||API response from https://10.199.1.132:8443/enterprise/control/agent.php:
=|2017-02-22_14:14:35,827|D|MT|core.utils.common.http_xml_client|||<packet version="1.5.2.1">
=|2017-02-22_14:14:35,827|D|MT|core.utils.common.http_xml_client||| <server>
=|2017-02-22_14:14:35,827|D|MT|core.utils.common.http_xml_client||| <get>
=|2017-02-22_14:14:35,827|D|MT|core.utils.common.http_xml_client||| <result>
=|2017-02-22_14:14:35,827|D|MT|core.utils.common.http_xml_client||| <status>ok</status>
=|2017-02-22_14:14:35,827|D|MT|core.utils.common.http_xml_client||| <stat>
=|2017-02-22_14:14:35,827|D|MT|core.utils.common.http_xml_client||| <objects>
=|2017-02-22_14:14:35,827|D|MT|core.utils.common.http_xml_client||| <clients>0</clients>
=|2017-02-22_14:14:35,827|D|MT|core.utils.common.http_xml_client||| <domains>0</domains>
=|2017-02-22_14:14:35,827|D|MT|core.utils.common.http_xml_client|||


CUT

=|2017-02-22_14:14:35,941|D|MT|core.utils.common.http_xml_client||| <value>false</value>
=|2017-02-22_14:14:35,941|D|MT|core.utils.common.http_xml_client||| </aspect>
=|2017-02-22_14:14:35,941|D|MT|core.utils.common.http_xml_client||| </vps-optimized-status>
=|2017-02-22_14:14:35,941|D|MT|core.utils.common.http_xml_client||| <mode>standard</mode>
=|2017-02-22_14:14:35,941|D|MT|core.utils.common.http_xml_client||| </gen_info>
=|2017-02-22_14:14:35,941|D|MT|core.utils.common.http_xml_client||| </result>
=|2017-02-22_14:14:35,941|D|MT|core.utils.common.http_xml_client||| </get>
=|2017-02-22_14:14:35,941|D|MT|core.utils.common.http_xml_client||| </server>
=|2017-02-22_14:14:35,941|D|MT|core.utils.common.http_xml_client|||</packet>
+|2017-02-22_14:14:35,943|D|MT|core.migrator|||Check Plesk version of the main target server
+|2017-02-22_14:14:35,943|D|MT|core.migrator|||Check log priority on target Plesk server
+|2017-02-22_14:14:35,943|D|MT|core.migrator|||Skip checking log priority option.
+|2017-02-22_14:14:35,943|D|MT|core.connections.checker|||Check SSH connection for the source server 'source' (XXX.XXX.XXX.XXX) server
+|2017-02-22_14:14:37,676|D|MT|core.connections.ssh.lazy_open_ssh_connection|||Open SSH connection to the the source server 'source' (XXX.XXX.XXX.XXX)
+|2017-02-22_14:14:37,676|D|MT|core.runners.base|||Execute command on the source server 'source' (XXX.XXX.XXX.XXX): /bin/grep -m1 -E '^\s*PRODUCT_ROOT_D' /etc/psa/psa.conf
+|2017-02-22_14:14:37,986|D|MT|core.runners.base|||Command execution results:
=|2017-02-22_14:14:37,986|D|MT|core.runners.base|||stdout:
=|2017-02-22_14:14:37,986|D|MT|core.runners.base|||stderr: LANG=en_US.utf-8: Command not found.
=|2017-02-22_14:14:37,986|D|MT|core.runners.base|||
=|2017-02-22_14:14:37,986|D|MT|core.runners.base|||exit code: 1

 

[RickandRoll]

I wonder why nobody has an answer.

 

[IgorG]

+|2017-02-22_14:14:37,676|D|MT|core.runners.base|||Execute command on the source server 'source' (XXX.XXX.XXX.XXX): /bin/grep -m1 -E '^\s*PRODUCT_ROOT_D' /etc/psa/psa.conf
+|2017-02-22_14:14:37,986|D|MT|core.runners.base|||Command execution results:
=|2017-02-22_14:14:37,986|D|MT|core.runners.base|||stdout:
=|2017-02-22_14:14:37,986|D|MT|core.runners.base|||stderr: LANG=en_US.utf-8: Command not found.

Try to run command

# /bin/grep -m1 -E '^\s*PRODUCT_ROOT_D' /etc/psa/psa.conf

on your source server. Do you have any errors in output?
Also check output of

# locale

command. It should be like

[root@ppu12-5 ~]# locale
LANG=en_US.utf-8
LC_CTYPE="en_US.utf-8"
LC_NUMERIC="en_US.utf-8"
LC_TIME="en_US.utf-8"
LC_COLLATE="en_US.utf-8"
LC_MONETARY="en_US.utf-8"
LC_MESSAGES="en_US.utf-8"
LC_PAPER="en_US.utf-8"
LC_NAME="en_US.utf-8"
LC_ADDRESS="en_US.utf-8"
LC_TELEPHONE="en_US.utf-8"
LC_MEASUREMENT="en_US.utf-8"
LC_IDENTIFICATION="en_US.utf-8"
LC_ALL=

 

[RickandRoll]

Hi Igor,
Command /bin/grep -m1 -E '^\s*PRODUCT_ROOT_D' /etc/psa/psa.conf runs perfectly on source
as well as ssh -p 54322 root@SOURCE_IP -a "/bin/grep -m1 -E '^\s*PRODUCT_ROOT_D' /etc/psa/psa.conf" on target
locale on both servers returns the same as on your server

When I execute migration process using other than root user it passed mentioned above command but fails on SQL:

Failed to fetch basic information about resellers, clients and domains data from source servers
=|2017-02-27_14:56:24,135|E|MT|parallels|||Cause: Failed to execute SQL query on Plesk database: failed to parse JSON returned by SQL script.
=|2017-02-27_14:56:24,135|E|MT|parallels|||Query:
=|2017-02-27_14:56:24,135|E|MT|parallels||| SELECT Subscriptions.id as subscription_id, clients.id, login, pname
=|2017-02-27_14:56:24,135|E|MT|parallels||| FROM clients
=|2017-02-27_14:56:24,135|E|MT|parallels||| LEFT JOIN Subscriptions ON
=|2017-02-27_14:56:24,135|E|MT|parallels||| Subscriptions.object_id = clients.id
=|2017-02-27_14:56:24,135|E|MT|parallels||| AND Subscriptions.object_type = 'client'
=|2017-02-27_14:56:24,135|E|MT|parallels||| WHERE clients.type = 'reseller'
=|2017-02-27_14:56:24,135|E|MT|parallels|||
=|2017-02-27_14:56:24,135|E|MT|parallels|||Command's exit code: 255
=|2017-02-27_14:56:24,135|E|MT|parallels|||Command's stdout:
=|2017-02-27_14:56:24,135|E|MT|parallels|||Command's stderr: Died at AgentConfig.pm line 23.


Also migration tool thinks it works with Windows servers

+|2017-02-27_14:56:24,081|D|MT|core.workflow.runner.by_subscription|||FINISH: Close SSH connections
+|2017-02-27_14:56:24,081|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2017-02-27_14:56:24,081|D|MT|core.workflow.runner.by_subscription|||START: Shutdown Windows rsync servers
+|2017-02-27_14:56:24,082|D|MT|core.workflow.runner.by_subscription|||FINISH: Shutdown Windows rsync servers
+|2017-02-27_14:56:24,082|D|MT|core.workflow.runner.by_subscription|||Checking whether it is required to execute action
+|2017-02-27_14:56:24,082|D|MT|core.workflow.runner.by_subscription|||START: Stop remote Windows agents
+|2017-02-27_14:56:24,082|D|MT|core.workflow.runner.by_subscription|||FINISH: Stop remote Windows agents

Thank you

 

[Alina Dmi]

Hello!
Make sure that /bin/bash is used as default shell for root. Set /bin/bash to default shell for root and try to start migration again or run the command ssh [email protected] "LANG=en_US.utf-8 /bin/grep -m1 -E '^\s*PRODUCT_ROOT_D' /etc/psa/psa.conf".
And if this does not help you, could you please provide root(ssh) access to source and target servers in private conversation?

 

[RickandRoll]

Changed to bash on source and boom!
You are awesome Alina! Thank you!