<html xmlns:v="urn:schemas-microsoft-com:vml" 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: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]--></head><body lang=EN-US link=blue vlink=purple><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">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">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">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">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 <midpoint-bounces@lists.evolveum.com> on behalf of Pavol Mederly <mederly@evolveum.com><br><b>Reply-To: </b>midPoint General Discussion <midpoint@lists.evolveum.com><br><b>Date: </b>Wednesday, October 17, 2018 at 8:55 AM<br><b>To: </b><midpoint@lists.evolveum.com><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"><midpoint-bounces@lists.evolveum.com></a> on behalf of Pavol Mederly <a href="mailto:mederly@evolveum.com"><mederly@evolveum.com></a><br><b>Reply-To: </b>midPoint General Discussion <a href="mailto:midpoint@lists.evolveum.com"><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"><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">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">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">midPoint@lists.evolveum.com</a><o:p></o:p></pre><pre><a href="http://lists.evolveum.com/mailman/listinfo/midpoint">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">midPoint@lists.evolveum.com</a> <a href="http://lists.evolveum.com/mailman/listinfo/midpoint">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">midPoint@lists.evolveum.com</a><o:p></o:p></pre><pre><a href="http://lists.evolveum.com/mailman/listinfo/midpoint">http://lists.evolveum.com/mailman/listinfo/midpoint</a><o:p></o:p></pre></blockquote><p class=MsoNormal><br>_______________________________________________ midPoint mailing list midPoint@lists.evolveum.com http://lists.evolveum.com/mailman/listinfo/midpoint <o:p></o:p></p></div></body></html>