<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<p>Resending as as soon as I clicked <send> realized didn't
correct the subject</p>
<p><br>
</p>
<p>Hi Stephen!</p>
<pre class="western" style="margin-left: 0.39in; margin-right: 0.39in"><font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">Now look at the */etc/mythtv/config.xml* file. Change the password there </span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">if you want to, and then set the same password in MariaDB:</span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US"><b>*sudo su*</b></span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US"><b>*mysql*</b></span></font></font></font>
<font color="#000000"> <font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">ERROR 2002 (HY000): Can’t connect to local MySQL server through</span></font></font></font>
<font color="#000000"> <font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">socket ‘var/run/mysqld/mysqld.sock’ (2 “No such file or directory”)</span></font></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">MariaDB is not running for some reason. You need to look at the log files:</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">/var/log/mysql.*</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US"><i>/var/log/mysql/</i>*</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">especially <span style="background: #fff200">/var/log/mysql/error.log</span>. There should be error messages in there that will tell you what is wrong.</span></font></font>
</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><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Looks like
started but at 127.0.0.1</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Last line of log
says ‘/usr/sbin/mysqld: Shutdown complete’ (so
turned off mariadb because nothing happening at
localhost?)</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">Also run these systemd commands and see what they show: </span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">sudo systemctl status mariadb</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US"> </span></font></font></pre>
<dl>
<dd>
<table width="621" cellspacing="0" cellpadding="4">
<colgroup><col width="611"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="611" valign="top">
<p><font face="moz-fixed"><font style="font-size: 9pt"
size="2">Unit mariabd.service could not be found</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">sudo journalctl --unit=mariadb</span></font></font></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><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Starting MariaDB
10.1.38 database server</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">(long line
indicating started as process 7472)</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">mariadb.service:
Start operation timed out. Terminating.</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">mariadb.service:
Failed with result ‘timeout’</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Failed to start
MariaDB 10.1.38 database service</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<p><font face="Liberation Mono, monospace"><font style="font-size:
10pt" size="2">Looks like I may as well stop here as need to
figure out why MariaDB is looking at localhost instead of the
static assigned IP 192.168.0.3 (or at least I’m assuming
that’s a problem).</font></font></p>
<pre class="western"><font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">*grant all on mythconverg.* to mythtv@"%" identified by "<password>";*</span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">(BJM) I stopped at this point as received the response indicating </span></font></font></font>
<font color="#000000">‘<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">command grant not found’. At that point was in a ‘deeper’ Terminal </span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">command level – root@Backend-3 vs. barry-@Backend-3. At the </span></font></font></font>
<font color="#000000">‘</font><font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">barry@Backend-3 <a href="mailto:barry@Backend-3"><mailto:barry@Backend-3></a>’ prompt checked ‘grant –help’: </span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">not found. Guessing ‘grant’ is a MySQL command but not loading because </span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">of the socket error.</span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">LIS, checked a couple things then stopped at this point to ask for help. </span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">BTW, the /etc/mythtv/config.xml file contained the same random password </span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">as (my) yesterday. Thought that a hare odd as when uninstalled MySQL </span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">previously (before asking for help) the new install of MythTV changed </span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">the original password (of install #1). Just in case that bit of trivia </span></font></font></font>
<font color="#000000"><font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">is significant.</span></font></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">Uninstalling a package does not uninstall any data files created by that package, or files created when that software was run. If you use apt-get purge instead of apt-get remove, that will remove the data</span></font></font>
<font face="moz-fixed"><font style="font-size: 9pt" size="2"><span lang="en-US">files created by the package (such as <i>/etc/mythtv/</i>* files). So reinstalling a package without a prior purge will leave the old files from the previous install and you will still have the old /etc/mythtv/config.xml with the old password in it.</span></font></font>
</pre>
<p> <font face="Liberation Mono, monospace"><font style="font-size:
10pt" size="2"><span lang="en-US">Right: had used </span></font></font><font
face="Andale Mono"><font style="font-size: 10pt" size="2"><span
lang="en-US"><b>sudo apt-get --purge remove my</b></span></font></font><font
face="Andale Mono"><font style="font-size: 10pt" size="2"><span
lang="en-US"><b>sql-</b></span></font></font><font
face="Liberation Mono, monospace"><font style="font-size: 10pt"
size="2"><span lang="en-US"> . ...Ah! did a reverse command
search and the site did it backwards: </span></font></font><font
face="Andale Mono"><font style="font-size: 10pt" size="2"><span
lang="en-US"><b>sudo ap</b></span></font></font><font
face="Andale Mono"><font style="font-size: 10pt" size="2"><span
lang="en-US"><b>t-get remove –purge mysql</b></span></font></font>
. Would that make any difference?</p>
<p><br>
Thanks! </p>
<p>Barry</p>
<br>
</body>
</html>