[mythtv-users] QMYSQL: Unable to connect

Andrew mythtv at heathsworld.com
Tue Nov 9 05:34:12 UTC 2010


Fixed.  DDWRT borked up and forgot all my static leases.  Argg.

On Mon, Nov 8, 2010 at 11:04 PM, Andrew <mythtv at heathsworld.com> wrote:

> 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/d22795e4/attachment.htm>


More information about the mythtv-users mailing list