<br><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">greg</b> <span dir="ltr"><<a href="mailto:greg12866@nycap.rr.com" target="_blank">greg12866@nycap.rr.com</a>></span><br>
Date: Wed, Sep 2, 2009 at 11:58 AM<br>
Subject: Re: [mythtv-users] SVN Update - then no connection to DB<br>To: Discussion about mythtv <<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a>><br><br><br>Kenneth Emerson wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>
<br>
<br>
On Wed, Sep 2, 2009 at 11:18 AM, John Drescher <<a href="mailto:drescherjm@gmail.com" target="_blank">drescherjm@gmail.com</a> <mailto:<a href="mailto:drescherjm@gmail.com" target="_blank">drescherjm@gmail.com</a>>> wrote:<br>
<br>
On Wed, Sep 2, 2009 at 12:12 PM, Kenneth<br>
Emerson<<a href="mailto:kenneth.emerson@gmail.com" target="_blank">kenneth.emerson@gmail.com</a><br></div><div>
<mailto:<a href="mailto:kenneth.emerson@gmail.com" target="_blank">kenneth.emerson@gmail.com</a>>> wrote:<br>
> Can someone please point me to what I may have forgotten to do? I have been<br>
> updating from trunk about every 2-3 weeks with no problems until<br>
last<br>
> night. After recompiling and installing, I get the following<br>
from the<br>
> backend (single machine with FE/BE):<br>
><br>
> 2009-09-02 10:54:08.131 mythbackend version: trunk [21636]<br></div>
<a href="http://www.mythtv.org" target="_blank">www.mythtv.org</a> <<a href="http://www.mythtv.org" target="_blank">http://www.mythtv.org</a>><div><div></div><div><br>
> 2009-09-02 10:54:08.151 Using runtime prefix = /usr/local<br>
> 2009-09-02 10:54:08.152 Using configuration directory =<br>
/home/mythtv/.mythtv<br>
> 2009-09-02 10:54:08.153 Using localhost value of 192.168.1.12<br>
> 2009-09-02 10:54:08.960 Cannot find default UPnP backend<br>
> 2009-09-02 10:54:08.960 Testing network connectivity to 'mythtv'<br>
> 2009-09-02 10:54:09.029 New DB connection, total: 1<br>
> 2009-09-02 10:57:18.030 Unable to connect to database!<br>
> 2009-09-02 10:57:18.031 Driver error was [1/2003]:<br>
> QMYSQL: Unable to connect<br>
> Database error was:<br>
> Can't connect to MySQL server on 'mythtv' (110)<br>
><br>
><br>
................................................................................<br>
> 2009-09-02 10:57:20.158 UPnPautoconf() - No UPnP backends found<br>
> 2009-09-02 10:57:20.162 No UPnP backends found<br>
><br>
> No UPnP backends found<br>
><br>
> Would you like to configure the database connection now? [no]<br>
> [console is not interactive, using default 'no']<br>
> 2009-09-02 10:57:20.188 Deleting UPnP client...<br>
> 2009-09-02 10:57:20.505 Failed to init MythContext, exiting.<br>
><br>
> From mythweb I get the script error:<br>
><br>
> Warning at /var/www/mythweb/modules/status/handler.php, line 35:<br>
> file_get_contents(<a href="http://192.168.1.12:6544" target="_blank">http://192.168.1.12:6544</a>)<br>
[function.file-get-contents]:<br>
> failed to open stream: Connection refused<br>
><br>
> the frontend has the same problem dropping me into the database<br>
> configuration dialogs.<br>
><br>
> Interestingly enough, starting up the backend right after the<br>
update,<br>
> everything seemed OK:<br>
><br>
> 2009-09-02 00:04:36.679 mythbackend version: trunk [21632]<br></div></div>
<a href="http://www.mythtv.org" target="_blank">www.mythtv.org</a> <<a href="http://www.mythtv.org" target="_blank">http://www.mythtv.org</a>><div><div></div><div><br>
> 2009-09-02 00:04:36.721 Using runtime prefix = /usr/local<br>
> 2009-09-02 00:04:36.722 Using configuration directory =<br>
/home/mythtv/.mythtv<br>
> 2009-09-02 00:04:36.723 Empty LocalHostName.<br>
> 2009-09-02 00:04:36.727 Using localhost value of mythtv<br>
> 2009-09-02 00:04:37.517 Cannot find default UPnP backend<br>
> 2009-09-02 00:04:37.552 New DB connection, total: 1<br>
> 2009-09-02 00:04:37.583 Connected to database 'mythconverg' at host:<br>
> localhost<br>
> 2009-09-02 00:04:37.585 Closing DB connection named 'DBManager0'<br>
> 2009-09-02 00:04:37.589 Deleting UPnP client...<br>
> 2009-09-02 00:04:38.175 Connected to database 'mythconverg' at host:<br>
> localhost<br>
> 2009-09-02 00:04:38.180 Current Schema Version: 1242<br>
> 2009-09-02 00:04:38.186 Database schema is old. Waiting to see<br>
if DB is<br>
> being upgraded.<br>
> 2009-09-02 00:04:39.187 New DB connection, total: 2<br>
> 2009-09-02 00:04:39.188 Connected to database 'mythconverg' at host:<br>
> localhost<br>
> 2009-09-02 00:04:39.225 Current Schema Version: 1242<br>
> 2009-09-02 00:04:40.231 Current Schema Version: 1242<br>
> 2009-09-02 00:04:41.235 Current Schema Version: 1242<br>
> 2009-09-02 00:04:42.239 Current Schema Version: 1242<br>
> 2009-09-02 00:04:43.243 Current Schema Version: 1242<br>
> 2009-09-02 00:04:43.244 Timed out waiting.<br>
> 2009-09-02 00:04:43.548 Backing up database with script:<br>
> '/usr/local/share/mythtv/mythconverg_backup.pl'<br>
> 2009-09-02 00:05:29.938 Database Backup complete.<br>
> 2009-09-02 00:05:29.977 Backed up database to file:<br>
> '/mythtv/data/mythconverg-1242-20090902000443.sql.gz'<br>
> 2009-09-02 00:05:29.993 Console is non-interactive, can't prompt<br>
user...<br>
> 2009-09-02 00:05:29.996 Upgrading.<br>
> 2009-09-02 00:05:30.012 Newest Schema Version : 1244<br>
> 2009-09-02 00:05:30.018 Upgrading to schema version 1243<br>
> 2009-09-02 00:05:30.020 New DB connection, total: 3<br>
> 2009-09-02 00:05:30.022 Connected to database 'mythconverg' at host:<br>
> localhost<br>
> 2009-09-02 00:05:30.025 Upgrading to schema version 1244<br>
> 2009-09-02 00:05:30.030 Database Schema upgrade complete, unlocking.<br>
> 2009-09-02 00:05:30.036 MythBackend: Starting up as the master<br>
server.<br>
><br>
> Then, at 1:00am, when a recording finished, the trouble started:<br>
><br>
> 2009-09-02 01:00:01.068 Finished recording Lost "Outlaws":<br>
channel 7739<br>
> 2009-09-02 01:00:01.495 mythbackend version: trunk [21632]<br></div></div>
<a href="http://www.mythtv.org" target="_blank">www.mythtv.org</a> <<a href="http://www.mythtv.org" target="_blank">http://www.mythtv.org</a>><div><div></div><div><br>
> 2009-09-02 01:00:01.500 Using runtime prefix = /usr/local<br>
> 2009-09-02 01:00:01.501 Using configuration directory =<br>
/home/mythtv/.mythtv<br>
> 2009-09-02 01:00:01.518 Empty LocalHostName.<br>
> 2009-09-02 01:00:01.520 Using localhost value of mythtv<br>
> 2009-09-02 01:00:12.365 HttpComms::Timeout for url:<br>
> <a href="http://192.168.1.12:6544/Myth" target="_blank">http://192.168.1.12:6544/Myth</a><br>
> 2009-09-02 01:00:12.377 HttpComms::done() - NetworkOperation<br>
Error on<br>
> Finish: Request aborted (1): url: '<a href="http://192.168.1.12:6544/Myth" target="_blank">http://192.168.1.12:6544/Myth</a>'<br>
> 2009-09-02 01:00:22.379 HttpComms::Timeout for url:<br>
> <a href="http://192.168.1.12:6544/Myth" target="_blank">http://192.168.1.12:6544/Myth</a><br>
> 2009-09-02 01:00:22.390 HttpComms::done() - NetworkOperation<br>
Error on<br>
> Finish: Request aborted (1): url: '<a href="http://192.168.1.12:6544/Myth" target="_blank">http://192.168.1.12:6544/Myth</a>'<br>
> 2009-09-02 01:00:32.393 HttpComms::Timeout for url:<br>
> <a href="http://192.168.1.12:6544/Myth" target="_blank">http://192.168.1.12:6544/Myth</a><br>
> 2009-09-02 01:00:32.403 HttpComms::done() - NetworkOperation<br>
Error on<br>
> Finish: Request aborted (1): url: '<a href="http://192.168.1.12:6544/Myth" target="_blank">http://192.168.1.12:6544/Myth</a>'<br>
> 2009-09-02 01:00:42.416 HttpComms::Timeout for url:<br>
> <a href="http://192.168.1.12:6544/Myth" target="_blank">http://192.168.1.12:6544/Myth</a><br>
> 2009-09-02 01:00:42.429 Failed to contact server for url:<br>
> <a href="http://192.168.1.12:6544/Myth" target="_blank">http://192.168.1.12:6544/Myth</a><br>
> 2009-09-02 01:00:42.430 HttpComms::done() - NetworkOperation<br>
Error on<br>
> Finish: Request aborted (1): url: '<a href="http://192.168.1.12:6544/Myth" target="_blank">http://192.168.1.12:6544/Myth</a>'<br>
> 2009-09-02 01:00:42.431 MythXMLClient::GetConnectionInfo Failed<br>
- (1)<br>
> unexpected end of file<br>
> 2009-09-02 01:00:42.439 Testing network connectivity to<br>
'192.168.1.12'<br>
> 2009-09-02 01:00:42.486 New DB connection, total: 1<br>
> 2009-09-02 01:00:42.487 Unable to connect to database!<br>
> 2009-09-02 01:00:42.488 Driver error was [1/2003]:<br>
> QMYSQL: Unable to connect<br>
> Database error was:<br>
> Can't connect to MySQL server on '192.168.1.12' (111)<br>
><br>
> 2009-09-02 01:00:42.495 Cannot login to database?<br>
><br>
> Any help?<br>
><br>
<br>
Is mysql running? Did you try to open the mythconverg database<br>
from using mysql?<br>
<br>
John<br>
<br>
<br>
Yes, I can connect with both phpmyadmin and mysql. The mysqld is running.<br>
<br>
-- Ken<br></div></div>
------------------------------------------------------------------------<div><br>
<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
<br>
</div></blockquote>
Did your ip change perhaps???? I had that happen once and drove me nuts for awhile..<div><div></div><div><br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users" target="_blank">http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users</a><br>
</div></div></div><br>My IP address did not change; however, you got me looking in other places. I was able to connect to mysql (mythconverg) directly, but I couldn't telnet to port 3306 (connection refused) so I assumed this had something to do with my hostname. I tried changing the database configuration when prompted by the BE when running it from the command line and got either access denied or could not connect while changing between actual hostname, localhost, and static IP address. I eventually went back to a backup of my mythtv user's mysql.txt file, restored it to the .mythtv directory, and (viola) everything began working again. I just don't understand what would have changed this file.<br>
<br>It had been a while since I had restarted the BE and, if the information in this text file is cached during startup, perhaps somehow I inadvertantly changed something when running through setup that didn't show up until a restart occurred. Just continues to prove that OMKWOID when dealing with parameters in myth (that is, one must know what one is doing).<br>
<br>-- Ken E<br>