<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hi Gábor,</p>
<p>==== linstor.toml<br>
</p>
<p>[db]<br>
user = "linstor"<br>
password = "xxxxxx"<br>
connection_url =
"jdbc:mariadb://db_host/LINSTOR?createDatabaseIfNotExist=true"</p>
<p>==== of course, did this in SQL side:</p>
<p>MariaDB [(none)]> create database LINSTOR;<br>
MariaDB [(none)]> GRANT ALL PRIVILEGES ON LINSTOR.* TO
'linstor'@'%' IDENTIFIED BY 'xxxxxx';<br>
</p>
<p>==== I downloaded MariaDB connector as suggested by 2.12.2 in
Linstor user guide:</p>
<p>root@stor1:/usr/share/linstor-server/lib# wget
<a class="moz-txt-link-freetext" href="https://downloads.mariadb.com/Connectors/java/connector-java-2.6.0/mariadb-java-client-2.6.0.jar">https://downloads.mariadb.com/Connectors/java/connector-java-2.6.0/mariadb-java-client-2.6.0.jar</a></p>
<p>Thank you.<br>
</p>
<div class="moz-cite-prefix">On 02.04.2020 13:20, Gábor Hernádi
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAL16tNYmJFMkTUXH2YnbtHuG97gbjuEHOKZs4-JQUU=f46Qnwg@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div dir="ltr">
<div>Hello,</div>
<div>see answers inline<br>
</div>
<br>
<div class="gmail_quote">
<div dir="ltr" class="gmail_attr">On Thu, Apr 2, 2020 at 12:09
PM Volodymyr Litovka <<a href="mailto:doka.ua@gmx.com"
moz-do-not-send="true">doka.ua@gmx.com</a>> wrote:<br>
</div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div>
<p>Dear colleagues,</p>
is it possible to use DB backend for keeping state of
controller in order to provide HA, instead of drbd volume
like described here? - <a
href="https://www.linbit.com/linstor-controller-pacemaker/"
target="_blank" moz-do-not-send="true">https://www.linbit.com/linstor-controller-pacemaker/</a></div>
</blockquote>
<div><br>
</div>
<div>It is! In fact, LINSTOR uses by default H2 as SQL
database. However, mariadb should also work just fine.</div>
<div> </div>
<blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left:1px solid
rgb(204,204,204);padding-left:1ex">
<div>
<p>I can't check whether it works or no, because after
configured [db] section in linstor.toml with
username/password/connector I hit the error message
below (spoiler: "Unsupported Database MariaDB 10.4").</p>
<p>So, two questions:</p>
<p>1) whether it is possible to use SQL as a backend for
HA configuration?<br>
1.1) if not - which role plays SQL in controller's life?<br>
2) MariaDB 10.4 is fairly stable and back-compatible
with 10.x, whether it can be supported by Linstor?<br>
</p>
</div>
</blockquote>
<div> </div>
<div>The mentioned error message is a bit strange. Would you
mind showing me the jdbc string you are using? Make sure
that it does not contain sensible data. <br>
</div>
<div>Also, which .jar are you using for your mariadb jdbc
driver?<br>
</div>
<br>
</div>
-- <br>
<div dir="ltr" class="gmail_signature">
<div dir="ltr">
<div>
<div dir="ltr">
<div>Best regards,<br>
</div>
Gabor Hernadi<br>
</div>
</div>
</div>
</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Star us on GITHUB: <a class="moz-txt-link-freetext" href="https://github.com/LINBIT">https://github.com/LINBIT</a>
drbd-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:drbd-user@lists.linbit.com">drbd-user@lists.linbit.com</a>
<a class="moz-txt-link-freetext" href="https://lists.linbit.com/mailman/listinfo/drbd-user">https://lists.linbit.com/mailman/listinfo/drbd-user</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Volodymyr Litovka
"Vision without Execution is Hallucination." -- Thomas Edison</pre>
</body>
</html>