Hi, Hello, I want to send other information such as mail address or firstname which is registered in user database. What should I add to application.properties? Can you give an example?
On Fri, Jan 18, 2019 at 8:07 PM Ray Bon <[email protected]> wrote: > 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 > <https://groups.google.com/a/apereo.org/d/msgid/cas-user/1547831249.3078.147.camel%40uvic.ca?utm_medium=email&utm_source=footer> > . > -- - 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/CA%2B4-XFjNsdsXkJ3wXsEBK%2BzD5xoZX4%3DB9yfFYBPvDUg5m3aSmQ%40mail.gmail.com.
