[mythtv-users] mythfrontend can't connect to backend/database

Steve Wilson mythtv_arizona at yahoo.com
Sun Apr 20 18:34:41 UTC 2008


--- starcycle <starcycle at gmail.com> wrote:

> This is the error I'm getting, but I can't figure
> out what's wrong.
> mythtv user can log in to mysql on the server. I
> don't understand why
> it says it can't connect to MySQL server on
> localhost since the IP of
> the mysql server is entered in the field.
> 
> Also, I noticed the ~/.mythtv directory and files
> were created with
> root:root ownership, which seems kind of weird since
> it's the user's
> directory. The mysql.txt file listed 192.168.0.1 as
> the database
> location, I changed that to the correct IP, but it
> still didn't work.
> Can anyone help sort this out?
> 
> ==================================================
> sero at homer:~ $ mythfrontend
> 2008-04-20 12:50:11.763 Using runtime prefix = /usr,
> libdir = /usr/lib
> 2008-04-20 12:50:12.425 XScreenSaver support enabled
> 2008-04-20 12:50:12.425 DPMS is active.
> 2008-04-20 12:50:12.426 Empty LocalHostName.
> 2008-04-20 12:50:12.426 Using localhost value of
> homer
> 2008-04-20 12:50:12.436 New DB connection, total: 1
> 2008-04-20 12:50:12.437 Unable to connect to
> database!
> 2008-04-20 12:50:12.437 Driver error was [1/2003]:
> QMYSQL3: Unable to connect
> Database error was:
> Can't connect to MySQL server on '192.168.0.1' (111)
> # [?????]
> 
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2008-04-20 12:50:12.489 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 
> 2008-04-20 12:50:12.673 UPnPautoconf() - Found one
> UPnP backend
> 2008-04-20 12:50:12.702 Unable to connect to
> database!
> 2008-04-20 12:50:12.702 Driver error was [1/2013]:
> QMYSQL3: Unable to connect
> Database error was:
> Lost connection to MySQL server at 'reading initial
> communication
> packet', system error: 0
> 
> QSqlQuery::exec: database not open
> QSqlQuery::exec: database not open
> 2008-04-20 12:50:12.753 DB Error (KickDatabase):
> Query was:
> SELECT NULL;
> No error type from QSqlError?  Strange...
> 2008-04-20 12:50:12.803 Cannot login to database?
> 2008-04-20 12:50:13.812 Total desktop dim:
> 1680x1050, with 1 screen[s].
> 2008-04-20 12:50:13.812 Using screen 0, 1680x1050 at
> 0,0
> 2008-04-20 12:50:13.813 Switching to square mode
> (blue)
> 2008-04-20 12:50:13.869 Using the Qt painter
> mythtv: could not connect to socket
> mythtv: No such file or directory
> 2008-04-20 12:50:13.872 lirc_init failed for mythtv,
> see preceding messages
> 2008-04-20 12:50:13.885 JoystickMenuClient Error:
> Joystick disabled -
> Failed to read /home/sero/.mythtv/joystickmenurc
> QSettings::sync: filename is null/empty
> QSettings::sync: filename is null/empty
> QSettings::sync: filename is null/empty
> QSettings::sync: filename is null/empty
> 2008-04-20 12:50:16.752 DB Error (Clear setting):
> Query was:
> 
> No error type from QSqlError?  Strange...
> 2008-04-20 12:50:16.753 DB Error (SaveSettingOnHost
> query failure: ):
> Query was:
> 
> No error type from QSqlError?  Strange...
> 2008-04-20 12:50:16.753 DB Error (Clear setting):
> Query was:
> 
> No error type from QSqlError?  Strange...
> 2008-04-20 12:50:16.753 DB Error (SaveSettingOnHost
> query failure: ):
> Query was:
> 
> No error type from QSqlError?  Strange...
> 2008-04-20 12:50:21.299 User cancelled database
> configuration
> 2008-04-20 12:50:21.405 Failed to init MythContext,
> exiting.
>
=========================================================
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
>
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> 

Under mythtv-setup then General what do you have for
IP address for both local and backend?


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ



More information about the mythtv-users mailing list