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/08bc61a3-0bf3-43c4-b0ee-5662c7258541%40apereo.org.
