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. · Accepted solution]

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 

[Christina Ferreri]

It was the list index! I'm not sure how that would have changed, but I was able to set the Internal directory back to 0 and voila! Thanks Guilherme!

[Christina Ferreri]

The same options in the database don't apply to Bamboo. I can log in as an admin through a Jira login, but not the internal admin. This would be helpful if we ever end up having to reset our Jira servers and lose connectivity.  So far, I reset the password in the users table to the string above, but it didn't work. There aren't any cwd tables.  Do you know how to get Bamboo to use both the user in the users table and the Jira users?