Re: [cas-user] JDBC attribute SQL query

2020-07-10 Thread Parker Grimes
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 pas

Re: [cas-user] JDBC attribute SQL query

2020-07-10 Thread Richard Frovarp
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 i

[cas-user] JDBC attribute SQL query

2020-07-09 Thread Parker Grimes
I recently set up a JDBC attributeRepository and my SQL query expects the username passed from CAS to be lowercase. Does anyone know how to either override the "WHERE {0}" or make sure the username being passed is lowercase? The problem we have is people entering their username in mixed case li