Project

General

Profile

Bug #3856

Services account username is case in-sensitive while db is case senstive

Added by Kyle Hazelwood over 6 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
05/13/2013
Due date:
% Done:

0%

Estimated time:
Duration:

Description

The users ldap login returns true with case insensitive username, however the db is case sensitive so the user will not be found.

History

#1 Updated by Kyle Hazelwood over 6 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.



Also available in: Atom PDF