<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 face="moz-fixed"><font style="font-size: 9pt" size="2">OK, now verify that MariaDB is actually running by using the mysql command:</font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">sudo mysql</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">show databases</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">quit</span></font></font>
</pre>
<dl>
<dd>
<table width="631" cellspacing="0" cellpadding="4">
<colgroup><col width="621"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="621" valign="top">
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Came out weird: only partially working??</font></font></p>
<p><br>
</p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">barry@Backend-3:~$ sudo mysql</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">[sudo] password for barry: </font></font>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Welcome to the MariaDB monitor. Commands
end with ; or \g.</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Your MariaDB connection id is 30</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Server version:
10.1.38-MariaDB-0ubuntu0.18.04.2 Ubuntu 18.04</font></font></p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Copyright (c) 2000, 2018, Oracle, MariaDB
Corporation Ab and others.</font></font></p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
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="moz-fixed"><font style="font-size: 9pt"
size="2">MariaDB [(none)]> show databases</font></font></p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> show database</font></font></p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> quit</font></font></p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> exit</font></font></p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> \h</font></font></p>
<dl>
<dl>
<dd>
<table width="552" cellspacing="0" cellpadding="4">
<colgroup><col width="542"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000;
padding: 0.04in" width="542" valign="top">
<p><font face="moz-fixed"><font
style="font-size: 9pt" size="2">(I’m
inserting a comment/explanation here
– various readers display how I’m
formatting differently.) So ‘show
databases’ just went to an arrow
prompt, though perhaps you had
accidentally added an ‘s’ so I
entered ‘show database’; still went
to an arrow prompt. Quit command
goes to prompt. (??!) Exit? Nope.
It’s not liking words so try \h and
get the help screen. (End comment;
next restarts screen display.)</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
</dl>
<p><br>
</p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">General information about MariaDB can be
found at</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2"><a class="moz-txt-link-freetext" href="http://mariadb.org">http://mariadb.org</a></font></font></p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">List of all MySQL commands:</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Note that all text commands must be first
on line and end with ';' </font></font> </p>
<div align="right">
<table width="551" cellspacing="0" cellpadding="4">
<colgroup><col width="541"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding:
0.04in" width="541" valign="top">
<p><font face="moz-fixed"><font
style="font-size: 9pt" size="2">BJM:
Ahh! Was just about to edit out the help
commands and saw the ‘end with
semi-colon’ requirement!</font></font></p>
<p><br>
</p>
<p><font face="moz-fixed"><font
style="font-size: 9pt" size="2">Now
getting:</font></font></p>
<p><font face="DejaVu Sans Mono, monospace"><font
style="font-size: 9pt" size="2">MariaDB
[(none)]> show databases;</font></font></p>
<pre class="western"><font face="DejaVu Sans Mono, monospace"><font style="font-size: 9pt" size="2">+--------------------+</font></font>
<font face="DejaVu Sans Mono, monospace"><font style="font-size: 9pt" size="2"><span lang="en-US">| Database |</span></font></font>
<font face="DejaVu Sans Mono, monospace"><font style="font-size: 9pt" size="2"><span lang="en-US">+--------------------+</span></font></font>
<font face="DejaVu Sans Mono, monospace"><font style="font-size: 9pt" size="2"><span lang="en-US">| information_schema |</span></font></font>
<font face="DejaVu Sans Mono, monospace"><font style="font-size: 9pt" size="2"><span lang="en-US">| mysql |</span></font></font>
<font face="DejaVu Sans Mono, monospace"><font style="font-size: 9pt" size="2"><span lang="en-US">| performance_schema |</span></font></font>
<font face="DejaVu Sans Mono, monospace"><font style="font-size: 9pt" size="2"><span lang="en-US">+--------------------+</span></font></font>
<font face="DejaVu Sans Mono, monospace"><font style="font-size: 9pt" size="2"><span lang="en-US">3 rows in set (0.01 sec)</span></font></font></pre>
<p> <br>
</p>
<p><font face="moz-fixed"><font
style="font-size: 9pt" size="2">So a
major error is my MariaDB isn’t seeing
the mythconverg. Why MySQL is listed
also seems a little odd.</font></font></p>
</td>
</tr>
</tbody>
</table>
</div>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2"><snip the help list – I did try these
– before that sneaky little semi-colon!></font></font></p>
<p><br>
</p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> -V</font></font></p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> </font></font> </p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> </font></font> </p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> warnings</font></font></p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> status</font></font></p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> connect db</font></font></p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> status</font></font></p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> connect host</font></font></p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> status</font></font></p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">-> \q</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Bye</font></font></p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">BJM: For some attempt to provide
information trying some of the above commands with
the semi-colon completion. Appending to this
message at “MariaDB semi-colon”.</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western">
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US"><snip></span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">netstat -l -n -p | grep mysql</span></font></font>
</pre>
<dl>
<dd>
<table width="633" cellspacing="0" cellpadding="4">
<colgroup><col width="623"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="623" valign="top">
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">I know things aren’t going to magically
work but figure the more information you have the
better you can help. Plus sometimes I learn
things. :) </font></font> </p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">barry@Backend-3:~$ netstat -l -n -p |
grep mysql</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">(Not all processes could be identified,
non-owned process info</font></font></p>
<p> <font face="moz-fixed"><font style="font-size: 9pt"
size="2">will not be shown, you would have to be
root to see it all.)</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">unix 2 [ ACC ] STREAM LISTENING 21417 -
/var/run/mysqld/mysqld.sock</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">barry@Backend-3:~$ </font></font> </p>
<p><br>
</p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">As whining I wasn't the owner did with
sudo:</font></font></p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">barry@Backend-3:~$ sudo netstat -l -n -p
| grep mysql</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN
1029/mysqld </font></font> </p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">unix 2 [ ACC ] STREAM LISTENING 21417
1029/mysqld /var/run/mysqld/mysqld.sock</font></font></p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">barry@Backend-3:~$ </font></font> </p>
<p><br>
</p>
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Different results (that could even be
something significant!).</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western">
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">Go into mythtv-setup and check what settings you have for General ></span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">Host Address Backend Setup > Primary IP address / DNS name. Is it</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">127.0.0.1 or localhost? Or is it the IP address of the PC? And are</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">the "Allow Connections from all Subnets" and "Listen on All IP</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">Addresses" options above that ticked or not?</span></font></font></pre>
<dl>
<dd>
<table width="628" cellspacing="0" cellpadding="4">
<colgroup><col width="618"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="618" valign="top">
<p>MythTV Startup Status screen: Database failed to
start.</p>
<p>Search screen: nothing listed, “No UPnP backends
found”. (I do have the system unplugged so it would
screw up BE2 like it did BE1.)</p>
<p><br>
</p>
<p>Database configuration screen:</p>
<p>Hostname set to 192.168.0.3. Have previously tried
127.0.0.1, localhost, Backend-3 in the off chance.</p>
<p><br>
</p>
<p>As for the “Allow Connections from all Subnets” and
“Listen to all IP Addresses”, I recall seeing those
but they’re not on this screen and that’s the only
screen I can get to other than the database one.</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p><br>
<br>
</p>
<dl>
<dd>
<table width="629" cellspacing="0" cellpadding="4">
<colgroup><col width="619"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="619" valign="top">
<p>Also adding this, from Terminal:</p>
<p><br>
</p>
<p>barry@Backend-3:~$ mythtv-setup</p>
<p>ERROR 2003 (HY000): Can't connect to MySQL server on
'192.168.0.3' (101 "Network is unreachable")</p>
<p>Gtk-Message: 14:27:40.034: GtkDialog mapped without a
transient parent. This is discouraged.</p>
<p>/usr/bin/mythtv-setup: 68: /usr/bin/mythtv-setup:
gksu: not found</p>
<p>Gtk-Message: 14:27:48.685: GtkDialog mapped without a
transient parent. This is discouraged.</p>
<p><br>
</p>
<p>I’m not all that concerned about the ‘this is
discouraged’ line but wondering if the ‘gksu’ part is.
Read it was discontinued in 18.04, so maybe the two
lines are creating a problem?</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p><br>
<br>
</p>
<p>Thanks again!</p>
<p>Barry</p>
<p style="margin-bottom: 0in; line-height: 100%">- - - -</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><b>Appendix</b></p>
<p>“<font face="moz-fixed"><font style="font-size: 9pt" size="2">MariaDB
semi-colon”</font></font></p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">New information
which may or may not be useful :</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">MariaDB
[(none)]>
-V;</p>
<p style="margin-bottom: 0in; line-height: 100%">ERROR 1064 (42000):
You have an error in your SQL syntax; check the manual that
corresponds to your MariaDB server version for the right syntax to
use near '-V' at line 1</p>
<p style="margin-bottom: 0in; line-height: 100%">MariaDB
[(none)]>
warnings;</p>
<p style="margin-bottom: 0in; line-height: 100%">Show warnings
enabled.</p>
<p style="margin-bottom: 0in; line-height: 100%">MariaDB
[(none)]>
status</p>
<p style="margin-bottom: 0in; line-height: 100%">--------------</p>
<p style="margin-bottom: 0in; line-height: 100%">mysql Ver 15.1
Distrib 10.1.38-MariaDB, for debian-linux-gnu (x86_64) using
readline
5.2</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Connection id: 33</p>
<p style="margin-bottom: 0in; line-height: 100%">Current database: </p>
<p style="margin-bottom: 0in; line-height: 100%">Current
user: root@localhost</p>
<p style="margin-bottom: 0in; line-height: 100%">SSL: Not in use</p>
<p style="margin-bottom: 0in; line-height: 100%">Current
pager: stdout</p>
<p style="margin-bottom: 0in; line-height: 100%">Using outfile: ''</p>
<p style="margin-bottom: 0in; line-height: 100%">Using delimiter: ;</p>
<p style="margin-bottom: 0in; line-height: 100%">Server: MariaDB</p>
<p style="margin-bottom: 0in; line-height: 100%">Server
version: 10.1.38-MariaDB-0ubuntu0.18.04.2 Ubuntu 18.04</p>
<p style="margin-bottom: 0in; line-height: 100%">Protocol version:
10</p>
<p style="margin-bottom: 0in; line-height: 100%">Connection:
Localhost
via UNIX socket</p>
<p style="margin-bottom: 0in; line-height: 100%">Server
characterset: utf8mb4</p>
<p style="margin-bottom: 0in; line-height: 100%">Db characterset:
utf8mb4</p>
<p style="margin-bottom: 0in; line-height: 100%">Client
characterset: utf8mb4</p>
<p style="margin-bottom: 0in; line-height: 100%">Conn. characterset:
utf8mb4</p>
<p style="margin-bottom: 0in; line-height: 100%">UNIX
socket: /var/run/mysqld/mysqld.sock</p>
<p style="margin-bottom: 0in; line-height: 100%">Uptime: 55 min 11
sec</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Threads: 1
Questions: 72 Slow queries: 0 Opens: 32 Flush tables: 1 Open
tables: 26 Queries per second avg: 0.021</p>
<p style="margin-bottom: 0in; line-height: 100%">--------------</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">MariaDB
[(none)]>
connect db;</p>
<p style="margin-bottom: 0in; line-height: 100%">ERROR 1049 (42000):
Unknown database 'db'</p>
<p style="margin-bottom: 0in; line-height: 100%">unknown [db]> </p>
<p style="margin-bottom: 0in; line-height: 100%">unknown [db]>
connect db</p>
<p style="margin-bottom: 0in; line-height: 100%">ERROR 1049 (42000):
Unknown database 'db'</p>
<p style="margin-bottom: 0in; line-height: 100%">unknown [db]>
connect host;</p>
<p style="margin-bottom: 0in; line-height: 100%">ERROR 1049 (42000):
Unknown database 'host'</p>
<p style="margin-bottom: 0in; line-height: 100%">unknown [host]>
connect host</p>
<p style="margin-bottom: 0in; line-height: 100%">ERROR 1049 (42000):
Unknown database 'host'</p>
<p style="margin-bottom: 0in; line-height: 100%">unknown [host]>
</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</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>