I noticed that the mythbox setting for:
MythTV => Master Backend Hostname = mythtv /
127.0.0.1
When I am in my AppleTV, mythtv does not resolve to an IP address whereas mythtv
. does resolve:
Code:
-bash-2.05b$ ping -c 3 mythtv
ping: cannot resolve mythtv: Unknown host
-bash-2.05b$ ping -c 3 mythtv.
PING mythtv (192.168.8.106): 56 data bytes
64 bytes from 192.168.8.106: icmp_seq=0 ttl=64 time=0.329 ms
64 bytes from 192.168.8.106: icmp_seq=1 ttl=64 time=1.106 ms
64 bytes from 192.168.8.106: icmp_seq=2 ttl=64 time=0.233 ms
--- mythtv ping statistics ---
3 packets transmitted, 3 packets received, 0% packet loss
round-trip min/avg/max/stddev = 0.233/0.556/1.106/0.391 ms
Because the "test settings" menu item returns: "Error: Connection to MythTV host 127.0.0.1 failed (22, 'Inv..." my initial reaction is to try to change the hostname to from mythtv to mythtv
.: not really sure if 127.0.0.1 should be of the format: 192.168.X.Y. Why would you use localhost? This parameter is greyed out and it does not like this option can be edited.
Here is a list of my configuration parameters:
Quote:
MySQL DB => Hostname = mythv.
MySQL DB => Port= 3306
MySQL DB => Database Name = mythconverg
MySQL DB => User = mythv
MySQL DB => Password = mythv
MythTV => Master Backend Hostname = /127.0.0.1
MythTV => Master Backend Port = 6543
MythTV => Enable Streaming = White dot (not selected?)
MythTV => Local Recording directory(s) = /change/me
MythTV => Confirm on Delete = white dot (not selected?)
MythTV => Enable aggressive checking = grey dot (selected?)
Fan Art => All are white Dot
Test Settings => Error, Connection to MythTV host 127.0.0.1 failed: 22, "INv...
Advanced => Enable debug logging = white dot
Adavanced => Twitter Feeds = mythboxfeed
About: Mythbox for XBMC 1.0.3 mythbox.googlecode.com
@robthegob: does these parameters match with your configuration?
I decided to add the following line to etc\hosts on the Apple TV:
Code:
192.168.8.106 mythtv
After this change, the ATV can resolve the hostanme mythtv (sans period):
Code:
-bash-2.05b$ ping -c 3 mythtv
PING mythtv (192.168.8.106): 56 data bytes
64 bytes from 192.168.8.106: icmp_seq=0 ttl=64 time=0.877 ms
64 bytes from 192.168.8.106: icmp_seq=1 ttl=64 time=0.498 ms
64 bytes from 192.168.8.106: icmp_seq=2 ttl=64 time=0.348 ms
--- mythtv ping statistics ---
3 packets transmitted, 3 packets received, 0% packet loss
round-trip min/avg/max/stddev = 0.348/0.574/0.877/0.223 ms
Rebooted ATV.
The mythbox paramater MYSQL_DB => Hostname now accepts mythtv (sans period).
I observed that that these two parameters would 'grey out and have no values' when I removed the '.' after the hostname (mythtv) in the paramater MYSQL_DB => Hostname = mythtv (sans period):
MythTV => Master Backend Hostname =
MythTV => Master Backend Port =
I have to decide whether to include the '.' after the hostname for the paramater: MYSQL_DB => Hostname. For now I choose to include the '.' in the hostname because it corresponds to ensuring that the MBE Hostname and ports have values.
Both sceneraios result in the same error when "test settings" is invoked. Interestingly enough, after "test setting" is invoked, the parameters for MBE hostname and port are disappeared and the same error is invoked.
Here is the pastebin from my initial post:
Mythbox Log PastebinAfter verifying that the database name, user & pw are valid:
Code:
[root@mythtv ~]# mysql --user=mythtv --password=mythtv mythconverg
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2797
Server version: 5.0.75 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
I think that I have exhausted tinkering with the configuration paramaters (I am hoping that I am wrong and that someone will point out something else that can be tried. In particular, I do not know of a good test to verify that the MBE port is 6543 (seems moot, considering that this is not something that can be configured) and I think that 3306 is working because I was able to extract a database ERD out of this port using Embarcadero.
Can anyone comment as to why localhost (127.0.0.1) was automatically configured, when the hostname is user supplied?
_________________
R7.3: 0.22.20091023-1, Hauppauge PVR-500 (Philips FQ1236A MK4),
Gigabyte Gigabyte EG45M-UD2H, E5200 2.4Ghz, 2GB RAM, NVIDIA GEFORCE 256MB