[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