[mythtv-users] Help! MythTV Backend not starting

[Mike Holden]

On 1 January 2017 at 10:45, <jeff at lotussevencars.com> wrote:

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


Please update the wiki page that refers to the incorrect/out-of-date table
column, so that others will benefit from what you've just been through.
Otherwise, you are setting up someone else to have exactly the same problem
you just went through!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20170101/963ab518/attachment.html>