Current time: 10-27-2021, 04:46 AM Hello There, Guest! (LoginRegister)


Post Reply 
mysql dump in ispcp-backup-all broken after password encryption
Author Message
ispcomm Offline
Junior Member
*

Posts: 93
Joined: Apr 2008
Reputation: 3
Post: #1
mysql dump in ispcp-backup-all broken after password encryption
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\'";
to
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\'";
However a proper solution would be better. I have not opened a ticket for this problem.
ispcomm.
03-23-2009 05:37 PM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #2
RE: mysql dump in ispcp-backup-all broken after password encryption
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
03-23-2009 09:56 PM
Visit this user's website Find all posts by this user Quote this message in a reply
ispcomm Offline
Junior Member
*

Posts: 93
Joined: Apr 2008
Reputation: 3
Post: #3
RE: mysql dump in ispcp-backup-all broken after password encryption
That ticket look nice Smile
03-26-2009 06:45 PM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)