Symptoms
-
MySQL databases are not migrated to Windows server with MariaDB 10.11
-
Migration fails with the following error:
Failed to copy content of database 'wp_test85'
Migration tools tried to perform operation in 3 attempts: Command execution failed on the local server with non-zero exit code.
command: "C:Program Files (x86)PleskMySQLbinmysql" --no-defaults -h localhost -P 3306 -uroot -p***hidden*** --default-character-set=utf8 wp_test85 -e "source C:Program Files (x86)Pleskvarmodulespanel-migratorsessions20241112210236target-serverdb_backup_pleskexample.com_wp_test85.sql"
exit code: 1
stdout:
stderr: ERROR 2026 (HY000): TLS/SSL error: SSL is required, but the server does not support it
Cause
This behavior is caused by Plesk bug PMT-5409
Resolution
1. Connect to the Windows Server via RDP
2. Remove the --no-defaults
option from the command in line 1141 of the file: %plesk_dir%adminplibmodulespanel-migratorbackendlibpythonparallelscoreutilsdatabase_utils.py
with db_server.runner() as runner:
assert isinstance(runner, BaseRunner)
runner.execute_command(
'{mysql_client} --no-defaults -h {host} -P {port} -u{login} -p{password} --default-character-set=utf8 {database_name} '
'-e {query}',
dict(
3. Resync the affected subscriptions