mythbuntu-bugs team mailing list archive

[Ryan Davies <829066@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: mythbuntu
     Importance: Undecided
         Status: New


** Tags: mysql mythtv-backend mythtv-database

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