Updating the Existing Connection URL's

 
1
0
-1

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

    CommentAdd your comment...

    1 answer

    1.  
      2
      1
      0

      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é

      1. Shiva

        Hi Andre,


        Can you tell me where the DB console is located?


        Thanks,

        Shiva

      2. 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é

      3. Shiva

        Hi André Leroy-Beaulieu Castro


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

        Thanks,

        Shiva


      4. 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é

      CommentAdd your comment...