There are two questions here, MySql and encryption key warnings. For MySql, use cas version in the pom and report on the errors for that config. For encryption key warnings, your field names for cas.tgc... and cas.webflow... are different than what is in the docs, https://apereo.github.io/cas/5.1.x/installation/Configuration-Properties.html#. Perhaps you are using values from CAS 4.x?
Ray On Mon, 2017-12-04 at 07:30 -0800, noumann.f wrote: Hi, I'm trying to deploy the CAS 5.1.x using Maven overlay from here: https://github.com/apereo/cas-overlay-template/tree/5.1 I want to activate the Database authentication from MySql database following up the formal documentation. It fails to authenticate me with the following WARN in the log: WARN [org.apereo.cas.authentication.PolicyBasedAuthenticationManager] - <Authentication has failed. Credentials may be incorrect or CAS cannot find authentication handler that supports [user1] of type [UsernamePasswordCredential], which suggests a configuration problem.> Here is the modifications in the POM file: <dependency> <groupId>org.jasig.cas</groupId> <artifactId>cas-server-support-jdbc</artifactId> <!-- <version>${cas.version}</version> --> <version>4.2.7</version> <scope>runtime</scope> <exclusions> <exclusion> <groupId>org.apache.logging.log4j</groupId> <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> 1. It didn't work with the <version>${cas.version}</version> for the cas-server-support-jdbc dependency! I used the latest version on the repository. 2. It didn't work without excluding the org.apache.logging.log4j and org.codehaus.groovy from the cas-server-support-jdbc dependency! Here is the cas.properties file: DEFAULT SETTINGS HERE . . . cas.tgc.crypto.enabled=true cas.tgc.crypto.encryption.key=W7t ... DHg cas.tgc.crypto.signing.key=fa6 ... jrQ cas.webflow.crypto.signing.key=Du_ ... sow cas.webflow.crypto.encryption.key=IQv ... 6Sw cas.authn.jdbc.query[0].sql=SELECT * FROM cas.credentials WHERE `username`=? cas.authn.jdbc.query[0].healthQuery=SELECT 1 FROM cas.credentials cas.authn.jdbc.query[0].url=jdbc:mysql://localhost:3306/cas cas.authn.jdbc.query[0].dialect=org.hibernate.dialect.MySQL5InnoDBDialect cas.authn.jdbc.query[0].user=root cas.authn.jdbc.query[0].password=**** cas.authn.jdbc.query[0].driverClass=com.mysql.cj.jdbc.Driver cas.authn.jdbc.query[0].fieldPassword=`password-plain` # cas.authn.jdbc.query[0].passwordEncoder.type=DEFAULT # cas.authn.jdbc.query[0].passwordEncoder.encodingAlgorithm=MD5 # cas.authn.jdbc.query[0].passwordEncoder.characterEncoding=UTF-8 logging.level.org.apereo=DEBUG cas.authn.accept.users= In the log I still find these WARNs: 2017-12-04 17:10:43,352 WARN [org.apereo.cas.util.cipher.BaseBinaryCipherExecutor] - <Secret key for signing is not defined. CAS will attempt to auto-generate the signing key> 2017-12-04 17:10:43,353 WARN [org.apereo.cas.util.cipher.BaseBinaryCipherExecutor] - <Generated signing key [jiH ... 4Ug] of size [512]. The generated key MUST be added to CAS settings.> 2017-12-04 17:10:43,353 WARN [org.apereo.cas.util.cipher.BaseBinaryCipherExecutor] - <No encryption key is defined. CAS will attempt to auto-generate keys> 2017-12-04 17:10:43,353 WARN [org.apereo.cas.util.cipher.BaseBinaryCipherExecutor] - <Generated encryption key [SYr ... nqI] of size [16]. The generated key MUST be added to CAS settings.> What are the keys in the cas.properties file should I assign these cipher keys to? Is there anyway to debug more what's happening after entering the username and password in the form? I'd <Property name="cas.log.level" >debug</Property> in the log4j2.xml file!!! any help is appreciated!! -- Ray Bon Programmer analyst Development Services, University Systems 2507218831 | CLE 019 | [email protected] -- - 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/1512409584.1769.12.camel%40uvic.ca.
