[mythtv-users] Help! MythTV Backend not starting

jeff at lotussevencars.com jeff at lotussevencars.com
Sat Dec 31 21:51:18 UTC 2016


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





More information about the mythtv-users mailing list