-
Bug
-
Resolution: Duplicate
-
Medium
-
None
-
4.3.4
-
None
-
4.03
-
Steps needed to reproduce the problem:
- Create new LDAP User Directory.
- Sync it with LDAP server.
- Remove the created directory.
- Reviewing content of cwd_user or cwd_grup table disclose list of records created during the sync and left behind after the directory was deleted.
Despite that at first it may look as an insignificant problem, for big LDAP repositories we may have possibly thousands of orphaned records.
_Before:_ mysql> select ID, directory_name from cwd_directory; +-------+-------------------------+ | ID | directory_name | +-------+-------------------------+ | 1 | JIRA Internal Directory | | 10001 | Active Directory server | +-------+-------------------------+ 2 rows in set (0.00 sec)
After:
mysql> select ID, directory_name from cwd_directory; +-------+-------------------------+ | ID | directory_name | +-------+-------------------------+ | 1 | JIRA Internal Directory | +-------+-------------------------+ 1 rows in set (0.00 sec)
mysql> select group_name, directory_id from cwd_group where directory_id=10001; +-----------------------------------------+--------------+ | group_name | directory_id | +-----------------------------------------+--------------+ | jira-users | 10001 | | Enterprise Read-only Domain Controllers | 10001 | | Schema Admins | 10001 | | Distributed COM Users | 10001 | +-----------------------------------------+--------------+ 4 rows in set (0.00 sec)
mysql> select user_name, directory_id from cwd_user where directory_id=10001; +---------------+--------------+ | user_name | directory_id | +---------------+--------------+ | Guest | 10001 | | krbtgt | 10001 | | Administrator | 10001 | | jira | 10001 | | jirauser | 10001 | | testtest | 10001 | +---------------+--------------+ 6 rows in set (0.00 sec)
- is duplicated by
-
-
- Closed
-
