[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