Skip to main content

Error when restoring backup

masterross
Hi guys, Today I needed to restore a backup but here is what happened: [QUOTE] 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!

Comments

5 comments

Date Votes
  • cPanelLauren
    There are a great number of threads on similar topics already for example:
    0
  • masterross
    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: [QUOTE] 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!
    0
  • cPanelLauren
    I'd say that this would be best handled with opening a ticket. Please if you do so add the ticket ID here so that we can follow up.
    0
  • masterross
    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?
    0
  • cPanelLauren
    I'm not sure, that would need to be investigated further but we've aways recommended you disable skip-name-resolve because of issues related to it.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post