nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confluence - administrator locked out

Ben Corcoran

I'm just using Confluence casually at home for some practice for my work set up.

I logged out the other day, and when I tried to log back in it doesn't recognise my user/password.

I'm damn sure the password is correct, but something's definitely not working. Don't have a mail client set up so can't email myself the password, etc - and neglected to set someone else up as admin to fix it for me. Yes, I'm an idiot.

Is there any way to either:

Reset the administrator

Reset the admin password?

Accepted answers

Nic Brough -Adaptavist-

Yup, see https://confluence.atlassian.com/display/DOC/Restoring+Passwords+To+Recover+Admin+User+Rights

All comments

Nic Brough -Adaptavist-

Yup, see https://confluence.atlassian.com/display/DOC/Restoring+Passwords+To+Recover+Admin+User+Rights

Rodrigo Girardi Adami

Just to specify the queries you'd need to run in order to change the administrator password:

select u.id, u.user_name, u.active from cwd_user u
join cwd_membership m on u.id=m.child_user_id join cwd_group g on m.parent_id=g.id join cwd_directory d on d.id=g.directory_id
where g.group_name = 'confluence-administrators' and d.directory_name='Confluence Internal Directory';

With this query, You'll get the admin IDs. Then you can change the admin password with the next query:

update cwd_user set credential =
'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A=='
where id=&lt;id from Stage 1&gt;;

Hope that helps!

Rodrigo

Ben Corcoran

Thanks to you both!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

password

administration