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

Kenneth Emerson kenneth.emerson at gmail.com
Wed Sep 2 16:25:49 UTC 2009


On Wed, Sep 2, 2009 at 11:18 AM, John Drescher <drescherjm at gmail.com> wrote:

> On Wed, Sep 2, 2009 at 12:12 PM, Kenneth
> Emerson<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
> > 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
> > 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
> > 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20090902/faabe132/attachment.htm>


More information about the mythtv-users mailing list