Re: [cas-user] JDBC attribute SQL query

Thanks for the feedback. We use Oracle and as far as I can tell, you would have to alter the Oracle session to change the queries to be case insensitive, that sounds like a messy path to go down. I have tried the cas.authn.attributeRepository.jdbc[0].caseCanonicalization=LOWER and it still

[cas-user] Re: Cas 6.1.2, anyone had a luck using MFA selection menu as shown on the cas blog

Hello Alexis, Many thanks for the feedback. If you happen to see this, any chance you can share how did you made these two parameters cas.authn.mfa.globalPrincipalAttributeNameTriggers=memberOf cas.authn.mfa.globalPrincipalAttributeValueRegex=something Was Regex just the top entry case

[cas-user] throttling authentication attempts

I'm trying to ensure I understand the configuration options for authentication failure throttling for cas 5.0.x described in this documentation. It explains the following two properties, #

Re: [cas-user] JDBC attribute SQL query

cas.authn.attribute-repository.jdbc[0].case-canonicalization=NONE|LOWER|UPPER It's been a while since we haven't used canonicalization, so I can't remember the details (like CAS 3.4). However, it used to be that CAS would return back the username attribute case matching whatever the user typed

[cas-user] Re: How to get latest values from attribute repository

hello. i am still open to suggestions and solution ways, anybody here?. thanks -- - 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

Re: [cas-user] Re: JDBC attribute SQL query

you could also just use a few lines of javascript on your login page to first convert the username input to lowercase before posting, easier then messing with your db if it is used for some other applications From: cas-user@apereo.org on behalf of Kink Sent:

Re: [cas-user] Re: Issue with cas 6 password managenment

Glad it helped you.  On Thu, Jul 9, 2020 at 7:02 PM arti wavale wrote: > Hello Root Sir, > > Thank you so much for guiding me and helping me to resolve problem. > Appreciated.. > > Thanks and Regards > Arti > > > On Thursday, July 9, 2020 at 5:18:57 AM UTC+5:30, Root wrote: >> >> >> SHA is

[cas-user] Cipher "clientSecret" params in OAuth2 JWT Token CAS Apereo version 6.1.7

Hi all, I follow this instruction to cipher "clientSecret" params in OAuth2 JWT Token with CAS Apereo 6.1 https://apereo.github.io/2019/11/04/cas62x-oauth-jwt-access-token/ *Step 1: Using CAS Shell to cipher clientSecret* root@ubuntu16:~/lam/cas-overlay-template# ./gradlew downloadShell

[cas-user] Re: JDBC attribute SQL query

Hi Parker, What about changing the collation of your DB/TABLE/COLUMN to a case insensitive (CI) one? MYSQL seems to do that easily: ALTER TABLE user_table MODIFY COLUMN username VARCHAR(…) CHARACTER SET UTF8 COLLATE UTF8_GENERAL_CI MSSQL would be something like: ALTER TABLE dbo.user_table