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