Shadow directory id in cwd_user database

Hello,

I am just curious if someone knows about the shadow directory which is not showing in the user directories section while I can see it in database and some users there are included in groups and are being shows in "Project Roles list" like inactive which is the correct behaviour but in Crowd these users were removed from all groups and must not be shown in JIRA, still I am able to "administer" this user in JIRA.

Selects are showing something like:

select * from cwd_user where directory_id=10000 and active=1 and user_name='test@test.com'\G
*************************** 1. row ***************************
ID: 12956
directory_id: 10000
user_name: test@test.com
lower_user_name: test@test.com
active: 1
created_date: 2011-11-18 15:51:42
updated_date: 2011-11-18 15:51:42
first_name: test
lower_first_name: test
last_name: test
lower_last_name: test
display_name: Atest
lower_display_name: test
email_address: test@test.com
lower_email_address: test@test.com
CREDENTIAL: nopass
1 row in set (0.00 sec)

select * from cwd_membership where directory_id=10000 and child_name='asavchenko@geeksforless.net' order by lower_child_name desc\

*************************** 1. row ***************************
ID: 13142
parent_id: 10218
child_id: 11956
membership_type: GROUP_USER
group_type: NULL
parent_name: jira-users
lower_parent_name: jira-users
child_name: test@test.com
lower_child_name: test@test.com
directory_id: 10000
*************************** 2. row ***************************
ID: 14982
parent_id: 10218
child_id: 12956
membership_type: GROUP_USER
group_type: NULL
parent_name: jira-users
lower_parent_name: jira-users
child_name: test@test.com
lower_child_name: test@test.com
directory_id: 10000
*************************** 3. row ***************************
ID: 15973
parent_id: 10310
child_id: 12956
membership_type: GROUP_USER
group_type: NULL
parent_name: confluence-users
lower_parent_name: confluence-users
child_name: test@test.com
lower_child_name: test@test.com
directory_id: 10000
*************************** 4. row ***************************
ID: 16056
parent_id: 10217
child_id: 12956
membership_type: GROUP_USER
group_type: NULL
parent_name: jira-QA
lower_parent_name: jira-qa
child_name: test@test.com
lower_child_name: test@test.com
directory_id: 10000
4 rows in set (0.00 sec)

The main concern is that I have only two directories ids I am aware of 1 - JIRA local, 10100 - Crowd Directory.

Does anyone know if these records can be removed or maybe they are used by something?

Thank you in advance.

1 answer

1 accepted

This widget could not be displayed.

Hi Vladimir,

There is a know bug with this description (https://jira.atlassian.com/browse/JRA-27437), it occurs when you delete an user directory and some orphan entries are kept into the database.

There is also this KB article that explain a known issue that those orphan entries can cause. You may follow the instructions at the resolution section of the KB and remove those entries.

I hope it helps

Cheers

Thank you, Tiago. I was able to remove the retired users using the KB Aricle that you have provided.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

199 views 1 3
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you