Greetings. I'm configuring the cas 5.1.x server's Database Authentication, and there is no problem with MySQL 5.7, which likes:
cas.authn.jdbc.query[0].sql=SELECT * FROM users WHERE uid=? cas.authn.jdbc.query[0].url= cas.authn.jdbc.query[0].dialect=org.hibernate.dialect.MySQLDialect cas.authn.jdbc.query[0].user=casuser cas.authn.jdbc.query[0].password=caspw cas.authn.jdbc.query[0].driverClass=com.mysql.cj.jdbc.Driver cas.authn.jdbc.query[0].fieldPassword=upw Well there is still a "com.mysql.jdbc.Driver" out of date warning which is very strange cause I never set that driverClass. When it comes to MSSQL, doesn't work at all: cas.authn.jdbc.query[1].sql=SELECT * FROM Sys_Users WHERE Account=? cas.authn.jdbc.query[1].url=jdbc:jtds:sqlserver cas.authn.jdbc.query[1].dialect=org.hibernate.dialect.SQLServerDialect cas.authn.jdbc.query[1].user=dbu cas.authn.jdbc.query[1].password=dbu cas.authn.jdbc.query[1].driverClass=net.sourceforge.jtds.jdbc.Driver cas.authn.jdbc.query[1].fieldPassword=Password cas.authn.jdbc.query[1].principalAttributeList=Account,UserName Error: [33m2017-08-08 16:19:51,810 WARN [org.apereo.cas.web.flow.resolver.impl.InitialAuthenticationAttemptWebflowEventResolver] - <'principal' cannot be null. Check the correctness of @Audit annotation at the following audit point: execution(public org.apereo.cas.authentication.Authentication org.apereo.cas.authentication.AbstractAuthenticationManager.authenticate(org.apereo.cas.authentication.AuthenticationTransaction))> [m java.lang.IllegalArgumentException: 'principal' cannot be null. Check the correctness of @Audit annotation at the following audit point: execution(public org.apereo.cas.authentication.Authentication org.apereo.cas.authentication.AbstractAuthenticationManager.authenticate(org.apereo.cas.authentication.AuthenticationTransaction)) I'm sure the database is available, if I change the user or password or url, then there will be timout or login failed error. -- - 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/d9795126-d7f2-4bcd-9d50-ce9643187bb7%40apereo.org.
