[mythtv-users] Problem connecting frontend

jack snodgrass mrlinuxgroups at gmail.com
Mon Sep 3 10:27:42 UTC 2007


On 9/3/07, Andrew Robinson <awrobinson-ml at nc.rr.com> wrote:
> I'm trying to connect a remote frontend. When I run 'mythfrontend', I
> get the following error messages. The second paragraph repeats many
> times until I'm eventually kicked out of X. (That's right, the sequence
> ends with the nVidia splash screen.) I tried running 'mythtvsetup' with
> the same results. I've got port 3306 open on both the frontend and the
> backend, so I don't think it is a firewall issue. Anyone know what I
> haven't set?
>
>
> 2007-08-28 18:41:15.095 Using runtime prefix = /usr
> 2007-08-28 18:41:15.102 DPMS is active.
> 2007-08-28 18:41:15.115 New DB connection, total: 1
> 2007-08-28 18:41:15.115 Unable to connect to database!
> 2007-08-28 18:41:15.116 Driver error was [1/2002]:
> QMYSQL3: Unable to connect
> Database error was:
> Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
>
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2007-08-28 18:41:15.166 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2007-08-28 18:41:15.216 Unable to connect to database!
> 2007-08-28 18:41:15.217 Driver error was [1/2002]:
> QMYSQL3: Unable to connect
> Database error was:
> Can't connect to local MySQL server through socket
> '/var/lib/mysql/mysql.sock' (2)
>
>
> Thanks!
>
> Andrew Robinson

Do you have a ~/.mythtv/mysql.txt file with your mysql info in it?
At some point that gets created ( or you have to create it... I can't
recall which.. ) and it has your mysql connect info in it.

Also... you can test out your mysql conection from the front end
to the mysql server by doing
mysql -hhost -uuser -pass mythconverg
where host, user and pass come from your mysql.txt file.
you should get a mysql connection and not a error.

jack


More information about the mythtv-users mailing list