Issue Error with migration SQL

[CobraArbok]

Server operating system version

Ubuntu 22.04.1 LTS

Plesk version and microupdate number

18.0.46

Trying to continue migrating Plesk from an Ubuntu 20 server to an Ubuntu 22 server I get this other error.

Migration tools tried to perform operation in 3 attempts: Command execution failed on the local server with non-zero exit code. command: MYSQL_PWD="$(cat)" mysql --silent --skip-column-names -h localhost -P 3306 -u admin -e 'SHOW DATABASES' exit code: 1 stdout: stderr: WARNING: Forcing protocol to TCP due to option specification. Please explicitly state intended protocol. ERROR 2002 (HY000): Can't connect to server on 'localhost' (115)

 

[IgorG]

Make sure that localhost is resolvable and defined in /etc/hosts file and you can connect to the database with this command:

# MYSQL_PWD=$(cat /etc/psa/.psa.shadow) mysql -uadmin -h localhost

Also, check that skip-name-resolve variable is not defined /etc/my.cnf config file.

 

[CobraArbok]

In hosts, I had replaced
127.0.0.1 localhost localhost.localdomain
with
127.0.0.1 nameserver.domain.tld nameserver

Now, with the right settings, the migration worked without errors.
But the Webmail that worked until yesterday now the URL leads to the Web Server's Default Page.

Also I still don't understand why still cgi is not possible to activate in Apache Server Setting (there is another post of mine about this)

Finally I did not understand why in the preparation of the migration appeared the error:
Service plan 'DPS-CPS' on source server has PHP handler that is not installed on the target server: running in unknown mode. Another PHP handler was selected for that service template: default Plesk handler for PHP 7.4.33 running in CGI mode To resolve the issue, it is recommended to do one of the following: - Install and enable such PHP handler to target server. - Ensure that PHP handler that was selected automatically is fine for migrated web sites. - Select appropriate PHP handler in service template once migration is finished and synchronize the changes to subscriptions. The following Apache modules are disabled on the destination server: cgi. Please turn on these modules in Plesk to prevent some possible problems.