<html><body><div style="font-family: times new roman, new york, times, serif; font-size: 12pt; color: #000000"><div>Hi Fabian,<br></div><div><br></div><div>btw. do you have the same keystore.jceks on both nodes... ? If you start the nodes independently, even with the same repository, the keystore.jceks may be created on each node independently...<br></div><div><br></div><div>Ivan<br></div><div><br></div><hr id="zwchr"><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Fabian Bosch" <fabian.bosch@daasi.de><br><b>To: </b>midpoint@lists.evolveum.com<br><b>Sent: </b>Tuesday, April 24, 2018 2:40:06 PM<br><b>Subject: </b>Re: [midPoint] DOCKERED MIDPONT (2 NODES) RUNNING ON AN ORACLE CLUSTER<br><div><br></div>
<p>Same here with mariaDB and midPoint v3.7.1.<br>
Any solution to this?</p>
<p>regards</p>
<p>Fabian<br>
</p>
<p>-- Midpoint 3.7.1 --</p>
<p>[embedded Tomcat opts (midpoint.sh)]<br>
</p>
<blockquote>
<p>JAVA_OPTS="$JAVA_OPTS<br>
-Xms2048M<br>
-Xmx2048M<br>
-Dpython.cachedir=$MIDPOINT_HOME/tmp<br>
-Djavax.net.ssl.trustStore=$MIDPOINT_HOME/keystore.jceks<br>
-Djavax.net.ssl.trustStoreType=jceks<br>
-Dmidpoint.home=$MIDPOINT_HOME<br>
-Dmidpoint.nodeId=NodeA<br>
-Dcom.sun.management.jmxremote.port=20001<br>
-Dcom.sun.management.jmxremote.rmi.port=20001<br>
-Dcom.sun.management.jmxremote.ssl=false<br>
-Dcom.sun.management.jmxremote.password.file=/opt/midpoint/midpoint-3.7-home/jmxremote.password<br>
-Dcom.sun.management.jmxremote.access.file=/opt/midpoint/midpoint-3.7-home/jmxremote.access"</p>
</blockquote>
<p>[MidPoint-Config]</p>
<p> <repository><br>
<repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass><br>
<baseDir>${midpoint.home}</baseDir><br>
<embedded>false</embedded><br>
<asServer>true</asServer><br>
<driverClassName>org.mariadb.jdbc.Driver</driverClassName><br>
<jdbcUsername>midpoint</jdbcUsername><br>
<jdbcPassword>secret</jdbcPassword><br>
<jdbcUrl>jdbc:mariadb://midpoint.remote.tld:3306/midpoint?characterEncoding=utf-8;LOCK_MODE=1;DB_CLOSE_ON_EXIT=FALSE;LOCK_TIMEOUT=10000</jdbcUrl><br>
<hibernateDialect>com.evolveum.midpoint.repo.sql.util.MidPointMySQLDialect</hibernateDialect><br>
<hibernateHbm2ddl>validate</hibernateHbm2ddl><br>
</repository><br>
<taskManager><br>
<clustered>true</clustered><br>
<jmxUsername>midpoint</jmxUsername><br>
<jmxPassword>secret</jmxPassword><br>
</taskManager><br>
</p>
<br>
<div class="moz-cite-prefix">Am 24.10.2017 um 21:51 schrieb Carlos
Ferreira:<br>
</div>
<blockquote cite="mid:CAJHEg67WKgAteNVjXNM6MpBhZALK9uMqAnFS0kFQfqz1uG-LeQ@mail.gmail.com">
<div dir="ltr">
<div>Hi, </div>
<div><br>
</div>
<div>1. I have downloaded the evolveum/midpoint image from
docker hub;</div>
<div><br>
</div>
<div>2. I have create 2 containers, each one running MIDPOINT in
2 separate servers;</div>
<div><br>
</div>
<div>3. I configured the Config.xml file (in both nodes):</div>
<div><br>
</div>
<div>*********************** /var/opt/midpoint/config.xml
****************************************************</div>
<div><br>
</div>
<div>(...)</div>
<div><br>
</div>
<div><configuration></div>
<div> <midpoint></div>
<div> <webApplication></div>
<div>
<importFolder>${midpoint.home}/import</importFolder></div>
<div> </webApplication></div>
<div> <repository></div>
<div>
<repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass></div>
<div> <baseDir>${midpoint.home}</baseDir></div>
<div> <embedded>false</embedded></div>
<div> <asServer>true</asServer></div>
<div> <database>oracle</database></div>
<div> <jdbcUsername>midpoint_wi</jdbcUsername></div>
<div> <jdbcPassword>secret</jdbcPassword></div>
<div> <jdbcUrl>jdbc:oracle:thin:@(DESCRIPTION
=(ADDRESS = (PROTOCOL = TCP)(HOST = orarac.trt)(PORT = 1521))
(LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME = <a href="http://prod.trt3.jus.br" target="_blank">prod.trt3.jus.br</a>)))</jdbcUrl></div>
<div> </repository></div>
<div><taskManager></div>
<div> <clustered>true</clustered></div>
<div> <jmxUsername>midpoint</jmxUsername></div>
<div> <jmxPassword>secret</jmxPassword></div>
<div></taskManager></div>
<div><br>
</div>
<div>(...)</div>
<div>
<div>*********************** /var/opt/midpoint/config.xml
****************************************************</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>----->>> midpoint was configured to access an
ORACLE DATABASE running in a CLUSTER;</div>
<div><br>
</div>
<div><br>
</div>
<div>4. The setenv.sh (/usr/local/tomcat/bin/setenv.sh) file has
been configured as follows:</div>
<div><br>
</div>
<div> a) on node A</div>
<div>CATALINA_OPTS="-Dmidpoint.nodeId=NodeA
-Dmidpoint.home=/var/opt/midpoint/
-Dcom.sun.management.jmxremote=true
-Dmidpoint.jmxHostName=10.3.190.47 -Dcom.sun.management.jmx</div>
<div>remote.port=20001 -Dcom.sun.management.jmxremote.ssl=false
-Dcom.sun.management.jmxremote.password.file=/var/opt/midpoint/jmxremote.password
-Dcom.sun.management.jmxremo</div>
<div>te.access.file=/var/opt/midpoint/jmxremote.access"</div>
<div><br>
</div>
<div> b) on node B</div>
<div>CATALINA_OPTS="-Dmidpoint.nodeId=NodeB
-Dmidpoint.home=/var/opt/midpoint/
-Dcom.sun.management.jmxremote=true
-Dmidpoint.jmxHostName=10.3.190.79 -Dcom.sun.management.jmx</div>
<div>remote.port=20002 -Dcom.sun.management.jmxremote.ssl=false
-Dcom.sun.management.jmxremote.password.file=/var/opt/midpoint/jmxremote.password
-Dcom.sun.management.jmxremo</div>
<div>te.access.file=/var/opt/midpoint/jmxremote.access"</div>
<div><br>
</div>
<div><br>
</div>
<div>3. I have run the script that creates on necessary objects
(tables, etc) in the oracle database;</div>
<div><br>
</div>
<div>4. When I start the first node (A, for example), I am able
to log in;</div>
<div><br>
</div>
<div>5. When I try to login in in the second node (B), I receive
the following message:</div>
<div><br>
</div>
<div>" Currently we are unable to process your request. Kindly
try again later."</div>
<div><br>
</div>
<div>6. In the "idm.log" file, I have the message:</div>
<div><br>
</div>
<div>2017-10-24 19:35:05,771 []
[QuartzScheduler_midPointScheduler-NodeB_ClusterManager] WARN
(org.quartz.impl.jdbcjobstore.JobStoreTX): This scheduler
instance (NodeB) is still active but was recovered by another
instance in the cluster. This may cause inconsistent
behavior.</div>
<div><br>
</div>
<div>7. If I drop all the objects and re-execute the install
script and try to login firstly from node B, I am successful.
Nevertheless, I receive the same error message when trying to
log in from node A.</div>
<div><br>
</div>
<div><br>
</div>
<div>Did I miss anything?</div>
<div><br>
</div>
<div><br>
</div>
<div>Thks,</div>
<div><br>
</div>
<div>Carlos A Ferreira</div>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<br>
<br>_______________________________________________<br>midPoint mailing list<br>midPoint@lists.evolveum.com<br>http://lists.evolveum.com/mailman/listinfo/midpoint<br></blockquote><div><br><br></div><div><br></div><div>-- <br></div><div><span name="x"></span>Ivan Noris<br>Senior Identity Engineer<br>evolveum.com<span name="x"></span><br></div></div></body></html>