[mythtv-users] remote mythfrontend not connecting again

[Monkey Pet]

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.



> max-connections = 100
>
>
> $ cat mariadb.conf.d/80-mythconverg.cnf
>
> # Disable Binary logging for the mythconverg database. Binary logging
> # for all databases was off by default prior to MySQL V8.
>
> [mysqld]
> binlog-ignore-db = mythconverg
>
> My config.xml is:
> <Configuration>
>   <LocalHostName>my-unique-identifier-goes-here</LocalHostName>
>   <Database>
>     <PingHost>false</PingHost>
>     <Host>192.168.68.40</Host>
>     <UserName>mythtv</UserName>
>     <Password>mythtv</Password>
>     <DatabaseName>mythconverg</DatabaseName>
>     <Port>3306</Port>
>   </Database>
>   <WakeOnLAN>
>     <Enabled>false</Enabled>
>     <SQLReconnectWaitTime>0</SQLReconnectWaitTime>
>     <SQLConnectRetry>5</SQLConnectRetry>
>     <Command>echo 'WOLsqlServerCommand not set'</Command>
>   </WakeOnLAN>
>   <UPnP>
>     <UDN>
>       <MediaRenderer>b2a70db5-92a8-46cc-9971-e65bceec4741</MediaRenderer>
>     </UDN>
>   </UPnP>
> </Configuration>
>
> I copied it from the backend where I can run mythfrontend I just put in
> the correct IP.
>
> I use the non unique password of mythtv,
>
> Any ideas where I screwed up?
>
> JIm A
>
>
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20250208/492f1b37/attachment.htm>