[mythtv-users] Problem connecting frontend

Andrew Robinson awrobinson-ml at nc.rr.com
Wed Sep 5 02:49:03 UTC 2007


jack snodgrass wrote:
> 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.
> 
Thanks for the tip. Turns out I had a bigger problem. Mythfrontend will 
create the mysql.txt file. However, I had some bug with my setup. I was 
crashing out of X and not writing any files on the way. I resolved the 
issue by reinstalling the system. Given that this is a new slave backend 
with some new hardware, that was OK.

Andrew


More information about the mythtv-users mailing list