i-MSCP backup script - Cannot dump mysql databases - Percona DB

tilicar · Jun 25th 2015

I look trough my email and i get this email:

Code

Dear admin,This is an automatic email sent by your myserver.tld(xx.xx.xx.xx) server.A critical error has been encountered while executing function main::runin /var/www/imscp/engine/backup/imscp-backup-all.Error was:==========================================================================iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access deniedfor user 'root'@'localhost' (using password: NO) when trying to connectiMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access deniedfor user 'root'@'localhost' (using password: NO) when trying to connectiMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access deniedfor user 'root'@'localhost' (using password: NO) when trying to connect==========================================================================

any ideea ?

I run command: tail /var/log/imscp/imscp-backup-all.log
and i get :

Code

[Wed Jun 24 23:41:22 2015] [debug] iMSCP::File::owner: Changing owner and group for /var/www/virtual/site/backups/site-backup-2015.06.24-23-41.tar.bz2 to 1006:1006
[Wed Jun 24 23:41:22 2015] [debug] iMSCP::Database::mysql::dumpdb: Dump 6_wp into /var/www/virtual/site/backups/6_wp.sql
[Wed Jun 24 23:41:22 2015] [debug] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --default-character-set=utf8 --quote-names --result-file='/var/www/virtual/site/backups/6_wp.sql' 6_wp
[Wed Jun 24 23:41:22 2015] [debug] iMSCP::Execute::getExitCode: External command exited with value 2
[Wed Jun 24 23:41:22 2015] [error] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
[Wed Jun 24 23:41:22 2015] [debug] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/mail/virtual/site --use-compress-program=pbzip2 --file=/var/www/virtual/site/backups/mail-site-backup-2015.06.24-23-41.tar.bz2 .
[Wed Jun 24 23:41:22 2015] [debug] iMSCP::Execute::getExitCode: External command exited with value 0
[Wed Jun 24 23:41:22 2015] [debug] iMSCP::File::mode: Changing mode for /var/www/virtual/site/backups/mail-site-backup-2015.06.24-23-41.tar.bz2 to 644
[Wed Jun 24 23:41:22 2015] [debug] iMSCP::File::owner: Changing owner and group for /var/www/virtual/site/backups/mail-site-backup-2015.06.24-23-41.tar.bz2 to 1006:1006
[Wed Jun 24 23:41:23 2015] [debug] iMSCP::Bootstrapper::unlock: Release exclusive lock on /tmp/imscp-backup-all.lock

**Nuxwin** · Jun 25th 2015

Hello ;

Please remove the /root/.my.cnf file if any

See also https://github.com/i-MSCP/imsc…_errata.md#rootmycnf-file

tilicar · Jun 25th 2015

it is allready removed.
I will track the email to see if the problem was before last update.

tilicar · Jun 25th 2015

RE;
Still have the problem !

mafioso · Jun 25th 2015

Please rerun the backup-script with parameter -v and post the output
/var/www/imscp/engine/backup/imscp-backup-all -v

**Nuxwin** · Jun 25th 2015

@tilicar

Please, check that in the /etc/mysql/conf.d/imscp.cnf, the password for the root user is OK in the mysqldump section. If the password is wrong, you must update it. And be sure that the /root/.my.cnf file is removed.

Once done, try to run the backup script manually as follow;

Shell-Script

# perl /var/www/imscp/engine/backup/imscp-backup-all -v

Then, post the output.

tilicar · Jun 25th 2015

Code

[DEBUG] iMSCP::Bootstrapper::lock: Acquire exclusive lock on /tmp/imscp-backup-all.lock
[DEBUG] iMSCP::Bootstrapper::boot: Booting backend...
[DEBUG] iMSCP::Config::_init: Tying /etc/imscp/imscp.conf
[DEBUG] iMSCP::Config::_loadConfig: Loading /etc/imscp/imscp.conf
[DEBUG] iMSCP::Config::_parseConfig: Parsing /etc/imscp/imscp.conf
[DEBUG] iMSCP::Execute::execute: Executing command: rm -fR /var/www/virtual/gratare.tk/backups/*
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/www/virtual/gratare.tk --use-compress-program=pbzip2 --file=/var/www/virtual/gratare.tk/backups/gratare.tk-backup-2015.06.26-00-53.tar.bz2 --exclude=logs --exclude=phptmp --exclude=backups --exclude=domain_disable_page .
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::File::mode: Changing mode for /var/www/virtual/gratare.tk/backups/gratare.tk-backup-2015.06.26-00-53.tar.bz2 to 644
[DEBUG] iMSCP::File::owner: Changing owner and group for /var/www/virtual/gratare.tk/backups/gratare.tk-backup-2015.06.26-00-53.tar.bz2 to 1006:1006
[DEBUG] iMSCP::Database::mysql::dumpdb: Dump 6_wp into /var/www/virtual/gratare.tk/backups/6_wp.sql
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --default-character-set=utf8 --quote-names --result-file='/var/www/virtual/gratare.tk/backups/6_wp.sql' 6_wp
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 2
[DEBUG] iMSCP::Config::_init: Tying /etc/imscp/postfix/postfix.data
[DEBUG] iMSCP::Config::_loadConfig: Loading /etc/imscp/postfix/postfix.data
[DEBUG] iMSCP::Config::_parseConfig: Parsing /etc/imscp/postfix/postfix.data
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/mail/virtual/gratare.tk --use-compress-program=pbzip2 --file=/var/www/virtual/gratare.tk/backups/mail-gratare.tk-backup-2015.06.26-00-53.tar.bz2 .
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::File::mode: Changing mode for /var/www/virtual/gratare.tk/backups/mail-gratare.tk-backup-2015.06.26-00-53.tar.bz2 to 644
[DEBUG] iMSCP::File::owner: Changing owner and group for /var/www/virtual/gratare.tk/backups/mail-gratare.tk-backup-2015.06.26-00-53.tar.bz2 to 1006:1006
[DEBUG] iMSCP::Execute::execute: Executing command: rm -fR /var/www/virtual/tilicar.tk/backups/*
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/www/virtual/tilicar.tk --use-compress-program=pbzip2 --file=/var/www/virtual/tilicar.tk/backups/tilicar.tk-backup-2015.06.26-00-54.tar.bz2 --exclude=logs --exclude=phptmp --exclude=backups --exclude=domain_disable_page .
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::File::mode: Changing mode for /var/www/virtual/tilicar.tk/backups/tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 644
[DEBUG] iMSCP::File::owner: Changing owner and group for /var/www/virtual/tilicar.tk/backups/tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 1008:1008
[DEBUG] iMSCP::Database::mysql::dumpdb: Dump 8_ana into /var/www/virtual/tilicar.tk/backups/8_ana.sql
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --default-character-set=utf8 --quote-names --result-file='/var/www/virtual/tilicar.tk/backups/8_ana.sql' 8_ana
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 2
[DEBUG] iMSCP::Database::mysql::dumpdb: Dump 8_drupal into /var/www/virtual/tilicar.tk/backups/8_drupal.sql
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --default-character-set=utf8 --quote-names --result-file='/var/www/virtual/tilicar.tk/backups/8_drupal.sql' 8_drupal
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 2
[DEBUG] iMSCP::Database::mysql::dumpdb: Dump 8_soft into /var/www/virtual/tilicar.tk/backups/8_soft.sql
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --default-character-set=utf8 --quote-names --result-file='/var/www/virtual/tilicar.tk/backups/8_soft.sql' 8_soft
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 2
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/mail/virtual/soft.tilicar.tk --use-compress-program=pbzip2 --file=/var/www/virtual/tilicar.tk/backups/mail-soft.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 .
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::File::mode: Changing mode for /var/www/virtual/tilicar.tk/backups/mail-soft.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 644
[DEBUG] iMSCP::File::owner: Changing owner and group for /var/www/virtual/tilicar.tk/backups/mail-soft.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 1008:1008
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/mail/virtual/drupal.tilicar.tk --use-compress-program=pbzip2 --file=/var/www/virtual/tilicar.tk/backups/mail-drupal.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 .
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::File::mode: Changing mode for /var/www/virtual/tilicar.tk/backups/mail-drupal.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 644
[DEBUG] iMSCP::File::owner: Changing owner and group for /var/www/virtual/tilicar.tk/backups/mail-drupal.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 1008:1008
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/mail/virtual/test.tilicar.tk --use-compress-program=pbzip2 --file=/var/www/virtual/tilicar.tk/backups/mail-test.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 .
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::File::mode: Changing mode for /var/www/virtual/tilicar.tk/backups/mail-test.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 644
[DEBUG] iMSCP::File::owner: Changing owner and group for /var/www/virtual/tilicar.tk/backups/mail-test.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 1008:1008
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/mail/virtual/app.tilicar.tk --use-compress-program=pbzip2 --file=/var/www/virtual/tilicar.tk/backups/mail-app.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 .
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::File::mode: Changing mode for /var/www/virtual/tilicar.tk/backups/mail-app.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 644
[DEBUG] iMSCP::File::owner: Changing owner and group for /var/www/virtual/tilicar.tk/backups/mail-app.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 1008:1008
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/mail/virtual/phpbb.tilicar.tk --use-compress-program=pbzip2 --file=/var/www/virtual/tilicar.tk/backups/mail-phpbb.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 .
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::File::mode: Changing mode for /var/www/virtual/tilicar.tk/backups/mail-phpbb.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 644
[DEBUG] iMSCP::File::owner: Changing owner and group for /var/www/virtual/tilicar.tk/backups/mail-phpbb.tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 1008:1008
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/mail/virtual/tilicar.tk --use-compress-program=pbzip2 --file=/var/www/virtual/tilicar.tk/backups/mail-tilicar.tk-backup-2015.06.26-00-54.tar.bz2 .
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::File::mode: Changing mode for /var/www/virtual/tilicar.tk/backups/mail-tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 644
[DEBUG] iMSCP::File::owner: Changing owner and group for /var/www/virtual/tilicar.tk/backups/mail-tilicar.tk-backup-2015.06.26-00-54.tar.bz2 to 1008:1008
[DEBUG] iMSCP::Execute::execute: Executing command: rm -fR /var/www/virtual/tilicarhost.tk/backups/*
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/www/virtual/tilicarhost.tk --use-compress-program=pbzip2 --file=/var/www/virtual/tilicarhost.tk/backups/tilicarhost.tk-backup-2015.06.26-00-54.tar.bz2 --exclude=logs --exclude=phptmp --exclude=backups --exclude=domain_disable_page .
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::File::mode: Changing mode for /var/www/virtual/tilicarhost.tk/backups/tilicarhost.tk-backup-2015.06.26-00-54.tar.bz2 to 644
[DEBUG] iMSCP::File::owner: Changing owner and group for /var/www/virtual/tilicarhost.tk/backups/tilicarhost.tk-backup-2015.06.26-00-54.tar.bz2 to 1007:1007
[DEBUG] iMSCP::Database::mysql::dumpdb: Dump 7_wp into /var/www/virtual/tilicarhost.tk/backups/7_wp.sql
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --default-character-set=utf8 --quote-names --result-file='/var/www/virtual/tilicarhost.tk/backups/7_wp.sql' 7_wp
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 2
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/mail/virtual/tilicarhost.tk --use-compress-program=pbzip2 --file=/var/www/virtual/tilicarhost.tk/backups/mail-tilicarhost.tk-backup-2015.06.26-00-54.tar.bz2 .
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::File::mode: Changing mode for /var/www/virtual/tilicarhost.tk/backups/mail-tilicarhost.tk-backup-2015.06.26-00-54.tar.bz2 to 644
[DEBUG] iMSCP::File::owner: Changing owner and group for /var/www/virtual/tilicarhost.tk/backups/mail-tilicarhost.tk-backup-2015.06.26-00-54.tar.bz2 to 1007:1007
[DEBUG] iMSCP::Execute::execute: Executing command: nice -n 15 ionice -c2 -n5 tar --create --directory=/var/mail/virtual/app.tilicarhost.tk --use-compress-program=pbzip2 --file=/var/www/virtual/tilicarhost.tk/backups/mail-app.tilicarhost.tk-backup-2015.06.26-00-54.tar.bz2 .
[DEBUG] iMSCP::Execute::getExitCode: External command exited with value 0
[DEBUG] iMSCP::File::mode: Changing mode for /var/www/virtual/tilicarhost.tk/backups/mail-app.tilicarhost.tk-backup-2015.06.26-00-54.tar.bz2 to 644
[DEBUG] iMSCP::File::owner: Changing owner and group for /var/www/virtual/tilicarhost.tk/backups/mail-app.tilicarhost.tk-backup-2015.06.26-00-54.tar.bz2 to 1007:1007
[DEBUG] iMSCP::Bootstrapper::unlock: Release exclusive lock on /tmp/imscp-backup-all.lock
[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect
iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: NO) when trying to connect