Multiple errors (esp database related) on multi-account cPanel -to- cPanel transfers

[PPNSteve]

Seeing a large bunch of errors during account transfers from old to new server.. mainly can't find the DB user password and then not able to add user to db on new server..

Unable to detect a password set for “commuteb”@“%”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80.
Unable to detect a password set for “commuteb”@“173.xxx.xxx.10”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80.
Unable to detect a password set for “commuteb”@“174.xxx.xxx.162”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80.
Unable to detect a password set for “commuteb”@“192.168.1.%”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80.
Unable to detect a password set for “commuteb”@“76.xxx.xxx.249”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80.
Unable to detect a password set for “commuteb”@“localhost”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80.
Unable to detect a password set for “commuteb”@“svr4.1-gb.net”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80.
Unable to detect a password set for “commuteb_admin”@“%”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80.
Unable to detect a password set for “commuteb_admin”@“173.xxx.xxx.10”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80.
Unable to detect a password set for “commuteb_admin”@“174.xxx.xxx.162”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80.
Unable to detect a password set for “commuteb_admin”@“192.168.1.%”!!! at /usr/local/cpanel/Cpanel/DBI/Mysql/Utils.pm line 80.
Unable to detect a password set for “commuteb_admin”@“76.xxx.xxx...  etc.

and then:

The system failed to grant privileges on the database “commuteb_draftpad” to the user “commuteb_admin” because of an error: (XID bdarkc) This system will not add the database user “commuteb_admin” to the database “commuteb_draftpad” because this user does not have a password.
The system failed to grant privileges on the database “commuteb_cv7” to the user “commuteb_admin” because of an error: (XID tshrr9) This system will not add the database user “commuteb_admin” to the database “commuteb_cv7” because this user does not have a password.
The system failed to grant privileges on the database “commuteb_rfh” to the user “commuteb_admin” because of an error: (XID 4bwe49) This system will not add the database user “commuteb_admin” to the database “commuteb_rfh” because this user does not have a password.

for pretty much all the db's in use..

also once the account transfer is complete, i'm seeing errors like:

(XID qmqjsm) The cPanel user “deviate” does not exist in the database map. at /usr/local/cpanel/Whostmgr/DB.pm line 69.
at /usr/local/cpanel/Whostmgr/DB.pm line 69.
    Whostmgr::DB::__ANON__(Cpanel::Exception::Database::CpuserNotInMap=HASH(0x3513c40)) called at /usr/local/cpanel/3rdparty/perl/528/lib/perl5/cpanel_lib/Try/Tiny.pm line 118
    Try::Tiny::try(CODE(0x3514210), Try::Tiny::Catch=REF(0x35145b0)) called at /usr/local/cpanel/Whostmgr/DB.pm line 70
    Whostmgr::DB::_list_database_objects("user") called at /usr/local/cpanel/Whostmgr/DB.pm line 30
    Whostmgr::DB::list_database_users() called at whostmgr/bin/whostmgr5.pl line 1024
    main::manage_database_users("manage_database_users") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 259
    Whostmgr::Dispatch::_do_call("manage_database_users", HASH(0x34eef38), HASH(0x34ffbf0)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 157
    Whostmgr::Dispatch::dispatch("manage_database_users", 1, ARRAY(0x34ff950)) called at whostmgr/bin/whostmgr5.pl line 280

This is an example user, there are quite a few from this transfer session including the previous example users/domains..

So, what's up? how do I fix it?

source server running CENTOS 6.10 [svr4] - cPanel v82.0.9
destination server running: CENTOS 7.6 [svr5] - cPanel v82.0.9

 

[cPanelLauren]

Hello,


On the source and destination server are you running MySQL or MariaDB? On the source server what is the output of the following:

 mysql -e "select user,host,plugin,password,authentication_string from mysql.user where user like 'deviate'"