Fixed. DDWRT borked up and forgot all my static leases. Argg.<br><br><div class="gmail_quote">On Mon, Nov 8, 2010 at 11:04 PM, Andrew <span dir="ltr"><<a href="mailto:mythtv@heathsworld.com">mythtv@heathsworld.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">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.<br>
<br>myth:~$ mythfrontend -vv<br>2010-11-08 22:56:36.898 mythfrontend version: branches/release-0-23-fixes [26231] <a href="http://www.mythtv.org" target="_blank">www.mythtv.org</a><br>2010-11-08 22:56:36.899 Using runtime prefix = /usr<br>
2010-11-08 22:56:36.899 Using configuration directory = /home/andrew/.mythtv<br>2010-11-08 22:56:37.634 Empty LocalHostName.<br>2010-11-08 22:56:37.634 Using localhost value of myth<br>2010-11-08 22:56:37.639 New DB connection, total: 1<br>
2010-11-08 22:56:37.750 Unable to connect to database!<br>2010-11-08 22:56:37.750 Driver error was [1/2003]:<br>QMYSQL: Unable to connect<br>Database error was:<br>Can't connect to MySQL server on '192.168.0.1' (113)<br>
................................................................................<br>2010-11-08 22:56:39.933 UPnPautoconf() - No UPnP backends found<br>2010-11-08 22:56:39.933 No UPnP backends found<br>2010-11-08 22:56:39.934 Primary screen: 0.<br>
2010-11-08 22:56:39.934 Using screen 0, 1920x1080 at 0,0<br>2010-11-08 22:56:39.934 Could not find theme: - Switching to Terra<br>2010-11-08 22:56:39.934 Using theme base resolution of 1280x720<br>2010-11-08 22:56:39.952 Desktop video mode: 1920x1080 60.0024 Hz<br>
2010-11-08 22:56:39.960 get_ip: No address associated with hostname<br>2010-11-08 22:56:39.960 LIRC, Error: Failed to parse IP address ''<br>2010-11-08 22:56:39.960 JoystickMenuThread Error: Joystick disabled - Failed to read /home/andrew/.mythtv/joystickmenurc<br>
2010-11-08 22:56:39.971 Using Frameless Window<br>2010-11-08 22:56:39.971 Using Full Screen Window<br>2010-11-08 22:56:39.975 Using the Qt painter<br>QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>
QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>QInotifyFileSystemWatcherEngine::addPaths: inotify_add_watch failed: No such file or directory<br>
QFileSystemWatcher: failed to add paths: /home/andrew/.config/ibus/bus<br>Bus::open: Can not get ibus-daemon's address. <br>IBusInputContext::createInputContext: no connection to ibus-daemon <br>QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>
QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>
QFont::setPointSize: Point size <= 0 (0), must be greater than 0<br>2010-11-08 22:56:48.231 User cancelled database configuration<br>2010-11-08 22:56:48.245 Failed to init MythContext, exiting.<br>2010-11-08 22:56:48.245 Deleting UPnP client...<br>
<br>======================================================<br>This is pretty much default....<br><br>myth:/etc/mythtv# cat mysql.txt <br>DBHostName=192.168.0.1<br><br># By default, Myth tries to ping the DB host to see if it exists.<br>
# If your DB host or network doesn't accept pings, set this to no:<br>#<br>DBHostPing=no<br><br>DBUserName=mythtv<br>DBName=mythconverg<br>DBType=<br><br># Set the following if you want to use something other than this<br>
# machine's real hostname for identifying settings in the database.<br># This is useful if your hostname changes often, as otherwise you<br># will need to reconfigure mythtv (or futz with the DB) every time.<br># TWO HOSTS MUST NOT USE THE SAME VALUE<br>
#<br>#LocalHostName=localhost<br><br># If you want your frontend to be able to wake your MySQL server<br># using WakeOnLan, have a look at the following settings:<br>#<br>#<br># The time the frontend waits (in seconds) between reconnect tries.<br>
# This should be the rough time your MySQL server needs for startup<br>#<br>#WOLsqlReconnectWaitTime=0<br>#<br>#<br># This is the number of retries to wake the MySQL server<br># until the frontend gives up<br>#<br>#WOLsqlConnectRetry=5<br>
#<br>#<br># This is the command executed to wake your MySQL server.<br>#<br>#WOLsqlCommand=echo 'WOLsqlServerCommand not set'<br>DBPassword=mythconverg<br><br>
</blockquote></div><br>