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