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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

602 views 20 11
Join discussion

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