<div dir="ltr">disabled the service account and ran from the script and it worked. I can go back and fix the service account later, thank you so much for the help.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Mar 24, 2021 at 9:41 AM <<a href="mailto:midpoint-request@lists.evolveum.com">midpoint-request@lists.evolveum.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send midPoint mailing list submissions to<br>
<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:midpoint-request@lists.evolveum.com" target="_blank">midpoint-request@lists.evolveum.com</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:midpoint-owner@lists.evolveum.com" target="_blank">midpoint-owner@lists.evolveum.com</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of midPoint digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. Message Configuration error: JDBC Driver is not found on<br>
classpath (Keith LeValley)<br>
2. Re: Message Configuration error: JDBC Driver is not found on<br>
classpath (Sven Lukrafka)<br>
3. Re: Message Configuration error: JDBC Driver is not found on<br>
classpath (Richard Richter)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Wed, 24 Mar 2021 09:23:45 -0400<br>
From: Keith LeValley <<a href="mailto:klevalley2@davenport.edu" target="_blank">klevalley2@davenport.edu</a>><br>
To: <a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a><br>
Subject: [midPoint] Message Configuration error: JDBC Driver is not<br>
found on classpath<br>
Message-ID:<br>
<CAAkzTLz+_j==3kqnVksxjFF8Ca=_<a href="mailto:sgXNMWRKXVsREuGoUL%2BPYA@mail.gmail.com" target="_blank">sgXNMWRKXVsREuGoUL+PYA@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
I am having trouble trying to connect to an Oracle database using the<br>
Database table connector v1.4.4.0<br>
<br>
I have already downloaded the ojdbc8.jar file and have placed it in the<br>
locations below:<br>
<br>
[root@midPointDemo var]# find / -name ojdbc8.jar<br>
/opt/midpoint-4.2/var/lib/ojdbc8.jar<br>
/opt/midpoint-4.2/var/ojdbc8.jar<br>
/opt/midpoint-4.2/lib/ojdbc8.jar<br>
<br>
-----------------------------------------------------------------------------<br>
Below is my service file that I use to run midpoint:<br>
<br>
[Unit]<br>
Description=MidPoint Standalone Service<br>
[Service]<br>
User=midpoint<br>
WorkingDirectory=/opt/midpoint-4.2<br>
ExecStart=/usr/bin/java -Xmx2048m -Dmidpoint.home=/opt/midpoint-4.2/var<br>
-jar /opt/midpoint-4.2/lib/midpoint.war<br>
SuccessExitStatus=143<br>
[Install]<br>
WantedBy=multi-user.target<br>
<br>
---------------------------------------------------------------------------------<br>
This is the config I am using for the class path<br>
<br>
<gen699:jdbcDriver>oracle.jdbc.OracleDriver</gen699:jdbcDriver><br>
<br>
I have also tried oracle.jdbc,driver.OracleDriver and neither are working.<br>
The error I am getting is:<br>
<br>
OperationICF schemaMessageConfiguration error: JDBC Driver is not found on<br>
classpath.Context<br>
connector [class<br>
org.identityconnectors.framework.impl.api.local.LocalConnectorFacadeImpl]<br>
ErrorConfiguration error: JDBC Driver is not found on<br>
classpath.showcom.evolveum.midpoint.util.exception.ConfigurationException:<br>
Configuration error: JDBC Driver is not found on classpath.<br>
<br>
<br>
<br>
Not really sure where to troubleshoot from here. My assumption is the<br>
ojdbc8.jar file isn't getting picked up by midpoint but I have tried<br>
placing it every location I can think off where midpoint might look, any<br>
suggestions or help would be appreciated.<br>
<br>
PS- I did cat the jar and it is in fact a binary file, I have restarted<br>
both the service and the server itself multiple times, and I changed the<br>
ownership of the jar to the midpoint service account just to ensure it<br>
wasn't a strange permissions issue.<br>
<br>
-- <br>
Keith LeValley<br>
Identity Services Architect, Davenport University<br>
phone: (616) 732-1102<br>
<a href="mailto:klevalley2@davenport.edu" target="_blank">klevalley2@davenport.edu</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="https://lists.evolveum.com/pipermail/midpoint/attachments/20210324/3525319f/attachment-0001.htm" rel="noreferrer" target="_blank">https://lists.evolveum.com/pipermail/midpoint/attachments/20210324/3525319f/attachment-0001.htm</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 24 Mar 2021 14:30:57 +0100<br>
From: Sven Lukrafka <<a href="mailto:sven.lukrafka@daasi.de" target="_blank">sven.lukrafka@daasi.de</a>><br>
To: Keith LeValley via midPoint <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br>
Subject: Re: [midPoint] Message Configuration error: JDBC Driver is<br>
not found on classpath<br>
Message-ID: <<a href="mailto:275c1ad7-1c5a-4441-05d9-4d70b5608075@daasi.de" target="_blank">275c1ad7-1c5a-4441-05d9-4d70b5608075@daasi.de</a>><br>
Content-Type: text/plain; charset="utf-8"; Format="flowed"<br>
<br>
Hello Keith,<br>
<br>
you might want to use "oracle.jdbc.driver.OracleDriver" instead of <br>
"oracle.jdbc.OracleDriver".<br>
<br>
<br>
Best regards,<br>
<br>
Sven<br>
<br>
<br>
Am 24.03.21 um 14:23 schrieb Keith LeValley via midPoint:<br>
> I am having trouble trying to connect to an Oracle database using the <br>
> Database table connector v1.4.4.0<br>
><br>
> I have already downloaded the ojdbc8.jar file and have placed it in <br>
> the locations below:<br>
><br>
> [root@midPointDemo var]# find / -name ojdbc8.jar<br>
> /opt/midpoint-4.2/var/lib/ojdbc8.jar<br>
> /opt/midpoint-4.2/var/ojdbc8.jar<br>
> /opt/midpoint-4.2/lib/ojdbc8.jar<br>
><br>
> -----------------------------------------------------------------------------<br>
> Below is my service file that I use to run midpoint:<br>
><br>
> [Unit]<br>
> Description=MidPoint Standalone Service<br>
> [Service]<br>
> User=midpoint<br>
> WorkingDirectory=/opt/midpoint-4.2<br>
> ExecStart=/usr/bin/java -Xmx2048m <br>
> -Dmidpoint.home=/opt/midpoint-4.2/var -jar <br>
> /opt/midpoint-4.2/lib/midpoint.war<br>
> SuccessExitStatus=143<br>
> [Install]<br>
> WantedBy=multi-user.target<br>
><br>
> ---------------------------------------------------------------------------------<br>
> This is the config I am using for the class path<br>
><br>
> <gen699:jdbcDriver>oracle.jdbc.OracleDriver</gen699:jdbcDriver><br>
><br>
> I have also tried oracle.jdbc,driver.OracleDriver and neither are <br>
> working. The error I am getting is:<br>
><br>
> Operation<br>
> ICF schema<br>
> Message<br>
> Configuration error: JDBC Driver is not found on classpath.<br>
><br>
> Context<br>
> connector [class<br>
> org.identityconnectors.framework.impl.api.local.LocalConnectorFacadeImpl]<br>
><br>
><br>
> Error<br>
> Configuration error: JDBC Driver is not found on classpath.<br>
> show<br>
> com.evolveum.midpoint.util.exception.ConfigurationException:<br>
> Configuration error: JDBC Driver is not found on classpath.<br>
><br>
><br>
><br>
> Not really sure where to troubleshoot from here. My assumption is the <br>
> ojdbc8.jar file isn't getting picked up by midpoint but I have tried <br>
> placing it every location I can think off where midpoint might look, <br>
> any suggestions or help would be appreciated.<br>
><br>
> PS- I did cat the jar and it is in fact a binary file, I have <br>
> restarted both the service and the server itself multiple times, and I <br>
> changed the ownership of the jar to the midpoint service account just <br>
> to ensure it wasn't a strange permissions issue.<br>
><br>
> -- <br>
> Keith LeValley<br>
> Identity Services Architect, Davenport University<br>
> phone: (616) 732-1102<br>
> <a href="mailto:klevalley2@davenport.edu" target="_blank">klevalley2@davenport.edu</a><br>
> <mailto:<a href="mailto:klevalley2@davenport.edu" target="_blank">klevalley2@davenport.edu</a>><br>
><br>
> _______________________________________________<br>
> midPoint mailing list<br>
> <a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
> <a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="https://lists.evolveum.com/pipermail/midpoint/attachments/20210324/12c4ed1d/attachment-0001.htm" rel="noreferrer" target="_blank">https://lists.evolveum.com/pipermail/midpoint/attachments/20210324/12c4ed1d/attachment-0001.htm</a>><br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Wed, 24 Mar 2021 14:40:57 +0100 (CET)<br>
From: Richard Richter <<a href="mailto:virgo@evolveum.com" target="_blank">virgo@evolveum.com</a>><br>
To: midPoint General Discussion <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>><br>
Subject: Re: [midPoint] Message Configuration error: JDBC Driver is<br>
not found on classpath<br>
Message-ID:<br>
<<a href="mailto:927803859.676806.1616593257744.JavaMail.zimbra@evolveum.com" target="_blank">927803859.676806.1616593257744.JavaMail.zimbra@evolveum.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi, <br>
<br>
with midPoint 4.2 the real issue is different. The startup command line changed and the critical missing option is here: <br>
[ <a href="https://github.com/Evolveum/midpoint/blob/master/dist/src/main/bin/midpoint.bat#L75" rel="noreferrer" target="_blank">https://github.com/Evolveum/midpoint/blob/master/dist/src/main/bin/midpoint.bat#L75</a> | <a href="https://github.com/Evolveum/midpoint/blob/master/dist/src/main/bin/midpoint.bat#L75" rel="noreferrer" target="_blank">https://github.com/Evolveum/midpoint/blob/master/dist/src/main/bin/midpoint.bat#L75</a> ] <br>
<br>
That is: -Dloader.path=WEB-INF/classes,WEB-INF/lib,WEB-INF/lib-provided, %MIDPOINT_HOME% \lib <br>
(the ^ character is to continue with the line and probably not relevant for your case) <br>
<br>
Please, adjust it accordingly for your case, replace %MIDPOINT_HOME% with the actual value. Hope this helps and sorry about this change, but it was necessary on our path to newer Spring Boot. We're considering some options how to hide this hassle, but at this moment this is the way and affects everyone who does not use our scripts. (And yes, I'm aware we broke the support for Windows service, it's actually part of this change and at this moment we don't have a fix. Sorry about it too.) <br>
<br>
Best regards <br>
<br>
Richard Richter <br>
midPoint developer <br>
<br>
<br>
From: "midPoint General Discussion" <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>> <br>
To: "midPoint General Discussion" <<a href="mailto:midpoint@lists.evolveum.com" target="_blank">midpoint@lists.evolveum.com</a>> <br>
Cc: "Sven Lukrafka" <<a href="mailto:sven.lukrafka@daasi.de" target="_blank">sven.lukrafka@daasi.de</a>> <br>
Sent: Wednesday, March 24, 2021 2:30:57 PM <br>
Subject: Re: [midPoint] Message Configuration error: JDBC Driver is not found on classpath <br>
<br>
<br>
<br>
Hello Keith, <br>
<br>
you might want to use "oracle.jdbc.driver.OracleDriver" instead of "oracle.jdbc.OracleDriver". <br>
<br>
<br>
<br>
<br>
Best regards, <br>
<br>
Sven <br>
<br>
<br>
<br>
Am 24.03.21 um 14:23 schrieb Keith LeValley via midPoint: <br>
<br>
<br>
<br>
I am having trouble trying to connect to an Oracle database using the Database table connector v1.4.4.0 <br>
<br>
I have already downloaded the ojdbc8.jar file and have placed it in the locations below: <br>
<br>
[root@midPointDemo var]# find / -name ojdbc8.jar <br>
/opt/midpoint-4.2/var/lib/ojdbc8.jar <br>
/opt/midpoint-4.2/var/ojdbc8.jar <br>
/opt/midpoint-4.2/lib/ojdbc8.jar <br>
<br>
----------------------------------------------------------------------------- <br>
Below is my service file that I use to run midpoint: <br>
<br>
[Unit] <br>
Description=MidPoint Standalone Service <br>
[Service] <br>
User=midpoint <br>
WorkingDirectory=/opt/midpoint-4.2 <br>
ExecStart=/usr/bin/java -Xmx2048m -Dmidpoint.home=/opt/midpoint-4.2/var -jar /opt/midpoint-4.2/lib/midpoint.war <br>
SuccessExitStatus=143 <br>
[Install] <br>
WantedBy=multi-user.target <br>
<br>
--------------------------------------------------------------------------------- <br>
This is the config I am using for the class path <br>
<br>
<gen699:jdbcDriver>oracle.jdbc.OracleDriver</gen699:jdbcDriver> <br>
<br>
I have also tried oracle.jdbc,driver.OracleDriver and neither are working. The error I am getting is: <br>
<br>
Operation ICF schema Message Configuration error: JDBC Driver is not found on classpath. Context connector [class org.identityconnectors.framework.impl.api.local.LocalConnectorFacadeImpl] Error Configuration error: JDBC Driver is not found on classpath. show <br>
com.evolveum.midpoint.util.exception.ConfigurationException: Configuration error: JDBC Driver is not found on classpath. <br>
<br>
<br>
<br>
Not really sure where to troubleshoot from here. My assumption is the ojdbc8.jar file isn't getting picked up by midpoint but I have tried placing it every location I can think off where midpoint might look, any suggestions or help would be appreciated. <br>
<br>
PS- I did cat the jar and it is in fact a binary file, I have restarted both the service and the server itself multiple times, and I changed the ownership of the jar to the midpoint service account just to ensure it wasn't a strange permissions issue. <br>
<br>
-- <br>
Keith LeValley <br>
Identity Services Architect , Davenport University <br>
phone: (616) 732-1102 <br>
[ mailto:<a href="mailto:klevalley2@davenport.edu" target="_blank">klevalley2@davenport.edu</a> | <a href="mailto:klevalley2@davenport.edu" target="_blank">klevalley2@davenport.edu</a><br>
] <br>
<br>
_______________________________________________<br>
midPoint mailing list [ mailto:<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a> | <a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a> ] [ <a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a> | <a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a> ] <br>
<br>
<br>
<br>
_______________________________________________ <br>
midPoint mailing list <br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a> <br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a> <br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="https://lists.evolveum.com/pipermail/midpoint/attachments/20210324/d6255bbc/attachment.htm" rel="noreferrer" target="_blank">https://lists.evolveum.com/pipermail/midpoint/attachments/20210324/d6255bbc/attachment.htm</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<br>
_______________________________________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com" target="_blank">midPoint@lists.evolveum.com</a><br>
<a href="https://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">https://lists.evolveum.com/mailman/listinfo/midpoint</a><br>
<br>
<br>
------------------------------<br>
<br>
End of midPoint Digest, Vol 107, Issue 16<br>
*****************************************<br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr">Keith LeValley<br><div><font face="arial, helvetica, sans-serif">Identity Services Architect</font>, Davenport University</div><div>phone: (616) 732-1102</div><div><a href="mailto:klevalley2@davenport.edu" target="_blank">klevalley2@davenport.edu<br></a></div></div></div></div></div></div></div></div></div>