[mythtv-users] what to setup bind-address to in mariadb system?

[Roland Ernst]

On Thu, Mar 16, 2023 at 9:46 PM James Abernathy <jfabernathy at gmail.com>
wrote:

>
>
> On Thu, Mar 16, 2023 at 1:23 PM James Abernathy <jfabernathy at gmail.com>
> wrote:
>
>>
>>
>> On Thu, Mar 16, 2023 at 12:57 PM Mike Perkins <
>> mikep at randomtraveller.org.uk> wrote:
>>
>>> On 16/03/2023 17:26, James Abernathy wrote:
>>> > I have a working Ubuntu 22.10 mythtv v33 system, but mythfrontend only
>>> > works locally. I can run Leanfront from a FireTV remotely, but not
>>> > mythfrontend on the same firetv stick.
>>> >
>>> > My /etc/mysql/conf.d/mythtv.cnf is
>>> > [mysqld]
>>> > #bind-address=::
>>> > max_connections=100
>>> >
>>> > When I remove the # from the bind-address statement as you do in mysql
>>> the
>>> > database fails to connect locally with the backend.  So there must be a
>>> > different way in mariaDB systems.
>>> >
>>> Same comment I just made to someone else: The mariadb config files
>>> override the mysql ones. Look for
>>> bind-address statements elsewhere in that tree.
>>>
>>> --
>>>
>>> Mike Perkins
>>>
>>
>> I can only find 2 bind-address statements in the searchable path.
>> one is
>> bind-address            = 127.0.0.1
>> with this explanation
>> # Instead of skip-networking the default is now to listen only on
>> # localhost which is more compatible and is not less secure.
>> bind-address            = 127.0.0.1
>>
>> in the mythtv.cnf there is another bind commented out:
>> #bind-address=::
>>
>> Removing that # make mythtv not work at all.
>>
>> So I'm lost.
>>
>> Jim A
>>
>
> I have tried using bind-address=0.0.0.0  everywhere I can find a
> bind-address statement. my mythtv-setup > General had the real IP of the
> backend and not 127.0.0.1.
>
> When I start up mythfrontend on the FireTV it can't find the database and
> if I select Search, it comes back with
> No UPnP backends found.
>
> Jim A
>
>
You look into the wrong path. For MariaDB, the path is
/etc/mysql/mariadb.conf.d

Create a file 80-mythtv.cnf under above path and add

# Additions form MythTV:
[mysqld]
bind-address=*
max_connections=100


Note the asterisk (*) is used for ipv4, the '::' is used for ipv6.
Creating an own file survives system updates.

Roland
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230316/db56c369/attachment-0001.htm>