<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Sat, Dec 31, 2016 at 11:52 AM, <span dir="ltr"><<a href="mailto:jeff@lotussevencars.com" target="_blank">jeff@lotussevencars.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="gmail-HOEnZb"><div class="gmail-h5"><br>
Quoting Hika van den Hoven <<a href="mailto:hikavdh@gmail.com" target="_blank">hikavdh@gmail.com</a>>:<br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Hoi Jeff,<br>
<br>
Saturday, December 31, 2016, 8:27:31 PM, you wrote:<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Quoting <a href="mailto:jeff@lotussevencars.com" target="_blank">jeff@lotussevencars.com</a>:<br>
</blockquote>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
Quoting Stephen Worthington <<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>>:<br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
On Sat, 31 Dec 2016 08:02:17 -0700, you wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<br>
I have set up and got working a standalone mythtv box. In the process<br>
of trying to open up the access to the database for a second remote<br>
frontend, I have broken the primary backend and don't know how.<br>
<br>
The mysql database is running:<br>
<br>
? mysql.service - MySQL Community Server<br>
Loaded: loaded (/lib/systemd/system/mysql.ser<wbr>vice; enabled;<br>
vendor preset: enabled)<br>
Active: active (running) since Fri 2016-12-30 17:32:35 EST; 16h ago<br>
Process: 2531 ExecStartPost=/usr/share/mysql<wbr>/mysql-systemd-start<br>
post (code=exited, status=0/SUCCESS)<br>
Process: 2527 ExecStartPre=/usr/share/mysql/<wbr>mysql-systemd-start<br>
pre (code=exited, status=0/SUCCESS)<br>
Main PID: 2530 (mysqld)<br>
CGroup: /system.slice/mysql.service<br>
??2530 /usr/sbin/mysqld<br>
<br>
Dec 30 17:32:34 MythBuntu-Server systemd[1]: Starting MySQL Community<br>
Server...<br>
Dec 30 17:32:35 MythBuntu-Server systemd[1]: Started MySQL<br>
Community Server.<br>
<br>
The mythTV backend, however, is not<br>
? mythtv-backend.service - MythTV Backend<br>
Loaded: loaded (/lib/systemd/system/mythtv-ba<wbr>ckend.service;<br>
enabled; vendor preset: enabled)<br>
Active: inactive (dead) (Result: exit-code) since Sat 2016-12-31<br>
09:40:24 EST; 14s ago<br>
Docs: <a href="https://www.mythtv.org/wiki/Mythbackend" rel="noreferrer" target="_blank">https://www.mythtv.org/wiki/My<wbr>thbackend</a><br>
Process: 9026 ExecStart=/usr/bin/mythbackend --quiet --syslog<br>
local7 $ADDITIONAL_ARGS (code=exited, status=130)<br>
Main PID: 9026 (code=exited, status=130)<br>
<br>
Dec 31 09:40:23 MythBuntu-Server systemd[1]: mythtv-backend.service:<br>
Unit entered failed state.<br>
Dec 31 09:40:23 MythBuntu-Server systemd[1]: mythtv-backend.service:<br>
Failed with result 'exit-code'.<br>
Dec 31 09:40:24 MythBuntu-Server systemd[1]: mythtv-backend.service:<br>
Service hold-off time over, scheduling restart.<br>
Dec 31 09:40:24 MythBuntu-Server systemd[1]: Stopped MythTV Backend.<br>
Dec 31 09:40:24 MythBuntu-Server systemd[1]: mythtv-backend.service:<br>
Start request repeated too quickly.<br>
Dec 31 09:40:24 MythBuntu-Server systemd[1]: Failed to start<br>
MythTV Backend.<br>
<br>
The database server settings are<br>
Hostname 127.0.0.1<br>
Port 3306<br>
Database name mythconverg<br>
User mythtv<br>
<br>
I've tried disabling and enabling mysql service on ethernet interfaces<br>
from mythbuntu control center, but neither option resolves my problem.<br>
<br>
Here are the results of journalctl -xe<br>
<br>
-- Support: <a href="http://lists.freedesktop.org/mailman/listinfo/systemd-devel" rel="noreferrer" target="_blank">http://lists.freedesktop.org/m<wbr>ailman/listinfo/systemd-devel</a><br>
--<br>
-- Unit systemd-hostnamed.service has finished starting up.<br>
--<br>
-- The start-up result is done.<br>
Dec 31 09:56:02 MythBuntu-Server sudo[2945]: jeff : TTY=pts/0 ;<br>
PWD=/home/jeff ; USER=root ; COMMAND=/etc/init.d/mythtv-bac<wbr>kend restart<br>
Dec 31 09:56:02 MythBuntu-Server sudo[2945]: pam_unix(sudo:session):<br>
session opened for user root by jeff(uid=0)<br>
Dec 31 09:56:02 MythBuntu-Server systemd[1]: Stopped MythTV Backend.<br>
-- Subject: Unit mythtv-backend.service has finished shutting down<br>
-- Defined-By: systemd<br>
-- Support: <a href="http://lists.freedesktop.org/mailman/listinfo/systemd-devel" rel="noreferrer" target="_blank">http://lists.freedesktop.org/m<wbr>ailman/listinfo/systemd-devel</a><br>
--<br>
-- Unit mythtv-backend.service has finished shutting down.<br>
Dec 31 09:56:02 MythBuntu-Server systemd[1]: mythtv-backend.service:<br>
Start request repeated too quickly.<br>
Dec 31 09:56:02 MythBuntu-Server systemd[1]: Failed to start<br>
MythTV Backend.<br>
-- Subject: Unit mythtv-backend.service has failed<br>
-- Defined-By: systemd<br>
-- Support: <a href="http://lists.freedesktop.org/mailman/listinfo/systemd-devel" rel="noreferrer" target="_blank">http://lists.freedesktop.org/m<wbr>ailman/listinfo/systemd-devel</a><br>
--<br>
-- Unit mythtv-backend.service has failed.<br>
</blockquote>
<br>
The first thing to do is to check the mysql log files to see if there<br>
is an error message about the changes you have been doing to its<br>
configuration. Then run this command to see where mysql is listening:<br>
<br>
netstat -pl | grep mysqld<br>
<br>
If all seems well there, then you need to look in mythbackend.log to<br>
see what error message is showing up there.<br>
<br>
Are you only having this problem when you boot? Does it work properly<br>
if you manually restart mythbackend after booting is complete? If so,<br>
then you need to do the systemd fixes for getting mythbackend to start<br>
up properly when using external networking. See here:<br>
<br>
<a href="http://mythtvinstall.blogspot.com/2016/12/how-to-install-mythbuntu-16041.html" rel="noreferrer" target="_blank">http://mythtvinstall.blogspot.<wbr>com/2016/12/how-to-install-myt<wbr>hbuntu-16041.html</a><br>
<br>
or here:<br>
<br>
<a href="https://www.mythtv.org/wiki/Install_Mythbuntu_16.04.01" rel="noreferrer" target="_blank">https://www.mythtv.org/wiki/In<wbr>stall_Mythbuntu_16.04.01</a><br>
______________________________<wbr>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailma<wbr>n/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing<wbr>_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote>
<br>
<br>
Manual restart of mythbackend after booting doesn't fix the problem.<br>
<br>
the netstat command returns this<br>
tcp 0 0 localhost:mysql *:*<br>
LISTEN 1051/mysqld<br>
unix 2 [ ACC ] STREAM LISTENING 20561<br>
1051/mysqld /var/run/mysqld/mysqld.sock<br>
<br>
The mysql log does appear to point to a password problem<br>
2016-12-31T18:02:09.112069Z 26 [Note] Access denied for user<br>
'mythtv'@'localhost' (using password: YES)<br>
<br>
Password seems to be the culprit from mythbackend.log<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: C<br>
thread_unknown mythcommandlineparser.cpp:2599 (ConfigureLogging)<br>
mythbackend version: fixes/0.28 [v0.28-102-g9befb42] <a href="http://www.mythtv.org" rel="noreferrer" target="_blank">www.mythtv.org</a><br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: C<br>
thread_unknown mythcommandlineparser.cpp:2601 (ConfigureLogging) Qt<br>
version: compile: 5.5.1, runtime: 5.5.1<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: N<br>
thread_unknown mythcommandlineparser.cpp:2603 (ConfigureLogging)<br>
Enabled verbose msgs: general<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: N<br>
thread_unknown logging.cpp:920 (logStart) Setting Log Level to<br>
LOG_INFO<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
Logger logging.cpp:313 (run) Added logging to the console<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup<br>
Interrupt handler<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup<br>
Terminated handler<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup<br>
Segmentation fault handler<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup<br>
Aborted handler<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup Bus<br>
error handler<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup<br>
Floating point exception handler<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup<br>
Illegal instruction handler<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup<br>
Real-time signal 0 handler<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
thread_unknown signalhandling.cpp:194 (SetHandlerPrivate) Setup<br>
Hangup handler<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: N<br>
thread_unknown mythdirs.cpp:192 (InitializeMythDirs) Using runtime<br>
prefix = /usr<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: N<br>
thread_unknown mythdirs.cpp:194 (InitializeMythDirs) Using<br>
configuration directory = /home/mythtv/.mythtv<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
CoreContext mythcorecontext.cpp:266 (Init) Assumed character<br>
encoding: en_US.UTF-8<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: N<br>
CoreContext mythcontext.cpp:505 (LoadDatabaseSettings) Empty<br>
LocalHostName.<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
CoreContext mythcontext.cpp:513 (LoadDatabaseSettings) Using<br>
localhost value of MythBuntu-Server<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: E<br>
CoreContext mythdbcon.cpp:229 (OpenDatabase) [DBManager0] Unable to<br>
connect to database!<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: E<br>
CoreContext mythdbcon.cpp:230 (OpenDatabase) Driver error was<br>
[1/1045]:#012QMYSQL: Unable to connect#012Database error<br>
was:#012Access denied for user 'mythtv'@'localhost' (using password:<br>
YES)<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: C<br>
CoreContext main.cpp:132 (main) Failed to init MythContext.<br>
Dec 31 13:02:09 MythBuntu-Server mythbackend: mythbackend[23089]: I<br>
LogForward loggingserver.cpp:295 (SyslogLogger) Added syslogging<br>
<br>
<br>
______________________________<wbr>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailma<wbr>n/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing<wbr>_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote></blockquote>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
So, thinking that the database user access is the problem, I tried to<br>
follow the instructions here:<br>
<a href="https://www.mythtv.org/wiki/Category:MySQL" rel="noreferrer" target="_blank">https://www.mythtv.org/wiki/Ca<wbr>tegory:MySQL</a><br>
When I try to enter the set password command, I get the error<br>
ERROR 1054 (42S22): Unknown column 'Password' in 'field list'<br>
</blockquote>
<br>
Are you using a Mac? Something about that came up in the last month!<br>
<br>
Tot mails,<br>
Hika mailto:<a href="mailto:hikavdh@gmail.com" target="_blank">hikavdh@gmail.com</a><br>
<br>
"Zonder hoop kun je niet leven<br>
Zonder leven is er geen hoop<br>
Het eeuwige dilemma<br>
Zeker als je hoop moet vernietigen om te kunnen overleven!"<br>
<br>
De lerende Mens<br>
<br>
______________________________<wbr>_________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailma<wbr>n/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing<wbr>_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</blockquote>
<br></div></div>
No, this is a Mythbuntu linux box.<br></blockquote><div><br></div><div>It's a change made in MySQL 5.7. The short answer is use "authentication_string" instead of "password". See here: <a href="http://stackoverflow.com/questions/30692812/mysql-user-db-does-not-have-password-columns-installing-mysql-on-osx">http://stackoverflow.com/questions/30692812/mysql-user-db-does-not-have-password-columns-installing-mysql-on-osx</a><br></div><div>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.<br></div><div><br></div><div>Karl </div></div></div></div>