M
mousehouse
Guest
Hello Forum,
For some reason I'm unable to use PMM to migrate a 7.1 server to a new and fresh 8.0.1 machine.
Using plesk PMM is transferred to the 7.1 server and reports:
Some other thread mentioned installing ART tools, which we cannot do as the 7.1 system is running BSD. The 8.0.1 server is running Debian.
Any clues?
For some reason I'm unable to use PMM to migrate a 7.1 server to a new and fresh 8.0.1 machine.
Using plesk PMM is transferred to the 7.1 server and reports:
Using this forum I have looked at the "show variables" in MySQL but they look ok (all are latin1 except system which is UTF8).Error during dump retrieval
Error during dump file retrieving.
Remote agent failed with the following stderr messages: 10:35:05 INFO FileFinder: tar resolved to /usr/bin/tar
10:35:05 INFO New connection: mysql shell connection. db psa, user admin, host localhost
10:35:05 TRACE SQL: SELECT ip_address, type FROM IP_Addresses
10:35:05 TRACE SQL: SELECT c.login, p.ip_address FROM clients c LEFT JOIN Repository r ON c.pool_id = r.rep_id LEFT JOIN IP_Addresses p ON r.component_id = p.id
10:35:05 TRACE SQL: SELECT d.displayName, p.ip_address FROM domains d, IP_Addresses p, hosting h WHERE p.id = h.ip_address_id AND h.dom_id = d.id
10:35:05 TRACE SQL: SELECT d.displayName, p.ip_address FROM domains d, IP_Addresses p, forwarding f WHERE p.id = f.ip_address_id AND f.dom_id = d.id
10:35:05 TRACE SQL: SELECT displayName FROM domains WHERE htype = 'none'
ERROR 1267 (HY000) at line 1: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
10:35:05 TRACE SQL: SELECT d.displayName, c.login FROM clients c LEFT JOIN domains d ON d.cl_id = c.id
10:35:05 INFO ------------------------------------------------------------
10:35:05 INFO FILE storage initialized.
10:35:05 INFO Base directory: /usr/local/psa/migration/supervisor.14236/
10:35:05 INFO Gzip bundles: yes
10:35:05 INFO Bundle split size: 2147483647
10:35:05 INFO ------------------------------------------------------------
10:35:05 TRACE SQL: SELECT * FROM clients WHERE login = 'xyzcustomer'
ERROR 1267 (HY000) at line 1: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Can't use an undefined value as a HASH reference at /usr/local/psa/migration/supervisor.14236/PleskX.pl line 597.
Some other thread mentioned installing ART tools, which we cannot do as the 7.1 system is running BSD. The 8.0.1 server is running Debian.
Any clues?