Have you included CAS' JDBC authentication module dependency in your overlay's build config (Maven or Gradle)?
Best, D. On Feb 3, 2017, 03:04 -0500, Jihad Talic <[email protected]>, wrote: > Hello, > > I am experiencing issues regarding my Database authentication configuration > in my CAS 5.0.1 server. The database I'm connecting with my CAS server uses > PostgreSQL, and deploying the overlay build in Tomcat 8.5. First of all, I > have enabled Database Authentication in the application.properties, > specifically the Encode handler, since the database uses a salt value for > hashing the password. As far as I know, I have applied the most basic > configuration for the database authentication setup, but if I try to > authenticate directly against the CAS server (not redirected from any url), > it always end up not being successful. I am very sure that I am using the > correct credentials, but I still experience an invalid authentication. > > Originally, I am accessing the database from a remote, but I also tried using > a local PostgreSQL database with similar unfortunate results. This is the > basic configuration I'm using in the application.properties (I purposely used > my local setup and some example values here): > > cas.authn.jdbc.encode[0].sql=SELECT password FROM public.user WHERE email=? > cas.authn.jdbc.encode[0].url=jdbc:postgresql://localhost:5432/tracking > cas.authn.jdbc.encode[0].driverClass=org.postgresql.Driver > cas.authn.jdbc.encode[0].user=sample_username > cas.authn.jdbc.encode[0].password=sample_password > cas.authn.jdbc.encode[0].saltFieldName=salt > cas.authn.jdbc.encode[0].passwordFieldName=password > > > cas.authn.jdbc.encode[0].passwordEncoder.type=DEFAULT > cas.authn.jdbc.encode[0].passwordEncoder.characterEncoding=UTF-8 > cas.authn.jdbc.encode[0].passwordEncoder.encodingAlgorithm=SHA > > > The password encoder setup should be right since the database uses SHA-1 > password encryption. > > This is what the tomcat logs says about: > > 2017-02-03 15:06:33,024 WARN > [org.apereo.cas.authentication.PolicyBasedAuthenticationManager] - > <Authentication has failed. Credentials may be incorrect or CAS cannot find > authentication handler that supports [jihad] of type > [UsernamePasswordCredential], which suggests a configuration problem.> > 2017-02-03 15:06:33,075 INFO > [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit > trail record BEGIN > ============================================================= > WHO: jihad > WHAT: Supplied credentials: [jihad] > ACTION: AUTHENTICATION_FAILED > APPLICATION: CAS > WHEN: Fri Feb 03 15:06:33 PHT 2017 > CLIENT IP ADDRESS: 127.0.0.1 > SERVER IP ADDRESS: 127.0.0.1 > ============================================================= > > > > 2017-02-03 15:06:33,210 ERROR > [org.apereo.cas.web.flow.AuthenticationExceptionHandler] - <Unable to > translate handler errors of the authentication exception > org.apereo.cas.authentication.AuthenticationException: 1 errors, 0 successes. > Returning UNKNOWN by default...> > > > I am hoping someone could help about this issue. Thank you in advance. > > --Jihad > > > > > -- > - 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] > (mailto:[email protected]). > To view this discussion on the web visit > https://groups.google.com/a/apereo.org/d/msgid/cas-user/b82b736e-7389-46a3-872b-53778b6acd64%40apereo.org > > (https://groups.google.com/a/apereo.org/d/msgid/cas-user/b82b736e-7389-46a3-872b-53778b6acd64%40apereo.org?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/14ea95a6-970a-40d0-a8a4-5f9df8e098a7%40Spark.
