Opened 11 years ago

Closed 11 years ago

#7612 closed defect (fixed)

mythconverg_backup.pl bails on MySQL passwords with special characters

Reported by: comptona@… Owned by: sphery
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 (1)

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

Download all attachments as: .zip

Change History (2)

Changed 11 years ago by comptona@…

Attachment: mythconverg_backup.patch added

patch to fix mythconverg_backup.pl

comment:1 Changed 11 years ago by sphery

Resolution: fixed
Status: newclosed

(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.

Note: See TracTickets for help on using tickets.