Restore Passwords To Recover Admin User Rights Does Not Work

So I have been hustling with this for hours now. But I still can't login to confluence.
I bumped into this problem for a month ago and the documentation worked fine then, but now. I can't login.

I have followed every step in this manual, 

https://confluence.atlassian.com/conf51/restoring-passwords-to-recover-admin-user-rights-336169506.html


A new admin is created and active ( T )
A new group is running
and a membership is connected to my admin user (id 1212121)

My internal directory is set to index 0 and its active ( T )

Have i missed something? or is it another problem?

I have done this at least 10 times. and every time it doesn't work I delete everything I created and start over.

Any tips on whats wrong? smile


Im using confluence 5.1

thanks
 



 

1 answer

0 votes

Hello Felipe,

I believe it's better to restore the password for the old admin user instead of creating a new one with that documentation.

I know that you tried 10 times, but, try the following:

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';
update cwd_user set credential =
'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A=='
where id=<id from Stage 1>;
Username:<admin-name-from-first-step>
Password: admin

Don't forget to restart the service after performing the second step

Suggest an answer

Log in or Sign up to answer
Community showcase
Published yesterday in Confluence Cloud

Happy holidays from our team to yours!

Hi Community!  2018 was filled with changes for our team, both big and small, and we've taken a lot of time to both celebrate our wins and recognize areas of improvement. One thing that we're a...

102 views 1 14
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