Modify

Ticket #7612 (closed defect: fixed)

Opened 3 years ago

Last modified 2 years ago

mythconverg_backup.pl bails on MySQL passwords with special characters

Reported by: comptona@… Owned by: mdean
Priority: minor Milestone: unknown
Component: Contributed Scripts & Apps Version: head
Severity: medium Keywords:
Cc: Ticket locked: no

Description

My MythTV database password includes a # (thanks goodpassword.com!), and the mythconverg_backup script fails:

mysqldump exited with status: 2
mysqldump output:
mysqldump: Got error: 1045: Access denied for user 'mythtv'@'localhost' (using password: YES) when trying to connect

I found that surrounding the password in the defaults file with quotes fixes this issue. I've attached a patch for mythconverg_backup.pl; presumably a similar issue/fix exists with the restore script, but I haven't had the chance to test it. The bug exists in the current trunk version of this script (which I downloaded per http://www.mythbuntu.org/Upgrading).

Attachments

mythconverg_backup.patch (312 bytes) - added by comptona@… 3 years ago.
patch to fix mythconverg_backup.pl

Change History

Changed 3 years ago by comptona@…

patch to fix mythconverg_backup.pl

comment:1 Changed 2 years ago by mdean

  • Status changed from new to closed
  • Resolution set to fixed

(In [22950]) Fixes #7612. Allow backup and restore scripts to work with #, ', ", and whitespace in passwords. Thanks to comptona for finding the issue and a fix.

View

Add a comment

Modify Ticket

Action
as closed
The resolution will be deleted. Next status will be 'new'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.