[RCD] mysql users case

Peter Overtoom 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:

> Hello,
>
> 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;
>
> Regards,
>
>
> Edouard Moreau
>
> Le 03/10/2012 18:49, Mirko Buffoni a écrit :
>
>  Hi,
>>
>> 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?
>>
>> Mirko
>>
>> ______________________________**_________________
>> Roundcube Development discussion mailing list
>> dev at lists.roundcube.net
>> http://lists.roundcube.net/**mailman/listinfo/dev<http://lists.roundcube.net/mailman/listinfo/dev>
>>
>
> ______________________________**_________________
> Roundcube Development discussion mailing list
> dev at lists.roundcube.net
> http://lists.roundcube.net/**mailman/listinfo/dev<http://lists.roundcube.net/mailman/listinfo/dev>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.roundcube.net/pipermail/dev/attachments/20121004/ff7060f6/attachment.html>


More information about the dev mailing list