[mythtv-users] Can't connect to remote backend database (again)
philledwards at gmail.com
Sat Aug 7 02:33:47 UTC 2021
> Leaving aside the possible Chromecast issues, it sounds more like a
> configuration problem on the *server*.
> The server machine MUST HAVE:
> bind-address= 0.0.0.0
> #skip-networking in thr my.cnf config.(That is, the skip-networking line
> must be commented OUT.)
> If bind-address is set to 127.0.0.1 then mysql/mariadb will NOT listen
> to anything external. Similarly with skip-networking which when active
> does exactly that.
> Since this is a Chromecast device which (surprising to me) seems not to
> allow ssh, then I can only suggest that you beg, borrow, steal a laptop
> and try ssh into the server from it. So long as your bbs laptop is on
> the same network sub-net (192.168.1...etc.) you should be able to launch
> a mysql client on it (presuming mysql is installed of course!).
> And try the login commands which you grants have set up on the server.
> If the laptop is set to a different IP address you will at least get an
> error message, proving that there is communication between the mysql
> client and the mysql server.
Thank you for these suggestions. I've got lots of PCs and virtual machines
around the place so I can have a crack at this. I'm pretty sure it's not an
issue with the MythBackend server config, or the subnet because I have a
linux PC on the same subnet running MythFrontend which works fine. Inspired
by your suggestions I think I'll reconfigure a linux frontend to have the
same IP address as the Chromecast device and see if it can connect. That
should give me some pointers.
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the mythtv-users