<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hello Zachary,</p>
<p>first of all, it would be best to use <b>midpoint</b> mailing
list, not midpoint-dev. The former has (at least I think so) much
more subscribers than this one.</p>
<p>As for your specific question - I don't know. The use of SET
TRANSACTION READ ONLY command can be turned off by setting <b>useReadOnlyTransactions</b>
repository configuration property to false (visit <a
moz-do-not-send="true"
href="https://wiki.evolveum.com/display/midPoint/Repository+Configuration">https://wiki.evolveum.com/display/midPoint/Repository+Configuration</a>
to see how repository configuration is done -- although this
particular property is not mentioned there). But I don't think
this will solve all the issues; probably there are others problems
related to the use of old MariaDB.</p>
<p>Anyway, you can try it; and if you have any more questions, I
recommend trying asking on midpoint mailing list.</p>
<p>Best regards,<br>
Pavol Mederly<br>
</p>
<br>
<div class="moz-cite-prefix">On 24.06.2018 0:11, Zachary Hanson-Hart
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CAF-2CQE9ABicMm_tm0kr_hjS9+RwCjxzyiscj+AkMdjGNQSQkA@mail.gmail.com">
<div dir="ltr">
<div>
<div>Hi Midpoint list,<br>
<br>
</div>
I'm trying to set up midpoint to use a remote database
server for the repository. The rub is that it's a RHEL 7
server, and therefore has mariadb 5.5.56. The wiki (<a
href="https://wiki.evolveum.com/display/midPoint/MariaDB"
moz-do-not-send="true">https://wiki.evolveum.com/display/midPoint/MariaDB</a>)
says midpoint tests on mariadb 10.0.28. <br>
</div>
<div><br>
</div>
<div>At this point, midpoint won't start using the mariadb
5.5.56 database.<br>
</div>
<div><br>
</div>
<div>So far, I had to make a trivial modification to the sql to
create the schema:<br>
midpoint-3.7.2/doc/config/sql/_all/mysql-3.7-all.sql<br>
-- mysql-3.7-all.sql 2018-06-08 04:58:50.000000000 -0400<br>
+++ mysql-3.7-all.sql.new 2018-06-23 17:57:01.441636150
-0400<br>
@@ -1923,7 +1923,7 @@<br>
PROC_INST_ID_ varchar(64),<br>
ACTIVITY_ID_ varchar(64),<br>
CONFIGURATION_ varchar(255),<br>
- CREATED_ timestamp(3) not null DEFAULT
CURRENT_TIMESTAMP(3),<br>
+ CREATED_ timestamp(3) not null DEFAULT
CURRENT_TIMESTAMP(),<br>
PROC_DEF_ID_ varchar(64),<br>
TENANT_ID_ varchar(255) default '',<br>
primary key (ID_)<br>
<br>
</div>
<div>Yup, just get rid of the 3 in the CURRENT_TIMESTAMP. <br>
<br>
</div>
<div>I have verified connectivity with the credentials in the
config.xml. <br>
</div>
<div><br>
The current failure is related to the `SET TRANSACTION READ
ONLY` statements that aren't supported in the RedHat provided
mariadb. This prevents midpoint from starting. If I use the
builtin H2, midpoint starts fine. So, it really is the
mariadb version issue causing the problems.<br>
<br>
Now, the questions to the greater midpoint-dev community:<br>
<br>
</div>
<div>Have you tried to get this to work, and if so, what were
the results?<br>
<br>
</div>
<div>For those who use an "enterprise" linux flavor and mariadb
as the DB repository store, how do you manage the mariadb
installation?<br>
</div>
<div><br>
</div>
<div>Is there any interest for me to try to hack the source to
get this to work and submit a (non-java-guru) patch set? <br>
</div>
<div><br>
</div>
<div>-Zach<br>
</div>
</div>
<!--'"--><br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
midPoint-dev mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint-dev@lists.evolveum.com">midPoint-dev@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint-dev">http://lists.evolveum.com/mailman/listinfo/midpoint-dev</a>
</pre>
</blockquote>
<br>
</body>
</html>