[mythtv-users] I broke my mythTV, help!

Thu Nov 8 04:11:09 UTC 2018

On 11/7/18 9:53 PM, Douglas Peale wrote:
> On 11/7/18 2:26 PM, Bill Meek wrote:
>> On 11/7/18 1:06 PM, Jonatan Lindblad wrote:
>>> Den 2018-11-07 kl. 18:32, skrev Douglas Peale:
>>>
>>>>>> Nov  6 20:41:57 Compromise mythbackend: mythbackend[7003]: N thread_unknown mythdirs.cpp:197 (InitializeMythDirs) Using
>>>>>> configuration directory = /home/mythtv/.mythtv
>>>
>>> <snip>
>>>
>>>> The username and password are correct in /user/home/mythtv/.mythtv/config.xml
>>>
>>> Do you really mean /user/home/mythtv/.mythtv/config.xml, with /user in the beginning? If you do, then you might have to set
>>> the environment variable MYTHCONFDIR to /user/home/mythtv/.mythtv.
>>>
>>> Jonatan
>>
>> Good idea, and it's easily done in:/etc/mythtv/additional.args by creating a like like this
>> and starting the backend again:
>>
>> MYTHCONFDIR=/user/home/mythtv/.mythtv
>>
>> It would also be nice to see a fresh backend log. The last one (I believe)
>> also suggested a problem accessing config.xml. The backend was using
>> default values:
>>
>> /// Load sensible connection defaults.
>> void DatabaseParams::LoadDefaults(void)
>> {
>>      dbHostName    = "localhost";
>>      dbHostPing    = true;
>>      dbPort        = 3306;
>>      dbUserName    = "mythtv";
>>      dbPassword    = "mythtv"; <----------------
>>      dbName        = "mythconverg";
>>      dbType        = "QMYSQL";
>>
>> Nov  6 20:41:57 Compromise mythbackend: mythbackend[7003]: E CoreContext mythdbparams.cpp:39 (IsValid) DBHostName is not set in
>> config.xml
>>
> End of the log file (this stuff repeats a bunch of times):
> 
> Nov  7 19:14:20 Compromise mythbackend: mythbackend[2308]: C CoreContext main.cpp:132 (main) Failed to init MythContext.
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: C thread_unknown mythcommandlineparser.cpp:2619 (ConfigureLogging)
> mythbackend version: fixes/29 [v29.1-13-g329c235] www.mythtv.org
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: C thread_unknown mythcommandlineparser.cpp:2621 (ConfigureLogging) Qt
> version: compile: 5.9.4, runtime: 5.9.5
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: N thread_unknown mythcommandlineparser.cpp:2623 (ConfigureLogging)
> Enabled verbose msgs:  general
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: N thread_unknown logging.cpp:927 (logStart) Setting Log Level to LOG_INFO
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I Logger logging.cpp:313 (run) Added logging to the console
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
> Interrupt handler
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
> Terminated handler
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
> Segmentation fault handler
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
> Aborted handler
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Bus
> error handler
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
> Floating point exception handler
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
> Illegal instruction handler
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
> Real-time signal 0 handler
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup
> Hangup handler
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: N thread_unknown mythdirs.cpp:195 (InitializeMythDirs) Using runtime
> prefix = /usr
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: N thread_unknown mythdirs.cpp:197 (InitializeMythDirs) Using
> configuration directory = /home/mythtv/.mythtv
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I CoreContext mythcorecontext.cpp:271 (Init) Assumed character
> encoding: en_US.UTF-8
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: E CoreContext mythdbparams.cpp:39 (IsValid) DBHostName is not set in
> config.xml
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: E CoreContext mythdbparams.cpp:39 (IsValid) DBHostName is not set in
> config.xml
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: N CoreContext mythcontext.cpp:599 (LoadDatabaseSettings) Empty
> LocalHostName.
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I CoreContext mythcontext.cpp:607 (LoadDatabaseSettings) Using
> localhost value of Compromise
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I CoreContext mythcontext.cpp:852 (TestDBconnection) Start up testing
> connections. DB localhost, BE , attempt 0, status dbAwake
> Nov  7 19:14:22 Compromise mythbackend: mythbackend[2322]: I LogForward loggingserver.cpp:302 (SyslogLogger) Added syslogging
> Nov  7 19:14:23 Compromise mythbackend: mythbackend[2322]: E CoreContext mythdbcon.cpp:242 (OpenDatabase) [DBManager0] Unable to
> connect to database!
> Nov  7 19:14:23 Compromise mythbackend: mythbackend[2322]: E CoreContext mythdbcon.cpp:243 (OpenDatabase) Driver error was
> [1/1045]:#012QMYSQL: Unable to connect#012Database error was:#012Access denied for user 'mythtv'@'localhost' (using password: YES)
> Nov  7 19:14:24 Compromise mythbackend: mythbackend[2322]: I CoreContext mythcontext.cpp:971 (TestDBconnection) Start up
> failure. host localhost, status dbStartedFail
> Nov  7 19:14:24 Compromise mythbackend: mythbackend[2322]: I CoreContext mythcontext.cpp:1127 (UPnPautoconf) UPNP Search 2 secs
> Nov  7 19:14:24 Compromise mythbackend: mythbackend[2322]: I CoreContext mythcontext.cpp:1142 (UPnPautoconf) UPNP Search 1 secs
> Nov  7 19:14:26 Compromise mythbackend: mythbackend[2322]: I CoreContext mythcontext.cpp:1152 (UPnPautoconf) No UPnP backends found
> Nov  7 19:14:27 Compromise mythbackend: mythbackend[2322]: C CoreContext main.cpp:132 (main) Failed to init MythContext.
> 
> 
> Why is it comlaining about "Empty LocalHostName"? Doesn't the line "<Host>localhost</Host> set it to "localhost"?

No, that message (it's just a Notice) says that: <LocalHostName></LocalHostName>
is set to "my-unique-identifier-goes-here" or empty or (in your case) missing
from config.xml. It's not an error and can be ignored.

These E (error) messages are of more concern. As mentioned earlier, the backend isn't finding
a config.xml and resorting to default values. That means the the DB password would be "mythtv".

     ... E CoreContext mythdbparams.cpp:39 (IsValid) DBHostName *is not set in config.xml*

The systemctl edit I just tested/posted would point the backend to /etc/mythtv. As I recall, you've got
some links to an old disk where the expected config.xml is. I'm trying to prove that's causing the
failure.

Thanks for new new log, it confirms a problem accessing the expected config.xml.

> $ cat config.xml
> <Configuration>
>    <Database>
>      <PingHost>1</PingHost>
>      <Host>localhost</Host>
>      <UserName>mythtv</UserName>
>      <Password>xxxxxxxx</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>

-- 
Bill