mythtv-database fails to install/upgrade with remote mysql database

[Ryan Davies]

Install/Upgrade fails when mysql server is not on the same machine as the backend with:

Setting up mythtv-database (2:0.24.1+fixes.20110818.4bc24ed-0ubuntu0mythbuntu4) ...
Failed to connect to database (incorrect admin password)
ERROR 2005 (HY000): Unknown MySQL server host '"mysql.localnet"' (1)
ERROR 2005 (HY000): Unknown MySQL server host '"mysql.localnet"' (1)
ERROR 2005 (HY000): Unknown MySQL server host '"mysql.localonet"' (1)
ERROR 2005 (HY000): Unknown MySQL server host '"mysql.localnet"' (1)
ERROR 2005 (HY000): Unknown MySQL server host '"mysql.localnet"' (1)
Failed to create or modify database (incorrect admin username/password?)
Try:
sudo dpkg-reconfigure mythtv-database

This machine is resolvable from the backend machine:
ryan@Doctor:~/Desktop$ nslookup mysql.localnet
Server: 192.168.254.1
Address: 192.168.254.1#53

mysql.localnet canonical name = picard.localnet.
Name: picard.localnet
Address: 192.168.254.1

Removing the escaped quotes (See Patch/Diff) on --host and --user of each of the SECURITY_INFO= lines fixes this issue

[Gunni (fgunni)]

Patch works for me.
I use 0.25 from the mythbuntu repos.

[Ubuntu Foundations Team Bug Bot (crichton)]

The attachment "Diff/Patch of changes required to make this workj as intended." of this bug report has been identified as being a patch. The ubuntu-reviewers team has been subscribed to the bug report so that they can review the patch. In the event that this is in fact not a patch you can resolve this situation by removing the tag 'patch' from the bug report and editing the attachment so that it is not flagged as a patch. Additionally, if you are member of the ubuntu-reviewers team please also unsubscribe the team from this bug report.

[This is an automated message performed by a Launchpad user owned by Brian Murray. Please contact him regarding any issues with the action taken in this bug report.]

[Mario Limonciello (superm1)]

Thanks for the patch Ryan, and the confirmation that it worked Gunni. I've added it to the -fixes and -master packaging branches. It should be available in any autobuilds containing the date 12/08/2011 or later and in precise after this bug is marked fixed released.

[Mario Limonciello (superm1)]

This has been fixed in precise via an upload of 0.25.