<div dir="auto"><div><br><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Sat, Feb 15, 2020, 12:36 PM Peter Bennett <<a href="mailto:pb.mythtv@gmail.com">pb.mythtv@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<br>
<br>
<div>On 2/15/20 12:04 PM, James Abernathy
wrote:<br>
</div>
<blockquote type="cite">
<div lang="x-unicode">
<div dir="ltr">I build a test system with mythtv v31 on ubuntu
18.04. It's working fine. I want to test it with a Shield TV
frontend using mythfrontend v31-Pre-1898 and I've having some
issues.
<div><br>
</div>
<div>First I used adb install to install the Shield frontend
and on the shield setup I reset all the data and cache.</div>
<div><br>
</div>
<div>Second I made user that the v31 backend had the
mythtv.cnf for for mysql (mariadb) had the # removed from
the bind address statement.</div>
<div><br>
</div>
</div>
</div>
</blockquote>
With MariaDB it needs to be set as <br>
bind-address = ::<br>
in /etc/mysql/mariadb.conf.d/50-server.cnf or whatever file has it<br>
<br>
<blockquote type="cite">
<div lang="x-unicode">
<div dir="ltr">
<div>When I do the search on Shield for the backend it shows
my 2 V30 backends and one V31 backend. I can't seem to
connect to is. Every time I go to setup its have the
database password right, but the IP is 127.0.0.1. I changed
that to the right IP for the v31 backend, but it's can't
connect to the database.</div>
<div><br>
</div>
<div>Any ideas?</div>
</div>
</div>
<br>
<fieldset></fieldset>
</blockquote>
there are some options - <br>
1. Set a pin on your v31 backend, then on the shield select that
backend and enter the correct PIN.<br>
or<br>
2. Select setup on the shield and enter the correct database ip
address, database, user id and password. You can check against
config.xml on your server to make sure you have the correct values.<br>
<br>
If it still does not connect you can run adb logcat > some file
and look through the file for the relevant database connection error
message.<br>
</div></blockquote></div></div><div dir="auto"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div bgcolor="#FFFFFF" text="#000000"></div></blockquote></div></div><div dir="auto">My mysql.cnf had the localhost bind-address, but the mythtv.cnf had the right one. I think the mythtv.cnf would take precedent.</div><div dir="auto"><br></div><div dir="auto">I think it could be the fact that in mythtv-setup-> General the IP was set to 127.0.0.1. I've changed to the real IP. </div><div dir="auto">I'll test after the Liverpool game is over. </div><div dir="auto"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div bgcolor="#FFFFFF" text="#000000"><br></div>
</blockquote></div></div></div>