Accounts Transfer Issues

[dmkmedia]

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

 

[cPanelMichael]

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.

 

[Naila]

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?

 

[MichaelCropper]

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.)

 

[cPRex]

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.

 

[ankeshanand]

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?

 

[cPRex]

@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?

 

[ankeshanand]

@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?

Already checked. It's due to MariaDB versions conflict. Trying https://support.cpanel.net/hc/en-us...er-all-accounts-using-pkgacct-and-restorepkg-

 

[cPRex]

The MariaDB things will be fixed in full today - I have more details on that here - SOLVED - One of the configured repositories failed (MariaDB106)

 

[ankeshanand]

The MariaDB things will be fixed in full today - I have more details on that here - SOLVED - One of the configured repositories failed (MariaDB106)

I know about that. Your MySQL/MariaDB upgrade feature is not working. I tried changing the repo link in yum.repos.d but mysql/mariadb upgrade feature just reverted it back. I installed MariaDB 10.3 through CloudLinux DB Governor.