[mythtv-users] QMYSQL: Unable to connect

[Andrew]

This ubuntu 10.04.1 FE/BE box has been working great for the longest time
and one day i cant connect after general system packages were upgraded.  I
can connect with myphpadmin and see all the databases fine, however myth
can't see it.  Did something change?  I haven't changed any configs for
months.

myth:~$ mythfrontend -vv
2010-11-08 22:56:36.898 mythfrontend version: branches/release-0-23-fixes
[26231] www.mythtv.org
2010-11-08 22:56:36.899 Using runtime prefix = /usr
2010-11-08 22:56:36.899 Using configuration directory = /home/andrew/.mythtv
2010-11-08 22:56:37.634 Empty LocalHostName.
2010-11-08 22:56:37.634 Using localhost value of myth
2010-11-08 22:56:37.639 New DB connection, total: 1
2010-11-08 22:56:37.750 Unable to connect to database!
2010-11-08 22:56:37.750 Driver error was [1/2003]:
QMYSQL: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.0.1' (113)
................................................................................
2010-11-08 22:56:39.933 UPnPautoconf() - No UPnP backends found
2010-11-08 22:56:39.933 No UPnP backends found
2010-11-08 22:56:39.934 Primary screen: 0.
2010-11-08 22:56:39.934 Using screen 0, 1920x1080 at 0,0
2010-11-08 22:56:39.934 Could not find theme:  - Switching to Terra
2010-11-08 22:56:39.934 Using theme base resolution of 1280x720
2010-11-08 22:56:39.952 Desktop video mode: 1920x1080 60.0024 Hz
2010-11-08 22:56:39.960 get_ip: No address associated with hostname
2010-11-08 22:56:39.960 LIRC, Error: Failed to parse IP address ''
2010-11-08 22:56:39.960 JoystickMenuThread Error: Joystick disabled - Failed
to read /home/andrew/.mythtv/joystickmenurc
2010-11-08 22:56:39.971 Using Frameless Window
2010-11-08 22:56:39.971 Using Full Screen Window
2010-11-08 22:56:39.975 Using the Qt painter
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QInotifyFileSystemWatcherEngine::addPaths: inotify_add_watch failed: No such
file or directory
QFileSystemWatcher: failed to add paths: /home/andrew/.config/ibus/bus
Bus::open: Can not get ibus-daemon's address.
IBusInputContext::createInputContext: no connection to ibus-daemon
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
QFont::setPointSize: Point size <= 0 (0), must be greater than 0
2010-11-08 22:56:48.231 User cancelled database configuration
2010-11-08 22:56:48.245 Failed to init MythContext, exiting.
2010-11-08 22:56:48.245 Deleting UPnP client...

======================================================
This is pretty much default....

myth:/etc/mythtv# cat mysql.txt
DBHostName=192.168.0.1

# By default, Myth tries to ping the DB host to see if it exists.
# If your DB host or network doesn't accept pings, set this to no:
#
DBHostPing=no

DBUserName=mythtv
DBName=mythconverg
DBType=

# Set the following if you want to use something other than this
# machine's real hostname for identifying settings in the database.
# This is useful if your hostname changes often, as otherwise you
# will need to reconfigure mythtv (or futz with the DB) every time.
# TWO HOSTS MUST NOT USE THE SAME VALUE
#
#LocalHostName=localhost

# If you want your frontend to be able to wake your MySQL server
# using WakeOnLan, have a look at the following settings:
#
#
# The time the frontend waits (in seconds) between reconnect tries.
# This should be the rough time your MySQL server needs for startup
#
#WOLsqlReconnectWaitTime=0
#
#
# This is the number of retries to wake the MySQL server
# until the frontend gives up
#
#WOLsqlConnectRetry=5
#
#
# This is the command executed to wake your MySQL server.
#
#WOLsqlCommand=echo 'WOLsqlServerCommand not set'
DBPassword=mythconverg
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20101108/383b106e/attachment.htm>