Reverting Back to MySQl Database from LDAP

[srivatsatatti]

Hi,

I had Integrated LDAP for Customer Login. It worked well. But i wanted to revert back to MySql database.
so i removed the scripts (LDAP) in config.pm [saved the default Config.pm]
Restarted the Apache and Mysql.

But now when i try to login as customer which is saved in MySql database end, it fails.
If i checksyslog it seems that otrs is still looking LDAP and not MySQL.

If i see the Customer in Admin area it shows list of customers which are stored in MySQL Database.

What else has to be done to revert back??

using RHEl, OTRS 3.0.10.

[crythias]

If Config.pm still has LDAP connection, it'll try it.

table customer_user_preferences holds the index value of which Customer::AuthModule backend was/is being used to authenticate the user.

Code: Select all

user_id            preferences_key    preferences_value
customerusername	UserAuthBackend	 (might be "" or "1" or ...)

[/code]

The thing I call index is "" or a number after Customer::AuthModule

Options:
change the Config.pm to use database instead of LDAP for the index. and/or

Code: Select all

update table customer_user_preferences set preferences_value="(some number relevant to Config.pm Customer::AuthModule index value or "")" where (optionally) user_id="username" and preferences_key="UserAuthBackend"

(You shouldn't need this. OTRS should be looking at ALL the methods before it says it can't connect.)

Standard disclaimers about backup before you change the database by hand apply.