How to Change URLs of External Gadgets in Jira

Still need help?

The Atlassian Community is here for you.

Ask the community

This article only applies to Atlassian's server products. Learn more about the differences between cloud and server.

Problem

When using external gadgets in Jira, there is no option to edit the existing gadget's URL.  This may be needed if the external hosts change in address.


For example:

  • Jira is connecting to Confluence (http://someconfluencesite.com) and using Confluence gadgets.  These gadgets are used by many users across many different dashboards.
  • Confluence is migrated to a new address: http://newconfluencesite.com
  • The Confluence gadgets in JIRA will now show the following error:

Workaround

Create a database backup before changing anything!

Additionally, any database modifications should be done while Jira is stopped.

  1. Stop Jira
  2. Backup the database
  3. Access the database and verify the gadget URLs that need updating by running the following SQL query:

    SELECT * FROM portletconfiguration WHERE gadget_xml LIKE '%old_address%';
    1. Replace "old_address" of the external gadgets
  4. Update the addresses by running the following query:

    UPDATE portletconfiguration SET gadget_xml = REPLACE(gadget_xml,'old_address','new_address') WHERE gadget_xml LIKE '%old_address%';
    1. Replace "old_address" and "new_address" accordingly
  5. Confirm the changes by running the SELECT query from step 3
  6. Restart JIRA
  7. As an admin, choose to "Manage Gadgets" as show here:
  8. Remove the gadget subscription with the old address
  9. Create a new gadget subscription with the new address


Description
Product
Last modified on Oct 10, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.