[mythtv-users] remote mythfrontend not connecting again

[James Abernathy]

On Sat, Feb 8, 2025 at 12:53 PM Monkey Pet <monkeypet at gmail.com> wrote:

>
>
> On Sat, Feb 8, 2025 at 9:42 AM James Abernathy <jfabernathy at gmail.com>
> wrote:
>
>> I know I've forgotten something stupid, but here's what happened.
>>
>> I rebuilt my production backend with the Debian 12 server and restored my
>> mythconverg database and all my recording files. It's running fine. I use
>> Leanfront on a FIreTV 4K Max stick so I know the backend is okay.
>>
>> The v35~Pre-master mythtv software was installed using mythtv-light per
>> the github readme. It was built with the default cmake.
>>
>> However on my LM22.1 laptop mythfrontend will not connect. That software
>> was installed via the ppa:mythbuntu/35
>>
>> I have the mariadb.conf.d files:
>>
>> $ cat mariadb.conf.d/80-mythtv.cnf
>>
>> [mysqld]
>> bind-address = *
>>
>
> Mine is empty, I thought it originally had 127.0.0.1 in it.
>
> Did you remember to grant access to the mythconverg tables to non
> localhost users?
>
> Also check that non firewall is running or your firewall is letting you
> access mysql from a remote host.
>
> Try mysql command on another  remote linux host to connect to it using the
> username and password.
>


So it was in the area of what was being searched in the /etc/mysql/
directory. It turns out that the logic to predict which bind-address will
be used is not based on what I consider as the order.  I have the correct
file called /etc/mysql/mariadb.conf.d/80-mythtv.cnf but somewhere else was
a bind-address=127.0.0.1 and after I commented all the bind-address
parameters out except the one in my correct file it worked.

Thanks for reminding me to check there.  I'm not sure why making my file
the last one in the list didn't override it.

JIm A
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20250208/3cc68700/attachment.htm>