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

Mache Creeger mache at creeger.com
Sun Aug 29 23:08:28 UTC 2010


At 01:11 PM 8/29/2010, R. G. Newbury wrote:
>On 08/29/2010 01:48 PM, Mache Creeger wrote:
>>Any ideas?
>
>>># mysql -u mythtv -p
>>>Enter password: <mythtv>
>>>Welcome to the MySQL monitor. Commands end with ; or \g.
>>>Your MySQL connection id is 12
>>>Server version: 5.1.47 Source distribution
>>>
>>>Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights
>>>reserved.
>>>This software comes with ABSOLUTELY NO WARRANTY. This is free software,
>>>and you are welcome to modify and redistribute it under the GPL v2 license
>>>
>>>Type 'help;' or '\h' for help. Type '\c' to clear the current input
>>>statement.
>>>
>>>mysql>
>>>
>>>
>>>/var/log/mythtv/mythbackend.log
>>>
>>>2010-08-28 12:39:06.687 mythbackend version:
>>>branches/release-0-23-fixes/mythtv/ [25469] www.mythtv.org
>>><http://www.mythtv.org/>
>>>2010-08-28 12:39:06.688 Using runtime prefix = /usr
>>>2010-08-28 12:39:06.691 Read conf dir = /var/lib/mythtv
>>>2010-08-28 12:39:06.691 Using configuration directory = /var/lib/mythtv
>>>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)
>
>
>You have a different user attempting to use myth (and thus mysql) 
>than you set up with. Do this, as root:
>
># mysql -u root -p
>(Enter your password)
>mysql> use mysql;
>mysql> select host,user password from user;
>
>You should get something like this:
>
>
>+-------------------+--------+------------------+
>| host              | user   | password         |
>+-------------------+--------+------------------+
>| localhost         | root   | 1b3ab4920bfa6d2a |
>| tor1.mandamus.org | root   | 1b3ab4920bfa6d2a |
>| 192.168.1.99      | root   | 1b3ab4920bfa6d2a |
>| localhost         | mythtv | 0476fc026afffe24 |
>| tor1.mandamus.org | mythtv | 0476fc026afffe24 |
>| 192.168.1.99      | mythtv | 0476fc026afffe24 |
>+-------------------+--------+------------------+
>
>But what you will see is probably something like:
>
>XXX.YYY.COM     mythtv at XXX.YYY.COM      <password-hash>
>or
>
>DIGIT.CREEGER.COM  mythtv at DIGIT.CREEGER.COM
>
>I'm reasonably certain that mysql treats that as 
>mythtv at DIGIT.CREEGER.COM@DIGIT.CREEGER.COM.
>
>Which does not work.
>You should revise the mc.sql script and run it again. Chapter 6 of 
>the Mythtv Documentation.
>
>then try:
>
>mysql> use mythconverg;
>
>mysql> select value,data,hostname from setting where value like "%IP%";
>you are looking for MasterServerIP and BackendServerIP to be correct 
>and the hostname match that IP address ( ie. what is in /etc/hosts).
>
>Geoff

That did the trick. Thanks,

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


More information about the mythtv-users mailing list