Where are users use LDAP (Microsoft AD) stored

Question

Hi,

I've setup JIRA server so that we would invite users in order to create them. Once the user accepts the invite, the user would be created. It is configured to use the LDAP (Microsoft active directory) instead of the internal directory.

I was wondering when the user is created, does it still save into teh JIRA database? (e.g.  to the "cwd_users" table?).

Sincerely,

Jason

Payne · Answer

Hmm, I'm at a loss, then. In our installation, our AD users are all in the cwd_user table.

Jason Yeung_2zffgc · Answer

@Payne ,

I expected 2 rows as well, as I thought it stores records in cwd_user, even if it uses LDAP. I'm starting to think it caches the results somewhere.

I tried to check email_address like '%tushar%', but no records are turned. When I checked user_name = 'jiraadmin', only 1 record appears, which is the one in the original screenshot.

Jason

Payne · Answer

I see that you have 2 users with a username of jiraadmin - one in the internal directory and one in your defined LDAP directory; I guess that explains the difference in which one is returned via the interface depending upon the order of the directories. Though, I would expect them both to be returned.

Your SQL looks fine, and I would expect it to return 2 rows. Perhaps the "tushar" address has a leading or trailing space? Maybe try a where clause of where email_address like '%tushar@binarystream.com%' You could also try where user_name='jiraadmin'