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 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/CA%2B4-XFiZzzBLx9Fy3FYnqMuXQhwHKdmiCf%2BVyqhvPHjXZAZQVg%40mail.gmail.com.
