How to reset Bamboo Admin password & also set bamboo internal directory ?

Hardik Parekh1

Hi, I am new user of bamboo. I am usning MySQL database. Now I want to reset admin password & I am already done with following steps :

1)select * from USERS where ID=1

it gives me error so I replace USERS with users,

2) update users set PASSWORD = 'x61Ey612Kl2gpFL56FT9weDnpSo4AV8j8+qx2AuTHdRyY036xxzTTrw10Wq3+4qQyB+XURPWx1ONxp3Y3pB37A==' where NAME = 'admin'

it shows me ok

but still I am not able to log-in bamboo. Now what I need to do?

Do I required to set internal directory T=1(as we do for jira) ? if yes how can I do that?

Hardik Parekh1

Hi Krystin,

Thanks for help!

I followed following steps for resolving issue.

1. Please stop Bamboo completely. Make sure there is no frozen/orphaned Bamboo process is running in the background. There are records in your log file showing that there were more than one instances running at the same time. Using command similar to "ps ax |grep amb" can help finding running processes. You can then use "kill -9 (process ID)" to kill them.
2. Open "seraph-config.xml" file from under <bamboo-install>\atlassian-bamboo\WEB-INF\classes and check if SSO is correctly disabled:

...
      <init-param>
        <!--
          the URL to redirect to when the user explicitly clicks on a login link (rather than being redirected after
          trying to access a protected resource). Most of the time, this will be the same value as 'login.url'.
            - same properties as login.url above
        -->
        <param-name>link.login.url</param-name>
        <param-value>/userlogin!default.action?os_destination=${originalurl}</param-value>
        <!--<param-value>/secure/Dashboard.jspa?os_destination=${originalurl}</param-value>-->
        <!--<param-value>http://sso.mycompany.com/login?redirectTo=${originalurl}</param-value>-->       </init-param>
....

3. Please edit the administration.xml file under <bamboo-home>/xml-data/configuration with the following changes:

...
<enableAnonymousAccess>true</enableAnonymousAccess>
...
<enableRestrictedAdmin>false</enableRestrictedAdmin>
...

4. Please remove previous user login credentials by running the command:

delete from rememberme_token;

5. Please also run:

delete from AUTH_ATTEMPT_INFO;

6. Confirm that you have modified the correct atlassian-user.xml file under <bamboo-home>/xml-data/configuration with the following (The file attached to this ticket is correctly modified):

<atlassian-user>
    <repositories>
        <hibernate name="Hibernate Repository" key="hibernateRepository" description="Hibernate Repository" cache="true"/>
    </repositories>
</atlassian-user>

7. Move "logs", "jms-store", "temp" and "caches" from under <bamboo-home> directory to a different location.
8. Please run the update query again and use the this hash this time: "d+o50IH94vMmkUj32ex+lwXNzbSmaZ/6TDueZFQydIH824tXAUtdfCpgiPjO3bV4hvHLDckI4MkapjOTJ2FsdQ=="

Double check to make sure it's saved correctly.

9. Now run Bamboo using "start-bamboo.sh" file from under <bamboo-installation-directory>/bin and login with:
User: admin
Password: sepideh