[midPoint] midPoint Digest, Vol 107, Issue 16

Wed Mar 24 15:26:39 CET 2021

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.

On Wed, Mar 24, 2021 at 9:41 AM <midpoint-request at lists.evolveum.com> wrote:

> Send midPoint mailing list submissions to
>         midpoint at lists.evolveum.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.evolveum.com/mailman/listinfo/midpoint
> or, via email, send a message with subject or body 'help' to
>         midpoint-request at lists.evolveum.com
>
> You can reach the person managing the list at
>         midpoint-owner at lists.evolveum.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of midPoint digest..."
>
>
> Today's Topics:
>
>    1. Message Configuration error: JDBC Driver is not found on
>       classpath (Keith LeValley)
>    2. Re: Message Configuration error: JDBC Driver is not found on
>       classpath (Sven Lukrafka)
>    3. Re: Message Configuration error: JDBC Driver is not found on
>       classpath (Richard Richter)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 24 Mar 2021 09:23:45 -0400
> From: Keith LeValley <klevalley2 at davenport.edu>
> To: midpoint at lists.evolveum.com
> Subject: [midPoint] Message Configuration error: JDBC Driver is not
>         found on classpath
> Message-ID:
>         <CAAkzTLz+_j==3kqnVksxjFF8Ca=_
> sgXNMWRKXVsREuGoUL+PYA at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> I am having trouble trying to connect to an Oracle database using the
> Database table connector v1.4.4.0
>
> I have already downloaded the ojdbc8.jar file and have placed it in the
> locations below:
>
> [root at midPointDemo var]# find / -name ojdbc8.jar
> /opt/midpoint-4.2/var/lib/ojdbc8.jar
> /opt/midpoint-4.2/var/ojdbc8.jar
> /opt/midpoint-4.2/lib/ojdbc8.jar
>
>
> -----------------------------------------------------------------------------
> Below is my service file that I use to run midpoint:
>
> [Unit]
> Description=MidPoint Standalone Service
> [Service]
> User=midpoint
> WorkingDirectory=/opt/midpoint-4.2
> ExecStart=/usr/bin/java -Xmx2048m -Dmidpoint.home=/opt/midpoint-4.2/var
> -jar /opt/midpoint-4.2/lib/midpoint.war
> SuccessExitStatus=143
> [Install]
> WantedBy=multi-user.target
>
>
> ---------------------------------------------------------------------------------
> This is the config I am using for the class path
>
> <gen699:jdbcDriver>oracle.jdbc.OracleDriver</gen699:jdbcDriver>
>
> I have also tried oracle.jdbc,driver.OracleDriver and neither are working.
> The error I am getting is:
>
> OperationICF schemaMessageConfiguration error: JDBC Driver is not found on
> classpath.Context
> connector [class
> org.identityconnectors.framework.impl.api.local.LocalConnectorFacadeImpl]
> ErrorConfiguration error: JDBC Driver is not found on
> classpath.showcom.evolveum.midpoint.util.exception.ConfigurationException:
> Configuration error: JDBC Driver is not found on classpath.
>
>
>
> 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.
>
> 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.
>
> --
> Keith LeValley
> Identity Services Architect, Davenport University
> phone:  (616) 732-1102
> klevalley2 at davenport.edu
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> https://lists.evolveum.com/pipermail/midpoint/attachments/20210324/3525319f/attachment-0001.htm
> >
>
> ------------------------------
>
> Message: 2
> Date: Wed, 24 Mar 2021 14:30:57 +0100
> From: Sven Lukrafka <sven.lukrafka at daasi.de>
> To: Keith LeValley via midPoint <midpoint at lists.evolveum.com>
> Subject: Re: [midPoint] Message Configuration error: JDBC Driver is
>         not found on classpath
> Message-ID: <275c1ad7-1c5a-4441-05d9-4d70b5608075 at daasi.de>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>
> Hello Keith,
>
> you might want to use "oracle.jdbc.driver.OracleDriver" instead of
> "oracle.jdbc.OracleDriver".
>
>
> Best regards,
>
> Sven
>
>
> Am 24.03.21 um 14:23 schrieb Keith LeValley via midPoint:
> > I am having trouble trying to connect to an Oracle database using the
> > Database table connector v1.4.4.0
> >
> > I have already downloaded the ojdbc8.jar file and have placed it in
> > the locations below:
> >
> > [root at midPointDemo var]# find / -name ojdbc8.jar
> > /opt/midpoint-4.2/var/lib/ojdbc8.jar
> > /opt/midpoint-4.2/var/ojdbc8.jar
> > /opt/midpoint-4.2/lib/ojdbc8.jar
> >
> >
> -----------------------------------------------------------------------------
> > Below is my service file that I use to run midpoint:
> >
> > [Unit]
> > Description=MidPoint Standalone Service
> > [Service]
> > User=midpoint
> > WorkingDirectory=/opt/midpoint-4.2
> > ExecStart=/usr/bin/java -Xmx2048m
> > -Dmidpoint.home=/opt/midpoint-4.2/var -jar
> > /opt/midpoint-4.2/lib/midpoint.war
> > SuccessExitStatus=143
> > [Install]
> > WantedBy=multi-user.target
> >
> >
> ---------------------------------------------------------------------------------
> > This is the config I am using for the class path
> >
> > <gen699:jdbcDriver>oracle.jdbc.OracleDriver</gen699:jdbcDriver>
> >
> > I have also tried oracle.jdbc,driver.OracleDriver and neither are
> > working.  The error I am getting is:
> >
> > 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
> >     com.evolveum.midpoint.util.exception.ConfigurationException:
> >     Configuration error: JDBC Driver is not found on classpath.
> >
> >
> >
> > 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.
> >
> > 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.
> >
> > --
> > Keith LeValley
> > Identity Services Architect, Davenport University
> > phone:  (616) 732-1102
> > klevalley2 at davenport.edu
> > <mailto:klevalley2 at davenport.edu>
> >
> > _______________________________________________
> > midPoint mailing list
> > midPoint at lists.evolveum.com
> > https://lists.evolveum.com/mailman/listinfo/midpoint
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> https://lists.evolveum.com/pipermail/midpoint/attachments/20210324/12c4ed1d/attachment-0001.htm
> >
>
> ------------------------------
>
> Message: 3
> Date: Wed, 24 Mar 2021 14:40:57 +0100 (CET)
> From: Richard Richter <virgo at evolveum.com>
> To: midPoint General Discussion <midpoint at lists.evolveum.com>
> Subject: Re: [midPoint] Message Configuration error: JDBC Driver is
>         not found on classpath
> Message-ID:
>         <927803859.676806.1616593257744.JavaMail.zimbra at evolveum.com>
> Content-Type: text/plain; charset="utf-8"
>
> Hi,
>
> with midPoint 4.2 the real issue is different. The startup command line
> changed and the critical missing option is here:
> [
> https://github.com/Evolveum/midpoint/blob/master/dist/src/main/bin/midpoint.bat#L75
> |
> https://github.com/Evolveum/midpoint/blob/master/dist/src/main/bin/midpoint.bat#L75
> ]
>
> That is: -Dloader.path=WEB-INF/classes,WEB-INF/lib,WEB-INF/lib-provided,
> %MIDPOINT_HOME% \lib
> (the ^ character is to continue with the line and probably not relevant
> for your case)
>
> 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.)
>
> Best regards
>
> Richard Richter
> midPoint developer
>
>
> From: "midPoint General Discussion" <midpoint at lists.evolveum.com>
> To: "midPoint General Discussion" <midpoint at lists.evolveum.com>
> Cc: "Sven Lukrafka" <sven.lukrafka at daasi.de>
> Sent: Wednesday, March 24, 2021 2:30:57 PM
> Subject: Re: [midPoint] Message Configuration error: JDBC Driver is not
> found on classpath
>
>
>
> Hello Keith,
>
> you might want to use "oracle.jdbc.driver.OracleDriver" instead of
> "oracle.jdbc.OracleDriver".
>
>
>
>
> Best regards,
>
> Sven
>
>
>
> Am 24.03.21 um 14:23 schrieb Keith LeValley via midPoint:
>
>
>
> I am having trouble trying to connect to an Oracle database using the
> Database table connector v1.4.4.0
>
> I have already downloaded the ojdbc8.jar file and have placed it in the
> locations below:
>
> [root at midPointDemo var]# find / -name ojdbc8.jar
> /opt/midpoint-4.2/var/lib/ojdbc8.jar
> /opt/midpoint-4.2/var/ojdbc8.jar
> /opt/midpoint-4.2/lib/ojdbc8.jar
>
> -----------------------------------------------------------------------------
>
> Below is my service file that I use to run midpoint:
>
> [Unit]
> Description=MidPoint Standalone Service
> [Service]
> User=midpoint
> WorkingDirectory=/opt/midpoint-4.2
> ExecStart=/usr/bin/java -Xmx2048m -Dmidpoint.home=/opt/midpoint-4.2/var
> -jar /opt/midpoint-4.2/lib/midpoint.war
> SuccessExitStatus=143
> [Install]
> WantedBy=multi-user.target
>
> ---------------------------------------------------------------------------------
>
> This is the config I am using for the class path
>
> <gen699:jdbcDriver>oracle.jdbc.OracleDriver</gen699:jdbcDriver>
>
> I have also tried oracle.jdbc,driver.OracleDriver and neither are working.
> The error I am getting is:
>
> 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
> com.evolveum.midpoint.util.exception.ConfigurationException: Configuration
> error: JDBC Driver is not found on classpath.
>
>
>
> 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.
>
> 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.
>
> --
> Keith LeValley
> Identity Services Architect , Davenport University
> phone: (616) 732-1102
> [ mailto:klevalley2 at davenport.edu | klevalley2 at davenport.edu
>                              ]
>
> _______________________________________________
> midPoint mailing list [ mailto:midPoint at lists.evolveum.com |
> midPoint at lists.evolveum.com ] [
> https://lists.evolveum.com/mailman/listinfo/midpoint |
> https://lists.evolveum.com/mailman/listinfo/midpoint ]
>
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> https://lists.evolveum.com/mailman/listinfo/midpoint
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> https://lists.evolveum.com/pipermail/midpoint/attachments/20210324/d6255bbc/attachment.htm
> >
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> https://lists.evolveum.com/mailman/listinfo/midpoint
>
>
> ------------------------------
>
> End of midPoint Digest, Vol 107, Issue 16
> *****************************************
>

-- 
Keith LeValley
Identity Services Architect, Davenport University
phone:  (616) 732-1102
klevalley2 at davenport.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20210324/1a0307a6/attachment-0001.htm>