[mythtv-users] Help! MythTV Backend not starting

[jeff at lotussevencars.com]

Quoting jeff at lotussevencars.com:

> Quoting Karl Newman <newmank1 at asme.org>:
>
>> On Sat, Dec 31, 2016 at 11:52 AM, <jeff at lotussevencars.com> wrote:
>
>>
>> It's a change made in MySQL 5.7. The short answer is use
>> "authentication_string" instead of "password". See here:
>> http://stackoverflow.com/questions/30692812/mysql-user-db-does-not-have-password-columns-installing-mysql-on-osx
>> Or even better, use the ALTER USER function. That appears to be the more
>> "approved" way of doing it and doesn't involve directly modifying the user
>> tables.
>>
>> Karl
>
> Thanks - that moved me forward.  I was able to change the  
> authentication string by following the instructions in your link,  
> and it appears that my system is a little happier.  The mythbackend  
> setup window no longer fails, and I'm back to my regular visual  
> theme on the setup windows, implying that my system can access mysql.
>
> Starting mythbackend still gives me an error on connecting to the  
> database (presumably a permission problem with accessing  
> mythconverg?).  Is there a second password that I need to set before  
> the backend can connect to the database?
>
> Here's the mythbackend log.
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: C  
> thread_unknown mythcommandlineparser.cpp:2599 (ConfigureLogging)  
> mythbackend version: fixes/0.28 [v0.28-102-g9befb42] www.mythtv.org
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: C  
> thread_unknown mythcommandlineparser.cpp:2601 (ConfigureLogging) Qt  
> version: compile: 5.5.1, runtime: 5.5.1
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: N  
> thread_unknown mythcommandlineparser.cpp:2603 (ConfigureLogging)  
> Enabled verbose msgs:  general
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: N  
> thread_unknown logging.cpp:920 (logStart) Setting Log Level to  
> LOG_INFO
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> Logger logging.cpp:313 (run) Added logging to the console
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup  
> Interrupt handler
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup  
> Terminated handler
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup  
> Segmentation fault handler
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup  
> Aborted handler
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Bus  
> error handler
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup  
> Floating point exception handler
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup  
> Illegal instruction handler
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup  
> Real-time signal 0 handler
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup  
> Hangup handler
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: N  
> thread_unknown mythdirs.cpp:192 (InitializeMythDirs) Using runtime  
> prefix = /usr
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: N  
> thread_unknown mythdirs.cpp:194 (InitializeMythDirs) Using  
> configuration directory = /home/mythtv/.mythtv
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> CoreContext mythcorecontext.cpp:266 (Init) Assumed character  
> encoding: en_US.UTF-8
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: N  
> CoreContext mythcontext.cpp:505 (LoadDatabaseSettings) Empty  
> LocalHostName.
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> CoreContext mythcontext.cpp:513 (LoadDatabaseSettings) Using  
> localhost value of MythBuntu-Server
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: E  
> CoreContext mythdbcon.cpp:229 (OpenDatabase) [DBManager0] Unable to  
> connect to database!
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: E  
> CoreContext mythdbcon.cpp:230 (OpenDatabase) Driver error was  
> [1/1045]:#012QMYSQL: Unable to connect#012Database error  
> was:#012Access denied for user 'mythtv'@'localhost' (using password:  
> YES)
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: C  
> CoreContext main.cpp:132 (main) Failed to init MythContext.
> Dec 31 16:37:09 MythBuntu-Server mythbackend: mythbackend[16098]: I  
> LogForward loggingserver.cpp:295 (SyslogLogger) Added syslogging

Success - I had to go to the /etc/mythtv/config.xml file which still  
had the old, bad password.  Once I updated the password in that file,  
I was back in operation.

Thanks for all the advice.

Jeff