Mailing List Archive

mythtv v29 can't connect remote frontend
Need some quick help here.  I got all my recordings and database
restored on a new V29 backend.  I can use ssh -X to run the mythtv-setup
and make sure thinks are working.  Same thing for mythfrontend.

The problem is when I try to install v29 mythtv-frontend on a remote FE.
It can't find the database.  during install I selected allow remote FEs
and it commented out the bind statement as expected.

I just can't see what I'm missing.  I have the config.xml in .mythtv and
in /etc/mythtv/ symbolically linked.

???

Jim A


_______________________________________________
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: mythtv v29 can't connect remote frontend [ In reply to ]
On Mon, 2018-01-08 at 21:36 +0000, Jim Abernathy wrote:
> Need some quick help here. I got all my recordings and database
> restored on a new V29 backend. I can use ssh -X to run the mythtv-
> setup
> and make sure thinks are working. Same thing for mythfrontend.
>
> The problem is when I try to install v29 mythtv-frontend on a remote
> FE.
> It can't find the database. during install I selected allow remote
> FEs
> and it commented out the bind statement as expected.
>
> I just can't see what I'm missing. I have the config.xml in .mythtv
> and
> in /etc/mythtv/ symbolically linked.

Did your distro install a firewall on the backend? Mysql/mariadb needs
port 3306 open, and mythtv needs ports 6543/6544/6549/6554 open.

David

_______________________________________________
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: mythtv v29 can't connect remote frontend [ In reply to ]
> On Jan 8, 2018, at 5:07 PM, David Hampton <mythtv@love2code.net> wrote:
>
> On Mon, 2018-01-08 at 21:36 +0000, Jim Abernathy wrote:
>> Need some quick help here. I got all my recordings and database
>> restored on a new V29 backend. I can use ssh -X to run the mythtv-
>> setup
>> and make sure thinks are working. Same thing for mythfrontend.
>>
>> The problem is when I try to install v29 mythtv-frontend on a remote
>> FE.
>> It can't find the database. during install I selected allow remote
>> FEs
>> and it commented out the bind statement as expected.
>>
>> I just can't see what I'm missing. I have the config.xml in .mythtv
>> and
>> in /etc/mythtv/ symbolically linked.
>
> Did your distro install a firewall on the backend? Mysql/mariadb needs
> port 3306 open, and mythtv needs ports 6543/6544/6549/6554 open.
>
> David
>

My backend distro is Ubuntu 16.04 Server, so I don’t know about firewall. I do know that I installed Kodi and Kodi-pvr-mythtv on my frontends and they connected to the backend without a change except for the new IP address of the new backend. TV is playing find with Kodi.

We just prefer mythfrontend.

I’ll look into the firewall issues

Jim A

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

_______________________________________________
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: mythtv v29 can't connect remote frontend [ In reply to ]
On 01/08/2018 05:41 PM, Jim Abernathy wrote:
> We just prefer mythfrontend.

Check you mysql bind-address line.

I usually have to change it from localhost or 127.0.0.1 to 0.0.0.0
(Listen on all addresses)

You can find it in

/etc/mysql/mysql.conf.d/mysqld.conf

If you have to change it, make sure to restart mysql

Doug
Re: mythtv v29 can't connect remote frontend [ In reply to ]
On Jan 8, 2018, at 5:55 PM, Doug Lytle <support@drdos.info<mailto:support@drdos.info>> wrote:

On 01/08/2018 05:41 PM, Jim Abernathy wrote:

We just prefer mythfrontend.

Check you mysql bind-address line.

I usually have to change it from localhost or 127.0.0.1 to 0.0.0.0 (Listen on all addresses)

You can find it in

/etc/mysql/mysql.conf.d/mysqld.conf

If you have to change it, make sure to restart mysql

Doug
_____________

In /etc/mysql/conf.d/mythtv.conf file I have #bind-address=:: It was installed by mythtv installation.

I’ll test with bind 0.0.0.0

Jim A

__________________________________
mythtv-users mailing list
mythtv-users@mythtv.org<mailto: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: mythtv v29 can't connect remote frontend [ In reply to ]
On Jan 8, 2018, at 6:02 PM, Jim Abernathy <jfabernathy@outlook.com<mailto:jfabernathy@outlook.com>> wrote:



On Jan 8, 2018, at 5:55 PM, Doug Lytle <support@drdos.info<mailto:support@drdos.info>> wrote:

On 01/08/2018 05:41 PM, Jim Abernathy wrote:

We just prefer mythfrontend.

Check you mysql bind-address line.

I usually have to change it from localhost or 127.0.0.1 to 0.0.0.0 (Listen on all addresses)

You can find it in

/etc/mysql/mysql.conf.d/mysqld.conf

If you have to change it, make sure to restart mysql

Doug
_____________

In /etc/mysql/conf.d/mythtv.conf file I have #bind-address=:: It was installed by mythtv installation.

I’ll test with bind 0.0.0.0

Jim A


bind 0.0.0.0 made no difference. I’ll have to use Kodi until I get this fixed

Jim A


__________________________________
mythtv-users mailing list
mythtv-users@mythtv.org<mailto: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<https://forum.mythtv.org/>

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org<mailto: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<https://forum.mythtv.org/>
Re: mythtv v29 can't connect remote frontend [ In reply to ]
On 01/08/2018 05:19 PM, Jim Abernathy wrote:
>
> bind 0.0.0.0 made no difference. I’ll have to use Kodi until I get this fixed

It's: bind-address=:: for mine. The :: works for IPv4 and IPv6.
Or, 0.0.0.0 works for IPv4 only.

--
Bill
_______________________________________________
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: mythtv v29 can't connect remote frontend [ In reply to ]
On Jan 8, 2018, at 5:07 PM, David Hampton <mythtv@love2code.net<mailto:mythtv@love2code.net>> wrote:

On Mon, 2018-01-08 at 21:36 +0000, Jim Abernathy wrote:
Need some quick help here. I got all my recordings and database
restored on a new V29 backend. I can use ssh -X to run the mythtv-
setup
and make sure thinks are working. Same thing for mythfrontend.

The problem is when I try to install v29 mythtv-frontend on a remote
FE.
It can't find the database. during install I selected allow remote
FEs
and it commented out the bind statement as expected.

I just can't see what I'm missing. I have the config.xml in .mythtv
and
in /etc/mythtv/ symbolically linked.

Did your distro install a firewall on the backend? Mysql/mariadb needs
port 3306 open, and mythtv needs ports 6543/6544/6549/6554 open.


on my server I did the command

netstat -ntlp | grep LISTEN

tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:139 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:6543 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:6544 0.0.0.0:* LISTEN -
tcp 0 0 0.0.0.0:6549 0.0.0.0:* LISTEN -

I’m concerned about the 127.0.0.1:3306. I’m not a firewall expert, but that looks like 3306 is localhost only.

Jim A

David

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org<mailto: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: mythtv v29 can't connect remote frontend [ In reply to ]
On 01/08/2018 05:46 PM, Jim Abernathy wrote:
> I’m concerned about the 127.0.0.1:3306. I’m not a firewall expert, but that looks like 3306 is localhost only.

Probably because in /etc/mysql/my.cnf (or wherever yours is) bind-addres = 127.0.0.1
is set. Override it as mentioned before and restart mysql.

--
Bill
_______________________________________________
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: mythtv v29 can't connect remote frontend [ In reply to ]
On 01/08/2018 07:09 PM, Bill Meek wrote:
> On 01/08/2018 05:46 PM, Jim Abernathy wrote:
>> I’m concerned about the 127.0.0.1:3306. I’m not a firewall expert,
>> but that looks like 3306 is localhost only.
>
> Probably because in /etc/mysql/my.cnf (or wherever yours is)
> bind-addres = 127.0.0.1
> is set. Override it as mentioned before and restart mysql.
>
In my mythtv v29 installed mariadb and put a file called mythtv.cnf in
/etc/mysql/conf.d.  That file only had:
[mysqld]
#bind-address=::
max_connections=100

I answered the install question that asked about remote frontends and I
said yes, which I figure is what put in the # in front of the bind
statement.

I even looked at the grant all permissions in mysql database but that
didn't help either.

This was a no brainer back with v0.28, but remote frontends on v29 I
can't get working.  local in fine (I tested in a VM) but no luck otherwise.

Jim A

_______________________________________________
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: mythtv v29 can't connect remote frontend [ In reply to ]
On 01/08/2018 06:40 PM, Jim Abernathy wrote:

...

> In my mythtv v29 installed mariadb and put a file called mythtv.cnf in
> /etc/mysql/conf.d.  That file only had:
> [mysqld]
> #bind-address=::
> max_connections=100

Right, mariadb is a bit different. Edit the file above and uncomment
the bind-address line.

Or, if you want to follow things you'll see the 2 includes
below and that's the order they're read. You have to read
each file in each directory to really see what's happening.

cat /etc/mysql/my.cnf

...

# Import all .cnf files from configuration directory
!includedir /etc/mysql/conf.d/.
!includedir /etc/mysql/mariadb.conf.d/

cat /etc/mysql/mariadb.conf.d/mythtv.cnf
[mysqld]
bind-address=::
max_connections = 100
table_open_cache = 128

--
Bill
_______________________________________________
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: mythtv v29 can't connect remote frontend [ In reply to ]
On 01/08/2018 07:51 PM, Bill Meek wrote:
> On 01/08/2018 06:40 PM, Jim Abernathy wrote:
>
> ...
>
>> In my mythtv v29 installed mariadb and put a file called mythtv.cnf in
>> /etc/mysql/conf.d.  That file only had:
>> [mysqld]
>> #bind-address=::
>> max_connections=100
>
> Right, mariadb is a bit different. Edit the file above and uncomment
> the bind-address line.
>
> Or, if you want to follow things you'll see the 2 includes
> below and that's the order they're read. You have to read
> each file in each directory to really see what's happening.
>
> cat /etc/mysql/my.cnf
>
> ...
>
> # Import all .cnf files from configuration directory
> !includedir /etc/mysql/conf.d/.
> !includedir /etc/mysql/mariadb.conf.d/
>
> cat /etc/mysql/mariadb.conf.d/mythtv.cnf
> [mysqld]
> bind-address=::
> max_connections = 100
> table_open_cache = 128
>
so I made my mythtv.cnf have the bind-address=:: and restarted mysql.
but no change.  I even uninstalled mythtv-frontend and reinstalled.

I think it can't build the config.xml files because it can't open the
database for the mythtv BE it found via  UPNP.  seems that's what it's
saying the --verbose console

Jim A

_______________________________________________
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: mythtv v29 can't connect remote frontend [ In reply to ]
On 01/08/2018 08:08 PM, Jim Abernathy wrote:
>
> On 01/08/2018 07:51 PM, Bill Meek wrote:
>> On 01/08/2018 06:40 PM, Jim Abernathy wrote:
>>
>> ...
>>
>>> In my mythtv v29 installed mariadb and put a file called mythtv.cnf in
>>> /etc/mysql/conf.d.  That file only had:
>>> [mysqld]
>>> #bind-address=::
>>> max_connections=100
>> Right, mariadb is a bit different. Edit the file above and uncomment
>> the bind-address line.
>>
>> Or, if you want to follow things you'll see the 2 includes
>> below and that's the order they're read. You have to read
>> each file in each directory to really see what's happening.
>>
>> cat /etc/mysql/my.cnf
>>
>> ...
>>
>> # Import all .cnf files from configuration directory
>> !includedir /etc/mysql/conf.d/.
>> !includedir /etc/mysql/mariadb.conf.d/
>>
>> cat /etc/mysql/mariadb.conf.d/mythtv.cnf
>> [mysqld]
>> bind-address=::
>> max_connections = 100
>> table_open_cache = 128
>>
> so I made my mythtv.cnf have the bind-address=:: and restarted mysql.
> but no change.  I even uninstalled mythtv-frontend and reinstalled.
>
> I think it can't build the config.xml files because it can't open the
> database for the mythtv BE it found via  UPNP.  seems that's what it's
> saying the --verbose console
>
> Jim A
some of the log
2018-01-08 20:15:04.948759 E  [DBManager0] Unable to connect to database!
2018-01-08 20:15:04.948770 E  Driver error was [1/2003]:
QMYSQL: Unable to connect
Database error was:
Can't connect to MySQL server on '192.168.0.250' (111)

2018-01-08 20:15:04.957303 E  MythFontProperties: Failed to load 'Droid
Sans', got 'DejaVu Sans' instead
            Location:
/usr/share/mythtv/themes/MythCenter-wide/keyboard/keyboard.xml @ 7
            Name: 'key'    Type: 'fontdef'
2018-01-08 20:15:04.996621 N  Loading definitions from:
/usr/share/mythtv/themes/default/keyboard/en_us.xml
2018-01-08 20:15:17.342719 I  Start up testing connections. DB
192.168.0.250, BE , attempt 0, status dbAwake
2018-01-08 20:15:18.344088 I  Start up testing connections. DB
192.168.0.250, BE , attempt 1, status dbAwake
2018-01-08 20:15:23.439495 I  Start up testing connections. DB
192.168.0.250, BE , attempt 2, status dbAwake
2018-01-08 20:15:25.950128 I  Start up failure. host 192.168.0.250,
status dbAwakeFail
2018-01-08 20:15:25.950146 A  Cannot login to database
2018-01-08 20:15:25.950153 E  Error: Cannot login to database
2018-01-08 20:15:25.951272 I  Putting up the UPnP backend chooser
2018-01-08 20:15:28.648077 I  Start up testing connections. DB
192.168.0.250, BE , attempt 0, status dbAwake
2018-01-08 20:15:29.659073 I  Start up testing connections. DB
192.168.0.250, BE , attempt 1, status dbAwake
2018-01-08 20:15:34.794192 I  Start up failure. host 192.168.0.250,
status dbAwakeFail
2018-01-08 20:15:34.794216 A  Cannot login to database

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

_______________________________________________
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: mythtv v29 can't connect remote frontend [ In reply to ]
On 9 January 2018 at 11:08, Jim Abernathy <jfabernathy@outlook.com> wrote:

>
>
> On 01/08/2018 07:51 PM, Bill Meek wrote:
> > On 01/08/2018 06:40 PM, Jim Abernathy wrote:
> >
> > ...
> >
> >> In my mythtv v29 installed mariadb and put a file called mythtv.cnf in
> >> /etc/mysql/conf.d. That file only had:
> >> [mysqld]
> >> #bind-address=::
> >> max_connections=100
> >
> > Right, mariadb is a bit different. Edit the file above and uncomment
> > the bind-address line.
> >
> > Or, if you want to follow things you'll see the 2 includes
> > below and that's the order they're read. You have to read
> > each file in each directory to really see what's happening.
> >
> > cat /etc/mysql/my.cnf
> >
> > ...
> >
> > # Import all .cnf files from configuration directory
> > !includedir /etc/mysql/conf.d/.
> > !includedir /etc/mysql/mariadb.conf.d/
> >
> > cat /etc/mysql/mariadb.conf.d/mythtv.cnf
> > [mysqld]
> > bind-address=::
> > max_connections = 100
> > table_open_cache = 128
> >
> so I made my mythtv.cnf have the bind-address=:: and restarted mysql.
> but no change. I even uninstalled mythtv-frontend and reinstalled.
>
> I think it can't build the config.xml files because it can't open the
> database for the mythtv BE it found via UPNP. seems that's what it's
> saying the --verbose console
>
> Jim A
>
>
I'm assuming you have rebooted after the v29 upgrade?

As per my post https://lists.gt.net/mythtv/users/613497

I had to enable "Allow Connections from all Subnets" even though the
frontends were on the same subnet

https://www.mythtv.org/wiki/Setup_General#Host_Address_Backend_Setup_.28v29.29


I haven't tried removing this setting after the initial reboot

Cheers,

Anthony
Re: mythtv v29 can't connect remote frontend [ In reply to ]
I'm assuming you have rebooted after the v29 upgrade?

As per my post https://lists.gt.net/mythtv/users/613497

I had to enable "Allow Connections from all Subnets" even though the frontends were on the same subnet

https://www.mythtv.org/wiki/Setup_General#Host_Address_Backend_Setup_.28v29.29

I haven't tried removing this setting after the initial reboot

Cheers,

Anthony


rebooted FE and BE multiple times. I just setup Allow Connections from all Subnets and rebooted. No change. Can't get FE to connect to DB but Kodi still works on live tv and recorded tv

Jim A



_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org<mailto: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: mythtv v29 can't connect remote frontend [ In reply to ]
On 9 January 2018 at 11:17, Jim Abernathy <jfabernathy@outlook.com> wrote:

>
>
> On 01/08/2018 08:08 PM, Jim Abernathy wrote:
> >
> > On 01/08/2018 07:51 PM, Bill Meek wrote:
> >> On 01/08/2018 06:40 PM, Jim Abernathy wrote:
> >>
> >> ...
> >>
> >>> In my mythtv v29 installed mariadb and put a file called mythtv.cnf in
> >>> /etc/mysql/conf.d. That file only had:
> >>> [mysqld]
> >>> #bind-address=::
> >>> max_connections=100
> >> Right, mariadb is a bit different. Edit the file above and uncomment
> >> the bind-address line.
> >>
> >> Or, if you want to follow things you'll see the 2 includes
> >> below and that's the order they're read. You have to read
> >> each file in each directory to really see what's happening.
> >>
> >> cat /etc/mysql/my.cnf
> >>
> >> ...
> >>
> >> # Import all .cnf files from configuration directory
> >> !includedir /etc/mysql/conf.d/.
> >> !includedir /etc/mysql/mariadb.conf.d/
> >>
> >> cat /etc/mysql/mariadb.conf.d/mythtv.cnf
> >> [mysqld]
> >> bind-address=::
> >> max_connections = 100
> >> table_open_cache = 128
> >>
> > so I made my mythtv.cnf have the bind-address=:: and restarted mysql.
> > but no change. I even uninstalled mythtv-frontend and reinstalled.
> >
> > I think it can't build the config.xml files because it can't open the
> > database for the mythtv BE it found via UPNP. seems that's what it's
> > saying the --verbose console
> >
> > Jim A
> some of the log
> 2018-01-08 20:15:04.948759 E [DBManager0] Unable to connect to database!
> 2018-01-08 20:15:04.948770 E Driver error was [1/2003]:
> QMYSQL: Unable to connect
> Database error was:
> Can't connect to MySQL server on '192.168.0.250' (111)
>
> 2018-01-08 20:15:04.957303 E MythFontProperties: Failed to load 'Droid
> Sans', got 'DejaVu Sans' instead
> Location:
> /usr/share/mythtv/themes/MythCenter-wide/keyboard/keyboard.xml @ 7
> Name: 'key' Type: 'fontdef'
> 2018-01-08 20:15:04.996621 N Loading definitions from:
> /usr/share/mythtv/themes/default/keyboard/en_us.xml
> 2018-01-08 20:15:17.342719 I Start up testing connections. DB
> 192.168.0.250, BE , attempt 0, status dbAwake
> 2018-01-08 20:15:18.344088 I Start up testing connections. DB
> 192.168.0.250, BE , attempt 1, status dbAwake
> 2018-01-08 20:15:23.439495 I Start up testing connections. DB
> 192.168.0.250, BE , attempt 2, status dbAwake
> 2018-01-08 20:15:25.950128 I Start up failure. host 192.168.0.250,
> status dbAwakeFail
> 2018-01-08 20:15:25.950146 A Cannot login to database
> 2018-01-08 20:15:25.950153 E Error: Cannot login to database
> 2018-01-08 20:15:25.951272 I Putting up the UPnP backend chooser
> 2018-01-08 20:15:28.648077 I Start up testing connections. DB
> 192.168.0.250, BE , attempt 0, status dbAwake
> 2018-01-08 20:15:29.659073 I Start up testing connections. DB
> 192.168.0.250, BE , attempt 1, status dbAwake
> 2018-01-08 20:15:34.794192 I Start up failure. host 192.168.0.250,
> status dbAwakeFail
> 2018-01-08 20:15:34.794216 A Cannot login to database
>
>
Perhaps mysql permissions? you can test from your frontend

mysql -h192.168.0.250 -umythtv -p<YourPassword>

if you need to add permissions check out the below

https://www.mythtv.org/wiki/Database_Setup#Modifying_access_to_the_MySQL_database_for_multiple_systems

Cheers,

Anthony
Re: mythtv v29 can't connect remote frontend [ In reply to ]
On Mon, Jan 8, 2018 at 7:38 PM, Jim Abernathy <jfabernathy@outlook.com>
wrote:

>
>
> I'm assuming you have rebooted after the v29 upgrade?
>
> As per my post https://lists.gt.net/mythtv/users/613497
>
> I had to enable "Allow Connections from all Subnets" even though the
> frontends were on the same subnet
>
> https://www.mythtv.org/wiki/Setup_General#Host_Address_
> Backend_Setup_.28v29.29
>
> I haven't tried removing this setting after the initial reboot
>
> Cheers,
>
> Anthony
>
>
> rebooted FE and BE multiple times. I just setup Allow Connections from all
> Subnets and rebooted. No change. Can't get FE to connect to DB but Kodi
> still works on live tv and recorded tv
>
> Jim A
>

I do not use Debian derivatives (like Ubuntu), but until netstat tells you
that port 3306 is not listening on only localhost, you can quit fiddling
with anything else. I am sure the frontends will work just fine when they
can connect to the database.

What is in the systemd logs when you start mariadb?
Re: mythtv v29 can't connect remote frontend [ In reply to ]
On 01/08/2018 08:55 PM, Greg Oliver wrote:
On Mon, Jan 8, 2018 at 7:38 PM, Jim Abernathy <jfabernathy@outlook.com<mailto:jfabernathy@outlook.com>> wrote:


I'm assuming you have rebooted after the v29 upgrade?

As per my post https://lists.gt.net/mythtv/users/613497

I had to enable "Allow Connections from all Subnets" even though the frontends were on the same subnet

https://www.mythtv.org/wiki/Setup_General#Host_Address_Backend_Setup_.28v29.29

I haven't tried removing this setting after the initial reboot

Cheers,

Anthony


rebooted FE and BE multiple times. I just setup Allow Connections from all Subnets and rebooted. No change. Can't get FE to connect to DB but Kodi still works on live tv and recorded tv

Jim A

I do not use Debian derivatives (like Ubuntu), but until netstat tells you that port 3306 is not listening on only localhost, you can quit fiddling with anything else. I am sure the frontends will work just fine when they can connect to the database.

What is in the systemd logs when you start mariadb?


I could not find the systemd. They are not in /var/log that I can find.

I wish I could figure out how to fix the 3360 port issue. I've never had this much trouble with FE setup or BE setup. But this is the first time I haven't use mythbuntu distro. This is Ubuntu server with no desktop and V29, so lots of new stuff for me.

Jim A



_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org<mailto: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: mythtv v29 can't connect remote frontend [ In reply to ]
On 01/08/2018 08:19 PM, Jim Abernathy wrote:
> I wish I could figure out how to fix the 3360 port issue. I've never had this much trouble with FE setup or BE setup. But this is the first time I haven't use mythbuntu distro. This is Ubuntu server with no desktop and V29, so lots of new stuff for me.

Do this:
grep include /etc/mysql/my.cnf

Which, on my Ubuntu 17.10 Desktop host running MariaDB returns:

!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mariadb.conf.d/

Do the following ls on the last includedir, again on my box
it looks like this:

ls -ld /etc/mysql/mariadb.conf.d/*
-rw-r--r-- 1 root root 733 Jul 30 07:15 /etc/mysql/mariadb.conf.d/50-client.cnf
-rw-r--r-- 1 root root 336 Feb 8 2016 /etc/mysql/mariadb.conf.d/50-mysql-clients.cnf
-rw-r--r-- 1 root root 1032 Mar 28 2017 /etc/mysql/mariadb.conf.d/50-mysqld_safe.cnf
-rw-r--r-- 1 root root 3719 Mar 28 2017 /etc/mysql/mariadb.conf.d/50-server.cnf
-rw-r--r-- 1 root root 111 Feb 17 2015 /etc/mysql/mariadb.conf.d/client.cnf
-rw-r--r-- 1 root root 2715 Feb 17 2015 /etc/mysql/mariadb.conf.d/mysqld.cnf
-rw-r--r-- 1 root root 321 Nov 2 2015 /etc/mysql/mariadb.conf.d/mysqld_safe.cnf
-rw-r--r-- 1 root root 207 Dec 22 2016 /etc/mysql/mariadb.conf.d/mythtv.cnf

The files are parsed in the numeric then alphabetic order, so look for bind-address in the
mythtv.cnf file and any that follow it. (there are none in my case)

Make sure the last file has bind-address=:: or no bind-address
at all, meaning that the one in mythtv.cnf will be used. Some
folks create an xmythtv.cnf file to be sure it's last and not
overwritten by a release from Ubuntu.

If that's correct, there's another problem, so do this.
Pretty unlikely there's an error here, but it's a quick test.

sudo cat /var/log/mysql/error.log

You're running systemd now, so consider things like for Greg's
question:

systemctl status mariadb.service
journalctl --unit mariadb.service

If Kodi works with MythTV, then we know the backend is running
and is able to access the DB.

netstat is good, I prefer: nmap -p3306 --reason yourBackendHostNameOrIO
but you may have to install it. It should run OK on the backend. Then
do it from the failing frontend.

--
Bill
_______________________________________________
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: mythtv v29 can't connect remote frontend [ In reply to ]
I trimmed most of the previous text.

I went to mariadb.com<http://mariadb.com> and looked into Configuring for remote Client access. They say:

* MariaDB is bound to the loopback interface by default because it makes it impossible to connect to the TCP port on the server from a remote host (the bind-address must refer to a local IP address, or you will receive a fatal error and MariaDB will not start). This of course is not desirable if you want to use the TCP port from a remote host, so you must remove this bind-address directive (MariaDB only supports one bind-address, but binds to 0.0.0.0, or :: (every IP) if the bind-address directive is left out).

This tells me that either of these 2 statements are the same:

bind-address=::
#bind-address=::

So not sure why it didn’t work after mythtv install because they set it to the 2nd statement.

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org<mailto: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: mythtv v29 can't connect remote frontend [ In reply to ]
On 01/08/2018 09:05 PM, Jim Abernathy wrote:
> I trimmed most of the previous text.
>
> I went to mariadb.com<http://mariadb.com> and looked into Configuring for remote Client access. They say:
>
> * MariaDB is bound to the loopback interface by default because it makes it impossible to connect to the TCP port on the server from a remote host (the bind-address must refer to a local IP address, or you will receive a fatal error and MariaDB will not start). This of course is not desirable if you want to use the TCP port from a remote host, so you must remove this bind-address directive (MariaDB only supports one bind-address, but binds to 0.0.0.0, or :: (every IP) if the bind-address directive is left out).
>
> This tells me that either of these 2 statements are the same:
>
> bind-address=::
> #bind-address=::
>
> So not sure why it didn’t work after mythtv install because they set it to the 2nd statement.

Because it is set in another file (follow the includedirs in the previous post.)

Or, do this: grep -r bind-address /etc/mysql and, at least on my box,
there are two other instances setting it to the 127.... address. These
files are parsed before mythtv.cnf.

--
Bill
_______________________________________________
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: mythtv v29 can't connect remote frontend [ In reply to ]
On Jan 8, 2018, at 10:13 PM, Bill Meek <keemllib@gmail.com<mailto:keemllib@gmail.com>> wrote:

On 01/08/2018 09:05 PM, Jim Abernathy wrote:
I trimmed most of the previous text.
I went to mariadb.com<http://mariadb.com><http://mariadb.com> and looked into Configuring for remote Client access. They say:
* MariaDB is bound to the loopback interface by default because it makes it impossible to connect to the TCP port on the server from a remote host (the bind-address must refer to a local IP address, or you will receive a fatal error and MariaDB will not start). This of course is not desirable if you want to use the TCP port from a remote host, so you must remove this bind-address directive (MariaDB only supports one bind-address, but binds to 0.0.0.0, or :: (every IP) if the bind-address directive is left out).
This tells me that either of these 2 statements are the same:
bind-address=::
#bind-address=::
So not sure why it didn’t work after mythtv install because they set it to the 2nd statement.

Because it is set in another file (follow the includedirs in the previous post.)

Or, do this: grep -r bind-address /etc/mysql and, at least on my box,
there are two other instances setting it to the 127.... address. These
files are parsed before mythtv.cnf.

--
Bill

I think I see the problem:
jim@mythbuntu:~$ sudo grep -r bind-address /etc/mysql
/etc/mysql/mariadb.conf.d/50-server.cnf:bind-address = 127.0.0.1
/etc/mysql/conf.d/mythtv.cnf:#bind-address=::
jim@mythbuntu:~$
I think it chases the conf.d directory with the mythtv.cnf before it goes to mariadb.conf.d where ther is a bind-address=127.0.0.1

So I need to move the mythtv.cnf to mariadb.conf.d because it would be last in the list so that would fix it. I’ll test that tomorrow.

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org<mailto: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: mythtv v29 can't connect remote frontend [ In reply to ]
On Mon, Jan 8, 2018 at 9:27 PM, Jim Abernathy <jfabernathy@outlook.com>
wrote:

>
>
> On Jan 8, 2018, at 10:13 PM, Bill Meek <keemllib@gmail.com> wrote:
>
> On 01/08/2018 09:05 PM, Jim Abernathy wrote:
>
> I trimmed most of the previous text.
> I went to mariadb.com<http://mariadb.com> and looked into Configuring
> for remote Client access. They say:
> * MariaDB is bound to the loopback interface by default because it
> makes it impossible to connect to the TCP port on the server from a remote
> host (the bind-address must refer to a local IP address, or you will
> receive a fatal error and MariaDB will not start). This of course is not
> desirable if you want to use the TCP port from a remote host, so you must
> remove this bind-address directive (MariaDB only supports one bind-address,
> but binds to 0.0.0.0, or :: (every IP) if the bind-address directive is
> left out).
> This tells me that either of these 2 statements are the same:
> bind-address=::
> #bind-address=::
> So not sure why it didn’t work after mythtv install because they set it to
> the 2nd statement.
>
>
> Because it is set in another file (follow the includedirs in the previous
> post.)
>
> Or, do this: grep -r bind-address /etc/mysql and, at least on my box,
> there are two other instances setting it to the 127.... address. These
> files are parsed before mythtv.cnf.
>
> --
> Bill
>
>
> I think I see the problem:
> *jim@mythbuntu*:*~*$ sudo grep -r bind-address /etc/mysql
> /etc/mysql/mariadb.conf.d/50-server.cnf:bind-address = 127.0.0.1
> /etc/mysql/conf.d/mythtv.cnf:#bind-address=::
> *jim@mythbuntu*:*~*$
> I think it chases the conf.d directory with the mythtv.cnf before it goes
> to mariadb.conf.d where ther is a bind-address=127.0.0.1
>
> So I need to move the mythtv.cnf to mariadb.conf.d because it would be
> last in the list so that would fix it. I’ll test that tomorrow.
>
> No, just remove the hash mark from the beginning of the line in
mythtv.conf and it should work.
Re: mythtv v29 can't connect remote frontend [ In reply to ]
On Mon, 8 Jan 2018 23:02:13 +0000, you wrote:

>In /etc/mysql/conf.d/mythtv.conf file I have #bind-address=:: It was installed by mythtv installation.



>I?ll test with bind 0.0.0.0
>
>Jim A
_______________________________________________
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: mythtv v29 can't connect remote frontend [ In reply to ]
On Jan 8, 2018, at 10:56 PM, Greg Oliver <oliver.greg@gmail.com<mailto:oliver.greg@gmail.com>> wrote:

On Mon, Jan 8, 2018 at 9:27 PM, Jim Abernathy <jfabernathy@outlook.com<mailto:jfabernathy@outlook.com>> wrote:


On Jan 8, 2018, at 10:13 PM, Bill Meek <keemllib@gmail.com<mailto:keemllib@gmail.com>> wrote:

On 01/08/2018 09:05 PM, Jim Abernathy wrote:
I trimmed most of the previous text.
I went to mariadb.com<http://mariadb.com/><http://mariadb.com<http://mariadb.com/>> and looked into Configuring for remote Client access. They say:
* MariaDB is bound to the loopback interface by default because it makes it impossible to connect to the TCP port on the server from a remote host (the bind-address must refer to a local IP address, or you will receive a fatal error and MariaDB will not start). This of course is not desirable if you want to use the TCP port from a remote host, so you must remove this bind-address directive (MariaDB only supports one bind-address, but binds to 0.0.0.0, or :: (every IP) if the bind-address directive is left out).
This tells me that either of these 2 statements are the same:
bind-address=::
#bind-address=::
So not sure why it didn’t work after mythtv install because they set it to the 2nd statement.

Because it is set in another file (follow the includedirs in the previous post.)

Or, do this: grep -r bind-address /etc/mysql and, at least on my box,
there are two other instances setting it to the 127.... address. These
files are parsed before mythtv.cnf.

--
Bill

I think I see the problem:
jim@mythbuntu:~$ sudo grep -r bind-address /etc/mysql
/etc/mysql/mariadb.conf.d/50-server.cnf:bind-address = 127.0.0.1
/etc/mysql/conf.d/mythtv.cnf:#bind-address=::
jim@mythbuntu:~$
I think it chases the conf.d directory with the mythtv.cnf before it goes to mariadb.conf.d where ther is a bind-address=127.0.0.1

So I need to move the mythtv.cnf to mariadb.conf.d because it would be last in the list so that would fix it. I’ll test that tomorrow.

No, just remove the hash mark from the beginning of the line in mythtv.conf and it should work.

That didn’t work since removing it didn’t override the 50-server.cnf bind-address statement. Moving it to mariadb.conf.d and making it bind-address=:: or bind-address=0.0.0.0 will work. It’s just in the wrong directory for the way mysql (mariadb) search.

Jim A

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org<mailto: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<https://forum.mythtv.org/>
Re: mythtv v29 can't connect remote frontend [ In reply to ]
On Mon, 8 Jan 2018 23:02:13 +0000, you wrote:


>In /etc/mysql/conf.d/mythtv.conf file I have #bind-address=:: It was installed by mythtv installation.

Note that the line you quoted there has a # on the front, making it a
comment. If your new bind 0.0.0.0 line was also done with a #, it
will do nothing.

>I?ll test with bind 0.0.0.0
>
>Jim A

Check all the config files under /etc/mysql - they are read in a
specific order given by the include statements, and then
alphabetically in each directory. If an option such as bind-address
is used in more than one place, the last one read is used. So comment
out all the bind-address settings you find except for the one you want
to use.

Use:

bind-address=::

if you want to bind automatically to all available IP addresses,
including both IPv4 and IPv6 addresses. Use:

bind-address=0.0.0.0

to bind to all available IPv4 addresses, and not bind IPv6 addresses.
_______________________________________________
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