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

Mark Perkins perkins1724 at hotmail.com
Tue Oct 16 05:26:27 UTC 2018 


On 16 October 2018 11:31:40 am Jack McGee <jack at greendesk.net> 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>
>
>
>
>
>
> _______________________________________________
> 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
Long shot - try:
<PingHost>0</PingHost>

It looks like it is failing the db awake test.

More information about the mythtv-users mailing list