Can't Log In To Confluence/Bamboo As Admin After resetting user in database

Christina Ferreri

I can't access the admin account on the Confluence Internal Directory. I followed the instructions (link below) to reset the credentials for the admin account, but I'm still not able to login.  The account was previously working, but stopped when I was doing a number of things to update the SSL certificate and the server.xml connection to a new keystore.

https://community.atlassian.com/t5/Confluence-questions/Confluence-administrator-locked-out/qaq-p/139356

INFO [http-bio-443-exec-21] [confluence.security.login.DefaultLoginManager] recordLoginFailure
Failed login attempt for user 'admin':

INFO [http-bio-443-exec-11] [confluence.security.login.DefaultLoginManager] recordLoginFailure
Failed login attempt for user 'admin':

WARN [http-bio-443-exec-8] [atlassian.seraph.auth.DefaultAuthenticator] login login : 'admin' tried to login but they do not have USE permission or weren't found. Deleting remember me cookie.

INFO [http-bio-443-exec-8] [confluence.security.login.DefaultLoginManager] recordLoginFailure
Failed login attempt for user 'admin':

Thanks in advance.

Guilherme V.

Hi Christina,

Do you know if the 'admin' user is a member of any 'can use' group?

You can check with the following query:

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';

 If the 'admin' is appearing to you, ensure that you have reset his password to 'admin':

update cwd_user set credential =
'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A=='
where id=<id from Stage 1>;

(!) Don't forget to replace the <id from stage 1> of the above query.

If you are still unable to login, check if the Confluence Internal directory has the '0' value:

select d.id, d.directory_name, m.list_index from cwd_directory d join cwd_app_dir_mapping m on d.id=m.directory_id;

More steps in https://confluence.atlassian.com/conf64/restore-passwords-to-recover-admin-user-rights-936511358.html