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

Wed Sep 2 19:24:53 UTC 2009

---------- Forwarded message ----------
From: greg <greg12866 at nycap.rr.com>
Date: Wed, Sep 2, 2009 at 11:58 AM
Subject: Re: [mythtv-users] SVN Update - then no connection to DB
To: Discussion about mythtv <mythtv-users at mythtv.org>

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..

_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

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.

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).

-- Ken E
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20090902/8ea749a3/attachment.htm>