<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<p> </p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Hi Stephen!</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<pre class="western"><font color="#000000">sudo restart mythtv-backend</font>
<font color="#000000"> Found another potential error, or could be just a shortcut command I</font>
<font color="#000000"> don?t have installed:</font>
<font color="#000000"> barry@Backend-3:~$ sudo restart mythtv-backend</font>
<font color="#000000"> sudo: restart: command not found</font>
Sorry, that was a typo on my part. It should be:
sudo systemctl restart mythtv-backend
</pre>
<dl>
<dd>
<table width="620" cellspacing="0" cellpadding="4">
<colgroup><col width="610"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="610" valign="top">
<pre class="western" style="margin-right: 0.39in"><font face="Liberation Mono, monospace"><font style="font-size: 10pt" size="2"><font color="#000000">Oops! I might have caught the error if you did what I do often: add an ‘r’ ==> “systemct</font><font color="#000000"><b>r</b></font><font color="#000000">l”!</font></font></font></pre>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western" style="margin-left: 0.39in; margin-right: 0.39in; margin-bottom: 0.2in">OK, that all looks good except for not being able to connect to
MariaDB on 192.168.0.3. That is likely only that you have not yet
changed the bind-address= line in the MariaDB config files, so it is
only allowing connections on localhost. So you need to fix that now.
Do this to find all the bind-address lines:
sudo su
cd /etc/mysql
grep -ar "bind-address" *
There may be more than one bind-address line. If so, choose one of
them and change it to:
bind-address=::
and change all the others by adding a # character as the first
character on the line (comment them out). Use your favourite editor,
or nano.</pre>
<dl>
<dd>
<table width="623" cellspacing="0" cellpadding="4">
<colgroup><col width="613"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="613" valign="top">
<p>OK. I’m taking things too literal here and realizing
a problem. <b>cd /etc/mysql</b> changes to a
directory and there are several files and subir’s
within. (<b>grep -ar</b> command) ...Ah! So sort of
like the find command!</p>
<p><br>
</p>
<p style="margin-left: 0.49in">barry@Backend-3:~$ cd
/etc/mysql</p>
<p style="margin-left: 0.49in">barry@Backend-3:/etc/mysql$
ls</p>
<p style="margin-left: 0.49in">conf.d debian.cnf-5.7
mariadb.cnf my.cnf mysql.cnf</p>
<p style="margin-left: 0.49in">debian.cnf debian-start
mariadb.conf.d my.cnf.fallback mysql.conf.d</p>
<p style="margin-left: 0.49in">barry@Backend-3:/etc/mysql$
</p>
<p><br>
</p>
<p><br>
</p>
<p>This is the original: </p>
<p><br>
</p>
<p style="margin-left: 0.49in"><span style="font-style:
normal">root@Backend-3:/etc/mysql# grep -ar
"bind-address" *</span></p>
<p style="margin-left: 0.49in"><span style="font-style:
normal">conf.d/mythtv.cnf:#bind-address=::</span></p>
<p style="margin-left: 0.49in"><span style="font-style:
normal">mariadb.conf.d/50-server.cnf:bind-address =
127.0.0.1</span></p>
<p style="margin-left: 0.49in"><span style="font-style:
normal">mysql.conf.d/mysqld.cnf:bind-address =
127.0.0.1</span></p>
<p style="margin-left: 0.49in"><span style="font-style:
normal">root@Backend-3:/etc/mysql# </span> </p>
<p><br>
</p>
<p><span style="font-style: normal">And the one with the
double colon is commented out. Think I’ll uncomment
that one and comment the two with 127.0.0.1.</span></p>
<p><br>
</p>
<p style="margin-left: 0.49in"><span style="font-style:
normal">root@Backend-3:/etc/mysql# grep -ar
"bind-address" *</span></p>
<p style="margin-left: 0.49in"><span style="font-style:
normal">conf.d/mythtv.cnf:bind-address=::</span></p>
<p style="margin-left: 0.49in"><span style="font-style:
normal">mariadb.conf.d/50-server.cnf:# bind-address
= 127.0.0.1</span></p>
<p style="margin-left: 0.49in"><span style="font-style:
normal">mysql.conf.d/mysqld.cnf:# bind-address =
127.0.0.1</span></p>
<p style="margin-left: 0.49in"><span style="font-style:
normal">root@Backend-3:/etc/mysql# </span> </p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<pre class="western">Then restart MariaDB:
systemctl restart mariadb
and exit from the root command prompt:
exit
Now check that you can connect using 192.168.0.3:
mysql -u mythtv -p mythconverg
and give it the password from /etc/mythtv/config.xml.</pre>
<dl>
<dd>
<table width="619" cellspacing="0" cellpadding="4">
<colgroup><col width="609"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="609" valign="top">
<p>barry@Backend-3:/etc/mysql$ mysql -u mythtv -p
mythconverg</p>
<p>Enter password: </p>
<p>Reading table information for completion of table and
column names</p>
<p>You can turn off this feature to get a quicker
startup with -A</p>
<p><br>
</p>
<p>Welcome to the MariaDB monitor. Commands end with ;
or \g.</p>
<p>Your MariaDB connection id is 109</p>
<p>Server version: 10.1.38-MariaDB-0ubuntu0.18.04.2
Ubuntu 18.04</p>
<p><br>
</p>
<p>Copyright (c) 2000, 2018, Oracle, MariaDB Corporation
Ab and others.</p>
<p><br>
</p>
<p>Type 'help;' or '\h' for help. Type '\c' to clear the
current input statement.</p>
<p><br>
</p>
<p>MariaDB [mythconverg]> </p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p>This looks better!! :)</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Will check out your
credentials-checking script.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">… Hmm: is it safe
to try to configure the Backend? Think I’ll upload this port and
then take a celebratory break.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Thanks!</p>
<p style="margin-bottom: 0in; line-height: 100%">Barry </p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p>
<style type="text/css">td p { margin-bottom: 0in; }pre.cjk { font-family: "Courier New", monospace; }p { margin-bottom: 0.1in; line-height: 115%; }a:link { }</style></p>
<br>
</body>
</html>