Quality Center LDAP

How to change the authentication from LDAP to Quality Center when LDAP server is down?

Below are the steps to change the Authentication from LDAP to QC.
1. In the qcsiteadmin_db database, find the PARAMS table.
2. Look for the record where PARAM_NAME = 'Authentication'. Change the PARAM_VALUE to 'QualityCenter'.
3. Look for records where PARAM_NAME starts with 'LDAP', and delete all of them except one 'LDAP_SEARCH_USER_CRITIRIA'.
4. Restart the Quality Center service using the Quality Center icon in system tray.
5. Users should be able to log in using Quality Center authentication.

Quality Center Authentication

Quality Center Authentication DB Process

• After authenticating with LDAP server, a new row will be inserted to Login_Sessions table with LS_ID, LS_CLIENT_TYPE and with few other details. LS_ID will  be the primary key in this table.

• Once the user selects the Domain name and Project name and click on login button. A row will be inserted into the Project_Sessions table with PS_LS_ID which is a foreign key to the LS_ID of Login_Sessions table and login process will be completed.

• If the user click on logout button these rows will be deleted from the corresponding tables and a row will be inserted into the SESSION_HISTORY table with this information.