Hi Pandu, The requirement of "Custom Password Encoder with MD5,SHA-256 based on the third party application" doesn't seems to be available out of the box yet in latest CAS version,
[as seem here: "https://apereo.github.io/cas/5.3.x/installation/Configuration-Properties-Common.html#password-encoding";] What you can try is create your custom password encoding by following the paragraph under the link above. I do think it will take some time to implement such feature. Cheers! - Andy On Thursday, 23 August 2018 21:30:48 UTC+8, Ranga Nadha wrote: > > Hi Andy/Colin, > > Thanks for the reply, I have added the OJDB dependency in the pom.xml and > the exception is gone. > > Now CAS is connecting to the database for authentication purpose. > > But the problem is we have a custom password encoder, MD5,SHA-256 based on > the third party application rule the encoding format will decide. > > So, our requirement is to call the third party application > passwordEncoding class for the encodingAlgorithm. > > Could you please tell me how to set the third-party class in the > application.properties for passwordEncryption. > > Thanks, > Pandu Ranga T. > > On Tuesday, 21 August 2018 21:19:46 UTC+5:30, 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/9523dffc-0096-4a35-a7c7-04bb6d265d20%40apereo.org.
