<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">I can connect to mysql from the command
line. I do not have any secondary backends, only a single frontend
backend system.<br>
The front end can play recorded shows, but can't do live TV.<br>
Mythweb reports: Error Unable to connect to the master backend at
192.168.63.3:6543.Is it running? This is the correct IP address.<br>
<br>
On 07/16/2016 04:48 PM, Steve Greene wrote:<br>
</div>
<blockquote
cite="mid:CAJMGAoksSf+2Ffpue0174PTLdsBD8VurJ9Npkyshs+yFXFNF7g@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
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 moz-do-not-send="true"
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
moz-do-not-send="true"
href="mailto:sgreene59@verizon.net"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:sgreene59@verizon.net">sgreene59@verizon.net</a></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
moz-do-not-send="true"
href="mailto:hikavdh@gmail.com"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:hikavdh@gmail.com">hikavdh@gmail.com</a></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
moz-do-not-send="true"
href="mailto:sgreene59@verizon.net"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:sgreene59@verizon.net">sgreene59@verizon.net</a></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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="mailto:mythtv-users@mythtv.org"
target="_blank">mythtv-users@mythtv.org</a><br>
<a moz-do-not-send="true"
href="http://lists.mythtv.org/mailman/listinfo/mythtv-users"
rel="noreferrer"
target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a moz-do-not-send="true"
href="http://wiki.mythtv.org/Mailing_List_etiquette"
rel="noreferrer"
target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a
moz-do-not-send="true"
href="https://forum.mythtv.org"
rel="noreferrer"
target="_blank"><a class="moz-txt-link-freetext" href="https://forum.mythtv.org">https://forum.mythtv.org</a></a><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
mythtv-users mailing list
<a moz-do-not-send="true" href="mailto:mythtv-users@mythtv.org" target="_blank">mythtv-users@mythtv.org</a>
<a moz-do-not-send="true" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a moz-do-not-send="true" href="http://wiki.mythtv.org/Mailing_List_etiquette" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a moz-do-not-send="true"
href="http://lists.mythtv.org/mailman/listinfo/mythtv-users"
rel="noreferrer" target="_blank">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<a moz-do-not-send="true"
href="http://wiki.mythtv.org/Mailing_List_etiquette"
rel="noreferrer" target="_blank">http://wiki.mythtv.org/Mailing_List_etiquette</a><br>
MythTV Forums: <a moz-do-not-send="true"
href="https://forum.mythtv.org" rel="noreferrer"
target="_blank">https://forum.mythtv.org</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
mythtv-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a>
<a class="moz-txt-link-freetext" href="http://lists.mythtv.org/mailman/listinfo/mythtv-users">http://lists.mythtv.org/mailman/listinfo/mythtv-users</a>
<a class="moz-txt-link-freetext" href="http://wiki.mythtv.org/Mailing_List_etiquette">http://wiki.mythtv.org/Mailing_List_etiquette</a>
MythTV Forums: <a class="moz-txt-link-freetext" href="https://forum.mythtv.org">https://forum.mythtv.org</a>
</pre>
</blockquote>
<p><br>
</p>
</body>
</html>