Updating the Existing Connection URL's

Use Case
, , , ,
1

Originally asked by Shiva on 04 December 2019 (original question)

Hi,

We are using exalate over 6 months now. Now we are updating the base URL for the internal Jira( http to https) so once we update the url how the exalate connection behave? If we update the URL in the external Jira side with the new internal Jira url then the sync will works as usual or do we have to follow any particular steps while updating with new url. We don’t want to lose any existing data sync between our External and Internal Jira environments.

Thanks,

Shiva

2

Answer by André Leroy-Beaulieu Castro on 09 December 2019

Hi Shiva,

The process would be as follows:

  1. In your Internal (Source) Jira, update the base URL from http to https.
  2. In the External (Destination) Jira, since there is no way to update the remote instance URL from the UI, go to the DB Console and execute the following command, replacing the ‘new url’ and ‘old url’ placeholders with their respective values:
UPDATE FROM "AO_08F1AF_INSTANCE" SET "URL" = 'new url', "ISSUE_TRACKER_URL"= 'new url' where "URL" = 'old url';

UPDATE FROM "AO_08F1AF_NODE_INFO" SET "BASE_URL" = 'new url', "ISSUE_TRACKER_URL"= 'new url' where "BASE_URL" = 'old url';

Let me know if this does the trick.

Thanks,

André

Comments:

Shiva commented on 09 December 2019

Hi Andre,

Can you tell me where the DB console is located?

Thanks,

Shiva

André Leroy-Beaulieu Castro commented on 09 December 2019

Hi Shiva,

The easiest way would be with this add-on: https://marketplace.atlassian.com/apps/1212248/home-directory-and-db-browser-for-jira?hosting=server&tab=overview

If you can’t download it for some reason, there has to be someone that configured your jira’s db structure that can tell you how they execute DB commands in your specific Jira infrastructure.

Thanks,

André

Shiva commented on 17 December 2019

Hi André Leroy-Beaulieu Castro

We got this error while executing the SQL using the add-on you suggested.

Thanks,

Shiva

André Leroy-Beaulieu Castro commented on 15 July 2020

Hi Shiva,

We were missing quotes around “URL”, I edited my original answer. let me know how that goes.

Thanks,

André

3

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.