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

Thu Nov 8 03:53:55 UTC 2018

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"?

$ 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>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 833 bytes
Desc: OpenPGP digital signature
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20181107/79ac37d5/attachment.sig>