Error when restoring backup

Operating System & Version
CENTOS 7.8
cPanel & WHM Version
v88.0.13

masterross

Well-Known Member
Apr 7, 2004
73
5
158
Hi guys,

Today I needed to restore a backup but here is what happened:

RESTORE: 1 completed, 1 had warnings, and 0 failed.
RESTORE: Account “my_user”: Warnings
The “Roundcube” restore module failed because of an error: Failed to grant “my_user” access to “cptmpdb_my_user_6AHdaRGQf4OaUYwd”: The system could not perform “GRANT” statements on the database “cptmpdb_my_user_6AHdaRGQf4OaUYwd” for the user “my_user” due to an error: Cpanel::Exception::Database::Error/(XID ntbwv7) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table) at /usr/local/cpanel/Cpanel/DBI.pm line 200. Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x6c756a8), "DBD::mysql::db do failed: Can't find any matching row in the "..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 188 Cpanel::DBI::_error_handler("DBD::mysql::db do failed: Can't find any matching row in the "..., Cpanel::DBI::Mysql::db=HASH(0x6c756a8), undef) called at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 348 Cpanel::Mysql::Basic::_sendmysql_untrapped(Cpanel::Mysql=HASH(0x6c6d770), "SET PASSWORD FOR 'my_user'\@'loca…eue::Processor=HASH(0x3000188), Cpanel::TaskQueue::Task=HASH(0x3045490), Cpanel::LoggerAdapter=HASH(0x153ad70)) called at /usr/local/cpanel/Cpanel/TaskQueue.pm line 635 eval {...} called at /usr/local/cpanel/Cpanel/TaskQueue.pm line 638 Cpanel::TaskQueue::__ANON__() called at /usr/local/cpanel/Cpanel/StateFile.pm line 241 eval {...} called at /usr/local/cpanel/Cpanel/StateFile.pm line 241 Cpanel::StateFile::Guard::call_unlocked(Cpanel::StateFile::Guard=HASH(0x302a768), CODE(0x302a798)) called at /usr/local/cpanel/Cpanel/TaskQueue.pm line 643 Cpanel::TaskQueue::process_next_task(Cpanel::TaskQueue=HASH(0x30202c0)) called at /usr/local/cpanel/Cpanel/Backup/RestoreQueue.pm line 1003 Cpanel::Backup::RestoreQueue::activate() called at bin/backup_restore_manager.pl line 219 QUERY: SET PASSWORD FOR 'my_user'@'localhost' = PASSWORD('QU30HmeLqG'); GRANT USAGE ON *.* TO 'my_user'@'localhost'; SET PASSWORD FOR 'my_user'@'wipm019.my_server.com' = PASSWORD('QU30HmeLqG'); GRANT USAGE ON *.* TO 'my_user'@'wipm019.my_server.com'
The system failed to reinstall the MySQL database “my_user_db” as “my_user_db” because of an error: Failed to grant “my_user” access to “my_user_db”: The system could not perform “GRANT” statements on the database “my_user_db” for the user “my_user” due to an error: Cpanel::Exception::Database::Error/(XID skcvq2) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table) at /usr/local/cpanel/Cpanel/DBI.pm line 200. Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x724c9d0), "DBD::mysql::db do failed: Can't find any matching row in the "..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 188 Cpanel::DBI::_error_handler("DBD::mysql::db do failed: Can't find any matching row in the "..., Cpanel::DBI::Mysql::db=HASH(0x724c9d0), undef) called at /usr/local/cpanel/Cpanel/Mysql/Basic.pm line 348 Cpanel::Mysql::Basic::_sendmysql_untrapped(Cpanel::Mysql=HASH(0x6c33d60), "SET PASSWORD FOR 'my_user'\@'wipm019.m…ue::Processor=HASH(0x3000188), Cpanel::TaskQueue::Task=HASH(0x3045490), Cpanel::LoggerAdapter=HASH(0x153ad70)) called at /usr/local/cpanel/Cpanel/TaskQueue.pm line 635 eval {...} called at /usr/local/cpanel/Cpanel/TaskQueue.pm line 638 Cpanel::TaskQueue::__ANON__() called at /usr/local/cpanel/Cpanel/StateFile.pm line 241 eval {...} called at /usr/local/cpanel/Cpanel/StateFile.pm line 241 Cpanel::StateFile::Guard::call_unlocked(Cpanel::StateFile::Guard=HASH(0x302a768), CODE(0x302a798)) called at /usr/local/cpanel/Cpanel/TaskQueue.pm line 643 Cpanel::TaskQueue::process_next_task(Cpanel::TaskQueue=HASH(0x30202c0)) called at /usr/local/cpanel/Cpanel/Backup/RestoreQueue.pm line 1003 Cpanel::Backup::RestoreQueue::activate() called at bin/backup_restore_manager.pl line 219 QUERY: SET PASSWORD FOR 'my_user'@'wipm019.my_server.com' = PASSWORD('99DjkhD7FK'); GRANT USAGE ON *.* TO 'my_user'@'wipm019.my_server.com'; SET PASSWORD FOR 'my_user'@'localhost' = PASSWORD('99DjkhD7FK'); GRANT USAGE ON *.* TO 'my_user'@'localhost'

Not sure is it related but a week ago I chown by mistake most of the /home users files and folders.
And I thought I restored. But maybe I miss something?

Help please!
 

cPanelLauren

Product Owner II
Staff member
Nov 14, 2017
13,266
1,301
363
Houston
There are a great number of threads on similar topics already for example:

 

masterross

Well-Known Member
Apr 7, 2004
73
5
158
Hello,

Of course, I already tried them.
There is a mysql permission problem.
The only partial solution to restore a backup is to terminate the user and restore it.
But then other errors appears:

Roundcube

The system will create a temporary database named “cptmpdb_my_user_tZMbHfVEQsH3pshD” to import the Roundcube data.

Restoring the database “roundcube” as “cptmpdb_my_user_tZMbHfVEQsH3pshD” …

The system has created a new database named “cptmpdb_my_user_tZMbHfVEQsH3pshD”.

Granting “my_user” access to “cptmpdb_my_user_tZMbHfVEQsH3pshD” with temporary password …

Spawning restoration subprocess for “cptmpdb_my_user_tZMbHfVEQsH3pshD” …

Connecting to MySQL server as “my_user” in order to restore “cptmpdb_my_user_tZMbHfVEQsH3pshD” …

Releasing objects in preparation for database restore for “cptmpdb_my_user_tZMbHfVEQsH3pshD” …

Cleaning up in preparation for database restore for “cptmpdb_my_user_tZMbHfVEQsH3pshD” …

Disabling InnoDB strict mode for database restore for “cptmpdb_my_user_tZMbHfVEQsH3pshD” …

Restoring database data for “cptmpdb_my_user_tZMbHfVEQsH3pshD” …

The database restoration subprocess for “cptmpdb_my_user_tZMbHfVEQsH3pshD” is running …

The database restoration subprocess for “cptmpdb_my_user_tZMbHfVEQsH3pshD” has ended.

The system has restored the contents of the database “cptmpdb_my_user_tZMbHfVEQsH3pshD”.

Merging grants from the temporary database named “cptmpdb_my_user_tZMbHfVEQsH3pshD” into Roundcube …

[2020-08-07 02:15:03 +0300] warn [transfer_session] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'roundcube'@'localhost' IDENTIFIED BY 'dA65sM9O7GIJKdMn'' at line 1 at /usr/local/cpanel/Cpanel/Email/RoundCube.pm line 663.

Cpanel::Email::RoundCube::handle_mysql_roundcube_grants("cptmpdb_my_user_tZMbHfVEQsH3pshD", Cpanel::DBI::Mysql::db=HASH(0x6dea738)) called at /usr/local/cpanel/Whostmgr/Transfers/Systems/Roundcube.pm line 140

Whostmgr::Transfers::Systems::Roundcube::restricted_restore(Whostmgr::Transfers::Systems::Roundcube=HASH(0x6e6fdd8)) called at /usr/local/cpanel/Whostmgr/Transfers/Systems.pm line 128

Whostmgr::Transfers::Systems::restore(Whostmgr::Transfers::Systems::Roundcube=HASH(0x6e6fdd8)) called at /usr/local/cpanel/Whostmgr/Transfers/AccountRestoration.pm line 227

Whostmgr::Transfers::AccountRestoration::__ANON__() called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 97

eval {...} called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 88

Try::Tiny::try(CODE(0x167d780), Try::Tiny::Catch=REF(0x694b380)) called at /usr/local/cpanel/Whostmgr/Transfers/AccountRestoration.pm line 231

Whostmgr::Transfers::AccountRestoration::_call_one_restore_module_without_archive_prep_check(Whostmgr::Transfers::AccountRestoration=HASH(0x36d0bf0), "Roundcube") called at /usr/local/cpanel/Whostmgr/Transfers/AccountRestoration.pm line 539

Whostmgr::Transfers::AccountRestoration::_call_one_restore_module_with_notices(Whostmgr::Transfers::AccountRestoration=HASH(0x36d0bf0), "Roundcube") called at /usr/local/cpanel/Whostmgr/Transfers/AccountRestoration.pm line 511

Whostmgr::Transfers::AccountRestoration::_run_restore_system_module(Whostmgr::Transfers::AccountRestoration=HASH(0x36d0bf0), HASH(0x3746830), HASH(0x5869df8)) called at /usr/local/cpanel/Whostmgr/Transfers/AccountRestoration.pm line 477

Whostmgr::Transfers::AccountRestoration::_run_restore_modules(Whostmgr::Transfers::AccountRestoration=HASH(0x36d0bf0), HASH(0x3746830)) called at /usr/local/cpanel/Whostmgr/Transfers/AccountRestoration.pm line 410

Whostmgr::Transfers::AccountRestoration::_restore_package(Whostmgr::Transfers::AccountRestoration=HASH(0x36d0bf0)) called at /usr/local/cpanel/Whostmgr/Transfers/AccountRestoration.pm line 92

eval {...} called at /usr/local/cpanel/Whostmgr/Transfers/AccountRestoration.pm line 92

Whostmgr::Transfers::AccountRestoration::restore_package(Whostmgr::Transfers::AccountRestoration=HASH(0x36d0bf0)) called at /usr/local/cpanel/Whostmgr/Backup/Restore.pm line 81

eval {...} called at /usr/local/cpanel/Whostmgr/Backup/Restore.pm line 81

Whostmgr::Backup::Restore::load_transfers_then_restorecpmove("overwrite_sameowner_dbs", 0, "customip", undef, "extractname", "cpmove-my_user", "restoremail", 1, ...) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Items/AccountBase.pm line 169

Whostmgr::Transfers::Session::Items::AccountBase::_restore_package(Whostmgr::Transfers::Session::Items::AccountLocal=HASH(0x35847a8)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Item.pm line 314

Whostmgr::Transfers::Session::Item::__ANON__() called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 97

eval {...} called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 88

Try::Tiny::try(CODE(0x3585558), Try::Tiny::Catch=REF(0x3584aa8)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Item.pm line 343

Whostmgr::Transfers::Session::Item::exec_path(Whostmgr::Transfers::Session::Items::AccountLocal=HASH(0x35847a8), ARRAY(0x36ba880), ARRAY(0x35854c8), 1) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Items/AccountBase.pm line 46

Whostmgr::Transfers::Session::Items::AccountBase::restore(Whostmgr::Transfers::Session::Items::AccountLocal=HASH(0x35847a8)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 656

Whostmgr::Transfers::Session::Processor::__ANON__() called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1476

Whostmgr::Transfers::Session::__ANON__() called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 97

eval {...} called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 88

Try::Tiny::try(CODE(0x3584fa0), Try::Tiny::Catch=REF(0x3584970)) called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 1480

Whostmgr::Transfers::Session::exec_with_output_directed_to_fh(Whostmgr::Transfers::Session=HASH(0x355f848), GLOB(0x36ba3d0), CODE(0x36ba7c0)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 672

Whostmgr::Transfers::Session::Processor::_process_dequeued_item(Whostmgr::Transfers::Session::Processor=HASH(0x358d120)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 552

Whostmgr::Transfers::Session::Processor::_process_items(Whostmgr::Transfers::Session::Processor=HASH(0x358d120)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 506

Whostmgr::Transfers::Session::Processor::__ANON__() called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 68

eval {...} called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 68

Cpanel::ForkAsync::do_in_child(CODE(0x2a05778)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 508

Whostmgr::Transfers::Session::Processor::_spawn_child(Whostmgr::Transfers::Session::Processor=HASH(0x358d120), "--\x{a}", Whostmgr::Transfers::Session=HASH(0x355f848)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 290

Whostmgr::Transfers::Session::Processor::_process_child(Whostmgr::Transfers::Session::Processor=HASH(0x358d120), Whostmgr::Transfers::Session=HASH(0x355f848), 0) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 238

Whostmgr::Transfers::Session::Processor::_process_child_with_output_redirection(Whostmgr::Transfers::Session::Processor=HASH(0x358d120), Whostmgr::Transfers::Session=HASH(0x355f848), 0, "wipm019masterrbacku20200806231017EqB") called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 203

Whostmgr::Transfers::Session::Processor::__ANON__() called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 68

eval {...} called at /usr/local/cpanel/Cpanel/ForkAsync.pm line 68

Cpanel::ForkAsync::do_in_child(CODE(0x2a05e50)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/Processor.pm line 205

Whostmgr::Transfers::Session::Processor::start(Whostmgr::Transfers::Session::Processor=HASH(0x358d120)) called at /usr/local/cpanel/Cpanel/Backup/RestoreQueue.pm line 454

Cpanel::Backup::RestoreQueue::Processor::__ANON__() called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 97

eval {...} called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 88

Try::Tiny::try(CODE(0x26c92b0), Try::Tiny::Catch=REF(0x2428d60)) called at /usr/local/cpanel/Cpanel/Backup/RestoreQueue.pm line 463

Cpanel::Backup::RestoreQueue::Processor::restore_account(HASH(0x22f6768), Cpanel::LoggerAdapter=HASH(0x153ad70)) called at /usr/local/cpanel/Cpanel/Backup/RestoreQueue.pm line 138

Cpanel::Backup::RestoreQueue::Processor::__ANON__() called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 97

eval {...} called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 88

Try::Tiny::try(CODE(0x22f66a8), Try::Tiny::Catch=REF(0x15495c0)) called at /usr/local/cpanel/Cpanel/Backup/RestoreQueue.pm line 142

Cpanel::Backup::RestoreQueue::Processor::process_task(Cpanel::Backup::RestoreQueue::Processor=HASH(0x22af188), Cpanel::TaskQueue::Task=HASH(0x22f66f0), Cpanel::LoggerAdapter=HASH(0x153ad70)) called at /usr/local/cpanel/Cpanel/TaskQueue.pm line 635

eval {...} called at /usr/local/cpanel/Cpanel/TaskQueue.pm line 638

Cpanel::TaskQueue::__ANON__() called at /usr/local/cpanel/Cpanel/StateFile.pm line 241

eval {...} called at /usr/local/cpanel/Cpanel/StateFile.pm line 241

Cpanel::StateFile::Guard::call_unlocked(Cpanel::StateFile::Guard=HASH(0x22d9678), CODE(0x22d9318)) called at /usr/local/cpanel/Cpanel/TaskQueue.pm line 643

Cpanel::TaskQueue::process_next_task(Cpanel::TaskQueue=HASH(0x22cf2d8)) called at /usr/local/cpanel/Cpanel/Backup/RestoreQueue.pm line 1003

Cpanel::Backup::RestoreQueue::activate() called at bin/backup_restore_manager.pl line 219

Roundcube

You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'USER 'roundcube'@'localhost' IDENTIFIED BY 'dA65sM9O7GIJKdMn'' at line 1

Mysql

Preparing MySQL restore …

Databases will be overwritten on conflict.

Restoring MySQL databases

The database restoration subprocess for “my_user_db” has opened the SQL archive.

Restoring the database “my_user_db” as “my_user_db” …

The system will rename the unmanaged database “my_user_db” to “my_user_db3”.

The system has created a new database named “my_user_db”.

Granting “my_user” access to “my_user_db” with temporary password …

Spawning restoration subprocess for “my_user_db” …

Connecting to MySQL server as “my_user” in order to restore “my_user_db” …

Releasing objects in preparation for database restore for “my_user_db” …

Cleaning up in preparation for database restore for “my_user_db” …

Disabling InnoDB strict mode for database restore for “my_user_db” …

Restoring database data for “my_user_db” …

The database restoration subprocess for “my_user_db” is running …

The database restoration subprocess for “my_user_db” has ended.

The system has restored the contents of the database “my_user_db”.

The database restoration subprocess for “my_user_db” has closed the SQL archive.

Restoring MySQL database mappings


Restoring MySQL privileges

Database users will be overwritten on conflict.

Restoring MySQL grants

[2020-08-07 02:18:49 +0300] info [transfer_session] Creating MySQL virtual user my_user_user for user my_user

Restoring MySQL access hosts

[2020-08-07 02:18:50 +0300] warn [transfer_session] GRANT statement “SET PASSWORD FOR 'my_user'@'wipm019.my_server.com' = '*B1AFCD600DF3E53109B04716AEF3B27FBFCCF24F';

” failed: Cpanel::Exception::Database::Error/(XID fzqkcd) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)

at /usr/local/cpanel/Cpanel/DBI.pm line 200.

Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::db=HASH(0x6d4ed18), "DBD::mysql::db do failed: Can't find any matching row in the "..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 188

Cpanel::DBI::_error_handler("DBD::mysql::db do failed: Can't find any matching row in the "..., Cpanel::DBI::Mysql::db=HASH(0x6d4ed18), undef) called at /usr/local/cpanel/Cpanel/DBAdmin.pm line 32

Cpanel::DBAdmin::dbh_do(Cpanel::Mysql=HASH(0x27049c8), "SET PASSWORD FOR 'my_user'\@'wipm019.my_server.com' = '*B1AFCD60"...) called at /usr/local/cpanel/Cpanel/Mysql.pm line 1102

eval {...} called at /usr/local/cpanel/Cpanel/Mysql.pm line 1102

Cpanel::Mysql::_do_sql_for_addhosts(Cpanel::Mysql=HASH(0x27049c8), "SET PASSWORD FOR 'my_user'\@'wipm019.my_server.com' = '*B1AFCD60"...) called at /usr/local/cpanel/Cpanel/Mysql.pm line 1052

Cpanel::Mysql::_addhosts(Cpanel::Mysql=HASH(0x27049c8), ARRAY(0x6d4e4f0)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 983

Cpanel::Mysql::addhosts(Cpanel::Mysql=HASH(0x27049c8), ARRAY(0x6d4e4f0)) called at /usr/local/cpanel/Whostmgr/Transfers/Systems/Mysql.pm line 1230

Whostmgr::Transfers::Systems::Mysql::__ANON__(Cpanel::Mysql=HASH(0x27049c8)) called at /usr/local/cpanel/Whostmgr/Transfers/SystemsBase/MysqlBase.pm line 918

Whostmgr::Transfers::SystemsBase::MysqlBase::_do_cpanel_mysql_with_newuser_privs(Whostmgr::Transfers::Systems::Mysql=HASH(0x6e71578), CODE(0x6b65330)) called at /usr/local/cpanel/Whostmgr/Transfers/Systems/Mysql.pm line 1232

Whostmgr::Transfers::Systems::Mysql::_restore_hosts(Whostmgr::Transfers::Systems::Mysql=HASH(0x6e71578), HASH(0x69bdb00)) called at /usr/local/cpanel/Whostmgr/Transfers/Systems/Mysql.pm line 238

Whostmgr::Transfers::Systems::Mysql::_restore_mysql(Whostmgr::Transfers::Systems::Mysql=HASH(0x6e71578)) called at /usr/local/cpanel/Whostmgr/Transfers/Systems/Mysql.pm line 87

Whostmgr::Transfers::Systems::Mysql::unrestricted_restore(Whostmgr::Transfers::Systems::Mysql=HASH(0x6e71578)) called at /usr/local/cpanel/Whostmgr/Transfers/Systems.pm line 128

Whostmgr::Transfers::Systems::restore(Whostmgr::Transfers::Systems::Mysql=HASH(0x6e71578)) called at /usr/local/cpanel/Whostmgr/Transfers/AccountRestoration.pm line 227

Whostmgr::Transfers::AccountRestoration::__ANON__() called at /usr/local/cpanel/3rdparty/perl/530/lib/perl5/cpanel_lib/Try/Tiny.pm line 97

Too many errors from “item-RESTORE_AccountLocal_my_user”. Future errors will be suppressed.

Storing MySQL Grants


Mysql
Even the errors the DB is restored but if I repeat the backup restoration then the previous errors appear and DB is missing.
So if you have a clue why cant grant perms to mysql user will be apprecialted!
 

masterross

Well-Known Member
Apr 7, 2004
73
5
158
Hello,
I found a temp solution by removing skip-name-resolve from /etc/my.cnf
But I had this setting ON for at least 3 years and I did restores many, many times.
Why now using skip-name-resolve is a problem?