How to Change URLs of External Gadgets in Jira
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
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.
- Stop Jira
- Backup the database
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%';- Replace "old_address" of the external gadgets
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%';- Replace "old_address" and "new_address" accordingly
- Confirm the changes by running the SELECT query from step 3
- Restart Jira
- As an admin, choose to "Manage Gadgets" as show here:
- Remove the gadget subscription with the old address
- Create a new gadget subscription with the new address