Migrate current users from DB to LDAP

[msksharma]

Hi,

We are running OTRS 3.3.3 on Ubuntu.

We have about 85 agents whose user information is stored in DB(Local authentication).

I have configured LDAP authentication and it is working.

Recently we have implemented AD and i wanted to know if i can migrate the existing users to authenticate using LDAP.

This will help in managing usernames/passwords easily.

Thanks and Regards,
Krishna M S

[crythias]

No, but if they have the same username DB and LDAP and you change the backend it should just work.

[msksharma]

Hi,

I tried this today.

The username in current OTRS is firstname.lastname@company.com and in LDAP it is firstname.lastname

I went to Agents-> Click on one of the users and rename the username from firstname.lastname@company.com to firstname

I was able to login as firstname.lastname and was able to view the queue.

Now in this case, can we change the backend to LDAP?

How is that possible? Do we need to modify the SQL DB. I checked everywhere in Sysconfig, but did not find out anything.

Thanks,
Krishna M S

[crythias]

You should try it, then ask a relevant question.

Note that changing the username of an agent or customer does not retroactively change the username associated with a ticket. In the otrs database/ticket table, the username, and not an identifying number/ID, is used.

[msksharma]

Hi,

In this case, How migrate the existing users?

Also, When i renamed the user from krishna.ms@toradex.com to krishna.ms and login with my AD crendentials, i get this error

Panic, user authenticated but no user data can be found in OTRS DB!! Perhaps the user is invalid.

What are the other alternatives for us to make this work?

Thanks and Regards,
Krishna M S

[crythias]

The logged in user doesn't match user data. You should provide that via AD, see my HowTo on LDAP troubleshooting (start with Need Help?)