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
Am 03.10.2012 18:49, schrieb Mirko Buffoni:
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?
there are systems with case-sensitive usernames and short ago there was even a strange guy explaining that e-mail addresses are case-sensitive for him and me@mydomain.tld is another person than ME@myadomain.tld
there are systems with case-sensitive usernames and short ago there was even a strange guy explaining that e-mail addresses are case-sensitive for him and me@mydomain.tld is another person than ME@myadomain.tld
Fascinating! Thanks for the explanation of the login_lc option too. The update SQL "UPDATE users SET username = LOWER(username);" is ok if there aren't duplicates yet, but I suspect it will produce problems if there are duplicates (i.e., it will select the first of these).
Mirko
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@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/dev
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@ensma.frwrote:
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@lists.roundcube.net http://lists.roundcube.net/**mailman/listinfo/devhttp://lists.roundcube.net/mailman/listinfo/dev
______________________________**_________________ Roundcube Development discussion mailing list dev@lists.roundcube.net http://lists.roundcube.net/**mailman/listinfo/devhttp://lists.roundcube.net/mailman/listinfo/dev
No, Roundcube first check if an existing user already exist with that login in the database.
Le 04/10/2012 09:10, Peter Overtoom a écrit :
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@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@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/dev [1]
Roundcube Development discussion mailing list dev@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/dev [1]
Links:
[1] http://lists.roundcube.net/mailman/listinfo/dev
Roundcube Development discussion mailing list dev@lists.roundcube.net http://lists.roundcube.net/mailman/listinfo/dev