Me too. Looking for a solution. On Thursday, November 17, 2016 at 9:55:13 PM UTC+8, Daniel wrote: > > I'm getting this error with a new LDAP configuration. Probably unrelated > but I am interested in seeing how this resolves. > > > > On Wednesday, November 9, 2016 at 9:39:58 AM UTC-5, mrcasa wrote: >> >> 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/login >> >> Updated /etc/cas/config/cas.properties for jdbc source - >> >> cas.server.name: https://cas.example.org:8443 >> cas.server.prefix: https://cas.example.org:8443/cas >> >> endpoints.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 [[email protected]] 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! >> >
-- - 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/526d505c-1ecc-4482-adf1-8d79d9df046e%40apereo.org.
