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

[James Abernathy]

On Thu, Mar 16, 2023 at 4:06 PM Roland Ernst <rcrernst at gmail.com> wrote:

>
>
> 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
>

Thanks, that allowed me to manually setup the IP and mythconverg username
and password and get mythfrontend for FireTV working.

I used to be about to do Search for backends, but UPnP doesn't seem to be
configured in the default ubuntu fixes/33?

Jim A
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20230316/73a99c08/attachment.htm>