Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-78706

The Default Group Memberships field is not cleared when removed from the LDAP configuration

XMLWordPrintable

      Issue Summary

      This is reproducible on Data Center: yes

      Steps to Reproduce

      1. Create an LDAP Directory and select Read Only, with Local Groups; 
      2. Set a test group in the Default Group Memberships field, example, jira-software-users;
      3. Save the LDAP configuration;
      4. Edit the LDAP configuration again and remove the value from the Default Group Memberships field; 
      5. Save the configuration. 

      Expected Results

      The Default Group Memberships field will be cleared.

      Actual Results

      The Default Group Memberships field is still with the group value. 

      Workaround

      There is a workaround to manually remove this value from the Jira database, but we recommend that you first perform this approach on a test instance first and create a backup of the database.

      1. Stop Jira;
      2. Create a database backup;
      3. Run the following SQL query in order to find the affected directory ID:
        select * from cwd_directory;
        
      4. With the ID from step 3, run the following query in order to clean the Default Group Memberships field:
        update cwd_directory_attribute set attribute_value= NULL where directory_id= <ID_FROM_STEP_3> and attribute_name='autoAddGroups';
        
      5. Start Jira

              Unassigned Unassigned
              7d74d3b1a350 Rodrigo Jose Zaparoli
              Votes:
              11 Vote for this issue
              Watchers:
              17 Start watching this issue

                Created:
                Updated: