View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - How to make username case insensitive ? - Page 2 - ProjeQtOr
 
 

How to make username case insensitive ?

More
10 Mar 2018 13:41 - 10 Mar 2018 13:41 #7 by babynus
Replied by babynus on topic How to make username case insensitive ?
Sorry.
I posted the patch before testing.
The correct patch is :
$user=new User();
    $paramLdap_allow_login=Parameter::getGlobalParameter('paramLdap_allow_login'); // If ldap is enabled, look for username without case sensitive, as it will be stored this way.
    if (isset($paramLdap_allow_login) and strtolower($paramLdap_allow_login)=='true') {
      $critWhere="lower(name)='".strtolower($login)."'";
      $users=$user->getSqlElementsFromCriteria(null,true,$critWhere);
      if ( count($users)==1 ) {
        $user=$users[0];
      }
    }
(remove the last penrenthesis on line 83)
Babynus
Administrator of ProjeQtOr web site
Last edit: 10 Mar 2018 13:41 by babynus.

Please Log in or Create an account to join the conversation.

More
10 Mar 2018 15:20 #8 by fathibn
Replied by fathibn on topic How to make username case insensitive ?
Sorry, I should have noticed the unbalanced parentheses instead of blindly replying with No.

I applied this new patch and as cou can see from my postgresql log, here after, lowercase user is still created:
< 2018-03-10 15:11:48.446 CET >LOG: exécute pdo_stmt_0000000b: insert into audit ( sessionId , auditDay , idUser , userName , platform , browser , browserVersion , userAgent , connectionDateTime , lastAccessDateTime , duration , idle , requestRefreshParam , requestRefreshProject , requestDisconnection ) values ('ftf51cb7qq86ms2cg6njhidrn2', '20180310', '3', '39471N', 'Windows', 'Mozilla Firefox', '58.0', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-10 15:11:48', '2018-03-10 15:11:48', '00:00:00', '0', '0', '0', '0')
< 2018-03-10 15:12:24.119 CET >LOG: exécute pdo_stmt_0000000a: insert into resource (isuser, name , fullName , email , idProfile , locked , isContact , isResource , idle , dontReceiveTeamMails , isLdap , apiKey ) values ('1', '39471n', 'FATHI BEN NASR', 'This email address is being protected from spambots. You need JavaScript enabled to view it.', '5', '0', '1', '1', '0', '0', '1', '08195scarmbled280')
< 2018-03-10 15:12:24.529 CET >LOG: exécute pdo_stmt_00000021: insert into mail ( idUser , mailDateTime , mailTo , mailStatus , idle , mailTitle , mailBody ) values ('12', '2018-03-10 15:12', 'This email address is being protected from spambots. You need JavaScript enabled to view it.', 'WAIT', '0', 'ProjeQtOr - Nouvel utilisateur', 'L''utilisateur ''39471n'' a été créé à partir de Ldap')
< 2018-03-10 15:12:25.680 CET >LOG: exécute pdo_stmt_0000002c: insert into alert ( idUser , alertType , alertInitialDateTime , alertDateTime , readFlag , idle , title , message ) values ('1', 'INFO', '2018-03-10 15:12:25', '2018-03-10 15:12:25', '0', '0', 'ProjeQtOr - Nouvel utilisateur', 'L''utilisateur ''39471n'' a été créé à partir de Ldap')
< 2018-03-10 15:12:25.717 CET >LOG: exécute pdo_stmt_00000031: insert into audit ( sessionId , auditDay , idUser , userName , platform , browser , browserVersion , userAgent , connectionDateTime , lastAccessDateTime , duration , idle , requestRefreshParam , requestRefreshProject , requestDisconnection ) values ('6n3evcn5lmt5gcvgn186qom734', '20180310', '12', '39471n', 'Windows', 'Mozilla Firefox', '58.0', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:58.0) Gecko/20100101 Firefox/58.0', '2018-03-10 15:12:25', '2018-03-10 15:12:25', '00:00:00', '0', '0', '0', '0')

Please Log in or Create an account to join the conversation.

More
10 Mar 2018 16:25 #9 by babynus
Replied by babynus on topic How to make username case insensitive ?
The patch may not work if there already exists several users with same name (butwith different cases)
Babynus
Administrator of ProjeQtOr web site
The following user(s) said Thank You: fathibn

Please Log in or Create an account to join the conversation.

Moderators: babynus, protion
Time to create page: 0.041 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.

Login Form