[mythtvnz] IPAddress change

[Roger Searle]

Hi - I went through something similar and painful recently.  Took some 
hours to get to the bottom of it.

The route cause was that my backend was no longer listening on port 
6543.  "telnet <backend ip> 6543" from a frontend would not connect.  
"sudo netstat -nlp | grep 6543" on the backend did not show the host was 
listening.  The fix in the end for me was via Mythbuntu Control Centre, 
going to MySQL Config and enabling the "Master BAckend Role" (well, 
re-enabling it, because everything has worked perfectly before the IP 
address changes).

I found plenty of posts suggesting the cause of the issue related to the 
bind-address line in /etc/mysql/my.cnf however for me this did not 
provide the fix until I found the above. I have my line set to the 
backend IP address, NOT commented out, and from what I understand must 
not be set to localhost or 127.0.0.1.

Hope this is helpful
Roger

On 21/09/17 7:30 PM, Daniel Hughes wrote:
> I've had to change the IPAddress onp my mythtv box due to switching
> Internet providers and getting a new router on a different address
> range.
>
> I changed the IP Address in the front end and back end settings and general
>
> I also found the old address in /etc/mythtv/mysql.txt and changed it there.
>
> However my frontend still wont connect and my myth web displays an
> error showing it is still trying to use MySQL on the old address:
>
> Fatal Error
> !!NoTrans: Can't connect to MySQL server on '192.168.178.26' (4) [#2003]
>
> How do I convince mythtv to use the new address?
>
> _______________________________________________
> mythtvnz mailing list
> mythtvnz at lists.ourshack.com
> https://lists.ourshack.com/mailman/listinfo/mythtvnz
> Archives http://www.gossamer-threads.com/lists/mythtv/mythtvnz/