<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><br>
</p>
<p> </p>
<pre class="western" style="margin-bottom: 0.2in">Hi Bill!
A little searching found that the Aliases only get created when the service
is enabled. If it comes enabled already, the links don't exist (my case.)
sudo systemctl stop mariadb && sudo systemctl disable mariadb && sudo systemctl enable mariadb
created the links. Interesting. systemctl status mysql.service mysqld.service mariadb.service
now returns the same thing three times.
The commands and responses posted earlier were what I got. Apparently, at
one time the mysql LSB version in init.d was installed and started mariadb. I had
removed it and its rc?.d links, but when I went to 19.04 they were put back.
On topic: systemctl status mariadb
is all that's required.</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>Hi Bill!</p>
<p><br>
</p>
<p>More or less talking to Stephen about my problem so
I’ll mumble something here. Ran the last command (the
‘on-topic’ one) – I’m guessing my configuration is off
by going to localhost so mariadb is starting, can’t
find something, and shuts down.</p>
<p><br>
</p>
<p>I think I also only copied part of the output in a
previous response so here’;s the whole thing:</p>
<p><br>
</p>
<p>barry@Backend-3:~$ 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 52min </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)...skipping...</p>
<p>● mariadb.service - MariaDB 10.1.38 database server</p>
<p> Loaded: loaded (/lib/systemd/system/mariadb.service;
enabled; vendor preset: enabled)</p>
<p> Active: failed (Result: timeout) since Thu
2019-05-16 16:25:00 CDT; 1h 52min ago</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
$_WSREP_START_POSITION (code=exited, status=0/SUCCESS)</p>
<p> Process: 918 ExecStartPre=/bin/sh -c [ ! -e
/usr/bin/galera_recovery ] && VAR= ||
VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]
&& systemctl set-environment
_WSREP_START_POSITION=$VAR || exit 1 (code</p>
<p> Process: 914 ExecStartPre=/bin/sh -c systemctl
unset-environment _WSREP_START_POSITION (code=exited,
status=0/SUCCESS)</p>
<p> Process: 899 ExecStartPre=/usr/bin/install -m 755 -o
mysql -g root -d /var/run/mysqld (code=exited,
status=0/SUCCESS)</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 [Note] /usr/sbin/mysqld
(mysqld 10.1.38-MariaDB-0ubuntu0.18.04.2) starting as
process 1020 ...</p>
<p>May 16 16:24:57 Backend-3 systemd[1]:
mariadb.service: Start operation timed out.
Terminating.</p>
<p>May 16 16:25:00 Backend-3 systemd[1]:
mariadb.service: Failed with result 'timeout'.</p>
<p>May 16 16:25:00 Backend-3 systemd[1]: Failed to start
MariaDB 10.1.38 database server.</p>
<p>~</p>
<p><br>
</p>
<p>Thanks again!</p>
<p>Barry</p>
</td>
</tr>
</tbody>
</table>
</dd>
</dl>
<br>
</body>
</html>