MythBox: Connection to mythtv host 127.0.0.1 failed

The system setup:
MythTV backend running on a separate machine (e.g. 192.168.1.4)
XBMC MythBox plugin running on a separate computer (e.g. 192.168.1.5)

This error occurs during MythBox setup, stating the following after MySQL credentials are entered: Connection to mythtv host 127.0.0.1 failed: (10061..

This can be a plain MySQL error, but it can also be an error where the MySQL connection is successful but MythBox is referred back to 127.0.0.1 when it tries to connect (by settings on the mythtv backend system).

Checklist:
– Ensure that the MySQL user can connect remotely. To test this from another computer:

$ mysql -h 192.168.1.4 -u mythtv -p

If not working, check MySQL permissions for the mythtv user (make sure the host field for the user is ‘%’) and look at my.cnf (find the file with `locate my.cnf`).

From the mythtv backend:
$ mysql -u root -p
mysql> use mysql;
mysql> select * from user where user = 'mythtv';

* If MySQL is working, ensure that the MythTV backend is setup properly.

Summary:
Run mythtv-setup
Go General -> IP Address
Set both IP addresses to the external IP of the machine you are connecting to from XBMC (setting only Local Backend to an external address did not work).

References: http://wiki.xbmc.org/?title=MythTV#Setup_in_MythTV

Advertisements

One response to “MythBox: Connection to mythtv host 127.0.0.1 failed

  1. vadim

    Thanks for the tip. My problem was in MythTV backend setup.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: