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

[starcycle]

I still can't get it to work, but I installed mythtv on my laptop and
when I run mythfrontend it lists MythTV AV Media Server with the
hostname of the server, and a "Configure Manually" button.

When I press <enter> on either the server listing or on "Configure
Manually," a dialog pops up that asks for the PIN, and then after that
another one comes up that asks, "Save that backend or database as the
default?" On either one I select, it bounces out of the frontend gui
for a minute, then starts back in with a dialog that says "Cannot
login to database?" I hit "ok," and it goes back to the initial
screen.

I got this once on the desktop machine, but then it stopped listing
the server and went back to just displaying the initial setup screen.
I have no idea what I changed to allow that, but it won't change it
back.

How can I find out why these clients won't connect to the database?

thx

On Sun, Apr 20, 2008 at 1:03 PM, 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.
>  =========================================================
>