Mailing List Archive: what to setup bind-address to in mariadb system?

what to setup bind-address to in mariadb system?

Mar 16, 2023, 10:26 AM

Post #1 of 6 (295 views)

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.

Jim A

Re: what to setup bind-address to in mariadb system? [ In reply to ]

mikep at randomtraveller

Mar 16, 2023, 10:55 AM

Post #2 of 6 (295 views)

Permalink

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

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org

Re: what to setup bind-address to in mariadb system? [ In reply to ]

jfabernathy at gmail

Mar 16, 2023, 11:23 AM

Post #3 of 6 (295 views)

Permalink

On Thu, Mar 16, 2023 at 12:57?PM Mike Perkins <mikep@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

Re: what to setup bind-address to in mariadb system? [ In reply to ]

jfabernathy at gmail

Mar 16, 2023, 1:45 PM

Post #4 of 6 (294 views)

Permalink

On Thu, Mar 16, 2023 at 1:23?PM James Abernathy <jfabernathy@gmail.com>
wrote:

>
>
> On Thu, Mar 16, 2023 at 12:57?PM Mike Perkins <
> mikep@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

Re: what to setup bind-address to in mariadb system? [ In reply to ]

rcrernst at gmail

Mar 16, 2023, 2:05 PM

Post #5 of 6 (294 views)

Permalink

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

>
>
> On Thu, Mar 16, 2023 at 1:23?PM James Abernathy <jfabernathy@gmail.com>
> wrote:
>
>>
>>
>> On Thu, Mar 16, 2023 at 12:57?PM Mike Perkins <
>> mikep@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

Re: what to setup bind-address to in mariadb system? [ In reply to ]

jfabernathy at gmail

Mar 16, 2023, 4:34 PM

Post #6 of 6 (294 views)

Permalink

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

>
>
> On Thu, Mar 16, 2023 at 9:46?PM James Abernathy <jfabernathy@gmail.com>
> wrote:
>
>>
>>
>> On Thu, Mar 16, 2023 at 1:23?PM James Abernathy <jfabernathy@gmail.com>
>> wrote:
>>
>>>
>>>
>>> On Thu, Mar 16, 2023 at 12:57?PM Mike Perkins <
>>> mikep@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