cas.authn.jdbc.query.xx ====> org.apereo.cas.adaptors.jdbc. QueryDatabaseAuthenticationHandler cas.authn.jdbc.search.xx ======> org.apereo.cas.adaptors.jdbc. SearchModeSearchDatabaseAuthenticationHandler cas.authn.jdbc.bind.xx ======> org.apereo.cas.adaptors.jdbc. BindModeSearchDatabaseAuthenticationHandler cas.authn.jdbc.encode.xx ====> org.apereo.cas.adaptors.jdbc. QueryAndEncodeDatabaseAuthenticationHandler you can debug the handler
mvk <[email protected]>于2016年12月21日周三 上午5:49写道： > Hi All. > I am trying to setup CAS 5.0.0. > > So I installed CAS 5.0.0 per instructions and all works and now I am > trying to add a simple mysql authentication. > > This is the code I added to the application.properties. I tried to run > search function as well as query with and without [], I changed the > password with different encoding options. Nothing seem to make a > difference. Note: the name of the user database is called "user", it is not > a type :) > > cas.authn.jdbc.query.fieldUser=username > > cas.authn.jdbc.query.sql=SELECT password FROM user WHERE username=? > > cas.authn.jdbc.query.healthQuery=SELECT 1 FROM db_example.user > > cas.authn.jdbc.query.tableUsers=user > > cas.authn.jdbc.query.fieldPassword=password > > cas.authn.jdbc.query.passwordEncoder.type=DEFAULT > > > > cas.authn.jdbc.query.url=jdbc:mysql://localhost:3306/db_example > > > > cas.authn.jdbc.query.user=dbuser > > cas.authn.jdbc.query.password=dbpassword > > cas.authn.jdbc.query.driverClass=com.mysql.jdbc.Driver > > This is the error I am getting > > <Authentication has failed. Credentials may be incorrect or CAS cannot > find authentication handler that supports [admin] of type > [UsernamePasswordCredential], which suggests a configuration problem.> > > I am missing something not sure what it is. Any pointers and tips are > greatly appreciated. > > -- > - 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/23993d73-99fd-4f2c-b4b6-8fd5f7c92f78%40apereo.org > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/23993d73-99fd-4f2c-b4b6-8fd5f7c92f78%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/CAKy4QQ%3D0eVQqZ7pqA0-qMqCu_jMj2ZZTiAbpt9X2%2BbZQA30O5A%40mail.gmail.com.
