<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p style="margin-bottom: 0in"><br>
</p>
<p style="margin-bottom: 0in">Hi Stephen!</p>
<p style="margin-bottom: 0in"><br>
</p>
<pre class="western">If you have not changed the bind-address setting in the <i>/etc/mysql/</i>*
config files, you will get it only binding localhost (127.0.0.1). But
that will not stop it from working.
</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><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Assuming these
(maybe I'm looking at the wrong files!):</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:/etc/systemd/system$
find / -iname config.xml 2>/dev/null</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">/etc/mythtv/config.xml</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">/home/barry/.mythtv/config.xml</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">/home/mythtv/.mythtv/config.xml</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">/usr/share/doc/mythtv-backend/contrib/config_files/config.xml</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">/usr/share/mythtv/config.xml</font></font></p>
<p><br>
</p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">So:</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">/etc/mythtv/config.xml
192.168.0.3 username = mythtv password (correct)</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">/home/barry/.mythtv/config.xml
(same as above)</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">/home/mythtv/.mythtv/config.xml
(same as above)</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">/usr/share/doc/mythtv-backend/contrib/config_files/config.xml</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"> hostname:
my-unique-identifer-goes-here</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"> 127.0.0.1 mythtv
mythtv</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2"> (I've always
assumed this was a template rather than a config
file)</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">/usr/share/mythtv/config.xml
same as above (127.0.0.1, etc,)</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<pre class="western">
There are going to be error
messages in the log files. Unfortunately, which log file depends on
how it is configured. So you need to look at:
/var/log/mysql.log BJM: no such file per ls
/var/log/mysql.err BJM: no such file No errors! Yea! <joke>
and all the files in:
<i>/var/log/mysql/</i>
One or more of them will have all the normal startup messages, and the
error(s) that are causing it to shut down again. If it is configured
right, the most likely place for the error(s) to be logged is:
/var/log/mysql/error.log
</pre>
<dl>
<dd>
<table width="610" cellspacing="0" cellpadding="4">
<colgroup><col width="600"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="600" valign="top">
<p>Error.Log was requested by Bill and posted at <font
style="font-size: 12pt" size="3"> </font><a
href="https://pastebin.com/bVwNPwB8"><font
style="font-size: 12pt" size="3"><span
style="font-weight: normal">https://pastebin.com/bVwNPwB8</span></font></a></p>
<p><br>
</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p style="margin-bottom: 0in"><br>
</p>
<pre class="western">Since you do not know all that much about MariaDB yet, it is best if
you just post the entire log for the last time you attempted to start
MariaDB. The easiest way to do that is to try starting it:
sudo systemctl start mariadb
and note down the time you did that command. Then find any messages
in the logs that happened at that time and for the next few seconds
(minutes?) afterwards. If there is not too much, just post it in an
email here, otherwise post it on pastebin.com and post a URL to there.
My first guess is that it will have a message about "can't init" a
"tc.log" file. So when you are looking at the log files, if you find
one named tc.log, try deleting that and starting MariaDB again.</pre>
<p style="margin-bottom: 0in">
<br>
</p>
<dl>
<dd>
<table width="610" cellspacing="0" cellpadding="4">
<colgroup><col width="600"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="600" valign="top">
<p><font style="font-size: 12pt" size="3"><span
style="font-weight: normal">OK, I’ll admit to
getting tired and fuzzy-brained. If something got
posted oddly I apologize and will try to answer
when more rested.</span></font></p>
<p><br>
</p>
<p><font style="font-size: 12pt" size="3"><span
style="font-weight: normal">I did use </span></font><font
style="font-size: 12pt" size="3"><i><span
style="font-weight: normal">find </span></i></font><font
style="font-size: 12pt" size="3"><span
style="font-style: normal"><span
style="font-weight: normal">to look for tc.log –
starting at root. It didn’t locate.</span></span></font></p>
<p><br>
</p>
<p><font style="font-size: 12pt" size="3"><span
style="font-style: normal"><span
style="font-weight: normal">Good night for now!
Do appreciate the assistance!</span></span></font></p>
<p><font style="font-size: 12pt" size="3"><span
style="font-style: normal"><span
style="font-weight: normal">Barry</span></span></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p style="margin-bottom: 0in"><br>
</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>
</body>
</html>