<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">
<div>So unless I'm running this directly through Tomcat I can't do datasource how it comes normally?</div>
<div><br>
</div>
<div>I'm getting these:</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>On Tue, 2020-05-12 at 11:04 -0500, Jason Everling wrote:</div>
<blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex">
<div class="WordSection1">
<p class="MsoNormal"><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"><span class="DefaultFontHxMailStyle"><o:p> </o:p></span></p>
<p class="MsoNormal"><span class="DefaultFontHxMailStyle"> <repository><o:p></o:p></span></p>
<p class="MsoNormal"><span class="DefaultFontHxMailStyle"> <repositoryServiceFactoryClass>com.evolveum.midpoint.repo.sql.SqlRepositoryFactory</repositoryServiceFactoryClass><o:p></o:p></span></p>
<p class="MsoNormal"><span class="DefaultFontHxMailStyle"> <database>sqlserver</database><o:p></o:p></span></p>
<p class="MsoNormal"><span class="DefaultFontHxMailStyle"> <jdbcUsername>midpoint</jdbcUsername><o:p></o:p></span></p>
<p class="MsoNormal"><span class="DefaultFontHxMailStyle"> <jdbcPassword>password</jdbcPassword><o:p></o:p></span></p>
<p class="MsoNormal"><span class="DefaultFontHxMailStyle"> <jdbcUrl>jdbc:sqlserver://localhost:1433;database=midpoint</jdbcUrl><o:p></o:p></span></p>
<p class="MsoNormal"><span class="DefaultFontHxMailStyle"> </repository><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 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?</p>
</div>
<p class="MsoNormal"><span class="DefaultFontHxMailStyle"><o:p> </o:p></span></p>
<p class="MsoNormal">I've read the documentation here:</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">https://wiki.evolveum.com/display/midPoint/Repository+Configuration#Rep</p>
<p class="MsoNormal">ositoryConfiguration-Datasourceconfiguration</p>
<p class="MsoNormal"><o:p> </o:p></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"><o:p> </o:p></p>
<p class="MsoNormal">I'm getting a variety of connection problems, likely due to timeouts,</p>
<p class="MsoNormal">and it looks like the only way to set those is via a datasource.</p>
<p class="MsoNormal"><o:p> </o:p></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"><span class="DefaultFontHxMailStyle"><o:p> </o:p></span></p>
</div>
<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>
<pre><br></pre>
</blockquote>
</body>
</html>