We are running an onprem server Confluence 7.6.2 (with an AD as primary directory) and looking to migrate out to cloud, have hit a snag where I have 2 local user (not AD accounts) with the same email address.
I have disabled the AD directory , moved the local directory up the list and then logged in with a local admin user account.
I was expecting to be able to delete the local user as per these instructions
but the only options i get are:
View Profile, Edit Details, Delete Profile Picture, Set Password, Disable
No delete option.
The user has already logged in so this doesnt seem to work
I have tried this but the no joy (assuming its for jira not confluence)
but SQL throws an error Table 'confluence.app_user' doesn't exist
So I am unable to find either the correct SQL statements on how to remove the user, or even just being able to change the email address would be fine.
Many thanks in advance
Confluence's database doesn't have an equivalent table to Jira's app_user table. Only the cwd_* tables mentioned in that article are present in Confluence.
As you are looking to resolve the problem with duplicated email addresses in the migration assistant, I would advise changing the email address rather than deleting the user from the database. The records involved here are email_address and lower_email_address in the cwd_user table.
Standard warning: Confluence should be off when modifying the database, and you'll want to take a backup first if possible. If you are using a database client with a GUI, it might be convenient to simply modify those two records directly in your client and commit the changes to the database. Otherwise, you could use this SQL statement as a starting point, swapping in your <new_email> and <username>:
UPDATE cwd_user SET lower_email_address = '<new_email>', email_address = '<new_email>' WHERE user_name = '<username>'
Daniel | Atlassian Support
Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond. A long time favorite, Team Cale...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events