problem authenticating with jdbc
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
]
2017-07-12 16:40 GMT-05:00 Misagh Moayyed <[email protected]>:
>
>
> Just above demos there was the "getting started" section which links out
> to several documents. I've read all of those. Each of the demos has a
> documentation link on the left and the demo link on the right. I've read
> the documentation linked to on the left for CAS Overlay, CAS Service
> Management Server, and CAS Configuration Server a couple times each. They
> are all great starting points but leave me completely clueless about what
> settings are necessary to achieve what end.
>
>
> I sympathize. Half the time, I myself am just as confused. On the settings
> front, things should improve quite a bit with additional docs and tags
> explaining what is required vs optional, etc but for the time being you
> simply need to be more adventurous, or simply hope that I and others win
> the lottery :) Short of that, my suggestion is to do exactly as you did.
> Once you learn what X does and you feel like X needs to be more thoroughly
> explained, please take the time to do so and help the next person who in
> turn might help you and the next person along.
>
>
>
>
>
> --
> - 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/03e901d2fb57%245954c560%
> 240bfe5020%24%40unicon.net
> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/03e901d2fb57%245954c560%240bfe5020%24%40unicon.net?utm_medium=email&utm_source=footer>
> .
>
--
- 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/CACUgg29Bg20gpTsp0aQtM0%2Brp252WR%2BvmKokaNGmtuq337EBJw%40mail.gmail.com.
