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