IMSCP 1.4.0 backup error

**Viktor** · Mar 27th 2017

Hallo,

I have update i-MSCP to 1.4.0 and now I become a Mail with this error.

Quote

Version: 1.4.0
Build: 20170326
Message severity: error
==========================================================================
An error has been raised while executing function main::run in/var/www/imscp/engine/backup/imscp-backup-all:
iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045:
Access deniedfor user 'root'@'localhost' (using password: YES) when trying to connecti
MSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045:
Access deniedfor user 'root'@'localhost' (using password: YES) when trying to connect
iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045:
Access deniedfor user 'root'@'localhost' (using password: YES) when trying to connect

Display More

How con I sove this error?

Kind regards
Viktor

System: Ubuntu 16.04LTS
i-MSCP: 1.4.0

gOOvER · Mar 27th 2017

can you connect as root via pma?

Bulli · Mar 27th 2017

What is with imscp_user account? From which version you've upgrade?

gOOvER · Mar 27th 2017

i bet auth_socket is activated as Plugin.

**Nuxwin** · Mar 27th 2017

Quote from gOOvER

i bet auth_socket is activated as Plugin.

That the default behavior on MariaDB 10.1 for the root (eg, on Debian Stretch) but i-MSCP do not make usage of root user

@Viktor

It is local SQL server? MySQL? MariaDB? Percona?
Can you connect to MySQL monitor?

**Viktor** · Mar 27th 2017

Hallo,

I have MySQL 5.7.

With the imscp_user I can Login and all is working.

In the Usertable I see:

root 127.0.0.1
root ::1

Only the Backup is not working.

Kind regards
Viktor

**Nuxwin** · Mar 27th 2017

@Viktor

What the result of the following command:

Code

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

Also please, post the content of the /etc/mysql/conf.d/imscp.cnf file (hide the password from the client section).
Also, give us the result of the following command: ls -la /root

**Viktor** · Mar 27th 2017

Hallo Nuxwin,

here the result.

Code

root@ubuntu:~# perl /var/www/imscp/engine/backup/imscp-backup-all -v[DEBUG] iMSCP::Bootstrapper::lock: Acquire exclusive lock on /tmp/imscp-backup-all.lock[DEBUG] iMSCP::Bootstrapper::boot: Booting backend....[DEBUG] iMSCP::Config::_loadConfig: Tying /etc/imscp/imscp.conf file in readonly mode[DEBUG] iMSCP::Config::_loadConfig: Tying /etc/imscp/mysql/mysql.data file in readonly mode[DEBUG] iMSCP::Config::_loadConfig: Tying /etc/imscp/postfix/postfix.data file in readonly mode[DEBUG] iMSCP::Execute::execute: rm -fR /var/www/virtual/v-gn.com/backups/*[DEBUG] iMSCP::Execute::execute: tar -c -C /var/www/virtual/v-gn.com --exclude=logs --exclude=phptmp --exclude=backups . | bzip2 -1 > /var/www/virtual/v-gn.com/backups/v-gn.com-backup-2017.03.27-11-34.tar.bz2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `freakslite` database into /var/www/virtual/v-gn.com/backups/freakslite.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/freakslite.sql -B freakslite[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb318` database into /var/www/virtual/v-gn.com/backups/wbb318.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb318.sql -B wbb318[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `flxshare` database into /var/www/virtual/v-gn.com/backups/flxshare.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/flxshare.sql -B flxshare[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_pschab` database into /var/www/virtual/v-gn.com/backups/wbb23_pschab.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_pschab.sql -B wbb23_pschab[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `usermap` database into /var/www/virtual/v-gn.com/backups/usermap.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/usermap.sql -B usermap[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `dbmike` database into /var/www/virtual/v-gn.com/backups/dbmike.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/dbmike.sql -B dbmike[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `allinone` database into /var/www/virtual/v-gn.com/backups/allinone.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/allinone.sql -B allinone[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `familien` database into /var/www/virtual/v-gn.com/backups/familien.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/familien.sql -B familien[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23vgbayn` database into /var/www/virtual/v-gn.com/backups/wbb23vgbayn.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23vgbayn.sql -B wbb23vgbayn[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_regcode` database into /var/www/virtual/v-gn.com/backups/wbb23_regcode.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_regcode.sql -B wbb23_regcode[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_thread` database into /var/www/virtual/v-gn.com/backups/wbb23_thread.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_thread.sql -B wbb23_thread[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_wedaal` database into /var/www/virtual/v-gn.com/backups/wbb23_wedaal.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_wedaal.sql -B wbb23_wedaal[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_vgdb` database into /var/www/virtual/v-gn.com/backups/wbb23_vgdb.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_vgdb.sql -B wbb23_vgdb[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb216` database into /var/www/virtual/v-gn.com/backups/wbb216.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb216.sql -B wbb216[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb3pschab` database into /var/www/virtual/v-gn.com/backups/wbb3pschab.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb3pschab.sql -B wbb3pschab[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_pcoins` database into /var/www/virtual/v-gn.com/backups/wbb23_pcoins.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_pcoins.sql -B wbb23_pcoins[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `bekleveg` database into /var/www/virtual/v-gn.com/backups/bekleveg.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/bekleveg.sql -B bekleveg[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbblitep` database into /var/www/virtual/v-gn.com/backups/wbblitep.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbblitep.sql -B wbblitep[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23sim` database into /var/www/virtual/v-gn.com/backups/wbb23sim.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23sim.sql -B wbb23sim[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `1test` database into /var/www/virtual/v-gn.com/backups/1test.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/1test.sql -B 1test[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `fsync` database into /var/www/virtual/v-gn.com/backups/fsync.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/fsync.sql -B fsync[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `bckleve` database into /var/www/virtual/v-gn.com/backups/bckleve.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/bckleve.sql -B bckleve[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_lizenz` database into /var/www/virtual/v-gn.com/backups/wbb23_lizenz.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_lizenz.sql -B wbb23_lizenz[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `ramcloud` database into /var/www/virtual/v-gn.com/backups/ramcloud.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/ramcloud.sql -B ramcloud[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `open3600` database into /var/www/virtual/v-gn.com/backups/open3600.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/open3600.sql -B open3600[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `v-gn_wbb` database into /var/www/virtual/v-gn.com/backups/v-gn_wbb.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/v-gn_wbb.sql -B v-gn_wbb[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb4` database into /var/www/virtual/v-gn.com/backups/wbb4.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb4.sql -B wbb4[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_vgblog` database into /var/www/virtual/v-gn.com/backups/wbb23_vgblog.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_vgblog.sql -B wbb23_vgblog[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb5` database into /var/www/virtual/v-gn.com/backups/wbb5.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb5.sql -B wbb5[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `ramtest` database into /var/www/virtual/v-gn.com/backups/ramtest.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/ramtest.sql -B ramtest[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_treffen` database into /var/www/virtual/v-gn.com/backups/wbb23_treffen.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_treffen.sql -B wbb23_treffen[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `simple_invoices` database into /var/www/virtual/v-gn.com/backups/simple_invoices.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/simple_invoices.sql -B simple_invoices[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb4ram` database into /var/www/virtual/v-gn.com/backups/wbb4ram.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb4ram.sql -B wbb4ram[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `joomla` database into /var/www/virtual/v-gn.com/backups/joomla.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/joomla.sql -B joomla[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `bene` database into /var/www/virtual/v-gn.com/backups/bene.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/bene.sql -B bene[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `GEOCODES` database into /var/www/virtual/v-gn.com/backups/GEOCODES.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/GEOCODES.sql -B GEOCODES[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_literatur` database into /var/www/virtual/v-gn.com/backups/wbb23_literatur.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_literatur.sql -B wbb23_literatur[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `typolight` database into /var/www/virtual/v-gn.com/backups/typolight.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/typolight.sql -B typolight[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `usrdb_krebsdba1` database into /var/www/virtual/v-gn.com/backups/usrdb_krebsdba1.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/usrdb_krebsdba1.sql -B usrdb_krebsdba1[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb3_test` database into /var/www/virtual/v-gn.com/backups/wbb3_test.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb3_test.sql -B wbb3_test[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb_lite` database into /var/www/virtual/v-gn.com/backups/wbb_lite.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb_lite.sql -B wbb_lite[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23vgbay` database into /var/www/virtual/v-gn.com/backups/wbb23vgbay.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23vgbay.sql -B wbb23vgbay[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_foto20` database into /var/www/virtual/v-gn.com/backups/wbb23_foto20.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_foto20.sql -B wbb23_foto20[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_foto` database into /var/www/virtual/v-gn.com/backups/wbb23_foto.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_foto.sql -B wbb23_foto[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb22_literatur` database into /var/www/virtual/v-gn.com/backups/wbb22_literatur.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb22_literatur.sql -B wbb22_literatur[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23_kontakt` database into /var/www/virtual/v-gn.com/backups/wbb23_kontakt.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23_kontakt.sql -B wbb23_kontakt[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `mybb` database into /var/www/virtual/v-gn.com/backups/mybb.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/mybb.sql -B mybb[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `t2web` database into /var/www/virtual/v-gn.com/backups/t2web.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/t2web.sql -B t2web[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbblite2` database into /var/www/virtual/v-gn.com/backups/wbblite2.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbblite2.sql -B wbblite2[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `owncloud` database into /var/www/virtual/v-gn.com/backups/owncloud.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/owncloud.sql -B owncloud[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `gllcTS2` database into /var/www/virtual/v-gn.com/backups/gllcTS2.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/gllcTS2.sql -B gllcTS2[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `wbb23pgs` database into /var/www/virtual/v-gn.com/backups/wbb23pgs.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/wbb23pgs.sql -B wbb23pgs[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Database::mysql::dumpdb: Dump `imscp_test` database into /var/www/virtual/v-gn.com/backups/imscp_test.sql[DEBUG] iMSCP::Execute::execute: mysqldump --opt --complete-insert --add-drop-database --allow-keywords --compress --quote-names -r /var/www/virtual/v-gn.com/backups/imscp_test.sql -B imscp_test[DEBUG] iMSCP::Execute::getExitCode: Command exited with value: 2[DEBUG] iMSCP::Execute::execute: tar -c -C /var/mail/virtual/v-gn.com . | bzip2 -1 > /var/www/virtual/v-gn.com/backups/mail-v-gn.com-backup-2017.03.27-11-34.tar.bz2[DEBUG] iMSCP::Execute::execute: tar -c -C /var/mail/virtual/fsync.v-gn.com . | bzip2 -1 > /var/www/virtual/v-gn.com/backups/mail-fsync.v-gn.com-backup-2017.03.27-11-34.tar.bz2[DEBUG] iMSCP::Bootstrapper::unlock: Releasing 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: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect[ERROR] iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

/etc/mysql/conf.d/imscp.cnf

Code

[client]host = localhostport = 3306user = "imscp_user"password = "*********"[mysqld]performance_schema = 0sql_mode = "NO_AUTO_CREATE_USER"max_connections = 500innodb_use_native_aio = 1default_password_lifetime = 0event_scheduler = DISABLED

Code

root@ubuntu:~# ls -la /root
insgesamt 476876
drwx------ 15 root root 4096 Mär 27 10:42 .
drwxr-xr-x 27 root root 4096 Mär 15 22:59 ..
-rw-r--r-- 1 root root 1320 Dez 5 2002 –
drwx------ 2 root root 4096 Okt 2 13:46 .aptitude
-rw------- 1 root root 37999 Mär 27 11:07 .bash_history
-rw-r--r-- 1 root root 3106 Feb 20 2014 .bashrc
drwx------ 6 root root 4096 Sep 10 2016 .cache
drwxr-xr-x 3 root root 4096 Jul 27 2014 .composer
drwx------ 9 root root 4096 Okt 29 2015 .config
drwx------ 3 root root 4096 Jun 25 2014 .dbus
drwxr-xr-x 3 root root 4096 Jul 17 2014 .distlib
drwx------ 3 root root 4096 Okt 2 21:40 .gnupg
drwx------ 2 root root 4096 Okt 2 18:04 .gvfs
-rw-r--r-- 1 root root 1692 Jul 11 2007 izzysoft.asc
-rw-r--r-- 1 root root 1320 Dez 5 2002 jcameron-key.asc
-rw-r--r-- 1 root root 327993322 Nov 12 18:04 kfa_de_db3-20161112-1800.sql
drwxr-xr-x 14 root root 4096 Dez 4 2015 letsencrypt
drwx------ 3 root root 4096 Jun 17 2014 .local
-rw-r--r-- 1 root root 375 Jun 24 2014 log.log
-rw------- 1 root root 69 Sep 26 2015 .my.cnf
-rw------- 1 root root 18 Mär 27 10:42 .mysql_history
-rw-r--r-- 1 root root 148 Aug 17 2015 .profile
drwx------ 3 root root 4096 Jul 17 2014 .python-eggs
-rw------- 1 root root 1024 Dez 23 19:41 .rnd
-rw-r--r-- 1 root root 72 Jun 19 2014 .selected_editor
-rw-r--r-- 1 root root 12560 Jul 26 2002 serial_loopback.pl
-rw-r--r-- 1 root root 0 Sep 18 2014 set
drwx------ 3 root root 4096 Sep 26 2015 .spamassassin
drwx------ 2 root root 4096 Mai 25 2016 .ssh
-rw-r--r-- 1 root root 0 Okt 5 2014 test
-rw-r--r-- 1 root root 158714633 Feb 25 22:51 v-gn_wbb.sql
-rw------- 1 root root 611 Mär 28 2016 .viminfo
-rw-r--r-- 1 root root 1434134 Feb 25 22:51 wbb5.sql
-rw-r--r-- 1 root root 261 Mär 26 23:35 .wget-hsts

Display More

Kind reagrds
Viktor

**Nuxwin** · Mar 27th 2017

@Viktor

Please:

Shell-Script

# rm /root/.my.cnf

Once done:

Shell-Script

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

Thanks.

**Viktor** · Mar 27th 2017

Hallo Nuxwin,

now it is working fine.

Thanks for the support.

Kind regrads
Viktor

IMSCP 1.4.0 backup error

Share

Similar Threads

i-MSCP 1.5.3 RELEASED

Lets Encrypt Panel Certificate renew

Keine Backup Wiederherstellung möglich No backup recovery possible

1.5.1 - Couldn't install/update i-MSCP packages from GitHub

No system backups since upgrade to i-MSCP 1.4.4

Daily visitors