i was following the steps described in the database-authentication section
of the documentation (
https://apereo.github.io/cas/5.1.x/installation/Database-Authentication.html)
and the user is not authenticated in the form
https://localhost:8443/cas/login
-
[5.1] CAS server version
-
[tomcat] Container/environment type/version (Tomcat, Jetty, Java,
Linux/Windows, etc)
-
steps [
1.-add pom.xml
org.apereo.cas
cas-server-support-jdbc
${cas.version}
org.postgresql
postgresql
42.1.1
org.apache.commons commons-collections4 4.1
2.- add properties in cas.properties file
cas.server.name: https://localhost:8443
cas.server.prefix: https://localhost:8443/cas
cas.adminPagesSecurity.ip=127.0.0.1
logging.config: file:C:/etc/cas/config/log4j2.xml
cas.serviceRegistry.config.location: classpath:/services
cas.authn.policy.any.tryAll=true
cas.authn.accept.users=
server.ssl.key-store=file:C:/etc/cas/crunchifyKey.keystore
server.ssl.key-store-password=changeit
server.ssl.key-password=changeit
cas.authn.jdbc.query[0].url=jdbc:postgresql://localhost:5432/sistema_contable_erp
cas.authn.jdbc.query[0].user=postgres
cas.authn.jdbc.query[0].password=123456
cas.authn.jdbc.query[0].autocommit=false
cas.authn.jdbc.query[0].driverClass=org.postgresql.Driver
cas.authn.jdbc.query[0].sql=SELECT password FROM persona_empresa_usuario
WHERE ci_ruc=?
cas.authn.jdbc.query[0].healthQuery=select 1
cas.authn.jdbc.query[0].isolateInternalQueries=false
cas.authn.jdbc.query[0].failFast=true
cas.authn.jdbc.query[0].isolationLevelName=ISOLATION_READ_COMMITTED
cas.authn.jdbc.query[0].dialect=org.hibernate.dialect.PostgreSQL95Dialect
cas.authn.jdbc.query[0].leakThreshold=10
cas.authn.jdbc.query[0].propagationBehaviorName=PROPAGATION_REQUIRED
cas.authn.jdbc.query[0].batchSize=1
cas.authn.jdbc.query[0].ddlAuto=create-drop
cas.authn.jdbc.query[0].maxAgeDays=180
cas.authn.jdbc.query[0].idleTimeout=5000
cas.authn.jdbc.query[0].credentialCriteria=
cas.jdbc.showSql=true
cas.jdbc.genDdl=true
spring.jpa.show-sql=true
cas.authn.jdbc.query[0].passwordEncoder.type=NONE
]
- Stacktraces and CAS DEBUG logs where appropriate.[
2017-07-12 15:15:20,864 WARN
[org.apereo.cas.authentication.PolicyBasedAuthenticationManager] -
<Authentication has failed. Credentials may be incorrect or CAS cannot find
authentication handler that supports [0923746663] of type
[UsernamePasswordCredential], which suggests a configuration problem.>
2017-07-12 15:15:20,869 INFO
[org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit
trail record BEGIN
=============================================================
WHO: 0923746663
WHAT: Supplied credentials: [0923746663]
ACTION: AUTHENTICATION_FAILED
APPLICATION: CAS
WHEN: Wed Jul 12 15:15:20 COT 2017
CLIENT IP ADDRESS: 0:0:0:0:0:0:0:1
SERVER IP ADDRESS: 0:0:0:0:0:0:0:1
]
--
- CAS gitter chatroom: https://gitter.im/apereo/cas
- CAS mailing list guidelines: https://apereo.github.io/cas/Mailing-Lists.html
- CAS documentation website: https://apereo.github.io/cas
- CAS project website: https://github.com/apereo/cas
---
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/908a84fa-59ba-425e-a6e8-d9fb24337734%40apereo.org.
