+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Development Area (/forum-1.html)
+--- Forum: General discussion (/forum-11.html)
+--- Thread: mysql dump in ispcp-backup-all broken after password encryption (/thread-6163.html)
mysql dump in ispcp-backup-all broken after password encryption - ispcomm - 03-23-2009 05:37 PM
Hi all,
the title says it all: the current implementation of ispcp-backup-all does not decrypt passwords when it needs to dump user databases. The result is that mysqldump cannot connect to the database and the backup is not performed.
A quick solution is to change line 342:
Code:
my $db_backupcmd = "$main::cfg{'CMD_MYSQLDUMP'} --add-drop-table --allow-keywords --quote-names -h\'$main::cfg{'DATABASE_HOST'}\' -u\'$dbuser\' -p\'$dbpass\' \'$db_name\' >\'$db_backup_file\'";Code:
my $db_backupcmd = "$main::cfg{'CMD_MYSQLDUMP'} --add-drop-table --allow-keywords --quote-names -h\'$main::cfg{'DATABASE_HOST'}\' -uroot -proot-password \'$db_name\' >\'$db_backup_file\'";ispcomm.
RE: mysql dump in ispcp-backup-all broken after password encryption - BeNe - 03-23-2009 09:56 PM
Should be solved in trunk or not ?
--> http://www.isp-control.net/ispcp/ticket/1729#comment:4
--> http://www.isp-control.net/ispcp/changeset/1582
--> http://www.isp-control.net/ispcp/changeset/1583
Greez BeNe
RE: mysql dump in ispcp-backup-all broken after password encryption - ispcomm - 03-26-2009 06:45 PM
That ticket look nice
