<div dir="ltr"><div><div><div>I'm probably in no position to give good advice. <br><br>My main insight to your troubles is first verify that you can connect to mysql from the command-line via mysql -umythtv -p<user_mysql_password> and verify that you have normal connectivity to any connected secondary backends. In my case, sometimes my Intel mboard NIC doesn't load on a cold boot. <br><br></div>The main difference between my install in Mint 17.3 and Mint 18 is that Mint 18 uses mysql-server-5.7. There is a bug report out about 5.7, but it appears to be related to release-upgrading.<br><br></div>Good luck!<br><br></div>Steve<br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Jul 16, 2016 at 7:14 PM, Douglas Peale <span dir="ltr"><<a href="mailto:Douglas_Peale@comcast.net" target="_blank">Douglas_Peale@comcast.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>I am having a similar problem, so I
went to look at the user table in mythconveg. I don't seem to have
a user table.<br>
It looks like I do have a users table though.<br>
I'm running mint 18 Cinnamon and did a database restore. This has
left me with liveTV not working, and mythweb not working.<br>
I posted on the forum, but so far it has been a monologue with no
posts by anyone but me.<br>
<a href="https://forum.mythtv.org/viewtopic.php?f=36&t=151" target="_blank">https://forum.mythtv.org/viewtopic.php?f=36&t=151</a><br>
(skip down to July 9th to see the current issues and what I have
tried)<div><div class="h5"><br>
<br>
On 07/16/2016 03:43 PM, Steve Greene wrote:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div dir="ltr">
<div>
<div>Thanks for everyone's help and insight. I still haven't
solved this and I'm not about to surrender my Saturday night
to it. I've backed up the recalcitrant install and I'll work
on it as time permits.<br>
<br>
</div>
<div>I'd probably stay with Mint 17.3 if I could get it to
play nicely with all my new Skylake goodies!<br>
</div>
<div><br>
</div>
BTW, I'm really not liking mysql-server-5.7, it demanded a
clean install and replaced one or two cnf files with what
seems like 5-6. Not sure what the users are getting for that
added complexity!<br>
<br>
</div>
Steve<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sat, Jul 16, 2016 at 6:07 PM, Steve
Greene <span dir="ltr"><<a href="mailto:sgreene59@verizon.net" target="_blank">sgreene59@verizon.net</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<blockquote style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex" class="gmail_quote">mysql>
SELECT user, host from user;<br>
+------------------+-------------+<br>
| user | host |<br>
+------------------+-------------+<br>
| mythtv | % |<br>
| mythtv | 192.168.1.2 |<br>
| mythtv | bilbo.home |<br>
| debian-sys-maint | localhost |<br>
| mysql.sys | localhost |<br>
| root | localhost |<br>
+------------------+-------------+<br>
</blockquote>
<div><br>
</div>
<div>Shouldn't this cover all the locations?<br>
<br>
<br>
</div>
<div>This is super-frustrating, I always expect that a
database restore from a working setup should "just
work". It never does. <br>
<br>
</div>
<div>How do I turn on more helpful debugging messages?
/var/log/mysql/error.log gives me nothing more than what
I've seen from command-line login attempts.<span><font color="#888888"><br>
</font></span></div>
<span><font color="#888888">
<div><br>
</div>
<div>Steve<br>
</div>
</font></span></div>
<div>
<div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sat, Jul 16, 2016 at 5:42
PM, Hika van den Hoven <span dir="ltr"><<a href="mailto:hikavdh@gmail.com" target="_blank"></a><a href="mailto:hikavdh@gmail.com" target="_blank">hikavdh@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hoi
Steve,<br>
<div>
<div><br>
Saturday, July 16, 2016, 11:30:57 PM, you
wrote:<br>
<br>
> I thought that was what mythtv.cnf was
for, which I've set to my<br>
> local ip. I just tried setting
mysqld.cnf<br>
> "bind-address=my_ip_address" and it
hasn't worked.<br>
<br>
> I can still manually call up mysql
-umyth -p, but mysql<br>
> -h192.168.1.x -umyth -p gives me ERROR
1045 (28000): Access denied<br>
> for user 'mythtv'@'my_hostname' (using
password: YES).<br>
> Incidentally, same with the root mysql
account. I can connect from<br>
> my secondary backend via the ip address.
It just won't accept an<br>
> login via the IP address local to the
server.<br>
<br>
> Steve<br>
<br>
> On Sat, Jul 16, 2016 at 3:27 PM, Steve
Greene <<a href="mailto:sgreene59@verizon.net" target="_blank">sgreene59@verizon.net</a>>
wrote:<br>
<br>
> Since upgrading to 0.28 and Mint 18, my
local frontend connects to<br>
> "localhost" but not the IP address of the
MBE (which is local).<br>
<br>
> mysql -h"my_IP_ADDR" -u myth -p will
fail, but mysql -umythtv -p<br>
> will connect. Do I have to add the IP
address to one of the tables in mythconverg?<br>
<br>
> Thanks in advance for your assistance.<br>
<br>
> Steve<br>
><br>
<br>
</div>
</div>
Have you setup a user for that location in mysql.
You have to setup<br>
the user/password for the locations from where you
want to have<br>
access. So localhost or an IP address or % for all
machines.<br>
<br>
Tot mails,<br>
Hika mailto:<a href="mailto:hikavdh@gmail.com" target="_blank"></a><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>
<div>
<div><br>
_______________________________________________<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/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
mythtv-users mailing list
<a href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a href="https://forum.mythtv.org" target="_blank">https://forum.mythtv.org</a>
</pre>
</blockquote>
</div></div><p>I am hav<br>
</p>
</div>
<br>_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a href="http://wiki.mythtv.org/Mailing_List_etiquette" rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a href="https://forum.mythtv.org" rel="noreferrer" target="_blank">https://forum.mythtv.org</a><br>
<br></blockquote></div><br></div>