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

[R. G. Newbury]

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






















              R. Geoffrey Newbury