<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Hi Folks!</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Well, I’m not sure
what I did but seems MariaDB is now starting. It’s all Bill’s
fault: he wrote “Google” and Curious Kitty here got playing with
the keyboard…. <joke></p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Found this site:
<a class="moz-txt-link-freetext" href="https://stackoverflow.com/questions/40997257/mysql-service-fails-to-start-hangs-up-timeout-ubuntu-mariadb">https://stackoverflow.com/questions/40997257/mysql-service-fails-to-start-hangs-up-timeout-ubuntu-mariadb</a>
OK, similar to my issue. Does suggest turning off apparmor as
known bug with MySQL previous installed to MariaDB. OK, I don’t
make things worse so just temporarily turned off apparmor; the
system
is isolated as the Ethernet cable is unplugged.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">I had kept a copy
of
the Terminal session – in the box:</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<table width="100%" cellspacing="0" cellpadding="4">
<colgroup><col width="256*"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="100%" valign="top">
<p><br>
</p>
<p>barry@Backend-3:~$ sudo systemctl stop apparmor</p>
<p>[sudo] password for barry: </p>
<p>barry@Backend-3:~$ sudo systemctl disable apparmor</p>
<p>Synchronizing state of apparmor.service with SysV service
script with /lib/systemd/systemd-sysv-install.</p>
<p>Executing: /lib/systemd/systemd-sysv-install disable
apparmor</p>
<p>barry@Backend-3:~$ </p>
<p><br>
</p>
<p><br>
</p>
<p><br>
</p>
<p>barry@Backend-3:~$ service --status-all</p>
<p> [ - ] apparmor</p>
<p><br>
</p>
<p style="margin-bottom: 0in"><i>Use the site’s instructions
to turn apparmor back on; verify is working</i></p>
<p><br>
</p>
<p>barry@Backend-3:~$ sudo service mariadb start</p>
<p> <wait a long time....></p>
<p>Job for mariadb.service failed because a timeout was
exceeded.</p>
<p>See "systemctl status mariadb.service" and "journalctl
-xe" for details.</p>
<p>barry@Backend-3:~$ </p>
</td>
</tr>
</tbody>
</table>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">So at this point
looked I looked at systemctl status mariadb.service – it’s off,
same as before. The file (in the block, above) has a time stamp of
12:32.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">I had taken a
break,
come back to see if could find something worthwhile; typed some
command to check on things and notice a message stating mariadb
has
been running since approximately 12:30-something. The message
gives
the exact time but I’m rather exited to see something positive;
insert a thumbdrive to capture but the system locked up. ;(</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">Now getting this:</p>
<table width="100%" cellspacing="0" cellpadding="4">
<colgroup><col width="256*"> </colgroup><tbody>
<tr>
<td style="border: 1px solid #000000; padding: 0.04in"
width="100%" valign="top">
<p>barry@Backend-3:~$ systemctl status mariadb.service</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: active (running) since Sat 2019-05-18 15:41:17
CDT; 3min 3s 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: 1134 ExecStartPost=/bin/sh -c systemctl
unset-environment _WSREP_START_POSITION (code=exited,
status=0/SUCCESS)</p>
<p> Process: 1131 ExecStartPost=/etc/mysql/debian-start
(code=exited, status=0/SUCCESS)</p>
<p> Process: 903 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: 900 ExecStartPre=/bin/sh -c systemctl
unset-environment _WSREP_START_POSITION (code=exited,
status=0/SUCCESS)</p>
<p> Process: 895 ExecStartPre=/usr/bin/install -m 755 -o
mysql -g root -d /var/run/mysqld (code=exited,
status=0/SUCCESS)</p>
<p> Main PID: 1005 (mysqld)</p>
<p> Status: "Taking your SQL requests now..."</p>
<p> Tasks: 27 (limit: 4915)</p>
<p> CGroup: /system.slice/mariadb.service</p>
<p> └─1005 /usr/sbin/mysqld</p>
<p><br>
</p>
<p>May 18 15:41:10 Backend-3 systemd[1]: Starting MariaDB
10.1.38 database server...</p>
<p>May 18 15:41:13 Backend-3 mysqld[1005]: 2019-05-18
15:41:13 140244898974848 [Note] /usr/sbin/mysqld (mysqld
10.1.38-MariaDB-0ubuntu0.18.04.2) starting as process 1005
...</p>
<p>May 18 15:41:17 Backend-3 systemd[1]: Started MariaDB
10.1.38 database server.</p>
<p>May 18 15:41:20 Backend-3 /etc/mysql/debian-start[1137]:
/usr/bin/mysql_upgrade: the '--basedir' option is always
ignored</p>
<p>May 18 15:41:20 Backend-3 /etc/mysql/debian-start[1137]:
Looking for 'mysql' as: /usr/bin/mysql</p>
<p>May 18 15:41:20 Backend-3 /etc/mysql/debian-start[1137]:
Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck</p>
<p>May 18 15:41:20 Backend-3 /etc/mysql/debian-start[1137]:
This installation of MySQL is already upgraded to
10.1.38-MariaDB, use --force if you still need to run
mysql_upgrade</p>
<p>May 18 15:41:20 Backend-3 /etc/mysql/debian-start[1159]:
Checking for insecure root accounts.</p>
<p>~</p>
</td>
</tr>
</tbody>
</table>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">So looks like
it/something has started but MythTV (BackendSetup) still is not
seeing any sign of a Database: “No UPnP backends found”. ...The
later using the MythTV Backend Setup icon at ‘Show
Applications’ and at Terminal ‘mythtv-setup’ – what’s the
command to enable logging?? --help doesn’t display a help screen.</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<p style="margin-bottom: 0in; line-height: 100%">TIA! Hope I didn’t
screw something else up!</p>
<p style="margin-bottom: 0in; line-height: 100%">Barry</p>
<p style="margin-bottom: 0in; line-height: 100%"><br>
</p>
<style type="text/css">td p { margin-bottom: 0in; }p { margin-bottom: 0.1in; line-height: 115%; }a:link { }</style>
</body>
</html>