[mythtv-users] SVN Update - then no connection to DB

greg greg12866 at nycap.rr.com
Wed Sep 2 16:58:45 UTC 2009


Kenneth Emerson wrote:
>
>
> On Wed, Sep 2, 2009 at 11:18 AM, John Drescher <drescherjm at gmail.com 
> <mailto:drescherjm at gmail.com>> wrote:
>
>     On Wed, Sep 2, 2009 at 12:12 PM, Kenneth
>     Emerson<kenneth.emerson at gmail.com
>     <mailto:kenneth.emerson at gmail.com>> wrote:
>     > Can someone please point me to what I may have forgotten to do? 
>     I have been
>     > updating from trunk about every 2-3 weeks with no problems until
>     last
>     > night.  After recompiling and installing, I get the following
>     from the
>     > backend (single machine with FE/BE):
>     >
>     > 2009-09-02 10:54:08.131 mythbackend version: trunk [21636]
>     www.mythtv.org <http://www.mythtv.org>
>     > 2009-09-02 10:54:08.151 Using runtime prefix = /usr/local
>     > 2009-09-02 10:54:08.152 Using configuration directory =
>     /home/mythtv/.mythtv
>     > 2009-09-02 10:54:08.153 Using localhost value of 192.168.1.12
>     > 2009-09-02 10:54:08.960 Cannot find default UPnP backend
>     > 2009-09-02 10:54:08.960 Testing network connectivity to 'mythtv'
>     > 2009-09-02 10:54:09.029 New DB connection, total: 1
>     > 2009-09-02 10:57:18.030 Unable to connect to database!
>     > 2009-09-02 10:57:18.031 Driver error was [1/2003]:
>     > QMYSQL: Unable to connect
>     > Database error was:
>     > Can't connect to MySQL server on 'mythtv' (110)
>     >
>     >
>     ................................................................................
>     > 2009-09-02 10:57:20.158 UPnPautoconf() - No UPnP backends found
>     > 2009-09-02 10:57:20.162 No UPnP backends found
>     >
>     > No UPnP backends found
>     >
>     > Would you like to configure the database connection now? [no]
>     > [console is not interactive, using default 'no']
>     > 2009-09-02 10:57:20.188 Deleting UPnP client...
>     > 2009-09-02 10:57:20.505 Failed to init MythContext, exiting.
>     >
>     > From mythweb I get the script error:
>     >
>     > Warning at /var/www/mythweb/modules/status/handler.php, line 35:
>     > file_get_contents(http://192.168.1.12:6544)
>     [function.file-get-contents]:
>     > failed to open stream: Connection refused
>     >
>     > the frontend has the same problem dropping me into the database
>     > configuration dialogs.
>     >
>     > Interestingly enough, starting up the backend right after the
>     update,
>     > everything seemed OK:
>     >
>     > 2009-09-02 00:04:36.679 mythbackend version: trunk [21632]
>     www.mythtv.org <http://www.mythtv.org>
>     > 2009-09-02 00:04:36.721 Using runtime prefix = /usr/local
>     > 2009-09-02 00:04:36.722 Using configuration directory =
>     /home/mythtv/.mythtv
>     > 2009-09-02 00:04:36.723 Empty LocalHostName.
>     > 2009-09-02 00:04:36.727 Using localhost value of mythtv
>     > 2009-09-02 00:04:37.517 Cannot find default UPnP backend
>     > 2009-09-02 00:04:37.552 New DB connection, total: 1
>     > 2009-09-02 00:04:37.583 Connected to database 'mythconverg' at host:
>     > localhost
>     > 2009-09-02 00:04:37.585 Closing DB connection named 'DBManager0'
>     > 2009-09-02 00:04:37.589 Deleting UPnP client...
>     > 2009-09-02 00:04:38.175 Connected to database 'mythconverg' at host:
>     > localhost
>     > 2009-09-02 00:04:38.180 Current Schema Version: 1242
>     > 2009-09-02 00:04:38.186 Database schema is old. Waiting to see
>     if DB is
>     > being upgraded.
>     > 2009-09-02 00:04:39.187 New DB connection, total: 2
>     > 2009-09-02 00:04:39.188 Connected to database 'mythconverg' at host:
>     > localhost
>     > 2009-09-02 00:04:39.225 Current Schema Version: 1242
>     > 2009-09-02 00:04:40.231 Current Schema Version: 1242
>     > 2009-09-02 00:04:41.235 Current Schema Version: 1242
>     > 2009-09-02 00:04:42.239 Current Schema Version: 1242
>     > 2009-09-02 00:04:43.243 Current Schema Version: 1242
>     > 2009-09-02 00:04:43.244 Timed out waiting.
>     > 2009-09-02 00:04:43.548 Backing up database with script:
>     > '/usr/local/share/mythtv/mythconverg_backup.pl'
>     > 2009-09-02 00:05:29.938 Database Backup complete.
>     > 2009-09-02 00:05:29.977 Backed up database to file:
>     > '/mythtv/data/mythconverg-1242-20090902000443.sql.gz'
>     > 2009-09-02 00:05:29.993 Console is non-interactive, can't prompt
>     user...
>     > 2009-09-02 00:05:29.996 Upgrading.
>     > 2009-09-02 00:05:30.012 Newest Schema Version : 1244
>     > 2009-09-02 00:05:30.018 Upgrading to schema version 1243
>     > 2009-09-02 00:05:30.020 New DB connection, total: 3
>     > 2009-09-02 00:05:30.022 Connected to database 'mythconverg' at host:
>     > localhost
>     > 2009-09-02 00:05:30.025 Upgrading to schema version 1244
>     > 2009-09-02 00:05:30.030 Database Schema upgrade complete, unlocking.
>     > 2009-09-02 00:05:30.036 MythBackend: Starting up as the master
>     server.
>     >
>     > Then, at 1:00am, when a recording finished, the trouble started:
>     >
>     > 2009-09-02 01:00:01.068 Finished recording Lost "Outlaws":
>     channel 7739
>     > 2009-09-02 01:00:01.495 mythbackend version: trunk [21632]
>     www.mythtv.org <http://www.mythtv.org>
>     > 2009-09-02 01:00:01.500 Using runtime prefix = /usr/local
>     > 2009-09-02 01:00:01.501 Using configuration directory =
>     /home/mythtv/.mythtv
>     > 2009-09-02 01:00:01.518 Empty LocalHostName.
>     > 2009-09-02 01:00:01.520 Using localhost value of mythtv
>     > 2009-09-02 01:00:12.365 HttpComms::Timeout for url:
>     > http://192.168.1.12:6544/Myth
>     > 2009-09-02 01:00:12.377 HttpComms::done() - NetworkOperation
>     Error on
>     > Finish: Request aborted (1): url: 'http://192.168.1.12:6544/Myth'
>     > 2009-09-02 01:00:22.379 HttpComms::Timeout for url:
>     > http://192.168.1.12:6544/Myth
>     > 2009-09-02 01:00:22.390 HttpComms::done() - NetworkOperation
>     Error on
>     > Finish: Request aborted (1): url: 'http://192.168.1.12:6544/Myth'
>     > 2009-09-02 01:00:32.393 HttpComms::Timeout for url:
>     > http://192.168.1.12:6544/Myth
>     > 2009-09-02 01:00:32.403 HttpComms::done() - NetworkOperation
>     Error on
>     > Finish: Request aborted (1): url: 'http://192.168.1.12:6544/Myth'
>     > 2009-09-02 01:00:42.416 HttpComms::Timeout for url:
>     > http://192.168.1.12:6544/Myth
>     > 2009-09-02 01:00:42.429 Failed to contact server for url:
>     > http://192.168.1.12:6544/Myth
>     > 2009-09-02 01:00:42.430 HttpComms::done() - NetworkOperation
>     Error on
>     > Finish: Request aborted (1): url: 'http://192.168.1.12:6544/Myth'
>     > 2009-09-02 01:00:42.431 MythXMLClient::GetConnectionInfo Failed
>     - (1)
>     > unexpected end of file
>     > 2009-09-02 01:00:42.439 Testing network connectivity to
>     '192.168.1.12'
>     > 2009-09-02 01:00:42.486 New DB connection, total: 1
>     > 2009-09-02 01:00:42.487 Unable to connect to database!
>     > 2009-09-02 01:00:42.488 Driver error was [1/2003]:
>     > QMYSQL: Unable to connect
>     > Database error was:
>     > Can't connect to MySQL server on '192.168.1.12' (111)
>     >
>     > 2009-09-02 01:00:42.495 Cannot login to database?
>     >
>     > Any help?
>     >
>
>     Is mysql running? Did you try to open the mythconverg database
>     from using mysql?
>
>     John
>
>
> Yes, I can connect with both phpmyadmin and mysql.  The mysqld is running.
>
> -- Ken
> ------------------------------------------------------------------------
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>   
Did your ip change perhaps???? I had that happen once and drove me nuts 
for awhile..


More information about the mythtv-users mailing list