<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p><font face="Helvetica, Arial, sans-serif">Hello </font><font
face="Helvetica, Arial, sans-serif"><font face="Helvetica,
Arial, sans-serif">Faustin</font>,</font></p>
<p><font face="Helvetica, Arial, sans-serif">I am unfamiliar with
how libvirt works, so I cannot say.</font></p>
<p><font face="Helvetica, Arial, sans-serif">I have debian testing
running on the hardware and inside the container. Everything is
from official repo. I can get mariadb to start by messing
around with the systemd startup script.</font></p>
<p><font face="Helvetica, Arial, sans-serif">This may entirely be a
an apparmor/systemd issue and nothing to to with mariadb. But
I'm not clear if mariadb systemd configuration is doing
something unexpected or not.<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif">It works, if I create
/var/run/mysqld by hand, and then use this
/lib/systemd/system/mariadb.service:</font></p>
<p><font face="Helvetica, Arial, sans-serif">[Unit]<br>
Description=MariaDB 10.3.12 database server<br>
Documentation=man:mysqld(8)<br>
Documentation=<a class="moz-txt-link-freetext" href="https://mariadb.com/kb/en/library/systemd/">https://mariadb.com/kb/en/library/systemd/</a><br>
After=network.target<br>
<br>
[Install]<br>
WantedBy=multi-user.target<br>
Alias=mysql.service<br>
Alias=mysqld.service<br>
<br>
[Service]<br>
Type=notify<br>
PrivateNetwork=false<br>
User=mysql<br>
Group=mysql<br>
CapabilityBoundingSet=CAP_IPC_LOCK<br>
PermissionsStartOnly=true<br>
ExecStartPre=/bin/sh -c "systemctl unset-environment
_WSREP_START_POSITION"<br>
ExecStartPre=/bin/sh -c "[ ! -e /usr/bin/galera_recovery ]
&& VAR= || \<br>
VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ] \<br>
&& systemctl set-environment _WSREP_START_POSITION=$VAR
|| exit 1"<br>
ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER
$_WSREP_START_POSITION<br>
ExecStartPost=/etc/mysql/debian-start<br>
ExecStartPost=/bin/sh -c "systemctl unset-environment
_WSREP_START_POSITION"<br>
KillSignal=SIGTERM<br>
SendSIGKILL=no<br>
Restart=on-abort<br>
RestartSec=5s<br>
UMask=007<br>
PrivateTmp=false<br>
LimitNOFILE=16364<br>
<br>
</font></p>
<p><font face="Helvetica, Arial, sans-serif"><br>
</font></p>
<div class="moz-cite-prefix">On 2019-02-11 11:35 a.m., Faustin
Lammler wrote:<br>
</div>
<blockquote type="cite" cite="mid:20190211163546.GA3299@falared">
<pre class="moz-quote-pre" wrap="">Hi Matthew,
Thanks for your report!
I have no platform setup to test this so I have to install one but I am
not a LXC expert. Do you think this could be tested into a libvirt VM?
If I understand correctly, you have a Debian testing host and you are
running an LXC container with 10.3 mariadb version (everything from
official Debian repositories?).
This (<a class="moz-txt-link-freetext" href="https://github.com/lxc/lxc/pull/2758">https://github.com/lxc/lxc/pull/2758</a>) seems to indicate that
problem may rather come from apparmor/systemd but I will try to
reproduce your issue.
Regards,
Faustin
</pre>
</blockquote>
</body>
</html>