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 vote

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Sarah Goff-Dupont
Published 2 hours ago in Confluence

Think you know shares vs. @mentions in Confluence? Take this collab quiz.

To anyone who doubts that Atlassians are a little too obsessed with collaboration, and tools related thereto, let me describe a recent discussion we had (which took place on our internal Confluence, ...

37 views 2 3
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