[mythtv-users] Ver 31 frontend cannot connect to the database

[Ram Ramesh]

On 11/22/20 6:53 PM, James Abernathy wrote:
>
>
> On Sun, Nov 22, 2020, 7:26 PM Mike Carron <jmcarron at gmx.com 
> <mailto:jmcarron at gmx.com>> wrote:
>
>     My backend host recently failed badly enough that I was not able
>     to salvage anything so I replaced the hardware and installed a new
>     Ubuntu 20.04 and a new v31 mythtv-backend-master with xmltv.
>
>     I then upgraded a remote frontend (Ubuntu 18.04) from MythTV 30 to
>     31 but that frontend will not connect to the database.
>
>     I've checked and rechecked the frontend setup screen and
>     everything is correct. The config.xml files for both look like
>     they should work. I've tried the backend config with </host> =
>     localhost and = 192.168.0.222 (the backend machine IP). The
>     frontend config host is 192.168.0.222.
>
>     I know the ip addresses are good. I can load 192.168.0.222:6544
>     <http://192.168.0.222:6544> into the address line of the Firefox
>     on the frontend machine and it finds the database immediately.
>
>     I'm no doubt missing something obvious but I can't find it. It
>     seems like I have worn out 2 search engines trying.
>
>     Suggestions?
>
>     mike
>
> Have you tried deleting the .mythtv/config.xml file on the FE? Then do 
> a search if the frontend does find it automatically
>
>
> _______________________________________________
> 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
Have you made sure that your mysql is setup to connect over ethernet?

Specifically have you commented out the line that looks like this (mine 
is debian buster and not xubuntu)

> mariadb.conf.d/50-server.cnf:# bind-address            = 127.0.0.1

Also, start up frontend on your backend machine and see if you can 
connect after setup to IP of the backend machine (instead of localhost)


Ramesh