[mythtv-users] 0.28 upgrade issue frontend connection

Steve Greene sgreene59 at verizon.net
Sun Jul 17 01:21:40 UTC 2016


Have you checked to see if it requires firmware.

dmesg | grep firmware
>

Steve

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

> I can connect to mysql from the command line. I do not have any secondary
> backends, only a single frontend backend system.
> The front end can play recorded shows, but can't do live TV.
> 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.
>
>
> On 07/16/2016 04:48 PM, Steve Greene wrote:
>
> 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>
>> 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>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>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
>>
>>
>
>
> _______________________________________________
> 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
>
>
>
> _______________________________________________
> 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/6a92cb06/attachment.html>


More information about the mythtv-users mailing list