OAuth token shows the wrong Bamboo URL

Issue Summary

When creating the first Application Link Bamboo will insert a new row in bandana table with the following key name:

com.atlassian.oauth.consumer.ConsumerService:host.__HOST_SERVICE__

The serialized_data will contain the below information:

<properties>
  <property name="privateKey" value="ARandomPrivateKey"/>
  <property name="name" value="Bamboo"/>
  <property name="key" value="Bamboo:6572144991"/>
  <property name="description" value="Atlassian Bamboo at http://localhost:8085 "/>
  <property name="signatureMethod" value="RSA_SHA1"/>
  <property name="publicKey" value="ARandomPublicKey"/>
</properties>

This data is used when a new OAuth token is generated. The URL shown in the description will be the same one in the OAuth token:

If the Application link URL changes, this database data will not get updated, and the new OAuth tokens created will not show the most recent URL.

Note: This will not affect the application, it's just a display issue.

Steps to Reproduce

1. Create an application link;
2. Try to use the features provided by the application link;
3. Bamboo will ask to Login and Approve in the other application (this will create the OAuth token);
4. Check OAuth token in the other application;
5. Change the Bamboo URL in the application link;
6. Delete the OAuth token and create a new one;

Expected Results

The OAuth token shows the same URL configured in the application link

Actual Results

The OAuth token URL will display the application URL set when the first application link was made.

Workaround

1. Stop Bamboo;
2. Made a database backup;
3. Run the query below replacing OldURL and NewURL:

   • UPDATE bandana set serialized_data = replace(serialized_data, 'OldURL', 'NewURL')
     where bandana.bandana_key = 'com.atlassian.oauth.consumer.ConsumerService:host.__HOST_SERVICE__';
     

4. Start Bamboo;
5. Delete the application link on both sides;
6. Create a new application link;

The new OAuth token generated should show the right Bamboo URL