Restoring passwords to recover admin users
This page describes the procedures if:
- you are unable to log in as an administrator.
- you have forgotten your password and don't have Mail Server configured,
- you want to replace administrator passwords manually.
If you're using the embedded database, you can access Bamboo's H2 through a Database Administration tool, Java GUI, or the command line. Check out how to access Bamboo's H2 database
Before you follow the instructions below, we recommend to back up your database. By that, you'll be able to restore your data if errors appear.
Identifying existing local admin users
To identify any existing local admin users on the Bamboo Internal Directory:
Connect to the Bamboo database and run the following statement to identify the ID of the Bamboo Internal User Directory:
select id from cwd_directory where directory_name = 'Bamboo Internal Directory'- Take note of the ID returned by the query.
Run the following statement to list the users that are part of that directory, replacing
<DIRECTORY_ID>with the ID we got from the previous step.select * from cwd_user where directory_id = '<DIRECTORY_ID>' order by id
Usually, the first user returned by the query would be the local admin created when Bamboo was first installed. However, we recommend checking the first few records to make sure you've identified the correct user.
Reset password
Once you have identified the local admin username, you can reset it if you don't remember its password. Connect to the Bamboo database and run the following statement. Replace the username and directory ID retrieved by the previous steps.
update cwd_user
set credential = 'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A=='
where user_name = '<USERNAME>'
and directory_id = '<DIRECTORY_ID>'The local admin password will now be admin.
If you want to change the password:
- Go to Bamboo Administration > User Management Search > User Directories
- Reorder the list of user directories so that the Bamboo Internal Directory comes first on the list. By that, you'll ensure that the internal admin will be used to log in instead of an external user with the same username.
- Open Bamboo in an incognito window and log in with the admin username you got from the database (usually
admin). The password isadmin. - Go to Profile icon > Profile > Change password and set up a new password.
- Log out and log in again via the incognito window to ensure everything works as expected.
- Return to the standard browser window where you reordered the user directories list. You can now return to the original order (assuming Crowd was first on the list).