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

PPNSteve

Well-Known Member
Mar 13, 2003
412
3
168
Somewhere in Ilex Forest
www.1-gb.net
cPanel Access Level
Root Administrator
Twitter
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..

Code:
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:

Code:
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:
Code:
(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

Forums Analyst II
Staff member
Nov 14, 2017
6,762
535
263
Houston
cPanel Access Level
DataCenter Provider
Hello,


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

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