How to make Confluence 4.0 user management from Jira 4.1.2

Question

We have Confluence 4.0 and Jira 4.1.2. Jira is configured to use ActiveDirectory and external password management is on.

We intended to use Jira for the user management of Confluence. 
We had to use Jira legacy connection (opensymphony) as a user directory which selects records from userbase table. But it also tried to get password from the same table. Then, we added delegated LDAP authentication (Ms. AD) to the user directories and ordered prior to the Jira legacy connection. This time, it related the user and the new directory hence breaking the relations between the users and the groups defined in Jira. Looks confusing.

Is there a way to; 
use LDAP/AD for user authentication, manage groups and related users in Jira and let Confluence use these?

Thanks.

Tolga.

Elijah · Answer

Question back to you. We are using 4.1.2 and are stumped. The system is making some 36 million database calls and we believe it has to do with the userbase and or membershipbase tables. Do you know how or where calls are made by JIRA to delete records? The postgres logs are capturing  query: EXECUTE <unnamed> = DELETE FROM PUBLIC.MEMBERSHIPBASE WHERE USER_NAME=$1 AND GROUP=$2.

See My posting here on the forum