Accounts Transfer Issues
i am moving from one cento 7 server to another centos 7 servers with whm on both using the transfer tool but getting so many errors i managed to move some account but some just won't go over
here is just one of the errors
The system failed to grant privileges on the database "clerkenw_wp115" to the user "clerkenw_wp148" because of an error: (XID zsccxn) This system will not add the database user "clerkenw_wp148" to the database "clerkenw_wp115" because this user does not have a password.
{"type":"warn","contents":{"time":1563270027,"msg":["The system failed to grant privileges on the database "clerkenw_wp91" to the user "clerkenw_wp148"
and also
RESTORE: Account "handyman": Account Restore Failed: "Account failure: Failed to create the account: A database owner with the name "handyman" already exists in the database map (/var/cpanel/databases/handyman.*). at /usr/local/cpanel/Whostmgr/Accounts/Create.pm line 1224. "
please help
i do have a backup of the server in Acronis and wondering would it be easier to restore this but not sure if I restore the home dir and sql dbases would it show the accounts after i restore it
as i have only ever used this for file restores only
-
Hello @dmkmedia, Can you run the following commands on both the source and destination server and report the output here? cat /usr/local/cpanel/version mysql --version
Thank you.0 -
I have same issue with this on transfer account from old to new server The system failed to grant privileges on the database "user_wp340" to the user "user_wp340" because of an error: (XID p6mj4r) This system will not add the database user "user_wp340" to the database "user_wp340" because this user does not have a password.
Any solution to fix all "user does not have a password" issue?0 -
I've had the same issue. Solution was to; 1) Delete cPanel account completely from new server 2) Re-transfer cPanel account from old server to new server Don't want to say this would work for others as cPanel is a bit of a mystery in the background in a lot of areas. So just sharing my experience of what worked in my situation (but I had a LOT of other errors throughout the transfer process in general, so it's difficult to pinpoint issues.) 0 -
It's hard to say exactly what the cause may be. In some cases if you are moving from a server running an older MySQL version it could be using an old-style password, and that could cause this error. If you're seeing the issue, it would be helpful to know the MySQL version of both systems using the commands that Michael provided above as that might get us more details. 0 -
It's hard to say exactly what the cause may be. In some cases if you are moving from a server running an older MySQL version it could be using an old-style password, and that could cause this error. If you're seeing the issue, it would be helpful to know the MySQL version of both systems using the commands that Michael provided above as that might get us more details.
Happening with me right now! Source server is running MariaDB 10.6 Target server is running MariaDB 10.3 Maybe it's a version issue. Any workarounds discovered?0 -
@ankeshanand - you're getting the "failed to grant privileges" error? If so, can you open a ticket with our team so we can check this? 0
Please sign in to leave a comment.
Comments
9 comments