<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Hi Stephan!</p>
<p style="margin-bottom: 0in; line-height: 100%">Unplugged Ethernet
to BE-2, plugged in Backend-3 (the one we’re working on). Didn’t
want to do something and accidentally screw up and do a capture
like
I had managed to a while back with BE-1.</p>
<br>
<pre class="western">It should not be necessary to do that, as you already have permissions
set for 'mythtv'@'%', which will match 'mythtv'@'127.0.0.1'.
</pre>
<dl>
<dd>
<table width="618" cellspacing="0" cellpadding="4">
<colgroup><col width="608"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="608" valign="top">
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Right: I think
the problem was more the computer seeing an active
Ethernet connection. As noted above, unplugged
BE-2, plugged in BE-3. Issued a <b>sudo mysql</b>
and seeing that prompt as <b>MariaDB[(none)]</b>.
Backtracking to yesterday’s message to see if will
correct (thinking ‘not held’ because not seeing
any networking.)</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<dl>
<dd>
<table width="618" cellspacing="0" cellpadding="4">
<colgroup><col width="608"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="608" valign="top">
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">sudo mysql from
above</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">use mythconverg;
OK, that now display a prompt of MariaDB
[(mythconverg)]</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Hmmm: exited
(quit), sudo mysql, back to the (none).</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">reapply use
mythcoverg;</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Hmm: at Terminal
<b>mysql -h 192.168.0.3 -u mythtv -p mythconverg</b><span
style="font-weight: normal"> I get ERROR 2003
(HY000); Can’t connect to MySQL server on
‘192.168.0.3’ (111 “Connection refused). I’m
almost guessing has something to do with loosing
the database use command, thoug</span><span
style="font-weight: normal">h</span><span
style="font-weight: normal"> I think being told
to use it at the end of the command line </span><span
style="font-weight: normal">you gave me.</span></font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western">
<font color="#000000">barry@Backend-3:~$ mysql mythconverg</font>
<font color="#000000">ERROR 1698 (28000): Access denied for user 'barry'@'localhost'</font>
You might like to add a GRANT for user 'barry' also, as that means you
can use the "mysql" command without sudo from your normal login
(except for doing GRANT commands or adding users):
sudo mysql
GRANT ALL ON mythconverg.* TO barry@'%' IDENTIFIED BY "B*****6";
FLUSH PRIVILEGES;
quit</pre>
<dl>
<dd>
<table width="624" cellspacing="0" cellpadding="4">
<colgroup><col width="614"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="614" valign="top">
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Used this option.</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Thought I noted
an error as transcribing the notes but same
errors: needed <b>sudo</b> and the MariaDB prompt
as back to (none).</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<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><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
mysql -h 192.168.0.3 -u mythtv -p mythconverg</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">ERROR 2003
(HY000): Can't connect to MySQL server on
'192.168.0.3' (111 "Connection refused")</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
</font></font> </p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
</font></font> </p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
</font></font> </p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
sudo mysql -h 192.168.0.3 -u mythtv -p mythconverg</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Enter password: </font></font>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">ERROR 2003
(HY000): Can't connect to MySQL server on
'192.168.0.3' (111 "Connection refused")</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><i>This section
is from before the ‘thought found an error”,
above:</i></font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
sudo mysql</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Welcome to the
MariaDB monitor. Commands end with ; or \g.</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Your MariaDB
connection id is 111</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Server version:
10.1.38-MariaDB-0ubuntu0.18.04.2 Ubuntu 18.04</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Copyright (c)
2000, 2018, Oracle, MariaDB Corporation Ab and
others.</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Type 'help;' or
'\h' for help. Type '\c' to clear the current
input statement.</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">MariaDB
[(none)]> use mythconverg;</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Reading table
information for completion of table and column
names</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">You can turn off
this feature to get a quicker startup with -A</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Database changed</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">MariaDB
[mythconverg]> show grants;</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 7pt" size="1">+------------------------------------------------------------------------------------------------+</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 7pt" size="1">| Grants for
root@localhost |</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 7pt" size="1">+------------------------------------------------------------------------------------------------+</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 7pt" size="1">| GRANT ALL
PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED
VIA unix_socket WITH GRANT OPTION |</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 7pt" size="1">| GRANT PROXY ON
''@'%' TO 'root'@'localhost' WITH GRANT OPTION |</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 7pt" size="1">+------------------------------------------------------------------------------------------------+</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 7pt" size="1">2 rows in set
(0.00 sec)</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"><br>
</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">MariaDB
[mythconverg]> </font></font> </p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">MariaDB
[mythconverg]> GRANT ALL ON mythconverg.* TO
barry@'%' IDENTIFIED BY 'BJM1212406';</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Query OK, 0 rows
affected (0.02 sec) <== "zero rows" doesn't
seem right<br>
</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">MariaDB
[mythconverg]> </font></font> </p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<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><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Another potential
clue of where stuff went wrong:</font></font></p>
<pre class="western"><font face="Liberation Sans Narrow, sans-serif"><font style="font-size: 10pt" size="2">MariaDB [mythconverg]> select * from settings where value like </font>'%serverip%';</font></pre>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">I got a return of
“Empty set”.</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western">
That error "Network is unreachable" says that the Ethernet cable is
out or for some other reason the 192.168.0.3 address has not been
assigned to the Ethernet port.
<snip>
Check the output of this command:
ifconfig</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">
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
ifconfig</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">enp3s0:
flags=4163<UP,BROADCAST,RUNNING,MULTICAST>
mtu 1500</font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">inet 192.168.0.3
netmask 255.255.255.0 broadcast 192.168.0.255</font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">inet6
fe80::b7bd:5dcd:8b98:5ce2 prefixlen 64 scopeid
0x20<link></font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">ether
74:d4:35:9e:04:35 txqueuelen 1000 (Ethernet)</font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">RX packets 3736
bytes 663902 (663.9 KB)</font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">RX errors 0
dropped 0 overruns 0 frame 0</font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">TX packets 752
bytes 88062 (88.0 KB)</font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">TX errors 0
dropped 0 overruns 0 carrier 0 collisions 0</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">lo:
flags=73<UP,LOOPBACK,RUNNING> mtu 65536</font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">inet 127.0.0.1
netmask 255.0.0.0</font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">inet6 ::1
prefixlen 128 scopeid 0x10<host></font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">loop txqueuelen
1000 (Local Loopback)</font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">RX packets 4221
bytes 216282 (216.2 KB)</font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">RX errors 0
dropped 0 overruns 0 frame 0</font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">TX packets 4221
bytes 216282 (216.2 KB)</font></font></p>
<p> <font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">TX errors 0
dropped 0 overruns 0 carrier 0 collisions 0</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
</font></font> </p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">IIRC without the
Ethernet cable connected (so BE3 wouldn’t attack
and maim BE2!) the wired connection section
started with the ether line.</font></font></p>
<p><br>
</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western">
<snip>
As soon as you do that, mythbackend will start up too
soon, before that IP address is available on the Ethernet port. So it
will not work after boot, but will if you restart it after the network
is up:
sudo 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">
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Found another
potential error, or could be just a shortcut
command I don’t have installed:</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
sudo restart mythtv-backend</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">sudo: restart:
command not found</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
</font></font> </p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
</font></font> </p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
sudo systemctl stop mythtv-backend</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
sudo systemctl start mythtv-backend</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
</font></font> </p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Both of these
went to prompt immediately. Seems like should be a
bit of a delay. (BE3 is fast but not that fast!)</font></font></p>
<p><br>
</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<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><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Then thought I’d
try:</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:~$
mythtv-setup</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">ERROR 2003
(HY000): Can't connect to MySQL server on
'192.168.0.3' (111 "Connection refused")</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Gtk-Message:
14:23:58.949: GtkDialog mapped without a transient
parent. This is discouraged.</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Figure error 2003
due to the mysql/mythcoverg/etc., errors; the
second (discouraged) is just an advisory.</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western">
Tomorrow I may not be able to respond as have a few appointments scattered throughout the day, and as I am uncomfortable have Backend-3 and Backend-2 connected to the network at the same time until the problem is resolved might miss my window of experimentation. Plus gives you a chance to get get over the headache I’ve been given you. <joke>
Thanks again for the assistance! Right now it seems like something simple we’re overlooking.
Barry
<style type="text/css">pre.cjk { font-family: "Courier New", monospace; }p { margin-bottom: 0.1in; line-height: 115%; }a:link { }</style>
</pre>
<br>
</body>
</html>