Solved ... Removing the grave accent ` characters in the fieldPassword value solved the problem. Best regards
On Monday, December 4, 2017 at 5:30:13 PM UTC+2, 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!! > -- - 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/73e05b5f-f142-412e-a6ae-89af2259923e%40apereo.org.
