[mythtv-users] 0.28 upgrade issue frontend connection

Douglas Peale Douglas_Peale at comcast.net
Sun Jul 17 01:00:28 UTC 2016


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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 <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 <mailto: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 list
>>     mythtv-users at mythtv.org <mailto: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
>
>     I am hav
>
>
>     _______________________________________________
>     mythtv-users mailing list
>     mythtv-users at mythtv.org <mailto: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 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/b16d878e/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: OpenPGP digital signature
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20160716/b16d878e/attachment.sig>


More information about the mythtv-users mailing list