[mythtv-users] Problem with the mythconverg database

[Nathan Smith]

On Oct 22, 2006, at 6:36 PM, Kevin Kuphal wrote:

> Nathan Smith wrote:
>> On Oct 22, 2006, at 6:12 PM, William Munson wrote:
>>
>>
>>> Nathan Smith wrote:
>>>
>>>> On Oct 22, 2006, at 5:20 PM, Kevin Kuphal wrote:
>>>>
>>>>
>>>>
>>>>> Nathan Smith wrote:
>>>>>
>>>>>
>>>>>> Hello everyone,
>>>>>>
>>>>>> I'm using mythtv-0.19, I'm running into problems connecting to  
>>>>>> the
>>>>>> database through another computer.
>>>>>>
>>>>>> On the computer which is running the mythtv backend, I can
>>>>>> connect to
>>>>>> the database, and I can run mythbackend and mythfrontend. On my
>>>>>> other
>>>>>> computer (which is a mac -- I built the mythtv-0.19 binary from
>>>>>> source), I get the following error when I try and connect to the
>>>>>> server:
>>>>>>
>>>>>> 2006-10-22 16:40:51.339 Connected to database 'mythconverg' at
>>>>>> host:
>>>>>> 192.168.1.11
>>>>>>
>>>>>>
>>>>>>
>>>>> Is 1.11 the frontend or the backend?  Is it quite a common
>>>>> mistake to
>>>>> connect a remote frontend to a mysql instance running locally
>>>>> instead of
>>>>> the mysql running on the backend.
>>>>>
>>>>>
>>>> 1.11 is the backend -- 1.50 is the frontend, so afaik I'm doing
>>>> things correctly.
>>>>
>>>> Nate
>>>>
>>>>
>>>>
>>>>
>>> Are you sure that you built the frontend with mysql support? The
>>> message
>>> you indicate shows a successful connection to the database.
>>>
>>
>> This could be a stupid response, but I don't see any options in
>> configure to enable/disable mysql support for mythtv?
>> Or are you asking if I built qt with mysql support? I did (I ran ./
>> configure -qt-sql-mysql -thread)
>>
> Is anything revealed if you run the frontend with "mythfrontend -v
> database" to show more of what is happening?

That worked! (or helped me figure out what was going on)

When I ran "mythfrontend -v database" I saw the line

2006-10-23 10:59:31.623 MSqlQuery: SELECT data FROM settings WHERE  
value = 'RunFrontendInWindow' AND hostname IS NULL;

so I found in the ~./.mythtv/mysql.txt file the line

LocalHostName=somethingIDidntWant

and changed it to the hostname of my server. Sweet

Nate