[RCD] mysql users case
ps.overtoom at redheadtech.nl
Thu Oct 4 09:10:17 CEST 2012
Wont the query in the config file give problems when duplicates already
exist in the database?
On Thu, Oct 4, 2012 at 8:21 AM, Edouard Moreau <edouard.moreau at ensma.fr>wrote:
> You can force login to be converted to lower case in the config file :
> // Forces conversion of logins to lower case.
> // 0 - disabled, 1 - only domain part, 2 - domain and local part.
> // If users authentication is not case-sensitive this must be enabled.
> // After enabling it all user records need to be updated, e.g. with query:
> // UPDATE users SET username = LOWER(username);
> $rcmail_config['login_lc'] = 2;
> Edouard Moreau
> Le 03/10/2012 18:49, Mirko Buffoni a écrit :
>> I have a question about users: I noticed I have different users filed
>> under `users` mysql table.
>> This happens because of this options in configuration:
>> // automatically create a new Roundcube user when log-in the first time.
>> // a new user will be created once the IMAP login succeeds.
>> // set to false if only registered users can use this service
>> $rcmail_config['auto_create_**user'] = true;
>> which created different user entries when I have caps lock turned on
>> or accidentally hit Shift key during typing.
>> Anyway, shouldn't case of user be put to lowercase before
>> authentication and all subsequent operations?
>> is there any reason to have different user_id which lead to different
>> entries in contacts/contacts_groups/cache etc?
>> Roundcube Development discussion mailing list
>> dev at lists.roundcube.net
> Roundcube Development discussion mailing list
> dev at lists.roundcube.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the dev