Could you try the same property without squared brackets? cas.authn.attributeRepository.*jdbc*.attributes.mail=email
as described here? https://apereo.github.io/cas/5.0.x/installation/Configuration-Properties.html#jdbc On Tuesday, January 22, 2019 at 10:23:28 AM UTC+1, john adz wrote: > > Hi Michele, > > I get an invalid property error when I use jdbc [0]. I'il try again and > send the log. Because I am using cas 5.0.x. I think you said for 5.2. In > the meantime, I can understand how the mail sent mail. > > Thanks, > > On Tue, Jan 22, 2019 at 11:38 AM Michele Melluso <[email protected] > <javascript:>> wrote: > >> Hi, >> I was wrong, please ignore my previous answer. >> >> Looking at your configuration I think you may be using the wrong >> properties to select attributes: >> cas.authn.attributeRepository.attributes.mail=email >> >> both in my configuration and here: >> https://apereo.github.io/2018/02/20/cas-service-rbac-attributeresolution/ >> the following properties are used: >> cas.authn.attributeRepository.*jdbc[0**]*.attributes.mail=email >> >> I hope this time to be correct :) >> Michele >> >> >> >> On Tuesday, January 22, 2019 at 9:17:28 AM UTC+1, Michele Melluso wrote: >>> >>> Looking at your configuration I think you should replace in >>> defaultattributesToRelease property the value email with mail. >>> That is because you defined an attribute called "mail" populated with >>> the "email" field. The the new attribute "mail" is what you want to release. >>> >>> cas.authn.attributeRepository.attributes.mail=email >>> cas.authn.attributeRepository.defaultAttributesToRelease=*mail* >>> >>> Michele >>> >>> >>> On Tuesday, January 22, 2019 at 8:41:38 AM UTC+1, john adz wrote: >>>> >>>> Hi Ray, >>>> Thanks for your answer. I've done something, and I see e-mails in the >>>> logs. But I don't know how to send this email address to the application. >>>> Or I don't know if I'm sending it right now. log like >>>> >>>> 2019-01-22 07:28:04,472 INFO >>>> [org.apereo.cas.authentication.PolicyBasedAuthenticationManager] - >>>> <QueryDatabaseAuthenticationHandler successfully authenticated username**> >>>> >>>> 2019-01-22 07:28:04,477 INFO >>>> [org.apereo.cas.authentication.PolicyBasedAuthenticationManager] - >>>> <Authenticated principal [username**] and attributes {email= >>>> [email protected]} with credentials [username**].> >>>> >>>> 2019-01-22 07:28:04,478 INFO >>>> [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit >>>> trail record BEGIN >>>> >>>> ============================================================= >>>> >>>> WHO: username** >>>> >>>> WHAT: Supplied credentials: [username**] >>>> >>>> ACTION: AUTHENTICATION_SUCCESS >>>> >>>> APPLICATION: CAS >>>> >>>> WHEN: Tue Jan 22 07:28:04 UTC 2019 >>>> >>>> >>>> ============================================================= >>>> >>>> >>>> > >>>> >>>> 2019-01-22 07:28:04,478 INFO >>>> [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit >>>> trail record BEGIN >>>> >>>> ============================================================= >>>> >>>> WHO: username** >>>> >>>> WHAT: Supplied credentials: [username**] >>>> >>>> ACTION: AUTHENTICATION_SUCCESS >>>> >>>> APPLICATION: CAS >>>> >>>> WHEN: Tue Jan 22 07:28:04 UTC 2019 >>>> >>>> >>>> ============================================================= >>>> >>>> >>>> > >>>> >>>> 2019-01-22 07:28:04,480 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Locating principal attributes for username**> >>>> >>>> 2019-01-22 07:28:04,481 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Found principal attributes {[email protected]} for username**> >>>> >>>> 2019-01-22 07:28:04,481 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Calling attribute policy ReturnAllowedAttributeReleasePolicy to process >>>> attributes for username**> >>>> >>>> 2019-01-22 07:28:04,481 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Attribute policy ReturnAllowedAttributeReleasePolicy allows release of {} >>>> for username**> >>>> >>>> 2019-01-22 07:28:04,482 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Checking default attribute policy attributes> >>>> >>>> 2019-01-22 07:28:04,482 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Located application context. Retrieving default attributes for release, >>>> if >>>> any> >>>> >>>> 2019-01-22 07:28:04,482 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Default attributes for release are: [email]> >>>> >>>> 2019-01-22 07:28:04,483 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Found and added default attribute for release: email> >>>> >>>> 2019-01-22 07:28:04,483 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Default attributes found to be released are {[email protected]}> >>>> >>>> 2019-01-22 07:28:04,483 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Attempting to merge policy attributes and default attributes> >>>> >>>> 2019-01-22 07:28:04,483 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Adding default attributes first to the released set of attributes> >>>> >>>> 2019-01-22 07:28:04,484 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Adding policy attributes to the released set of attributes> >>>> >>>> 2019-01-22 07:28:04,484 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Final collection of attributes allowed are: {[email protected]}> >>>> >>>> 2019-01-22 07:28:04,485 INFO >>>> [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit >>>> trail record BEGIN >>>> >>>> ============================================================= >>>> >>>> WHO: username** >>>> >>>> WHAT: TGT-**********************************************ys3O6zFWVi- >>>> >>>> ACTION: TICKET_GRANTING_TICKET_CREATED >>>> >>>> APPLICATION: CAS >>>> >>>> WHEN: Tue Jan 22 07:28:04 UTC 2019 >>>> >>>> >>>> ============================================================= >>>> >>>> >>>> > >>>> >>>> 2019-01-22 07:28:04,485 INFO >>>> [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit >>>> trail record BEGIN >>>> >>>> ============================================================= >>>> >>>> WHO: username** >>>> >>>> WHAT: TGT-**********************************************ys3O6zFWVi-1 >>>> >>>> ACTION: TICKET_GRANTING_TICKET_CREATED >>>> >>>> APPLICATION: CAS >>>> >>>> WHEN: Tue Jan 22 07:28:04 UTC 2019 >>>> >>>> >>>> ============================================================= >>>> >>>> >>>> 2019-01-22 07:28:04,488 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Locating principal attributes for username**> >>>> >>>> 2019-01-22 07:28:04,489 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Found principal attributes {[email protected]} for username**> >>>> >>>> 2019-01-22 07:28:04,489 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Calling attribute policy ReturnAllowedAttributeReleasePolicy to process >>>> attributes for username**> >>>> >>>> 2019-01-22 07:28:04,489 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Attribute policy ReturnAllowedAttributeReleasePolicy allows release of {} >>>> for username**> >>>> >>>> 2019-01-22 07:28:04,489 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Checking default attribute policy attributes> >>>> >>>> 2019-01-22 07:28:04,490 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Located application context. Retrieving default attributes for release, >>>> if >>>> any> >>>> >>>> 2019-01-22 07:28:04,490 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Default attributes for release are: [email]> >>>> >>>> 2019-01-22 07:28:04,490 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Found and added default attribute for release: email> >>>> >>>> 2019-01-22 07:28:04,490 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Default attributes found to be released are {[email protected]}> >>>> >>>> 2019-01-22 07:28:04,496 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Attempting to merge policy attributes and default attributes> >>>> >>>> 2019-01-22 07:28:04,496 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Adding default attributes first to the released set of attributes> >>>> >>>> 2019-01-22 07:28:04,496 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Adding policy attributes to the released set of attributes> >>>> >>>> 2019-01-22 07:28:04,496 DEBUG >>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>> - >>>> <Final collection of attributes allowed are: {[email protected]}> >>>> >>>> 2019-01-22 07:28:04,497 INFO >>>> [org.apereo.cas.CentralAuthenticationServiceImpl] - <Granted ticket >>>> [ST-4-aelgq7GeRcO3bkld9owo] for service [https://* >>>> >>>> 2019-01-22 07:28:04,498 INFO >>>> [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit >>>> trail record BEGIN >>>> >>>> ============================================================= >>>> >>>> WHO: username** >>>> >>>> WHAT: ST-4-aelgq7GeRcO3bkld9owo- for https://* >>>> >>>> ACTION: SERVICE_TICKET_CREATED >>>> >>>> APPLICATION: CAS >>>> >>>> WHEN: Tue Jan 22 07:28:04 UTC 2019 >>>> >>>> >>>> ============================================================= >>>> >>>> >>>> > >>>> >>>> 2019-01-22 07:28:04,498 INFO >>>> [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit >>>> trail record BEGIN >>>> >>>> ============================================================= >>>> >>>> WHO: username** >>>> >>>> WHAT: ST-4-aelgq7GeRcO3bkld9owo- for https://k** >>>> >>>> ACTION: SERVICE_TICKET_CREATED >>>> >>>> APPLICATION: CAS >>>> >>>> WHEN: Tue Jan 22 07:28:04 UTC 2019 >>>> >>>> >>>> ============================================================= >>>> >>>> >>>> >>>> >>>> 2019-01-22 07:28:04,565 INFO >>>> [org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit >>>> trail record BEGIN >>>> >>>> ============================================================= >>>> >>>> WHO: username** >>>> >>>> WHAT: ST-4-aelgq7GeRcO3bkld9owo- >>>> >>>> ACTION: SERVICE_TICKET_VALIDATED >>>> >>>> APPLICATION: CAS >>>> >>>> WHEN: Tue Jan 22 07:28:04 UTC 2019 >>>> >>>> >>>> >>>> On Mon, Jan 21, 2019 at 11:31 PM Ray Bon <[email protected]> wrote: >>>> >>>>> John, >>>>> >>>>> Attribute release policy for 5.0.x is here >>>>> https://apereo.github.io/cas/5.0.x/integration/Attribute-Release-Policies.html >>>>> >>>>> You will also need to use SAML 1.1 or CAS 3 protocols, >>>>> https://apereo.github.io/cas/5.0.x/integration/Attribute-Release.html >>>>> >>>>> Ray >>>>> >>>>> On Mon, 2019-01-21 at 16:30 +0300, john adz wrote: >>>>> >>>>> Hi Michele; >>>>> >>>>> I tried to do as you said. I am sending the contents of the file. Can >>>>> you help me? >>>>> >>>>> application.properties >>>>> >>>>> 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.attributes.uid=mail >>>>> >>>>> cas.authn.attributeRepository.jdbc.singleRow=false >>>>> >>>>> cas.authn.attributeRepository.jdbc.sql=SELECT * FROM users WHERE {0} >>>>> >>>>> cas.authn.attributeRepository.jdbc.username=username >>>>> >>>>> cas.authn.attributeRepository.jdbc.url=jdbc:mysql://localhost:3306/db >>>>> >>>>> >>>>> cas.authn.attributeRepository.jdbc.dialect=org.hibernate.dialect.MySQL57InnoDBDialect >>>>> >>>>> cas.authn.attributeRepository.jdbc.user=root >>>>> >>>>> cas.authn.attributeRepository.jdbc.password=*** >>>>> >>>>> ###cas.authn.jdbc.query[0].driverClass=com.mysql.cj.jdbc.Driver >>>>> >>>>> cas.authn.attributeRepository.jdbc.driverClass=com.mysql.jdbc.Driver >>>>> >>>>> cas.authn.attributeRepository.jdbc.columnMappings.password=email >>>>> >>>>> cas.authn.attributeRepository.jdbc.healthQuery=SELECT 1 FROM >>>>> account_db.users >>>>> >>>>> cas.authn.attributeRepository.attributes.mail=email >>>>> >>>>> cas.authn.attributeRepository.defaultAttributesToRelease=email >>>>> >>>>> cas.log is also the attribute field as follows >>>>> >>>>> 2019-01-21 13:18:40,953 DEBUG >>>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>>> - >>>>> <Locating principal attributes for **username**> >>>>> >>>>> 2019-01-21 13:18:40,955 DEBUG >>>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>>> - >>>>> <Found principal attributes {} for **username**> >>>>> >>>>> 2019-01-21 13:18:40,956 DEBUG >>>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>>> - >>>>> <Calling attribute policy ReturnAllowedAttributeReleasePolicy to process >>>>> attributes for **username**> >>>>> >>>>> 2019-01-21 13:18:40,956 DEBUG >>>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>>> - >>>>> <Attribute policy ReturnAllowedAttributeReleasePolicy allows release of >>>>> {} >>>>> for **username**> >>>>> >>>>> 2019-01-21 13:18:40,956 DEBUG >>>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>>> - >>>>> <Checking default attribute policy attributes> >>>>> >>>>> 2019-01-21 13:18:40,956 DEBUG >>>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>>> - >>>>> <Located application context. Retrieving default attributes for release, >>>>> if >>>>> any> >>>>> >>>>> 2019-01-21 13:18:40,957 DEBUG >>>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>>> - >>>>> <Default attributes for release are: [email]> >>>>> >>>>> 2019-01-21 13:18:40,957 DEBUG >>>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>>> - >>>>> <Default attributes found to be released are {}> >>>>> >>>>> 2019-01-21 13:18:40,957 DEBUG >>>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>>> - >>>>> <Attempting to merge policy attributes and default attributes> >>>>> >>>>> 2019-01-21 13:18:40,957 DEBUG >>>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>>> - >>>>> <Adding default attributes first to the released set of attributes> >>>>> >>>>> 2019-01-21 13:18:40,957 DEBUG >>>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>>> - >>>>> <Adding policy attributes to the released set of attributes> >>>>> >>>>> 2019-01-21 13:18:40,958 DEBUG >>>>> [org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] >>>>> - >>>>> <Final collection of attributes allowed are: {}> >>>>> >>>>> I don't understand where I'm doing wrong. I'm using cas 5.0.x. >>>>> >>>>> >>>>> On Mon, Jan 21, 2019 at 11:39 AM Michele Melluso <[email protected]> >>>>> wrote: >>>>> >>>>> It seems like you are missing how to extract attributes. >>>>> >>>>> You can see how this is done here: >>>>> >>>>> https://apereo.github.io/2018/02/20/cas-service-rbac-attributeresolution/ >>>>> >>>>> >>>>> then i guess that you should define an attribute release policy as >>>>> described here: >>>>> >>>>> https://apereo.github.io/cas/6.0.x/integration/Attribute-Release-Policies.html >>>>> >>>>> hope it helps >>>>> Michele >>>>> >>>>> On Sunday, January 20, 2019 at 7:37:34 PM UTC+1, john adz wrote: >>>>> >>>>> I added what you said in the file, but I got an error. The file >>>>> contents and the output of cas.log are as follows. >>>>> >>>>> application.properties >>>>> >>>>> 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[0].attributes.mail=mail >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> cas.log >>>>> >>>>> WARN >>>>> [org.springframework.boot.context.embedded.AnnotationConfigEmbeddedWebApplicationContext] >>>>> >>>>> - <Exception encountered during context initialization - cancelling >>>>> refresh >>>>> attempt: org.springframework.beans.factory.BeanCreationException: Error >>>>> creating bean with name >>>>> 'com.ryantenney.metrics.spring.MetricsBeanPostProcessorFactory#4': Cannot >>>>> resolve reference to bean 'metrics' while setting constructor argument; >>>>> nested exception is >>>>> org.springframework.beans.factory.UnsatisfiedDependencyException: Error >>>>> creating bean with name 'casMetricsConfiguration': Unsatisfied dependency >>>>> expressed through field 'handlerMapping'; nested exception is >>>>> org.springframework.beans.factory.UnsatisfiedDependencyException: Error >>>>> creating bean with name 'casWebAppConfiguration': Unsatisfied dependency >>>>> expressed through field 'casProperties'; nested exception is >>>>> org.springframework.beans.factory.BeanCreationException: Error creating >>>>> bean with name >>>>> 'cas-org.apereo.cas.configuration.CasConfigurationProperties': Could not >>>>> bind properties to CasConfigurationProperties (prefix=cas, >>>>> ignoreInvalidFields=false, ignoreUnknownFields=true, >>>>> ignoreNestedProperties=false); nested exception is >>>>> org.springframework.beans.InvalidPropertyException: Invalid property >>>>> 'authn.attributeRepository.jdbc[0][attributes][mail]' of bean class >>>>> [org.apereo.cas.configuration.model.core.authentication.AuthenticationProperties]: >>>>> >>>>> Illegal attempt to get property 'jdbc' threw exception; nested exception >>>>> is >>>>> org.springframework.beans.InvalidPropertyException: Invalid property >>>>> 'authn.attributeRepository.jdbc[0][attributes][mail]' of bean class >>>>> [org.apereo.cas.configuration.model.core.authentication.AuthenticationProperties]: >>>>> >>>>> Property referenced in indexed property path 'jdbc[0][attributes][mail]' >>>>> is >>>>> neither an array nor a List nor a Set nor a Map; returned value was >>>>> [org.apereo.cas.configuration.model.core.authentication.PrincipalAttributesProperties$Jdbc@17869b28]> >>>>> >>>>> On Fri, Jan 18, 2019 at 10:59 PM Ray Bon <[email protected]> wrote: >>>>> >>>>> John, >>>>> >>>>> From this part of the docs, >>>>> https://apereo.github.io/cas/5.2.x/installation/Configuration-Properties.html#jdbc-1, >>>>> >>>>> you may need cas.authn.attributeRepository.jdbc[0].attributes.mail=mail >>>>> >>>>> Ray >>>>> >>>>> On Fri, 2019-01-18 at 21:55 +0300, john adz wrote: >>>>> >>>>> 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> >>>>> . >>>>> >>>>> -- >>>>> 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/1547841558.3078.169.camel%40uvic.ca >>>>> >>>>> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/1547841558.3078.169.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/3663f6da-1b0f-4953-a728-2dc81ee02113%40apereo.org >>>>> >>>>> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/3663f6da-1b0f-4953-a728-2dc81ee02113%40apereo.org?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>>> -- >>>>> 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/1548094473.3605.13.camel%40uvic.ca >>>>> >>>>> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/1548094473.3605.13.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] <javascript:>. >> To view this discussion on the web visit >> https://groups.google.com/a/apereo.org/d/msgid/cas-user/8e1635b1-0a77-4944-88b1-17a408466f98%40apereo.org >> >> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/8e1635b1-0a77-4944-88b1-17a408466f98%40apereo.org?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/4dd74afd-584b-4a46-b1db-3bcd4c2ea901%40apereo.org.
