Hi!
New to CAS 5 and gradle cas overlay. I'm trying to get authentication against postgresql 9.6.1 jdbc working.
Here what I did,
* cloned gradle overlay
https://github.com/apereo/cas-gradle-overlay-template.git* created keystore
* compiled and started cas.war
* default username/password casuser/Mellon works -
https://localhost:8443/cas/loginUpdated /etc/cas/config/cas.properties for jdbc source -
cas.server.name:
https://cas.example.org:8443cas.server.prefix:
https://cas.example.org:8443/casendpoints.enabled=true
management.contextPath=/status
cas.adminPagesSecurity.ip=127\.0\.0\.1
logging.config: file:/etc/cas/config/log4j2.xml
# cas.serviceRegistry.config.location: classpath:/services
cas.authn.accept.users=
cas.authn.jdbc.query[0].sql=SELECT password FROM user_table WHERE emailaddress=?
cas.authn.jdbc.query[0].healthQuery=SELECT 1 FROM INFORMATION_SCHEMA.SYSTEM_USERS
cas.authn.jdbc.query[0].isolateInternalQueries=false
cas.authn.jdbc.query[0].url=jdbc:postgresql://localhost:5432/users
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.PostgreSQLDialect
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].user=postgres
cas.authn.jdbc.query[0].ddlAuto=create-drop
cas.authn.jdbc.query[0].maxAgeDays=180
cas.authn.jdbc.query[0].password=postgres
cas.authn.jdbc.query[0].autocommit=false
cas.authn.jdbc.query[0].driverClass=org.postgresql.Driver
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
===
I get invalid credentials and I see in the logs -
===
...
2016-11-09 20:02:09,380 WARN [org.apereo.cas.authentication.PolicyBasedAuthenticationManager] - <Authentication has failed. Credentials may be incorrect or CAS cannot find authentication handler that supports [
x...@xxx.com] of type [UsernamePasswordCredential], which suggests a configuration problem.>
...
...
2016-11-09 20:02:09,436 ERROR [org.apereo.cas.web.flow.AuthenticationExceptionHandler] - <Unable to translate handler errors of the authentication exception org.apereo.cas.authentication.AuthenticationException: 0 errors, 0 successes. Returning UNKNOWN by default...>
...
====
I'm sure I have not configured it correctly and would appreciate some help
Thanks!