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 cas-user+unsubscr...@apereo.org. 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.
