<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>Hi Eric,</p>
<p>good point, I have just added a note to <a
href="https://wiki.evolveum.com/display/midPoint/MidPoint+Home+Directory">https://wiki.evolveum.com/display/midPoint/MidPoint+Home+Directory</a></p>
<p>I have only used this with stand-alone deployment, otherwise (=
in the old midPoints) I was using Tomcat's lib/ directory. So I'm
not sure if that would work for non-standalone too.</p>
<p>Best regards,</p>
<p>Ivan<br>
</p>
<div class="moz-cite-prefix">On 17. 10. 2018 19:02, Solberg, Eric
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:380A190E-3766-4FA7-8D79-21CBEB90A9A0@solberg.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:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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:Consolas;
panose-1:2 11 6 9 2 2 4 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;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
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";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Calibri",sans-serif;}
span.EmailStyle23
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:569384937;
mso-list-type:hybrid;
mso-list-template-ids:-1018679538 195213328 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Calibri",sans-serif;
mso-fareast-font-family:Calibri;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;}
@list l1
{mso-list-id:592856844;
mso-list-template-ids:-795825606;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">Gotcha – I probably didn’t try that. I’ll
add that to my list of things to try when I come back to this.
This is another thing you may want to make clear in the
installation documentation –<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">You’ll note that it isn’t mentioned here:<o:p></o:p></p>
<p class="MsoNormal"><a
href="https://wiki.evolveum.com/display/midPoint/Installing+MidPoint+Server"
moz-do-not-send="true">https://wiki.evolveum.com/display/midPoint/Installing+MidPoint+Server</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This one shows the directory structure of
midpoint home, but doesn’t mention lib:<o:p></o:p></p>
<p class="MsoNormal"><a
href="https://wiki.evolveum.com/display/midPoint/MidPoint+Home+Directory"
moz-do-not-send="true">https://wiki.evolveum.com/display/midPoint/MidPoint+Home+Directory</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Also not mentioned here:<o:p></o:p></p>
<p class="MsoNormal"><a
href="https://wiki.evolveum.com/display/midPoint/Repository+Configuration"
moz-do-not-send="true">https://wiki.evolveum.com/display/midPoint/Repository+Configuration</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This one does mention where to put the
driver- the wrong location!<o:p></o:p></p>
<p class="MsoNormal">“… insert driver (for instance
mysql-connector-java-5.1.30-bin.jar) on classpath either in
deployed midpoint */webapps/midPoint/WEB-INF/lib or in
*/apache-tomcat/lib”<o:p></o:p></p>
<p class="MsoNormal"><a
href="https://wiki.evolveum.com/display/midPoint/MySQL"
moz-do-not-send="true">https://wiki.evolveum.com/display/midPoint/MySQL</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Anyway I’m up and running now, and when I
come back to this I should be able to clean up and get my
docker-based repeatable deploy working as I had hoped.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal">Eric<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:none;border-top:solid #B5C4DF
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span
style="font-size:12.0pt;color:black">From: </span></b><span
style="font-size:12.0pt;color:black">midPoint
<a class="moz-txt-link-rfc2396E" href="mailto:midpoint-bounces@lists.evolveum.com"><midpoint-bounces@lists.evolveum.com></a> on behalf of
Pavol Mederly <a class="moz-txt-link-rfc2396E" href="mailto:mederly@evolveum.com"><mederly@evolveum.com></a><br>
<b>Reply-To: </b>midPoint General Discussion
<a class="moz-txt-link-rfc2396E" href="mailto:midpoint@lists.evolveum.com"><midpoint@lists.evolveum.com></a><br>
<b>Date: </b>Wednesday, October 17, 2018 at 8:55 AM<br>
<b>To: </b><a class="moz-txt-link-rfc2396E" href="mailto:midpoint@lists.evolveum.com"><midpoint@lists.evolveum.com></a><br>
<b>Subject: </b>Re: [midPoint] Installing MySQL Driver<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p>Hello Eric,<o:p></o:p></p>
<p>but I was referring to <u>/opt/midpoint/<b>var</b>/lib</u>
directory (not <u>/opt/midpoint/lib</u>), assuming midpoint
home is <u>/opt/midpoint/var</u>. This should work, as far as
you use embedded Tomcat (which is now the default way of
running midPoint).<o:p></o:p></p>
<p>But of course, you can modify midpoint.war; that's also a
way.<o:p></o:p></p>
<p class="MsoNormal">Best regards,<br>
<br>
<br>
<o:p></o:p></p>
<pre>Pavol Mederly<o:p></o:p></pre>
<pre>Software developer<o:p></o:p></pre>
<pre>evolveum.com<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<div>
<p class="MsoNormal">On 17.10.2018 17:35, Solberg, Eric wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal">Hi Pavol,<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">I’m pretty sure this is the first thing I
tried. But I think we may not be talking about the same
thing. I’m talking about the standard install for Midpoint
3.8. In this install, the lib file in midpoint home
contains:<o:p></o:p></p>
<p class="MsoNormal">/opt/midpoint/lib:<o:p></o:p></p>
<ul style="margin-top:0in" type="disc">
<li class="MsoListParagraph"
style="margin-left:0in;mso-list:l0 level1 lfo3">midpoint.war<o:p></o:p></li>
<li class="MsoListParagraph"
style="margin-left:0in;mso-list:l0 level1 lfo3">ninja-3.7.2.jar<o:p></o:p></li>
<li class="MsoListParagraph"
style="margin-left:0in;mso-list:l0 level1 lfo3">ninja.jar<o:p></o:p></li>
</ul>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">In this approach, following the
installation docs, everything is self-contained in the
midpoint.war file, right? I don’t think any java classes are
referenced external to this war that I could tell at least.<o:p></o:p></p>
<p class="MsoNormal">Putting the driver jar file here didn’t
work- and I couldn’t see anywhere where the classpath was
being set to look at the files in this directory.<o:p></o:p></p>
<p class="MsoNormal">On the other hand, inside of midpoint.war
there is a WEB-INF/lib directory that contains many jars,
that are on the classpath at runtime. Putting the driver in
that directory did work. It’s just an awkward approach to in
modify a distribution war file to add additional jars to it.
It seems the instructions that deal with drivers, and your
discussion below, are based on a different installation
approach. Of course, I may be totally confused as I was
chasing down many issues at once. <o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal">Thanks for the feedback.<o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<div style="border:none;border-top:solid #B5C4DF
1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span
style="font-size:12.0pt;color:black">From: </span></b><span
style="font-size:12.0pt;color:black">midPoint <a
href="mailto:midpoint-bounces@lists.evolveum.com"
moz-do-not-send="true"><midpoint-bounces@lists.evolveum.com></a>
on behalf of Pavol Mederly <a
href="mailto:mederly@evolveum.com"
moz-do-not-send="true"><mederly@evolveum.com></a><br>
<b>Reply-To: </b>midPoint General Discussion <a
href="mailto:midpoint@lists.evolveum.com"
moz-do-not-send="true"><midpoint@lists.evolveum.com></a><br>
<b>Date: </b>Wednesday, October 17, 2018 at 12:06 AM<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] Installing MySQL Driver</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
<p>Hello Eric,<o:p></o:p></p>
<p>you can put the driver into the <i>lib</i> directory of
the midPoint home.<o:p></o:p></p>
<p>Like here: <a
href="https://spaces.at.internet2.edu/display/MID/External+repository+demo"
moz-do-not-send="true">https://spaces.at.internet2.edu/display/MID/External+repository+demo</a>
(this is a part of the <a
href="https://spaces.at.internet2.edu/display/MID/Dockerized+midPoint"
moz-do-not-send="true">TIER midPoint dockerization</a>).<o:p></o:p></p>
<p>Note that some of the featured described there are specific
to upcoming 3.9 version, but this driver placement should
work for 3.8 as well.<o:p></o:p></p>
<p>Best regards,<o:p></o:p></p>
<pre>Pavol Mederly<o:p></o:p></pre>
<pre>Software developer<o:p></o:p></pre>
<pre>evolveum.com<o:p></o:p></pre>
<div>
<p class="MsoNormal">On 16.10.2018 18:41, Solberg, Eric
wrote:<o:p></o:p></p>
</div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<pre>I've been playing with the Midpoint demo and now want to get a real installation set up.<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>I'm using Google Cloud Platform and have made the demo work in a VM on the compute engine, and in a Kubernetes cluster. I've made both the binary install and the Docker install work. All good there.<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>The instructions seem to be incomplete or unclear on installation of the MySQL driver. Where to put the driver so it is on the class path? Or how to modify the classpath to include it? After a lot of trial and error, the approach I found that worked was to add the driver jar to midpoint.war - and specifically adding it without compression (0 flag), using this command:<o:p></o:p></pre>
<pre>jar uf0 ${MP_DIR}/lib/midpoint.war WEB-INF/lib/mysql-connector-java-8.0.12.jar<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>This seems to have worked (though I'm having another issue I'll ask about separately). <o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>Is there a better way?<o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>midPoint mailing list<o:p></o:p></pre>
<pre><a href="mailto:midPoint@lists.evolveum.com" moz-do-not-send="true">midPoint@lists.evolveum.com</a><o:p></o:p></pre>
<pre><a href="http://lists.evolveum.com/mailman/listinfo/midpoint" moz-do-not-send="true">http://lists.evolveum.com/mailman/listinfo/midpoint</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><br>
_______________________________________________ midPoint
mailing list <a href="mailto:midPoint@lists.evolveum.com"
moz-do-not-send="true">midPoint@lists.evolveum.com</a> <a
href="http://lists.evolveum.com/mailman/listinfo/midpoint"
moz-do-not-send="true">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
<o:p></o:p></p>
<p class="MsoNormal"><br>
<br>
<br>
<o:p></o:p></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>midPoint mailing list<o:p></o:p></pre>
<pre><a href="mailto:midPoint@lists.evolveum.com" moz-do-not-send="true">midPoint@lists.evolveum.com</a><o:p></o:p></pre>
<pre><a href="http://lists.evolveum.com/mailman/listinfo/midpoint" moz-do-not-send="true">http://lists.evolveum.com/mailman/listinfo/midpoint</a><o:p></o:p></pre>
</blockquote>
<p class="MsoNormal"><br>
_______________________________________________ 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="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a> <o:p></o:p></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="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Ivan Noris
Senior Identity Engineer
evolveum.com
</pre>
</body>
</html>