Services account username is case in-sensitive while db is case senstive
The users ldap login returns true with case insensitive username, however the db is case sensitive so the user will not be found.
#1 Updated by Kyle Hazelwood almost 7 years ago
- Category set to Database
- Status changed from New to Closed
added lower(?) to the queries that match names (i.e. user_name, log_name...). Postgres has a citext module for 9.1 and above which would be perfect for these columns as they shouldn't ever be case sensitive, however the module looks somewhat experimental. I'll wait to implement citext when it becomes a standard data type.