<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <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 type="cite"
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"
            moz-do-not-send="true">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 wrap="">_______________________________________________
midPoint mailing list
<a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a>
<a class="moz-txt-link-freetext" href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>