<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello Petr,</p>
<p>you're right. But you know the (usual) limitations :-)<br>
</p>
<pre class="moz-signature" cols="72">Pavol Mederly
Software developer
evolveum.com
</pre>
<div class="moz-cite-prefix">On 14/05/2020 11:15, Petr Gašparík -
AMI Praha a.s. wrote:<br>
</div>
<blockquote type="cite"
cite="mid:CABAspd2ZVH2NCqgVXKKcy=y9HDEU0GT9iGnz_4Db8vvxjnurGw@mail.gmail.com">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<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"
moz-do-not-send="true">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"
moz-do-not-send="true">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"
moz-do-not-send="true"></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" moz-do-not-send="true">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" moz-do-not-send="true">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.</span></p>
<p class="MsoNormal"><span> </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" moz-do-not-send="true">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" moz-do-not-send="true">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> </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"> </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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">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" moz-do-not-send="true">midPoint@lists.evolveum.com</a></p>
<p class="MsoNormal">> > <a
href="https://lists.evolveum.com/mailman/listinfo/midpoint"
target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">midPoint@lists.evolveum.com</a></p>
<p class="MsoNormal">> > <a
href="https://lists.evolveum.com/mailman/listinfo/midpoint"
target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">midPoint@lists.evolveum.com</a></p>
<p class="MsoNormal">> <a
href="https://lists.evolveum.com/mailman/listinfo/midpoint"
target="_blank" moz-do-not-send="true">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" moz-do-not-send="true">midPoint@lists.evolveum.com</a></p>
<p class="MsoNormal"><a
href="https://lists.evolveum.com/mailman/listinfo/midpoint"
target="_blank" moz-do-not-send="true">https://lists.evolveum.com/mailman/listinfo/midpoint</a></p>
<p class="MsoNormal"><span> </span></p>
</div>
<br>
<fieldset></fieldset>
<pre>_______________________________________________
midPoint mailing list
<a href="mailto:midPoint@lists.evolveum.com" target="_blank" moz-do-not-send="true">midPoint@lists.evolveum.com</a>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" target="_blank" moz-do-not-send="true">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"
moz-do-not-send="true">midPoint@lists.evolveum.com</a><br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint"
rel="noreferrer" target="_blank" moz-do-not-send="true">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
</blockquote>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-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="https://lists.evolveum.com/mailman/listinfo/midpoint">https://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
</body>
</html>