[mythtv-users] mythtv v29 can't connect remote frontend

[Greg Oliver]

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

>
>
> On Jan 8, 2018, at 10:13 PM, Bill Meek <keemllib at 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 at 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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20180108/7f154df0/attachment.html>