[mythtv-users] Remote frontend connection problems

[Mary Strimel]

Thank you.


> *make sure the port is open, no firewall blocking it, or if firewall open
> the port.*
> *on the mysql privleges try : GRANT ALL ON mythconverg.*
> TO mythtv at 192.168.1.% <mythtv at localhost>  **try adding the bind address
> to my.cnf, and for me it always by making it 0.0.0.0*


It was not the firewall, but I tried your next suggestion about the GRANT
ALL command, restarted mysql with "sudo service mysql restart" and now it
works.
I'm not familiar with mariadb as i last used myth about 10 years ago.  But
given that restarting mysql helped, I guess that must be what my system is
using.

Thank you Glenb and everyone for your help!


On Sun, Oct 18, 2020 at 10:23 PM glen <glenb at glenb.net> wrote:

> On Sun, 2020-10-18 at 21:38 -0400, Mary Strimel wrote:
>
> hi,
> I have freshly installed mythtv system on my Linux Mint PC. I installed
> the available packages from my distro, myth version 31.
>
> The local frontend works fine. However, the frontend that I installed on
> my Android TV -- also version 31 -- is unable to connect. At first it saw
> the database and was unable to connect to it. After trying some of the
> fixes I read about online, now it doesn't see the database at all.
>
> Here are the things I've tried:
> 1. went to mythbackend-setup and set the IP address to my real address
> instead of 127.0.0.1
> 2. verified that the PIN for remote logon is set to 0000
> 3. verified that the mysql password on the Android is the same as the one
> found in /home/mythtv/.mythtv/config.xml
> 4. Attempted to tell sql to allow the remote connection.
>   A. At first I used the command
> "grant all on mythconverg.* to 'mythtv'@'%' identified by 'mypassword';"
>
> then I got an error because apparently that command is now deprecated.
>
> B. So I tried GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED
> BY "mythtv" PASSWORD "mypassword" which did not report an error, but also
> didn't give any feedback. In fact it made the mysql prompt look funny, so
> I'm assuming it was unhelpful?
>
> 5. I then went to /etc/mysql/my.cnf. According to the docs I should be
> commenting out a particular line regarding networking. However, my file
> didn't have those lines. It did not have sections either, like other
> peoples' seem to have. It just had two lines that start with "!includedir".
> I didn't change anything there.
>
> 6. As a last resort I went to /etc/mysql/conf.d/mythtv.cnf and changed the
> first line to "bind-address=192.168.1.253" [my IP].  I think this last step
> might have been wrong.
>
> What else do I need to do to connect my frontend? Should I undo things I
> tried above?
> Thank you!
> Mary
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> <http://email.mg.glenb.net/c/eJxNjksKwyAYhE8TdxWN74WLbHoPX38iqCnRFnr7pqXQwmzmmxmYaAO4KDjKNmoHLoHgioEIYIyWUSmtPFBIyQjPBJgoCQ6upjJxspbUPG5poM0aJgh13DMClHsFQQsJMwWqA6dGzqjYbYzbxJZpvp4quY-O63Ns44H3Yz1RdblU175hbrC_4adxufd0dHTYf3s--O1fD2RA2Q>
> http://wiki.mythtv.org/Mailing_List_etiquette
> <http://email.mg.glenb.net/c/eJxFjbsOgkAQRb-G7dwszj6g2MLGSr-B7GMGNgIqDBr_XhILk1udnJObfaKQjRbF5yZQQDLaAZlEbdvY7FzjItWE2JoIhtpslUxhwrHSqh9xjnJGFoM3pG0Dqc4Qgo5ANild2wjWgFYKQIx-YH5UcKqO533vcity-vDAL3lf-p1cQxnL3HeXsnKHXJ4bMqNY_M86bCsu6_76j74v0jy3>
> MythTV Forums: https://forum.mythtv.org
> <http://email.mg.glenb.net/c/eJxFjMsKwyAQAL8m3ipG3bgePPTS_9DsblLIoxhT6N830ENhLsPAUBolE3j1TIRZMgv44ARGiREHCgFDkV6YIxQHEmkweswrL50308Jb0Rs3NSdGjoyWojEswZkCxg3WIWC01HtWS5pbex2du3f2cSF7PVe9ftrc3nqvk6rpJ7fz4Hpc-3_7AjG_NC8>
>
>
> make sure the port is open, no firewall blocking it, or if firewall open
> the port.
> on the mysql privleges try : GRANT ALL ON mythconverg.* TO
> mythtv at 192.168.1.% <mythtv at localhost>
> try adding the bind address to my.cnf, and for me it always by making it
> 0.0.0.0
>
> _______________________________________________
> 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/20201019/0bb60879/attachment.htm>