<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<p><i>Yesterday had erroneously used "Re: mythtv-users Digest, Vol
194, Issue 19" as the subject.</i><br>
</p>
<p><br>
</p>
<p>Hi Stephen!</p>
<p> </p>
<br>
<p style="margin-bottom: 0in">System (Backend-3) off overnight –
just powered up (to give a reference of what is going on)</p>
<p style="margin-bottom: 0in"><br>
</p>
<p style="margin-bottom: 0in">Did <b>service –status-all</b><span
style="font-weight: normal"> (because easier for me to
memorize!) - the two we’re interested
in:</span></p>
<p style="margin-bottom: 0in"><span style="font-weight: normal"> [-]
mysql</span></p>
<p style="margin-bottom: 0in"><span style="font-weight: normal"> [+]
mythtv-backend</span></p>
<p style="margin-bottom: 0in"><br>
</p>
<p style="margin-bottom: 0in"><br>
</p>
<pre class="western">If you have MariaDB installed, the mysql.service and mysqld.service
unit files get set up as links to mariadb.service:
root@mypvr:/etc/systemd/system# ll mys*
</pre>
<dl>
<dl>
<dd>
<table width="592" cellspacing="0" cellpadding="4">
<colgroup><col width="582"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="582" valign="top">
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Either
something wrong or I’m not understanding
something or both: to get to your root I’d have
to prefix with sudo. Ah! cd /etc/systemd/system
then sudo 11 mys* “11” command not found. Also
tried ‘ll’.</font></font></p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
</dl>
<dl>
<dl>
<dd>
<table width="593" cellspacing="0" cellpadding="4">
<colgroup><col width="583"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="583" valign="top">
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">Okay – back
from dinner. Still at <a
href="mailto:Barry@Backend-3">Barry@Backend-3</a>:/etc/systemd/system.
For no rear reason type ‘11’ - command not
found. Typed in ‘ll’ - bunch of stuff!</font></font></p>
<p><br>
</p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">So 11 mys*
gives: </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$
ll mys*</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">lrwxrwxrwx 1
root root 35 May 14 09:21 mysqld.service ->
/lib/systemd/system/mariadb.service</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">lrwxrwxrwx 1
root root 35 May 14 09:21 mysql.service ->
/lib/systemd/system/mariadb.service</font></font></p>
<p><font face="Liberation Mono, monospace"><font
style="font-size: 10pt" size="2">barry@Backend-3:/etc/systemd/system$
</font></font> </p>
<p><br>
</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
</dl>
<pre class="western">
root@mypvr:/etc/systemd/system# systemctl status mariadb</pre>
<p style="margin-bottom: 0in">
<br>
</p>
<dl>
<dl>
<dd>
<table width="597" cellspacing="0" cellpadding="4">
<colgroup><col width="587"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="587" valign="top">
<p>barry@Backend-3:/etc/systemd/system$ </p>
<p>barry@Backend-3:/etc/systemd/system$ systemctl
status mariadb</p>
<p>● mariadb.service - MariaDB 10.1.38 database server</p>
<p> Loaded: loaded
(/lib/systemd/system/mariadb.service; enabled;
vendor preset: </p>
<p> Active: failed (Result: timeout) since Thu
2019-05-16 16:25:00 CDT; 1h 23min </p>
<p> Docs: <a class="moz-txt-link-freetext" href="man:mysqld(8)">man:mysqld(8)</a></p>
<p> <a class="moz-txt-link-freetext" href="https://mariadb.com/kb/en/library/systemd/">https://mariadb.com/kb/en/library/systemd/</a></p>
<p> Process: 1020 ExecStart=/usr/sbin/mysqld
$MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WS</p>
<p> Process: 918 ExecStartPre=/bin/sh -c [ ! -e
/usr/bin/galera_recovery ] && VAR=</p>
<p> Process: 914 ExecStartPre=/bin/sh -c systemctl
unset-environment _WSREP_START_</p>
<p> Process: 899 ExecStartPre=/usr/bin/install -m 755
-o mysql -g root -d /var/run</p>
<p> Main PID: 1020 (code=exited, status=0/SUCCESS)</p>
<p><br>
</p>
<p>May 16 16:23:26 Backend-3 systemd[1]: Starting
MariaDB 10.1.38 database server..</p>
<p>May 16 16:23:28 Backend-3 mysqld[1020]: 2019-05-16
16:23:28 140267238837376 [Not</p>
<p>May 16 16:24:57 Backend-3 systemd[1]:
mariadb.service: Start operation timed out</p>
<p>May 16 16:25:00 Backend-3 systemd[1]:
mariadb.service: Failed with result 'timeo</p>
<p>May 16 16:25:00 Backend-3 systemd[1]: Failed to
start MariaDB 10.1.38 database s</p>
<p>lines 1-16/16 (END)</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
</dl>
<br>
<dl>
<dl>
<dd>
<table width="597" cellspacing="0" cellpadding="4">
<tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="587" valign="top">
<p>As I mentioned from some Google-wandering found
where appears to be configured to localhost
127.0.0.1 and I’m guessing it should be looking at
Backend-3 192.168.0.3</p>
<p><br>
</p>
<p>Thanks again! </p>
<p>Barry</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
</dl>
<p style="margin-bottom: 0in"><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>
<p><br>
</p>
</body>
</html>