<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<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 class="moz-signature" cols="72">Pavol Mederly
Software developer
evolveum.com
</pre>
<div class="moz-cite-prefix">On 13/05/2020 19:22, Jason Everling
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:5ebc2cd8.1c69fb81.b28f9.a0b2@mx.google.com">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Ubuntu;
panose-1:2 11 5 4 3 6 2 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.DefaultFontHxMailStyle
{mso-style-name:"Default Font HxMail Style";
font-family:"Ubuntu",sans-serif;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
<div class="WordSection1">
<p class="MsoNormal"><span class="DefaultFontHxMailStyle">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.<o:p></o:p></span></p>
<p class="MsoNormal"><span class="DefaultFontHxMailStyle"><o:p> </o:p></span></p>
<div
style="mso-element:para-border-div;border:none;border-top:solid
#E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="border:none;padding:0in"><b>From:
</b><a href="mailto:richard.frovarp@ndsu.edu"
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"
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 class="DefaultFontHxMailStyle"><o:p> </o:p></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"><o:p> </o:p></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 class="moz-txt-link-abbreviated" href="mailto:midpoint@lists.evolveum.com">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 class="moz-txt-link-abbreviated" href="mailto:midpoint@lists.evolveum.com">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 class="moz-txt-link-freetext" href="https://wiki.evolveum.com/display/midPoint/Repository+Configuration">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 class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a></p>
<p class="MsoNormal">> >
<a class="moz-txt-link-freetext" href="https://lists.evolveum.com/mailman/listinfo/midpoint">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 class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a></p>
<p class="MsoNormal">> >
<a class="moz-txt-link-freetext" href="https://lists.evolveum.com/mailman/listinfo/midpoint">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 class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a></p>
<p class="MsoNormal">>
<a class="moz-txt-link-freetext" href="https://lists.evolveum.com/mailman/listinfo/midpoint">https://lists.evolveum.com/mailman/listinfo/midpoint</a></p>
<p class="MsoNormal">_______________________________________________</p>
<p class="MsoNormal">midPoint mailing list</p>
<p class="MsoNormal"><a class="moz-txt-link-abbreviated" href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a></p>
<p class="MsoNormal"><a class="moz-txt-link-freetext" href="https://lists.evolveum.com/mailman/listinfo/midpoint">https://lists.evolveum.com/mailman/listinfo/midpoint</a></p>
<p class="MsoNormal"><span class="DefaultFontHxMailStyle"><o:p> </o:p></span></p>
</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>