[mythtv-users] 0.28 upgrade issue frontend connection

[Steve Greene]

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.

I'd probably stay with Mint 17.3 if I could get it to play nicely with all
my new Skylake goodies!

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!

Steve

On Sat, Jul 16, 2016 at 6:07 PM, Steve Greene <sgreene59 at verizon.net> wrote:

> mysql> SELECT user, host from user;
>> +------------------+-------------+
>> | user             | host        |
>> +------------------+-------------+
>> | mythtv           | %           |
>> | mythtv           | 192.168.1.2 |
>> | mythtv           | bilbo.home  |
>> | debian-sys-maint | localhost   |
>> | mysql.sys        | localhost   |
>> | root             | localhost   |
>> +------------------+-------------+
>>
>
> Shouldn't this cover all the locations?
>
>
> This is super-frustrating, I always expect that a database restore from a
> working setup should "just work". It never does.
>
> 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.
>
> Steve
>
> On Sat, Jul 16, 2016 at 5:42 PM, Hika van den Hoven <hikavdh at gmail.com>
> wrote:
>
>> Hoi Steve,
>>
>> Saturday, July 16, 2016, 11:30:57 PM, you wrote:
>>
>> > I thought that was what mythtv.cnf was for, which I've set to my
>> > local ip.  I just tried setting mysqld.cnf
>> > "bind-address=my_ip_address"  and it hasn't worked.
>>
>> > I can still manually call up mysql -umyth  -p, but mysql
>> > -h192.168.1.x -umyth -p gives me ERROR 1045 (28000):  Access denied
>> > for user 'mythtv'@'my_hostname' (using password: YES).
>> > Incidentally, same with the root mysql account. I can connect from
>> > my secondary backend via the ip address. It just won't accept an
>> > login via the IP address local to the server.
>>
>> > Steve
>>
>> > On Sat, Jul 16, 2016 at 3:27 PM, Steve Greene <sgreene59 at verizon.net>
>> wrote:
>>
>> > Since upgrading to 0.28 and Mint 18, my local frontend connects to
>> > "localhost" but not the IP address of the MBE (which is local).
>>
>> > mysql -h"my_IP_ADDR" -u myth -p will fail, but mysql -umythtv -p
>> > will connect. Do I have to add the IP address to one of the tables in
>> mythconverg?
>>
>> > Thanks in advance for your assistance.
>>
>> > Steve
>> >
>>
>> Have you setup a user for that location in mysql. You have to setup
>> the user/password for the locations from where you want to have
>> access. So localhost or an IP address or % for all machines.
>>
>> Tot mails,
>>   Hika                            mailto:hikavdh at gmail.com
>>
>> "Zonder hoop kun je niet leven
>> Zonder leven is er geen hoop
>> Het eeuwige dilemma
>> Zeker als je hoop moet vernietigen om te kunnen overleven!"
>>
>> De lerende Mens
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
>> http://wiki.mythtv.org/Mailing_List_etiquette
>> MythTV Forums: https://forum.mythtv.org
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160716/8031a7af/attachment.html>