[mythtv-users] mythbackend on MBE Crashes When mythfrontend Attempts to Connect

[Robert Longbottom]

  On 29/08/2010 22:24, Mache Creeger wrote:
> At 11:09 AM 8/29/2010, Robert Longbottom wrote:
>> At 12:54 PM 8/28/2010, Mache Creeger wrote:
>>>> Still working on getting my MBE back up and myth working for my 
>>>> family. When mythfrontend tries to connect to mythbackend on the 
>>>> MBE. It crashes mythbackend and leaves mythfrontend looking for it. 
>>>> Note mysql loads up just fine with mythtv for both user and password.
>>>>
>>>> Below are the logs
>>>>
>>>> Any help will be most appreciated.
>>>>
>>>> -- Mache
>>>>
>>>> /var/log/mythtv/mythbackend.log
>>>>
>>>> 2010-08-28 12:39:06.692 Empty LocalHostName.
>>>> 2010-08-28 12:39:06.692 Using localhost value of XXX.YYY.COM
>>>> 2010-08-28 12:39:06.721 New DB connection, total: 1
>>>> 2010-08-28 12:39:06.726 Unable to connect to database!
>>>> 2010-08-28 12:39:06.727 Driver error was [1/1045]:
>>>> QMYSQL: Unable to connect
>>>> Database error was:
>>>> Access denied for user 'mythtv'@'XXX.YYY.COM' (using password: YES)
>>>>
>>>> $ mythtv-setup
>>>> 2010-08-28 12:46:03.692 Using runtime prefix = /usr
>>>> 2010-08-28 12:46:03.692 Using configuration directory = 
>>>> /home/mythtv/.mythtv
>>>> 2010-08-28 12:46:03.694 Empty LocalHostName.
>>>> 2010-08-28 12:46:03.694 Using localhost value of DIGIT.CREEGER.COM
>>>> 2010-08-28 12:46:03.703 New DB connection, total: 1
>>>> 2010-08-28 12:46:03.708 Unable to connect to database!
>>>> 2010-08-28 12:46:03.708 Driver error was [1/1045]:
>>>> QMYSQL: Unable to connect
>>>> Database error was:
>>>> Access denied for user 'mythtv'@'DIGIT.CREEGER.COM' (using 
>>>> password: YES)
>>>>
>>>> # cat ~mythtv/.mythtv/mysql.txt
>>>> DBHostName=XXX.YYY.COM
>> It looks to me like there is something odd going on with your 
>> hostname(s).  Mythbackend says it is XXX.YYY.COM (looks like a 
>> default?), mythtv-setup seems to think it is DIGIT.CREEGER.COM, 
>> mysql.txt says XXX.YYY.COM.  Maybe try setting it to 
>> DIGIT.CREEGER.COM in ~mythtv/.mythtv/mysql.txt?
>>
>> Try the command "hostname" and see what it says.
>>
>> Good luck!
>> Robert.
>
> That was me screwing up trying not to publish my server name to the list
>
> -- Mache
doh!  At least you can rule that out as the problem then... :-)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100829/08702b39/attachment.htm>