[mythtv-users] Remote frontend connection problems

glen glenb at glenb.net
Mon Oct 19 02:31:48 UTC 2020


On Sun, 2020-10-18 at 22:21 -0400, glen 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://email.mg.glenb.net/c/eJxNjkEOwiAURE9TdhJaoPAXLNx4jw98WhKopqCJt7caE01mM29mkokuJIxasew0Cp28mpMGafxoY5DGApClYFDZSUUYiTDygJXKoMRSaPN8o85WZ72ZhLIY1Kg8mAjg5QyACERGCsmKW3u_DfI8TJdDJbfeeH32tT_4dV8OVDGXits3zFu6vuGncbo32hvb3b89Hvz2L9GTQKs
> > http://email.mg.glenb.net/c/eJxFjcsOwiAURL-m7CRQoMCChRtX-g2Gx6Ul0qrtrca_l8SFk1mdzMkkF7NPSpLilGcqBzlkZYUO3KQotLEWDETtpellshzAJxr9DLWTbKywBLoAkslJoVoE7yPjmoU4KC1TD4NhLCjIiVQ3IT46cez6U-u73AqdPzjhi97XsZGLL7Us4_VcNrwClucOiEBW91sd9g3Wrb3-pS_LPjxM
> > MythTV Forums: http://email.mg.glenb.net/c/eJxFjMsKwyAQAL8m3irGR9w9eOil_6HrmhTyKGoK_fsGeijMZRiYHKjE7Kx4BheVK8lOxaHxaYRMxgMiA5OPFrTNODLHLCluvA5WzSvvSe7cxRKQ2FmNmhJblY3yGiZHkwYCjdF5sYal91cbzH3Qj4ty1HOT26cv_S2POosafnI7G9d27f_tC-Q-M7o
> 
> 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.%  
> 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://email.mg.glenb.net/c/eJxNjkEOwiAURE9TdhJaoPAXLNx4jw98WhKopqCJt7caE01mM29mkokuJIxasew0Cp28mpMGafxoY5DGApClYFDZSUUYiTDygJXKoMRSaPN8o85WZ72ZhLIY1Kg8mAjg5QyACERGCsmKW3u_DfI8TJdDJbfeeH32tT_4dV8OVDGXits3zFu6vuGncbo32hvb3b89Hvz2L9GTQKs
> http://email.mg.glenb.net/c/eJxFjcsOwiAURL-m7CRQoMCChRtX-g2Gx6Ul0qrtrca_l8SFk1mdzMkkF7NPSpLilGcqBzlkZYUO3KQotLEWDETtpellshzAJxr9DLWTbKywBLoAkslJoVoE7yPjmoU4KC1TD4NhLCjIiVQ3IT46cez6U-u73AqdPzjhi97XsZGLL7Us4_VcNrwClucOiEBW91sd9g3Wrb3-pS_LPjxM
> MythTV Forums: http://email.mg.glenb.net/c/eJxFjMsKwyAQAL8m3irGR9w9eOil_6HrmhTyKGoK_fsGeijMZRiYHKjE7Kx4BheVK8lOxaHxaYRMxgMiA5OPFrTNODLHLCluvA5WzSvvSe7cxRKQ2FmNmhJblY3yGiZHkwYCjdF5sYal91cbzH3Qj4ty1HOT26cv_S2POosafnI7G9d27f_tC-Q-M7o

also check under /etc/mysql/conf.d to see if there is a server.cnf
there. i use mariadb and that is how it is on my system (arch linux),
so if that file is there, that would be the place to set your bind-
address=  statement

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20201018/38a38fb5/attachment.htm>


More information about the mythtv-users mailing list