[mythtv-users] I broke my mythTV, help!
Bill Meek
keemllib at gmail.com
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
More information about the mythtv-users
mailing list