mythbuntu-bugs team mailing list archive

[Ryan Davies <829066@xxxxxxxxxxxxxxxxxx>]

** Patch added: "Diff/Patch of changes required to make this workj as intended."
   https://bugs.launchpad.net/bugs/829066/+attachment/2290287/+files/mythtv-database.postinst.patch

-- 
You received this bug notification because you are a member of Mythbuntu
Bug Team, which is subscribed to Mythbuntu.
https://bugs.launchpad.net/bugs/829066

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

Status in Mythbuntu, Ubuntu derivative focused upon MythTV:
  New

Bug description:
  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

To manage notifications about this bug go to:
https://bugs.launchpad.net/mythbuntu/+bug/829066/+subscriptions