Bamboo 2.0 : Restoring passwords to recover admin users
This page last changed on Nov 01, 2007 by rosie@atlassian.com.
Use this document if you are unable to login as administrator or have forgotten your password and do not have Mail Server configured, to manually replace administrator passwords. Follow the instructions for either the Embedded Database or External Database. If you have not configured a database, use the Embedded instructions. Embedded Database InstructionsStage One - Identify AdministratorThis guide assumes that the first user added was an administrator. If this is not the case, search for the admin username and find their user id number, then modify their password hash instead.
INSERT INTO USERS VALUES(1,'admin','x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A==','admin@admin.com','2007-08-14 11:26:18.504000000','admin')
External Database InstructionsStage One - Identify UserThe first user added is always an admin. To restore your password you simply need to update the password hash in the USERS table with the admin hash Connect to your database using a database admin tool such as DBVisualiser. Please download a database admin tool now if you do not have one installed already. Once installed, connect to your database and retrieve the list of administrator usernames with: select * from USERS where ID=1 This command should list all users who belong to Bamboo-Admin user group. Stage Two - Replace Administrator PasswordBamboo does not store passwords in plain text in the database, but uses hashes computed from the original password. You instead cut and a paste a hash, rather than the plain password, over the existing password. Below is the hash for the password admin x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A== To change the password to admin for a given username:
|
![]() |
Document generated by Confluence on Apr 14, 2008 01:39 |