Here is what we added for oracle setup:
sadf
<dependency>
<groupId>org.apereo.cas</groupId>
<artifactId>cas-server-support-jdbc-drivers</artifactId>
<version>${cas.version}</version>
</dependency>
<dependency>
<groupId>com.oracle.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>12.2.0.1</version>
</dependency>
Next add the ojdbc8.jar into the folder jdbc/oracle/ojdbc8.jar
[image: oracleJar.PNG] <about:invalid#zClosurez>
We are using Oracle for just attribute resolution and AD LDAP for
credentials.
Here is our attribute resolution for Oracle:
# # Oracle Database Attribute query
cas.authn.attributeRepository.jdbc[0].attributes.GOBUMAP_UDC_ID=
UDC_IDENTIFIER
cas.authn.attributeRepository.jdbc[0].username= GOBTPAC_EXTERNAL_USER
cas.authn.attributeRepository.jdbc[0].singleRow= true
cas.authn.attributeRepository.jdbc[0].sql= select GOBUMAP_UDC_ID from
GOBUMAP INNER JOIN GOBTPAC on GOBTPAC.GOBTPAC_PIDM = GOBUMAP.GOBUMAP_PIDM
where upper(GOBTPAC_EXTERNAL_USER)=upper(?)
cas.authn.attributeRepository.jdbc[0].GOBTPAC_EXTERNAL_USER= uid
cas.authn.attributeRepository.jdbc[0].healthQuery= SELECT 1 FROM DUAL
cas.authn.attributeRepository.jdbc[0].isolateInternalQueries= false
cas.authn.attributeRepository.jdbc[0].url=
jdbc:oracle:thin:@//hostname:1521/PROD.example.edu
cas.authn.attributeRepository.jdbc[0].dialect=
org.hibernate.dialect.Oracle12cDialect
cas.authn.attributeRepository.jdbc[0].user= casUDCuser
cas.authn.attributeRepository.jdbc[0].password= asdf
cas.authn.attributeRepository.jdbc[0].driverClass= oracle.jdbc.OracleDriver
Hope this helps!
On Tuesday, August 21, 2018 at 10:49:46 AM UTC-5, Ranga Nadha wrote:
>
> Hi Everyone,
>
> We are using CAS 5.1.8 and I am trying to connect to the database for
> authentication purpose.
>
> I have followed the below procedure but I am getting exceptions.
>
>
> - Downloaded the CAS 5.1.8
> - Modify POM.xml with the following dependency
>
> <dependency>
> <groupId>org.apereo.cas</groupId>
> <artifactId>cas-server-support-jdbc</artifactId>
> <version>${cas.version}</version>
> <exclusions>
> <exclusion>
> <artifactId>log4j-slf4j-impl</artifactId>
> </exclusion>
> <exclusion>
> <groupId>org.codehaus.groovy</groupId>
> <artifactId>groovy-jsr223</artifactId>
> </exclusion>
> </exclusions>
> </dependency>
> <dependency>
> <groupId>org.apereo.cas</groupId>
> <artifactId>cas-server-support-jdbc-drivers</artifactId>
> <version>${cas.version}</version>
> </dependency>
> <dependency>
> <groupId>org.apereo.cas</groupId>
> <artifactId>cas-server-support-jdbc-authentication</artifactId>
> <version>${cas.version}</version>
> </dependency>
>
> - Build cas project using mvn clean install.
> - Take the war file and deploy in tomcat.
> - In the extracted cas war.
> - Go to Tomcat/webapps/cas/WEB-INF/classes/appliation.properties and
> add the below properties.
>
> cas.authn.jdbc.query[0].sql=SELECT * FROM USERS WHERE USER_ID=?
> cas.authn.jdbc.query[0].url=jdbc:oracle:thin:@xxx.xxxx.local:1521:db12c
> cas.authn.jdbc.query[0].dialect=org.hibernate.dialect.Oracle12cDialect
> cas.authn.jdbc.query[0].user=xxxx
> cas.authn.jdbc.query[0].password=xxxx
> cas.authn.jdbc.query[0].driverClass=oracle.jdbc.OracleDriver
> cas.authn.jdbc.query[0].fieldPassword=PASSWORD
> cas.authn.jdbc.query[0].passwordEncoder.type=DEFAULT
> cas.authn.jdbc.query[0].passwordEncoder.characterEncoding=UTF-8
> cas.authn.jdbc.query[0].passwordEncoder.encodingAlgorithm=SHA1
> cas.authn.jdbc.query[0].passwordEncoder.secret=
> cas.authn.jdbc.query[0].passwordEncoder.strength=16
>
>
> cas.authn.accept.users=
> logging.level.org.apereo=DEBUG
>
> *I am getting the below error*
>
> 2018-08-21 21:00:02,828 DEBUG
> [org.apereo.cas.adaptors.jdbc.config.CasJdbcAuthenticationConfiguration] -
> <Created and mapped principal attributes [{givenName=givenNa
> me, sn=sn, cn=commonName}] for
> [jdbc:oracle:thin:@xxxx.xxxx.local:1521:dev12c]...>
> 2018-08-21 21:00:02,870 ERROR [com.zaxxer.hikari.HikariConfig] - <Failed
> to load class of driverClassName oracle.jdbc.OracleDriver in HikariConfig
> class classloader
> ParallelWebappClassLoader
> context: cas
> delegate: false
> ----------> Parent Classloader:
> java.net.URLClassLoader@13221655
> >
> 2018-08-21 21:00:02,870 ERROR [org.apereo.cas.configuration.support.Beans]
> - <Error creating DataSource: [Failed to load class of driverClassName
> [oracle.jdbc.Oracle
> Driver] in either of HikariConfig class loader or Thread context
> classloader]>
>
> Can any one help to resolve this issue.
>
> Thanks in advance,
>
> Thanks,
> Pandu Ranga T.
>
--
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
---
You received this message because you are subscribed to the Google Groups "CAS
Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/0fc03805-e2a8-4b62-afeb-751c6f0cbc1d%40apereo.org.
