[mythtv-users] Myth Front End can't connect with database

Andrew Robinson awrobinson-ml at nc.rr.com
Wed Apr 4 02:56:24 UTC 2007


I am experiencing the exact same problem. If I turn off iptables on the 
backend server, the frontend connects and works. I have opened all the 
recommended ports on the backend but when I turn on iptables, I get the 
same set of error messages. I offer this as a clue.

Andrew Robinson

Lan Barnes wrote:
> Alas, I'm not that far along yet.
> 
> I set DBHostName in /home/mythtv/.mythtv/mysql.txt to the server's IP
> addr, 192.168.1.66. I checked /etc/my.cnf and there was no IP in it. I
> added
> 
>   bind-address=192.168.1.66
> 
> No joy so I tried without it. No joy there there either. BTW, I'm assuming
> these could have been the host name assuming it's in /etc/hosts.
> 
> lokkit is turned off. /etc/hosts.[deny|allow] are empty. I am rebooting
> between tests (superstitiously, I grant you).
> 
> I can connect with mythconverg using msql on the server (xena) when I use
> -h  localhost but not -h xena. Same when I substitute IP addrs.
> 
> I cleaned out the logs and rebooted. Here is /var.log/mythtv/mythbackend.log
> 
> ****
> 2007-04-03 18:41:49.511 Using runtime prefix = /usr
> 2007-04-03 18:41:49.946 New DB connection, total: 1
> 2007-04-03 18:41:49.964 Unable to connect to database!
> 2007-04-03 18:41:49.966 Driver error was [1/1045]:
> QMYSQL3: Unable to connect
> Database error was:
> Access denied for user 'mythtv'@'xena' (using password: YES)
> 
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2007-04-03 18:41:50.027 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2007-04-03 18:41:50.081 Failed to init MythContext, exiting.
> mythtv/mythbackend.log (END)
> ****
> 
> ... and here is /var/log/mysqld.log
> 
> ****
> 070403 18:39:18 [Note] /usr/libexec/mysqld: Normal shutdown
> 
> 070403 18:39:18  InnoDB: Starting shutdown...
> 070403 18:39:19  InnoDB: Shutdown completed; log sequence number 0 43655
> 070403 18:39:19 [Note] /usr/libexec/mysqld: Shutdown complete
> 
> 070403 18:39:19  mysqld ended
> 
> 070403 18:41:00  mysqld started
> 070403 18:41:01  InnoDB: Started; log sequence number 0 43655
> 070403 18:41:02 [Note] /usr/libexec/mysqld: ready for connections.
> Version: '5.0.22'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source
> distribution
> ****
> 
> I'm completely baffled as to why I can't get mysql to talk over the
> machine's IP addr (I'm a postgres guy, which is OK except now ;-)
> 
> I gotta go do a thing, but when I return, I'll be grateful for anyone who
> can spare some insight.
> 
> Once you've tasted the joys of Myth, it's hard to give it up even for a
> little moment :'-( But we will prevail.
> 
> 
> 
> On Tue, April 3, 2007 12:03 pm, Donald Webster wrote:
>> On the laptop, did you edit your mysql.txt to point to the right db?
>>
>> On 4/3/07, Lan Barnes <lan at falleagle.net> wrote:
>>> Newbie. I installed mythfrontend plus dependencies on my laptop using the
>>> MythDora 3.2 DVD image. The back end is MythDora as well. I changed the
> back end from 127.0.0.1 (two places, same screen in mythsetup) to
> 192.168.1.66 (IP mildly changed to give pitifully little protection).
> Myth
>>> on the server still works, so I assume the changes took in both places.
> mythconverge user and password mythtv/mythtv, the default.
>>> On the server as root, I ran:
>>>   mysql -u root mythconverge
>>> Then, in mysql> I ran
>>>   grant all on mythconverge.* to mythtv@"192.168.1.%" identified as
>>> "mythtv";
>>>   flush privileges;
>>> Both returned with 0 records updated, which I accepted as success (because
>>> I didn't expect any recoprds to change).
>>> Now when I go into mythfrontend on the laptop, it goes into the config
> screens with the message that it can't connect with the database. What
> should I check/do?
>>> --
>>> Lan Barnes
>>> SCM Analyst              Linux Guy
>>> Tcl/Tk Enthusiast        Biodiesel Brewer
>>> _______________________________________________
>>> mythtv-users mailing list
>>> mythtv-users at mythtv.org
>>> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>>
>> --
>> AIM: fryfrog
>> ICQ: 304825
>> WWW: http://www.fryfrog.com
>>
> 
> 



More information about the mythtv-users mailing list