Restore Passwords To Recover Admin User Rights Does Not Work

[Felipe Otarola]

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? 

Im using confluence 5.1

thanks
 

[Guilherme V.]

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