Hello,
from 2 days i have on all of my servers:
iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access deniedfor user 'root'@'localhost' (using password: YES) when trying to connect
mysql password is the same. What can be the reason ?
Problem is in file /var/www/imscp/engine/backup/imscp-backup-imscp
my $rs = $db->dumpdb($main::imscpConfig{'DATABASE_NAME'}, $sqlFName);
error("Unable to dump the $main::imscpConfig{'DATABASE_NAME'} database") if $rs;
return $rs if $rs;
Somehow $rs returns 2.How can i make it print user and password so i can see what is the problem exactly ?
I put extra prints in: imscp-backup-imscp
function "sub _backupDatabase"
print "Date: $date\n";
print "SQLFileName: $sqlFName\n";
print "DB Host: $main::imscpConfig{'DATABASE_HOST'}\n";
print "DB name: $main::imscpConfig{'DATABASE_NAME'}\n";
print "DB User: $main::imscpConfig{'DATABASE_USER'}\n";
print "DB Pass: $main::imscpConfig{'DATABASE_PASSWORD'}\n";
Date: 2015.03.16-15-51
SQLFileName: /var/www/imscp/backups/ispcp-2015.03.16-15-51.sql
DB Host: localhost
DB name: ispcp
DB User: root
DB Pass: *********
RS = 2
Information is absolutely correct as in /etc/imscp/imscp.conf but
still the scripts exits here:
my $rs = $db->dumpdb($main::imscpConfig{'DATABASE_NAME'}, $sqlFName);
error("Unable to dump the $main::imscpConfig{'DATABASE_NAME'} database") if $rs;
[ERROR]
iMSCP::Database::mysql::dumpdb: mysqldump: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect
main::_backupDatabase: Unable to dump the ispcp database
[FATAL]
Exit code: 2
Anyone can help ?
Additional info:
access denied i have only on machines which are upgraded from ispcp 1.0.7