User creation when migrating from Confluence 2.8 to 3.5


I'm upgrading a Confluence instance from 2.8 to 3.5. The instance was configured to use LDAP in the osuser.xml file. Before migrated, we copied the osuser.xml file into WEB-INF classes, and we upgraded the instance.

The upgrade failed because the osuser.xml file was too complex. So we decided to remove it and continue the upgrade.

But now we have to recreate the users... We chose a delegated authentication LDAP because the groups are not configured in the LDAP.

I want to recreate all users in the relevant tables via SQL. In JIRA, there is a table called SEQUENCE_VALUE_ITEM, but I can't find the equivalent in Confluence. How can I set the relevant ids in the tables?



1 answer


If your delegated connector has the "Copy User on Login" option selected all you will need to do to rebuild your user would be to have you users login. Having the default user group set to a permitted group is going to make sure that all of the users that are part of your LDAP will be able to access Confluence

Confluence 3.5.x has user information stored in the cwd_user and cwd_membership tables. It is going to be very difficult to try to write a query to insert users and their appropriate group memberships.

My best bet is that if you performed the upgrade without your osuser.xml that the cwd_* tables will no longer contain the older user information. My suggestion is to have your users log in one at a time, or set up your connection to your LDAP as a full sync connector with Ready Only with local groups.

A full sync will actively propogate all of the users in your LDAP into Confluence. You should still be able to set up a default user group to allow everyone access. Ticking the Read Only with Local groups connector ensures that Confluence permissions can be administered directly from Confluence.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,356 views 2 13
Read article

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