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 cas-user+unsubscr...@apereo.org.
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.

Reply via email to