[mythtv-users] .29 won't connect to backend

Stephen Worthington stephen_agent at jsw.gen.nz
Tue Oct 16 02:25:57 UTC 2018 

On Mon, 15 Oct 2018 20:01:15 -0500, you wrote:

>On 10/15/2018 07:10 PM, Mark Perkins wrote:
>> 
>> 
>> On 16 October 2018 10:33:46 am Jack McGee <jack at greendesk.net> wrote:
>> 
>>> On 10/15/2018 02:04 PM, Jack McGee wrote:
>>>> I upgraded a 16.04 frontend and 16.04 backend from .28 to .29.
>>>
>>> and this might be helpful:
>>>
>>> mythuser at amethi:/home/mythtv/.mythtv$ cat config.xml
>>> <Configuration>
>>>    <LocalHostName>my-unique-identifier-goes-here</LocalHostName>
>>>    <Database>
>>>      <PingHost>1</PingHost>
>>>      <Host>localhost</Host>
>>>      <UserName>mythtv</UserName>
>>>      <Password>mythtv</Password>
>>>      <DatabaseName>mythconverg</DatabaseName>
>>>      <Port>6543</Port>
>>>    </Database>
>> 
>> ....snip....
>> 
>>>
>>> 3306/tcp open   mysql   syn-ack
>> 
>> mysql is listening on 3306 but config.xml says 6543. Change config.xml to 3306.
>
>OK, I changed port in mythtv-setup to 3306, changed all config.xml to 
>3306 also.
>
>Now both frontends can connect to the backend, I think,  they do start 
>up and run.  But recorded show list is empty.  and other anomolies.
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: C thread_unknown mythcommandlineparser.cpp:2619 (ConfigureLogging) mythbackend version: fixes/29 [v29.1-40-g951f1fe] www.mythtv.org
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: C thread_unknown mythcommandlineparser.cpp:2621 (ConfigureLogging) Qt version: compile: 5.5.1, runtime: 5.5.1
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: N thread_unknown mythcommandlineparser.cpp:2623 (ConfigureLogging) Enabled verbose msgs:  general
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: N thread_unknown logging.cpp:927 (logStart) Setting Log Level to LOG_INFO
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I Logger logging.cpp:313 (run) Added logging to the console
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Interrupt handler
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Terminated handler
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Segmentation fault handler
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Aborted handler
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Bus error handler
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Floating point exception handler
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Illegal instruction handler
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Real-time signal 0 handler
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Hangup handler
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: N thread_unknown mythdirs.cpp:195 (InitializeMythDirs) Using runtime prefix = /usr
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: N thread_unknown mythdirs.cpp:197 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I CoreContext mythcorecontext.cpp:271 (Init) Assumed character encoding: en_US.UTF-8
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: N CoreContext mythcontext.cpp:599 (LoadDatabaseSettings) Empty LocalHostName.
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:607 (LoadDatabaseSettings) Using localhost value of amethi
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 0, status dbAwake
>> Oct 15 19:54:29 amethi mythbackend: mythbackend[1609]: I LogForward loggingserver.cpp:302 (SyslogLogger) Added syslogging
>> Oct 15 19:54:30 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 1, status dbAwake
>> Oct 15 19:54:35 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 2, status dbAwake
>> Oct 15 19:54:40 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 3, status dbAwake
>> Oct 15 19:54:45 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 4, status dbAwake
>> Oct 15 19:54:50 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 5, status dbAwake
>> Oct 15 19:54:55 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 6, status dbAwake
>> Oct 15 19:55:00 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 7, status dbAwake
>> Oct 15 19:55:05 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 8, status dbAwake
>> Oct 15 19:55:10 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 9, status dbAwake
>> Oct 15 19:55:15 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 10, status dbAwake
>> Oct 15 19:55:20 amethi mythbackend: mythbackend[1609]: I CoreContext mythcontext.cpp:971 (TestDBconnection) Start up failure. host localhost, status dbAwakeFail
>> Oct 15 19:55:21 amethi mythbackend: mythbackend[1609]: C CoreContext main.cpp:132 (main) Failed to init MythContext.
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: C thread_unknown mythcommandlineparser.cpp:2619 (ConfigureLogging) mythbackend version: fixes/29 [v29.1-40-g951f1fe] www.mythtv.org
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: C thread_unknown mythcommandlineparser.cpp:2621 (ConfigureLogging) Qt version: compile: 5.5.1, runtime: 5.5.1
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: N thread_unknown mythcommandlineparser.cpp:2623 (ConfigureLogging) Enabled verbose msgs:  general
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: N thread_unknown logging.cpp:927 (logStart) Setting Log Level to LOG_INFO
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I Logger logging.cpp:313 (run) Added logging to the console
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Interrupt handler
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Terminated handler
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Segmentation fault handler
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Aborted handler
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Bus error handler
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Floating point exception handler
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Illegal instruction handler
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Real-time signal 0 handler
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Hangup handler
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: N thread_unknown mythdirs.cpp:195 (InitializeMythDirs) Using runtime prefix = /usr
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: N thread_unknown mythdirs.cpp:197 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I CoreContext mythcorecontext.cpp:271 (Init) Assumed character encoding: en_US.UTF-8
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: N CoreContext mythcontext.cpp:599 (LoadDatabaseSettings) Empty LocalHostName.
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:607 (LoadDatabaseSettings) Using localhost value of amethi
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 0, status dbAwake
>> Oct 15 19:55:22 amethi mythbackend: mythbackend[3784]: I LogForward loggingserver.cpp:302 (SyslogLogger) Added syslogging
>> Oct 15 19:55:23 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 1, status dbAwake
>> Oct 15 19:55:28 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 2, status dbAwake
>> Oct 15 19:55:33 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 3, status dbAwake
>> Oct 15 19:55:38 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 4, status dbAwake
>> Oct 15 19:55:43 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 5, status dbAwake
>> Oct 15 19:55:48 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 6, status dbAwake
>> Oct 15 19:55:53 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 7, status dbAwake
>> Oct 15 19:55:58 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 8, status dbAwake
>> Oct 15 19:56:03 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 9, status dbAwake
>> Oct 15 19:56:08 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 10, status dbAwake
>> Oct 15 19:56:13 amethi mythbackend: mythbackend[3784]: I CoreContext mythcontext.cpp:971 (TestDBconnection) Start up failure. host localhost, status dbAwakeFail
>> Oct 15 19:56:14 amethi mythbackend: mythbackend[3784]: C CoreContext main.cpp:132 (main) Failed to init MythContext.
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: C thread_unknown mythcommandlineparser.cpp:2619 (ConfigureLogging) mythbackend version: fixes/29 [v29.1-40-g951f1fe] www.mythtv.org
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: C thread_unknown mythcommandlineparser.cpp:2621 (ConfigureLogging) Qt version: compile: 5.5.1, runtime: 5.5.1
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: N thread_unknown mythcommandlineparser.cpp:2623 (ConfigureLogging) Enabled verbose msgs:  general
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: N thread_unknown logging.cpp:927 (logStart) Setting Log Level to LOG_INFO
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I Logger logging.cpp:313 (run) Added logging to the console
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Interrupt handler
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Terminated handler
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Segmentation fault handler
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Aborted handler
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Bus error handler
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Floating point exception handler
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Illegal instruction handler
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Real-time signal 0 handler
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Hangup handler
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: N thread_unknown mythdirs.cpp:195 (InitializeMythDirs) Using runtime prefix = /usr
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: N thread_unknown mythdirs.cpp:197 (InitializeMythDirs) Using configuration directory = /home/mythtv/.mythtv
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I CoreContext mythcorecontext.cpp:271 (Init) Assumed character encoding: en_US.UTF-8
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: N CoreContext mythcontext.cpp:599 (LoadDatabaseSettings) Empty LocalHostName.
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:607 (LoadDatabaseSettings) Using localhost value of amethi
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 0, status dbAwake
>> Oct 15 19:56:15 amethi mythbackend: mythbackend[4143]: I LogForward loggingserver.cpp:302 (SyslogLogger) Added syslogging
>> Oct 15 19:56:16 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 1, status dbAwake
>> Oct 15 19:56:21 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 2, status dbAwake
>> Oct 15 19:56:26 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 3, status dbAwake
>> Oct 15 19:56:31 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 4, status dbAwake
>> Oct 15 19:56:36 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 5, status dbAwake
>> Oct 15 19:56:41 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 6, status dbAwake
>> Oct 15 19:56:46 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 7, status dbAwake
>> Oct 15 19:56:51 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 8, status dbAwake
>> Oct 15 19:56:56 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 9, status dbAwake
>> Oct 15 19:57:01 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing connections. DB localhost, BE , attempt 10, status dbAwake
>> Oct 15 19:57:06 amethi mythbackend: mythbackend[4143]: I CoreContext mythcontext.cpp:971 (TestDBconnection) Start up failure. host localhost, status dbAwakeFail
>
>mythuser at amethi:/var/log/mythtv$ cat /home/mythtv/.mythtv/config.xml
><Configuration>
>   <LocalHostName>my-unique-identifier-goes-here</LocalHostName>
>   <Database>
>     <PingHost>1</PingHost>
>     <Host>localhost</Host>
>     <UserName>mythtv</UserName>
>     <Password>mythtv</Password>
>     <DatabaseName>mythconverg</DatabaseName>
>     <Port>3306</Port>
>   </Database>
>   <WakeOnLAN>
>     <Enabled>0</Enabled>
>     <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
>     <SQLConnectRetry>5</SQLConnectRetry>
>     <Command>echo 'WOLsqlServerCommand not set'</Command>
>   </WakeOnLAN>
></Configuration>

It is not connecting to the database.  Are you running MariaDB or
MySQL?  Is mysqld running?  What do these commands show:

sudo netstat -alnp | grep 3306
sudo ps -ef | grep mysql
sudo systemctl status mysql

More information about the mythtv-users mailing list