OpenLDAP login problems when adding additional fields in table sdldapfieldmap
I added all users from our LDAP-Instance in ServiceDesk Plus in the Admin/Benutzer/LDAP-Section. Unfortunately the name in LDAP is only the login number but I wanted to have first, last and full name available for all requesters. Thereforte I followed the instructions:
https://pitstop.manageengine.com/portal/community/topic/how-to-configure-extra-ldap-field-map
After I added following columns to the sdldapfieldmap-table in the database
INSERT INTO sdldapfieldmap VALUES (7, NULL, 'FullName', 'cn', TRUE);
INSERT INTO sdldapfieldmap VALUES (8, NULL, 'FIRSTNAME', 'givenName', TRUE);
INSERT INTO sdldapfieldmap VALUES (9, NULL, 'LASTNAME', 'sn', TRUE);
and reimported all users (where the new info was added - "overwritten"), there was a problem with the login.
Users which were logged in at least one before the change were able to log in, all other users were not able to log in (wrong credentials error).
I also tried to only add first and last name but the login doesn't work. Only when I delete the entries in sdldapfieldmap, delete all useres and reimport all, the login works again.
https://pitstop.manageengine.com/portal/community/topic/how-to-configure-extra-ldap-field-map
After I added following columns to the sdldapfieldmap-table in the database
INSERT INTO sdldapfieldmap VALUES (7, NULL, 'FullName', 'cn', TRUE);
INSERT INTO sdldapfieldmap VALUES (8, NULL, 'FIRSTNAME', 'givenName', TRUE);
INSERT INTO sdldapfieldmap VALUES (9, NULL, 'LASTNAME', 'sn', TRUE);
and reimported all users (where the new info was added - "overwritten"), there was a problem with the login.
Users which were logged in at least one before the change were able to log in, all other users were not able to log in (wrong credentials error).
I also tried to only add first and last name but the login doesn't work. Only when I delete the entries in sdldapfieldmap, delete all useres and reimport all, the login works again.