[mythtv-users] mysql connection troubles (NOT mysql.txt)

[Greg Woods]

I feel like a newbie all over again, but I can't get past this.

I have a machine that was running a front end only hooked to my Sony TV
under FC5. A couple of SVN upgrades ago, it started having display
problems with a flickering display that was unwatchable. Since FC5 is
quite old now, I decided that it might be just as easy to fix it by
starting over from scratch with FC8. So I did that, got the OS
installed, compiled MythTV (and went through dependency hell to get all
the necessary libraries installed), but now I cannot connect to the
database. This is NOT a mysql.txt problem, as it properly names the
machine that should have the database, then says it can't connect to it.
It is also not a mysql privilege problem as I can connect to the
database from the frontend machine just fine with a mysql command line.
Furthermore, if I check the "ping database server" box, it then
complains that it can't find the database server on the network (of
course I can ping it fine from the command line). I'm positive it's
spelled right (I've also tried specifying it by IP address), I've tried
running mythtv-setup and mythfrontend both as root and as mythtv, but
it's the same thing every time: cannot connect to port 3306 on the
database server. The same thing happens if I go through the database
configuration in mythtv-setup, it still cannot connect.

I'm sure I've done something obvious and stupid, but I've been stuck and
frustrated at this point for two hours now, and all the Googling I've
been able to do has turned up nothing except problems that were solved
by inserting a proper mysql.txt file, which I already have:

DBHostName=confusion.gregandeva.net
DBUserName=mythtv
DBPassword=*****
DBName=mythconverg
DBType=QMYSQL3



The screen output is:

Session management error: Authentication Rejected, reason : None of the
authentication protocols specified are supported and host-based
authentication failed
2007-12-02 22:17:04.234 Using runtime prefix = /usr/local
2007-12-02 22:17:08.381 XScreenSaver support enabled
2007-12-02 22:17:08.431 DPMS is active.
2007-12-02 22:17:08.433 Empty LocalHostName.
2007-12-02 22:17:08.433 Using localhost value of
quicksilver.gregandeva.net
2007-12-02 22:17:08.434 Cannot connect to port 3306 on database host
confusion.gregandeva.net
2007-12-02 22:17:08.510 New DB connection, total: 1
2007-12-02 22:17:11.146 Total desktop dim: 1360x768, with 2 screen[s].
2007-12-02 22:17:11.194 Using screen 0, 1360x768 at 0,0
2007-12-02 22:17:11.197 Switching to square mode (blue)
2007-12-02 22:17:11.246 Using the Qt painter
mythtv: could not connect to socket
mythtv: No such file or directory
2007-12-02 22:17:11.247 lirc_init failed for mythtv, see preceding
messages
2007-12-02 22:17:11.248 Joystick disabled.
2007-12-02 22:17:14.237 DB Error (Clear setting):
Query was:

No error type from QSqlError?  Strange...
2007-12-02 22:17:14.237 DB Error (SaveSettingOnHost query failure: ):
Query was:

No error type from QSqlError?  Strange...
2007-12-02 22:17:15.435 User canceled database configuration
2007-12-02 22:17:15.477 Failed to init MythContext, exiting.