[mythtv-users] Remote frontend connection problems

[glen]

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/eJxNjksKwyAYhE8TdxWN74WLbHoPX38iqCnRFnr7pqXQwmzmmxmYaAO4KDjKNmoHLoHgioEIYIyWUSmtPFBIyQjPBJgoCQ6upjJxspbUPG5poM0aJgh13DMClHsFQQsJMwWqA6dGzqjYbYzbxJZpvp4quY-O63Ns44H3Yz1RdblU175hbrC_4adxufd0dHTYf3s--O1fD2RA2Q
> http://email.mg.glenb.net/c/eJxFjbsOgkAQRb-G7dwszj6g2MLGSr-B7GMGNgIqDBr_XhILk1udnJObfaKQjRbF5yZQQDLaAZlEbdvY7FzjItWE2JoIhtpslUxhwrHSqh9xjnJGFoM3pG0Dqc4Qgo5ANild2wjWgFYKQIx-YH5UcKqO533vcity-vDAL3lf-p1cQxnL3HeXsnKHXJ4bMqNY_M86bCsu6_76j74v0jy3
> MythTV Forums: 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.%  
try adding the bind address to my.cnf, and for me it always by making
it 0.0.0.0

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