<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;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
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;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
.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>Are you running container? I thought there was settings for them if using container, maybe someone here has examples for containers. We still use tomcat with global datasources so I cant speak to container’d deployment<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 11:18 AM<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><div><p class=MsoNormal>So unless I'm running this directly through Tomcat I can't do datasource how it comes normally?<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>I'm getting these:<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>2020-05-12 11:11:52,084 [REPOSITORY] [midPointScheduler_Worker-3] WARN (com.zaxxer.hikari.pool.PoolBase): HikariPool-1 - Failed to validate connection <a href="mailto:com.mysql.jdbc.JDBC4Connection@5bce37af">com.mysql.jdbc.JDBC4Connection@5bce37af</a> (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Which I don't see a setting on how to address that via config.xml. I know that 4.1 deprecates MariaDB and I'll need to change to PostgreSQL. I was kind of hoping to use datasource so that I can skip providing passwords to a lot of resources that will be reading data in from the same DB.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>On Tue, 2020-05-12 at 11:04 -0500, Jason Everling wrote:<o:p></o:p></p></div><blockquote style='border:none;border-left:solid #729FCF 1.5pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><p class=MsoNormal style='margin-left:4.8pt'><span class=DefaultFontHxMailStyle>Those examples are for tomcat native datasource configuration, standard configuration is done in config.xml in midpoint.home directory,<o:p></o:p></span></p><p class=MsoNormal style='margin-left:4.8pt'><span class=DefaultFontHxMailStyle><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:4.8pt'><span class=DefaultFontHxMailStyle> <repository><o:p></o:p></span></p><p class=MsoNormal style='margin-left:4.8pt'><span class=DefaultFontHxMailStyle> <repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass><o:p></o:p></span></p><p class=MsoNormal style='margin-left:4.8pt'><span class=DefaultFontHxMailStyle> <database>sqlserver</database><o:p></o:p></span></p><p class=MsoNormal style='margin-left:4.8pt'><span class=DefaultFontHxMailStyle> <jdbcUsername>midpoint</jdbcUsername><o:p></o:p></span></p><p class=MsoNormal style='margin-left:4.8pt'><span class=DefaultFontHxMailStyle> <jdbcPassword>password</jdbcPassword><o:p></o:p></span></p><p class=MsoNormal style='margin-left:4.8pt'><span class=DefaultFontHxMailStyle> <jdbcUrl>jdbc:sqlserver://localhost:1433;database=midpoint</jdbcUrl><o:p></o:p></span></p><p class=MsoNormal style='margin-left:4.8pt'><span class=DefaultFontHxMailStyle> </repository><o:p></o:p></span></p><p class=MsoNormal style='margin-left:4.8pt'><span class=DefaultFontHxMailStyle><o:p> </o:p></span></p><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal style='margin-left:4.8pt'><b>From: </b><a href="mailto:richard.frovarp@ndsu.edu">Richard Frovarp</a><br><b>Sent: </b>Tuesday, May 12, 2020 9:40 AM<br><b>To: </b><a href="mailto:midpoint@lists.evolveum.com">midpoint@lists.evolveum.com</a><br><b>Subject: </b>[midPoint] Where does one configure datasources in midPoint 4.0.2?<o:p></o:p></p></div><p class=MsoNormal style='margin-left:4.8pt'><span class=DefaultFontHxMailStyle><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:4.8pt'>I've read the documentation here:<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:4.8pt'>https://wiki.evolveum.com/display/midPoint/Repository+Configuration#Rep<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'>ositoryConfiguration-Datasourceconfiguration<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:4.8pt'>But that doesn't give a current answer. Grepping through everything<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'>looking for the bits I think might exist in files doesn't give me a<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'>result. <o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:4.8pt'>I'm getting a variety of connection problems, likely due to timeouts,<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'>and it looks like the only way to set those is via a datasource.<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'><o:p> </o:p></p><p class=MsoNormal style='margin-left:4.8pt'>Thanks,<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'>Richard<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'>_______________________________________________<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'>midPoint mailing list<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'>midPoint@lists.evolveum.com<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'>https://lists.evolveum.com/mailman/listinfo/midpoint<o:p></o:p></p><p class=MsoNormal style='margin-left:4.8pt'><span class=DefaultFontHxMailStyle><o:p> </o:p></span></p><pre>_______________________________________________</pre><pre>midPoint mailing list</pre><pre><a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a></pre><pre><a href="https://lists.evolveum.com/mailman/listinfo/midpoint">https://lists.evolveum.com/mailman/listinfo/midpoint</a></pre></blockquote><pre style='margin-left:4.8pt'><o:p> </o:p></pre><p class=MsoNormal><span class=DefaultFontHxMailStyle><o:p> </o:p></span></p></div></body></html>