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 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,187 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