Skip to main content
We are aware of an issue after updating to cPanel versions 11.110.0.65, 11.126.0.21, or 11.128.0.11, some cPanel plugins or features are no longer functioning properly including WP Toolkit. Please see the following article for more information and updates:
Update to latest cPanel 110, 126, or 128 versions removes "addonfeatures" directory.

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