[midPoint] Installing MySQL Driver

[Solberg, Eric]

Hi Pavol,

 

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:

/opt/midpoint/lib:
midpoint.war
ninja-3.7.2.jar
ninja.jar
 

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.

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.

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. 

 

Thanks for the feedback.

 

From: midPoint <midpoint-bounces at lists.evolveum.com> on behalf of Pavol Mederly <mederly at evolveum.com>
Reply-To: midPoint General Discussion <midpoint at lists.evolveum.com>
Date: Wednesday, October 17, 2018 at 12:06 AM
To: <midpoint at lists.evolveum.com>
Subject: Re: [midPoint] Installing MySQL Driver

 

Hello Eric,

you can put the driver into the lib directory of the midPoint home.

Like here: https://spaces.at.internet2.edu/display/MID/External+repository+demo (this is a part of the TIER midPoint dockerization).

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.

Best regards,
Pavol Mederly
Software developer
evolveum.com
On 16.10.2018 18:41, Solberg, Eric wrote:
I've been playing with the Midpoint demo and now want to get a real installation set up.
 
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.
 
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:
jar uf0 ${MP_DIR}/lib/midpoint.war WEB-INF/lib/mysql-connector-java-8.0.12.jar
 
This seems to have worked (though I'm having another issue I'll ask about separately). 
 
Is there a better way?
 
 
_______________________________________________
midPoint mailing list
midPoint at lists.evolveum.com
http://lists.evolveum.com/mailman/listinfo/midpoint

_______________________________________________ midPoint mailing list midPoint at lists.evolveum.com http://lists.evolveum.com/mailman/listinfo/midpoint 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20181017/9f5dc892/attachment.htm>