John,
Do you mean you want to email the user the service they logged in to? Or send
the service the user's email address?
If the latter, you have to release the attribute in the service definition,
https://apereo.github.io/cas/5.2.x/integration/Attribute-Release-Policies.html
To see what attributes are being released, use this logging:
<!-- DEBUG Found principal attributes [...] for [username]
Attribute policy [???] allows release of [...] for [username]
Final collection of attributes allowed are: [...] -->
<AsyncLogger
name="org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy"
level="debug"/>
Ray
On Fri, 2019-01-18 at 04:16 -0800, john adz wrote:
Hi,
I did cas mysql authentication. I want to send cas service to the user's email
address. Add attribute, but not. Can you help me?
application.properties
cas.authn.accept.users=
cas.authn.jdbc.query[0].fieldUser=username
cas.authn.jdbc.query[0].sql=SELECT password FROM users WHERE username=?
cas.authn.jdbc.query[0].healthQuery=SELECT 1 FROM db.users
cas.authn.jdbc.query[0].tableUsers=users
cas.authn.jdbc.query[0].fieldPassword=password
cas.authn.jdbc.query[0].url=jdbc:mysql://localhost:3306/db
cas.authn.jdbc.query[0].user=root
cas.authn.jdbc.query[0].password=***
cas.authn.jdbc.query[0].driverClass=com.mysql.jdbc.Driver
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].principalAttributeList=email,mail
cas.authn.attributeRepository.jdbc.sql=SELECT * FROM users WHERE {0}
cas.authn.attributeRepository.jdbc.username=username
cas.authn.attributeRepository.jdbc.healthQuery=
cas.authn.attributeRepository.jdbc.url=jdbc:mysql://localhost:3306/db
cas.authn.attributeRepository.jdbc.singleRow=true
cas.authn.attributeRepository.jdbc.user=root
cas.authn.attributeRepository.jdbc.password=***
cas.authn.attributeRepository.attributes.email=email
cas.authn.attributeRepository.attributes.mail=mail
--
Ray Bon
Programmer analyst
Development Services, University Systems
2507218831 | CLE 019 | [email protected]
--
- 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/a/apereo.org/d/msgid/cas-user/1547831249.3078.147.camel%40uvic.ca.
