I can not auth user with config when i'm using salt:
cas.authn.jdbc.query[0].user=cas_app
cas.authn.jdbc.query[0].password=xxxxxxx
cas.authn.jdbc.query[0].driverClass=com.mysql.cj.jdbc.Driver
cas.authn.jdbc.query[0].url=jdbc:mysql://xxxxx:3306/cas_db?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&useSSL=false
cas.authn.jdbc.query[0].passwordEncoder.type=DEFAULT
cas.authn.jdbc.query[0].passwordEncoder.characterEncoding=UTF-8
cas.authn.jdbc.query[0].passwordEncoder.encodingAlgorithm=SHA-256
cas.authn.jdbc.query[0].passwordEncoder.secret=
cas.authn.jdbc.query[0].passwordEncoder.strength=16
cas.authn.jdbc.query[0].sql=SELECT * FROM grants WHERE validTo >= CURDATE()
and mail=?
cas.authn.jdbc.query[0].field-password=password
cas.authn.jdbc.query[0].name=local_DB
cas.authn.jdbc.query[0].principalAttributeList=mail,memberOf
cas.authn.jdbc.encode[0].salt-field-name=mail < - for test inly such salt
I'm windering is correct such conf especialy about :
cas.authn.jdbc.query[0].passwordEncoder.encodingAlgorithm=SHA-256
It seems that in doc they are talking about SSHA to put in
cas.authn.jdbc.query[0].passwordEncoder.encodingAlgorithm
DB:
Hash had been generated in this way:
select SHA2(CONCAT('mail-as-salt-test','passuser'),256);
and than was inserted to password column.
structure db
cas_db:table grants has columns mail,password,memberOf.For testing
puproses im using mail as salt.
--
BR
--
- 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/850a3d41-e717-4afa-8985-b2ab72495b38n%40apereo.org.
