I tried this way but I couldn't send the mail again.
application.properties
cas.authn.attributeRepository.jdbc.attributes.mail=email
cas.authn.attributeRepository.defaultAttributesToRelease=mail
cas.log
INFO [org.apereo.cas.authentication.PolicyBasedAuthenticationManager] -
<QueryDatabaseAuthenticationHandler successfully authenticated username**>
2019-01-22 13:10:12,051 INFO
[org.apereo.cas.authentication.PolicyBasedAuthenticationManager] -
<Authenticated principal [username**] and attributes {email=aa@gg, id=24,
password=5994471abb01112afcc18159f6cc74b4f511b99806da59b3caf5a9c173cacfc5,
username=username**} with credentials [username**].>
2019-01-22 13:10:12,059 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 13:10:12 UTC 2019
=============================================================
>
2019-01-22 13:10:12,059 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 13:10:12 UTC 2019
=============================================================
2019-01-22 13:10:12,138 DEBUG
[org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] -
<Locating principal attributes for username**>
2019-01-22 13:10:12,139 DEBUG
[org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] -
<Found principal attributes {email=aa@gg, id=24,
password=5994471abb01112afcc18159f6cc74b4f511b99806da59b3caf5a9c173cacfc5,
username=username**} for username**>
2019-01-22 13:10:12,140 DEBUG
[org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] -
<Calling attribute policy ReturnAllowedAttributeReleasePolicy to process
attributes for username**>
2019-01-22 13:10:12,142 DEBUG
[org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] -
<Attribute policy ReturnAllowedAttributeReleasePolicy allows release of {}
for username**>
2019-01-22 13:10:12,143 DEBUG
[org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] -
<Checking default attribute policy attributes>
2019-01-22 13:10:12,143 DEBUG
[org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] -
<Located application context. Retrieving default attributes for release, if
any>
2019-01-22 13:10:12,144 DEBUG
[org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] -
<Default attributes for release are: [mail]>
2019-01-22 13:10:12,145 DEBUG
[org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] -
<Default attributes found to be released are {}>
2019-01-22 13:10:12,145 DEBUG
[org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] -
<Attempting to merge policy attributes and default attributes>
2019-01-22 13:10:12,145 DEBUG
[org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] -
<Adding default attributes first to the released set of attributes>
2019-01-22 13:10:12,146 DEBUG
[org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] -
<Adding policy attributes to the released set of attributes>
2019-01-22 13:10:12,146 DEBUG
[org.apereo.cas.services.AbstractRegisteredServiceAttributeReleasePolicy] -
<Final collection of attributes allowed are: {}>
2019-01-22 13:10:12,157 INFO
[org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit
trail record BEGIN
=============================================================
WHO: username**
WHAT: TGT-**********************************************y0RNBAtfXo-1
ACTION: TICKET_GRANTING_TICKET_CREATED
APPLICATION: CAS
WHEN: Tue Jan 22 13:10:12 UTC 2019
=============================================================
>
2019-01-22 13:10:12,157 INFO
[org.apereo.inspektr.audit.support.Slf4jLoggingAuditTrailManager] - <Audit
trail record BEGIN
=============================================================
WHO: username**
WHAT: TGT-**********************************************y0RNBAtfXo-1
ACTION: TICKET_GRANTING_TICKET_CREATED
APPLICATION: CAS
WHEN: Tue Jan 22 13:10:12 UTC 2019
=============================================================
On Tue, Jan 22, 2019 at 1:24 PM Michele Melluso <[email protected]>
wrote:
> 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]>
>> 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].
>>> 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
> <https://groups.google.com/a/apereo.org/d/msgid/cas-user/4dd74afd-584b-4a46-b1db-3bcd4c2ea901%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/CA%2B4-XFgUNu9TrLGO9N1KVwE9K1tQKLcY%3DXm0s1n%3Dbsa4OY%2BuJA%40mail.gmail.com.
