Username and Emails case sensitive... sometimes OR add the possibility to have case-insensitive networks

[gbastien]

A new user can signup with a username different only by case from an existing user.

Since many queries afterwards use an ILike with the username and expect only one result to come back, this situation can be problematic.

A solution would be to not allow usernames differing only by case.

[a@…]

There's a similar problem with email addresses. A user can create an account with an address, say user@server .tld and create another account by putting USER@SERVER .TLD in the email field.

[networkfusion]

To fix this, change the sql statements to use ILIKE instead of LIKE or = . e.g. in user.php "SELECT user_id FROM users WHERE username = '$username_str' AND account_origin = '$account_origin_str'" would become "SELECT user_id FROM users WHERE username ILike '$username_str' AND account_origin ILike '$account_origin_str'"

[gbastien]

There has been requests from groups to add the possibility to have case-insensitive networks (many support requests from people who have problems with username because they forgot the casing the initially used)

The '=' or 'Ilike' in the queries above would be dependent upon the case-sensitiveness of the origin network.

Problem would arise when passing from a case-sensitive network to a case-insensitive one. If some usernames differ only by case, we would need to do something with those users... My idea would be to issue a warning before changing the case-sensitiveness to ask what to do.

1- Nothing, stay case-sensitive, just give a list of problematic usernames so the admin can do whatever they wish with it. 2- Execute a one-time script to add a number after those usernames so that they are different and send an email to those users telling them their usernames have been change and they can change it back at next login.

[gbastien]

Networks can now be made case insensitive, but if some users pose problems, an error is issued with a list of those users and the network stays case sensitive.