<div dir="ltr">This should be definitely better documented, as embedded Tomcat is recommended, and in the near future the only one supported option.<br clear="all"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><p><span style="font-family:Arial,sans-serif;font-size:10pt">--</span></p><p><span style="font-family:Arial,sans-serif;font-size:10pt">s pozdravem</span></p><div style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:13px"><p><strong>Petr Gašparík</strong><br><span style="font-size:11px;color:rgb(128,128,128)">konzultant IT bezpečnosti</span></p></div><p style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px">gsm: [+420] 603 523 860<br>e‑mail: <a href="mailto:petr.gasparik@ami.cz" target="_blank">petr.gasparik@ami.cz</a></p><p style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px"><strong>AMI Praha a.s.</strong><br>Pláničkova 11, 162 00 Praha 6</p><p style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px">tel.: [+420] 274 783 239 | web: <a href="https://www.ami.cz" target="_blank">www.ami.cz</a></p><p style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;margin-top:20px"><img src="http://www.ami.cz/images/podpis/ami_logo.gif" alt="AMI Praha a.s." style="border:0px"></p><p style="font-family:Arial,sans-serif;font-size:11px;color:rgb(170,170,170)">Textem tohoto e‑mailu podepisující neslibuje uzavřít ani neuzavírá za společnost AMI Praha a.s.<br>jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít výhradně písemnou formu.<br><span style="font-size:6px"> </span><br>Tento e‑mail je určen výhradně pro potřeby jeho adresáta/ů a může obsahovat důvěrné nebo osobní<br>informace. Nejste‑li zamýšleným příjemcem, je zakázáno jakékoliv zveřejňování, zprostředkování<br>nebo jiné použití těchto informací. Pokud jste obdrželi e‑mail neoprávněně, informujte o tom prosím<br>odesílatele a vymažte neprodleně všechny kopie tohoto e‑mailu včetně všech jeho příloh. Nakládáním<br>s neoprávněně získanými informacemi se vystavujete riziku právního postihu.</p></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">čt 14. 5. 2020 v 11:02 odesílatel Pavol Mederly <<a href="mailto:mederly@evolveum.com">mederly@evolveum.com</a>> napsal:<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>Richard,<br>
</p>
<p>I believe that even for embedded Tomcat (used when running in
standalone mode) you can configure data sources, probably by
setting up things in application.yml file.</p>
<p>Best regards,<br>
</p>
<pre cols="72">Pavol Mederly
Software developer
<a href="http://evolveum.com" target="_blank">evolveum.com</a>
</pre>
<div>On 13/05/2020 19:22, Jason Everling
wrote:<br>
</div>
<blockquote type="cite">
<div>
<p class="MsoNormal"><span>Yeah
that was kind of what I meant by container, I believe its
using Tomcat as the backend, or Jetty? In any case, you
should still be able to create them, we don’t use that
method so someone else would have to chime in on configuring
them.<u></u><u></u></span></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal" style="border:none;padding:0in"><b>From:
</b><a href="mailto:richard.frovarp@ndsu.edu" target="_blank">Richard Frovarp</a><br>
<b>Sent: </b>Tuesday, May 12, 2020 12:07 PM<br>
<b>To: </b><a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a><br>
<b>Subject: </b>Re: [midPoint] Where does one configure
datasources in midPoint 4.0.2?</p>
</div>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
<p class="MsoNormal">Not running in a container. Just did the
download and run using the</p>
<p class="MsoNormal">start.sh script in the tarball.</p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">On Tue, 2020-05-12 at 11:51 -0500, Jason
Everling wrote:</p>
<p class="MsoNormal">> Are you running container? I thought
there was settings for them if</p>
<p class="MsoNormal">> using container, maybe someone here
has examples for containers. We</p>
<p class="MsoNormal">> still use tomcat with global
datasources so I cant speak to</p>
<p class="MsoNormal">> container’d deployment</p>
<p class="MsoNormal">> </p>
<p class="MsoNormal">> From: Richard Frovarp</p>
<p class="MsoNormal">> Sent: Tuesday, May 12, 2020 11:18 AM</p>
<p class="MsoNormal">> To: <a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a></p>
<p class="MsoNormal">> Subject: Re: [midPoint] Where does one
configure datasources in</p>
<p class="MsoNormal">> midPoint 4.0.2?</p>
<p class="MsoNormal">> </p>
<p class="MsoNormal">> So unless I'm running this directly
through Tomcat I can't do</p>
<p class="MsoNormal">> datasource how it comes normally?</p>
<p class="MsoNormal">> </p>
<p class="MsoNormal">> I'm getting these:</p>
<p class="MsoNormal">> </p>
<p class="MsoNormal">> 2020-05-12 11:11:52,084 [REPOSITORY]
[midPointScheduler_Worker-3]</p>
<p class="MsoNormal">> WARN
(com.zaxxer.hikari.pool.PoolBase): HikariPool-1 - Failed to</p>
<p class="MsoNormal">> validate connection
com.mysql.jdbc.JDBC4Connection@5bce37af (No</p>
<p class="MsoNormal">> operations allowed after connection
closed.). Possibly consider using</p>
<p class="MsoNormal">> a shorter maxLifetime value.</p>
<p class="MsoNormal">> </p>
<p class="MsoNormal">> Which I don't see a setting on how to
address that via config.xml. I</p>
<p class="MsoNormal">> know that 4.1 deprecates MariaDB and
I'll need to change to</p>
<p class="MsoNormal">> PostgreSQL. I was kind of hoping to
use datasource so that I can skip</p>
<p class="MsoNormal">> providing passwords to a lot of
resources that will be reading data</p>
<p class="MsoNormal">> in from the same DB.</p>
<p class="MsoNormal">> </p>
<p class="MsoNormal">> On Tue, 2020-05-12 at 11:04 -0500,
Jason Everling wrote:</p>
<p class="MsoNormal">> > Those examples are for tomcat
native datasource configuration,</p>
<p class="MsoNormal">> > standard configuration is done in
config.xml in midpoint.home</p>
<p class="MsoNormal">> > directory,</p>
<p class="MsoNormal">> > </p>
<p class="MsoNormal">> > <repository></p>
<p class="MsoNormal">> > </p>
<p class="MsoNormal">> >
<repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRe</p>
<p class="MsoNormal">> >
positoryFactory</repositoryServiceFactoryClass></p>
<p class="MsoNormal">> >
<database>sqlserver</database></p>
<p class="MsoNormal">> >
<jdbcUsername>midpoint</jdbcUsername></p>
<p class="MsoNormal">> >
<jdbcPassword>password</jdbcPassword></p>
<p class="MsoNormal">> > </p>
<p class="MsoNormal">> >
<jdbcUrl>jdbc:sqlserver://localhost:1433;database=midpoint</jdbcUrl</p>
<p class="MsoNormal">> > ></p>
<p class="MsoNormal">> > </repository></p>
<p class="MsoNormal">> > </p>
<p class="MsoNormal">> > From: Richard Frovarp</p>
<p class="MsoNormal">> > Sent: Tuesday, May 12, 2020 9:40
AM</p>
<p class="MsoNormal">> > To: <a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a></p>
<p class="MsoNormal">> > Subject: [midPoint] Where does
one configure datasources in</p>
<p class="MsoNormal">> > midPoint 4.0.2?</p>
<p class="MsoNormal">> > </p>
<p class="MsoNormal">> > I've read the documentation here:</p>
<p class="MsoNormal">> > </p>
<p class="MsoNormal">> >
<a href="https://wiki.evolveum.com/display/midPoint/Repository+Configuration" target="_blank">https://wiki.evolveum.com/display/midPoint/Repository+Configuration</a></p>
<p class="MsoNormal">> > #Rep</p>
<p class="MsoNormal">> >
ositoryConfiguration-Datasourceconfiguration</p>
<p class="MsoNormal">> > </p>
<p class="MsoNormal">> > But that doesn't give a current
answer. Grepping through everything</p>
<p class="MsoNormal">> > looking for the bits I think
might exist in files doesn't give me a</p>
<p class="MsoNormal">> > result.</p>
<p class="MsoNormal">> > </p>
<p class="MsoNormal">> > I'm getting a variety of
connection problems, likely due to</p>
<p class="MsoNormal">> > timeouts,</p>
<p class="MsoNormal">> > and it looks like the only way to
set those is via a datasource.</p>
<p class="MsoNormal">> > </p>
<p class="MsoNormal">> > Thanks,</p>
<p class="MsoNormal">> > Richard</p>
<p class="MsoNormal">> >
_______________________________________________</p>
<p class="MsoNormal">> > midPoint mailing list</p>
<p class="MsoNormal">> > <a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a></p>
<p class="MsoNormal">> >
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a></p>
<p class="MsoNormal">> > </p>
<p class="MsoNormal">> >
_______________________________________________</p>
<p class="MsoNormal">> > midPoint mailing list</p>
<p class="MsoNormal">> > <a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a></p>
<p class="MsoNormal">> >
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a></p>
<p class="MsoNormal">> </p>
<p class="MsoNormal">> </p>
<p class="MsoNormal">> </p>
<p class="MsoNormal">>
_______________________________________________</p>
<p class="MsoNormal">> midPoint mailing list</p>
<p class="MsoNormal">> <a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a></p>
<p class="MsoNormal">>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a></p>
<p class="MsoNormal">_______________________________________________</p>
<p class="MsoNormal">midPoint mailing list</p>
<p class="MsoNormal"><a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a></p>
<p class="MsoNormal"><a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
midPoint mailing list
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
</div>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</blockquote></div>