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