[cas-user] cas.authn.jdbc.encode throws "Authentication handler is not configured correctly"

[David Bonnes]

Hi, I am stuck on *cas.authn.jdbc.encode*, although I can get 
*cas.authn.jdbc.query* to work OK.

cas.authn.jdbc.encode throws "*Authentication handler is not configured 
correctly*", maybe is due to (StringUtils.isBlank(this.sql) || 
StringUtils.isBlank(this.algorithmName) || getJdbcTemplate() == null) ??

*** Environment ***
 - CAS Version: 5.2.0-RC4-SNAPSHOT
 - Java Version: 1.8.0_131
 - Apache Tomcat Version: Apache Tomcat/8.0.32 (Ubuntu)
 - Linux Ubuntu Xenial Version: 16.04.3

*** pom.xlm ** *Only relevant changes are:

 <cas.version>5.2.0-RC4-SNAPSHOT</cas.version>

 ...and...

 <dependency>
    <groupId>org.apereo.cas</groupId>
    <artifactId>cas-server-support-jdbc</artifactId>
    <version>${cas.version}</version>
</dependency>
<dependency>
   <groupId>org.apereo.cas</groupId>
   <artifactId>cas-server-support-jdbc-drivers</artifactId>
   <version>${cas.version}</version>
</dependency>

*** cas.properties ***
Note first, that the following works fine - note the clever trick with 
*fieldPassword=username*:
 
  cas.authn.jdbc.query[0].url=jdbc:mysql:
//lxc-mysql.home:3306/guacamole_db?useSSL=false
  cas.authn.jdbc.query[0].driverClass=com.mysql.cj.jdbc.Driver
  cas.authn.jdbc.query[0].user=guac_username
  cas.authn.jdbc.query[0].password=guac_password


  cas.authn.jdbc.query[0].sql=SELECT * FROM guacamole_user WHERE username=?
  cas.authn.jdbc.query[0].fieldPassword=username


However, the following does not work (FWIW, this 
<https://guacamole.incubator.apache.org/doc/gug/jdbc-auth.html> may be a 
useful reference):
  cas.authn.jdbc.encode[0].url=jdbc:mysql:
//lxc-mysql.home:3306/guacamole_db?useSSL=false
  cas.authn.jdbc.encode[0].driverClass=com.mysql.cj.jdbc.Driver
  cas.authn.jdbc.encode[0].dialect=org.hibernate.dialect.MySQL5Dialect
  cas.authn.jdbc.encode[0].user=guac_username
  cas.authn.jdbc.encode[0].password=guac_password


  cas.authn.jdbc.encode[0].sql=SELECT * FROM guacamole_user WHERE username=?
  cas.authn.jdbc.encode[0].disabledFieldName=disabled
  cas.authn.jdbc.encode[0].saltFieldName=password_salt
  cas.authn.jdbc.encode[0].passwordFieldName=password_hash
  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-256

  
Which throws this error:
2017-09-23 23:20:06,446 DEBUG [org.apereo.cas.authentication.
PolicyBasedAuthenticationManager] - <[
QueryAndEncodeDatabaseAuthenticationHandler] exception details: [
Authentication handler is not configured correctly].>


I see from QueryAndEncodeDatabaseAuthenticationHandler.java 
<https://github.com/apereo/cas/blob/master/support/cas-server-support-jdbc-authentication/src/main/java/org/apereo/cas/adaptors/jdbc/QueryAndEncodeDatabaseAuthenticationHandler.java>
 that:
 if (StringUtils.isBlank(this.sql) || StringUtils.isBlank(this.algorithmName
) || getJdbcTemplate() == null) {
     throw new GeneralSecurityException("Authentication handler is not 
configured correctly");
 }

Can anyone suggest a solution, or (heaven forbid) is it a bug?

  

-- 
- Website: https://apereo.github.io/cas
- Gitter Chatroom: https://gitter.im/apereo/cas
- List Guidelines: https://goo.gl/1VRrw7
- Contributions: https://goo.gl/mh7qDG
--- 
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/b08cb989-21c6-47d5-85c4-38905de43f52%40apereo.org.