[mythtv-users] 0.28 upgrade issue frontend connection

Sat Jul 16 23:48:14 UTC 2016

I'm probably in no position to give good advice.

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.

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.

Good luck!

Steve

On Sat, Jul 16, 2016 at 7:14 PM, Douglas Peale <Douglas_Peale at comcast.net>
wrote:

> 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.
> It looks like I do have a users table though.
> I'm running mint 18 Cinnamon and did a database restore. This has left me
> with liveTV not working, and mythweb not working.
> I posted on the forum, but so far it has been a monologue with no posts by
> anyone but me.
> https://forum.mythtv.org/viewtopic.php?f=36&t=151
> (skip down to July 9th to see the current issues and what I have tried)
>
>
> On 07/16/2016 03:43 PM, Steve Greene wrote:
>
> 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>
>> 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>
>>> 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
>>>
>>
>>
>
>
> _______________________________________________
> mythtv-users mailing listmythtv-users at mythtv.orghttp://lists.mythtv.org/mailman/listinfo/mythtv-usershttp://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
> I am hav
>
> _______________________________________________
> 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/5a6e7b9b/attachment-0001.html>