1 answer
- 210
Hi Shiva,
The process would be as follows:
- In your Internal (Source) Jira, update the base URL from http to https.
- 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é
- Shiva
Hi Andre,
Can you tell me where the DB console is located?
Thanks,
Shiva
- André Leroy-Beaulieu Castro
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
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
Hi Shiva,
We were missing quotes around "URL", I edited my original answer. let me know how that goes.
Thanks,
André
Add your comment... - In your Internal (Source) Jira, update the base URL from http to https.
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