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

[Ian Evans]

>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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20151214/f498474c/attachment.html>