[mythtv-users] Remote Frontend Won't Connect to Database

[Kevin Kuphal]

Kevin Kuphal wrote:
> Ed O'Brien wrote:
>   
>> I can't get my remote frontend (xbox) to successfully
>> connect to my backend. (Both are running Myth .19 -
>> Frontend on backend server works fine.) The myth
>> frontend will load properly on the xbox remote
>> machine, but will display a message stating that it
>> cannot connect to the database. After exiting the
>> frontend, I can see this error at the command line:
>>
>>      Connecting to backend server: localhost:6543 (try
>> 1 of 5)
>>      Connection timed out.
>>
>> My issue seems to be that the frontend is trying to
>> connect to the database on "localhost" - where it
>> obviously isn't going to find it. The problem is that
>> I can't seem to find the setting to change to correct
>> this. My frontend is running on an Xbox, but at this
>> point I think the problem is on my backend.
>>
>> My remote frontend general settings are: (Note:
>> 192.168.2.148 is the correct IP of my
>> backend/database, 192.168.2.180 is the IP of my xbox)
>>      Host name: 192.168.2.148
>>      Database: mythconverg
>>      User: mythtv
>>      Password: mythtv
>>      Database type: MySQL
>>
>> My backend general settings are:
>>      IP address for mythtv: 192.168.2.148
>>      Port the server runs on: 6543
>>      Port the server shows status on: 6544
>>      Master Server IP address: 192.168.2.148
>>      Port the master server runs on: 6543
>>
>> If I attempt to log into my backend database from the
>> command line on my frontend with user mythtv, it works
>> successfully, so I don't think it is a permissions
>> thing. The following command works fine from my remote
>> frontend: (using password mythtv)
>>      mysql -u mythtv -p -h 192.168.2.148
>> That command alone should prove that my xbox has the
>> proper DB permissions.
>>
>>
>> Another thing that seems strange is that from my
>> backend, I can type: (with a blank password)
>>      mysql -u root -p -h localhost
>> ....and successfully get in to my db.
>>
>> But, if I type:
>>      mysql -u root -p -h 192.168.2.148
>>
>> It doesn't let me in!!
>>
>> Where could the frontend be getting the idea that it
>> should connect to "localhost" for the database?
>>
>> I keep seeing this every time I try to connect:
>>
>>    Connecting to backend server: localhost:6543 (try 1
>> of 5)
>>    Connection timed out.         
>>    You probably should modify the Master Server
>>    settings in the setup program and set the   
>>    proper IP address.
>>
>> Can anyone tell me why I'm seeing localhost:6543 when
>> I have the backend IP address listed in the General
>> Setup of both my backend and frontend, as well at my
>> mysql.txt file? I think that is the root of my
>> problem.
>>   
>>     
> You need to change the IP of your backend in the backend setup
>
> http://www.mythtv.org/docs/mythtv-HOWTO-9.html#ss9.1
>
> Specifically the section about "If you will be deploying multiple 
> backends, or if your backend is on one system and you're running the 
> frontend on another machine then /do not/ use the "127.0.0.1" IP address."
>   
My bad.  You've already done. this. 

Kevin