<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><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></head><body lang=EN-US link=blue vlink="#954F72"><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">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">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: midpoint@lists.evolveum.com</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: midpoint@lists.evolveum.com</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>> > https://wiki.evolveum.com/display/midPoint/Repository+Configuration</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>> > midPoint@lists.evolveum.com</p><p class=MsoNormal>> > https://lists.evolveum.com/mailman/listinfo/midpoint</p><p class=MsoNormal>> > </p><p class=MsoNormal>> > _______________________________________________</p><p class=MsoNormal>> > midPoint mailing list</p><p class=MsoNormal>> > midPoint@lists.evolveum.com</p><p class=MsoNormal>> > https://lists.evolveum.com/mailman/listinfo/midpoint</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>> midPoint@lists.evolveum.com</p><p class=MsoNormal>> https://lists.evolveum.com/mailman/listinfo/midpoint</p><p class=MsoNormal>_______________________________________________</p><p class=MsoNormal>midPoint mailing list</p><p class=MsoNormal>midPoint@lists.evolveum.com</p><p class=MsoNormal>https://lists.evolveum.com/mailman/listinfo/midpoint</p><p class=MsoNormal><span class=DefaultFontHxMailStyle><o:p> </o:p></span></p></div></body></html>