nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need to reset admin password on bitbucket server

jitendramohan

Hi,

I installed BitBucket, JIRA and Confluence on a Linux server. I chose "admin" as the user name and the same complex password for all three. For a while I could login everywhere.

Now, however, I can only login on JIRA. Cannot login to BitBucket nor to Confluence. When I click on "forgot password", I get the following error:

"Sorry, you can't retrieve your password as no email service has been configured for Confluence. Please contact your administrators for assistance."

Sending an outgoing mail on JIRA works, but I am not sure about BitBucket/Confluence and I have no way of checking.

These are pretty new version and for the most part, there is no/little actual data in them.

Any thoughts?

Accepted answers

Christian Glockner

Hi Yogesh,

If you're completely unable to log into Bitbucket Server, you can use the lockout recovery process (see https://confluence.atlassian.com/bitbucketserver/lockout-recovery-process-776640158.html) to re-gain access, which then allows you to reset the password and configure SMTP.

Cheers,

Christian

Premier Support Engineer

Atlassian

All comments

Yogesh Mude_u145qk

HI @jitendramohan

Welcome to the community!

Here is the document related to retrieving the admin password or you can reset the admin password but you should know the username for that.

In this documentation, you can find the DB queries using that you can do rest the admin password.

jitendramohan

Hi, I did try the suggestion but it did not work. Below is what I get after the change. As you can see, the password for the bitbucket admin is now set as described in the article. However, at the login prompt on the web, I cannot get in. I did not get a chance to setup SMTP therefore I cannot use it to reset password.

atlbitbucket=> select u.id, u.user_name, d.directory_name from cwd_user u inner join cwd_directory d on u.directory_id = d.id order by directory_name, user_name;

atlbitbucket=> select id, user_name, credential from cwd_user;
id | user_name | credential
--------+-----------+------------------------------------------------------------------------------------------
131073 | admin | uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==
131074 | admin | nopass
(2 rows)

jitendramohan

atlbitbucket=> select u.id, u.user_name, d.directory_name from cwd_user u inner join cwd_directory d on u.directory_id = d.id order by directory_name, user_name;

Yogesh Mude_u145qk

Hi @jitendramohan

As you can see the admin user belongs to Bitbucket Internal Directory so here you can run the below query and set the password for this admin user once done you can able to log with admin username.

update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where user_name='XXXX';

The password for this admin user is a sphere, After successful login with the username you can reset the password for your admin user

jitendramohan

Yes, this is what I did. That is why in the second command, you can see that the user "admin" has the same password as you recommend. However, I still cannot login using password 'sphere'.