<div dir="ltr"><div>Thanks for your notes, Stephen. This largely worked with my original issue. For those of you working with mysql-server-5.7, avoid the set of mysql tweaks offered in the mythbuntu repos: mythbuntu-tweaks.cnf. This may be a similar issue to that <a href="https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1571865">reported</a> in the Ubuntu release notes. I haven't worked through line by line to see what the issue is.<br><br></div>What works with 0.28:<br><ul><li>frontend connections (now)!</li><li>mythweb</li><li>livetv</li><li>tuners on the master backend</li></ul><p>What doesn't:</p><ul><li>Tuners on the secondary backend show status: "is unavailable"</li><li>Recordings on the secondary from those tuners.</li></ul><p>Still some work to do...</p><p>Steve<br></p></div><div class="gmail_extra"><br><div class="gmail_quote">On Sat, Jul 16, 2016 at 10:16 PM, Stephen Worthington <span dir="ltr"><<a href="mailto:stephen_agent@jsw.gen.nz" target="_blank">stephen_agent@jsw.gen.nz</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On Sat, 16 Jul 2016 18:07:20 -0400, you wrote:<br>
<br>
>On Sat, Jul 16, 2016 at 5:42 PM, Hika van den Hoven <<a href="mailto:hikavdh@gmail.com">hikavdh@gmail.com</a>><br>
>wrote:<br>
><br>
>> Hoi Steve,<br>
>><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">sgreene59@verizon.net</a>><br>
>> 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<br>
>> mythconverg?<br>
>><br>
>> > Thanks in advance for your assistance.<br>
>><br>
>> > Steve<br>
>> ><br>
>><br>
>> 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>
>><br>
>> 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>
>><br>
><br>
>Shouldn't this cover all the locations?<br>
><br>
><br>
>This is super-frustrating, I always expect that a database restore from a<br>
>working setup should "just work". It never does.<br>
><br>
>How do I turn on more helpful debugging messages? /var/log/mysql/error.log<br>
>gives me nothing more than what I've seen from command-line login attempts.<br>
><br>
>Steve<br>
<br>
</div></div>The database you are backing up and restoring is "mythconverg". The<br>
database that the user table is in is "mysql", so it is not part of<br>
the mythconverg database and is not backed up and restored. Hence<br>
your problem when restoring mythconverg into a completely new mysql<br>
system. If you upgrade the system in place, the mysql database is<br>
preserved and these problems do not happen.<br>
<br>
Not only do the correct users need to be set created, they also need<br>
to have the correct access rights set up. So the appropriate mysql<br>
"grant" commands also need to have been done for each user. See<br>
<br>
<a href="https://www.mythtv.org/wiki/Database_Setup" rel="noreferrer" target="_blank">https://www.mythtv.org/wiki/Database_Setup</a><br>
<br>
in the section "Modifying access to the MySQL database for multiple<br>
systems" for how to do that. So you may need to run these commands:<br>
<br>
grant all on mythconverg.* to mythtv@"%" identified by "mythtv";<br>
flush privileges;<br>
<br>
or something like. Since you did not post the exact error message you<br>
are getting, it is impossible to say for sure.<br>
<br>
Also, now that you have multiple config files for mysql, you have to<br>
remember that they are loaded in order and config in one file will be<br>
overridden by config in a file that is loaded later. So you need to<br>
grep the entire /etc/mysql and all its subdirectories for the<br>
bindaddress option and make sure that they are all commented out, or<br>
create or find the last file with one in it and set it to the right<br>
value. In my case (Mythbuntu 14.04), I have created a<br>
/etc/mysql/conf.d/mythtv-tweaks-jsw.cnf file which is always the last<br>
one loaded and put my mysql setup tweaks in there. That includes a<br>
"bindaddress=0.0.0.0" line. Different distros have different setups<br>
for how they load the config files, so you may have to look at the<br>
config file that is loaded first by mysql (normally /etc/mysql/my.cnf)<br>
for the "!include" lines and then follow the include setup from there<br>
to figure out what order the config files are loaded in. When a<br>
config directory is !included, all the files in that directory are<br>
loaded in alphanumeric order by filename. If any of those files have<br>
!include lines, those are executed (and the specified files loaded) as<br>
those lines are read.<br>
<div class="HOEnZb"><div class="h5">_______________________________________________<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>
</div></div></blockquote></div><br></div>