[mythtv-users] Backend not connecting to database after reboot

Mon Dec 14 19:17:44 UTC 2015

On Mon, Dec 14, 2015 at 9:06 AM Ian Evans <dheianevans at gmail.com> wrote:

> From the "it was working fine two minutes ago" department:
>
> I just VNCing into the desktop of my combined FE/BE (.27.5) and while
> there clicked on the upgrades arrow. The upgrade included a kernel upgrade.
>
> Done that hundreds of times, no problems. Because of the kernel upgrade,
> the system had to restart. Upon starting I was confronted by the Country,
> Language page, a check the database setting page and a can't find the
> database notice.
>
> All the info is the same.
>
> ps aux | grep mysql shows the database running
>
> The mysql log shows it has started:
>
> 151214 11:53:58 [Note] Server hostname (bind-address): '127.0.0.1'; port:
> 3306
> 151214 11:53:58 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
> 151214 11:53:58 [Note] Server socket created on IP: '127.0.0.1'.
> 151214 11:53:59 [Note] Event Scheduler: Loaded 0 events
> 151214 11:53:59 [Note] /usr/sbin/mysqld: ready for connections.
> Version: '5.5.46-0ubuntu0.12.04.2'  socket: '/var/run/mysqld/mysqld.sock'
> port:
>  3306  (Ubuntu)
>
> The mythbackend log shows:
>
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: C thread_unknown
> mythcommandlineparser.cpp:2595 (ConfigureLogging) mythbackend version:
> fixes/0.27 [v0.27.5-69-g31b271b] www.mythtv.org
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: C thread_unknown
> mythcommandlineparser.cpp:2597 (ConfigureLogging) Qt version: compile:
> 4.8.1, runtime: 4.8.1
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: N thread_unknown
> mythcommandlineparser.cpp:2599 (ConfigureLogging) Enabled verbose msgs:
> general
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: N thread_unknown
> logging.cpp:907 (logStart) Setting Log Level to LOG_INFO
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I thread_unknown
> signalhandling.cpp:194 (SetHandlerPrivate) Setup Interrupt handler
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I thread_unknown
> signalhandling.cpp:194 (SetHandlerPrivate) Setup Terminated handler
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I thread_unknown
> signalhandling.cpp:194 (SetHandlerPrivate) Setup Segmentation fault handler
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I thread_unknown
> signalhandling.cpp:194 (SetHandlerPrivate) Setup Aborted handler
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I thread_unknown
> signalhandling.cpp:194 (SetHandlerPrivate) Setup Bus error handler
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I thread_unknown
> signalhandling.cpp:194 (SetHandlerPrivate) Setup Floating point exception
> handler
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I thread_unknown
> signalhandling.cpp:194 (SetHandlerPrivate) Setup Illegal instruction handler
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I thread_unknown
> signalhandling.cpp:194 (SetHandlerPrivate) Setup Real-time signal 0 handler
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: N thread_unknown
> mythdirs.cpp:55 (InitializeMythDirs) Using runtime prefix = /usr
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: N thread_unknown
> mythdirs.cpp:68 (InitializeMythDirs) Using configuration directory =
> /home/mythtv/.mythtv
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I CoreContext
> mythcorecontext.cpp:257 (Init) Assumed character encoding: en_CA.UTF-8
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: N CoreContext
> mythcontext.cpp:504 (LoadDatabaseSettings) Empty LocalHostName.
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I CoreContext
> mythcontext.cpp:512 (LoadDatabaseSettings) Using localhost value of buster
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I CoreContext
> mythcontext.cpp:693 (TestDBconnection) Testing network connectivity to
> '192.168.1.145'
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I Logger
> logging.cpp:308 (run) Added logging to the console
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I SystemIOHandlerW
> mythsystemunix.cpp:91 (run) Starting IO manager (write)
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I SystemIOHandlerR
> mythsystemunix.cpp:91 (run) Starting IO manager (read)
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I
> SystemSignalManager mythsystemunix.cpp:510 (run) Starting process signal
> handler
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I SystemManager
> mythsystemunix.cpp:275 (run) Starting process manager
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I LogForward
> loggingserver.cpp:1373 (forwardMessage) New Client:  (#1)
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: I LogForward
> loggingserver.cpp:295 (SyslogLogger) Added syslogging
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: E CoreContext
> mythdbcon.cpp:216 (OpenDatabase) Unable to connect to database!
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: E CoreContext
> mythdbcon.cpp:217 (OpenDatabase) Driver error was [1/2003]:#012QMYSQL:
> Unable to connect#012Database error was:#012Can't connect to MySQL server
> on '192.168.1.145' (111)
> Dec 14 11:54:00 buster mythbackend: mythbackend[2750]: C CoreContext
> main.cpp:129 (main) Failed to init MythContext
>
> So mysql's running but were not getting a connection. Never seen this
> happen in a reboot before. What should I be checking next?
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org

What distro are you running?

The issue is that your mssql server is only listening on 127.0.0.1 and your
backend is trying to connect to it on 192.168.1.145. You need to either
tell your backend to connect to 127.0.0.1 (assuming both are on the same
box) or tell mysql to listen on the other interface (or all interfaces).
-- 
Thomas Mashos
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20151214/d8a4edcc/attachment.html>