[mythtv-users] .29 won't connect to backend
Jack McGee
jack at greendesk.net
Tue Oct 16 01:01:15 UTC 2018
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>
More information about the mythtv-users
mailing list