Cpanel Plesk Göç İşlemi

30 Oct 2019 19:08:51] Geçiş
Unable to create database user 'xxx' in subscription 'xxx.com': Command execution failed on the local server with non-zero exit code.
command: /usr/local/psa/bin/database --create-dbuser xxxx -passwd '' -domain ahemstone.com -any-database -type mysql -server localhost:3306 -ignore-nonexistent-options
exit code: 1
stdout:
stderr: Unable to add database user: Database user name is invalid.

Plesk restore report problem:
Failed deployment of user xxxx for any database(domain xxxx.com)
Plesk restore report problem:
Execution of /usr/local/psa/admin/plib/api-cli/database.php --create-dbuser xxxx_xxx -server localhost:3306 -domain xxx.com -set-acl % -passwd '' -passwd_type encrypted -ignore-nonexistent-options failed with return code 1.
Stderr is
Unable to add database user: Database user name is invalid.
Failed to copy content of database 'xxxxx'
Migration tools tried to perform operation in 1 attempts: Restoration of MySQL database failed. Most probable reason:

Target MySQL server does not contain necessary character set.
Most likely it is required to have at least MySQL 5.5 to restore such database.

Proposed solutions:
*) Obtain another target server which has OS providing appropriate MySQL server version.
For example, CentOS 6 provides MySQL 5.1 by default, while CentOS 7 provides MySQL 5.5 by default.
*) Connect another external MySQL server to the target server with appropriate MySQL version.
Configure that server as default, or specify it in service plan to which subscriptions are assigned to.
Remove migrated subscription from the target server and start migration once more.
*) Upgrade MySQL server on the target server to appropriate version, then run migration once more (no need to
remove subscriptions from target - just run migration over existing domains). For example, for CentOS you could use
packages provided by EPEL repositories. This way is not recommended for servers already running in production.

Here is the original error message reported by MySQL client when restoring the database:
ERROR 1273 (HY000) at line 193: Unknown collation: 'utf8mb4_unicode_ci'



Mysql update edildi göç sonrası sorun hala devam ediyor.



Sorunu Çözdüm Plesk onxy mysql user ve db karakter sayısı maksimum 15 ile sınırlı imiş plesk obsidian ile 32 ve 50 karakter uzunluğunda mysql kullanıcı ve user oluşturabiliyoruz ancak mariadb 5.7 upgrade etmek gerekiyor maridb tekrar update etmek gerekiyor.