Need to change the application link URL

[Tom Annear]

Hi,

I'd prefer not to have to rebuild 36 project connections from Confluence to Jira.

How can I change the application connection URL from http://localhost:8080 to

http://<insert working="" lan="" address="">:8080 ?

Is there a configuration file I can edit?

I will need to change these again, when we move from a stage

environment to a proper URL.

I know how to change the displayed URL, that is not the problem.

If I have to remove the link and rebuild it,

I need to know this now, because I will halt further work

until I get a final destination for the applications.

Regards

Tom

[LucasA · Accepted solution]

Hi Tom,

There's no way to edit the application links via UI on both, JIRA and Confluence. So you have two alternatives:

1) You can remove and re-create all of them; Or
2) You can edit them straight on the database.

Since you're doing it on a stage environment, I believe that you can do it via database. Just perform a backup before modifying any value.

In advance, to locate your application links, you can use the following query:

SELECT PS.id, PS.propertyvalue, PE.propertytype, PE.property_key FROM propertystring AS PS
INNER JOIN propertyentry AS PE
ON PS.id = PE.id WHERE PS.propertyvalue LIKE '%localhost:8080%' AND PE.property_key LIKE '%app%';

After that, stop JIRA and modify the "propertyvalue" field in the "propertystring" table according to its "id".

Start JIRA once again and check if the URL has changed on the application link screen. You may also need to modify the application link in the Confluence side, but I don't know how to do this via database.

Best regards,
Lucas Timm

[Tom Annear]

Thanks Lucas!

Best Regards

Tom

[Remon van Gijn]

For us the only way to get this right (in a stack of jira,confluence,fisheye) was indeed to stop each application, and use the detection in the application links section to give the RELOCATE option. The app does not need to be online to push the change through.

[Veracode]

Could you elaborate on what you mean by "use the detection in the application links section to give the RELOCATE option"? We are scripting the migration of our stack (JIRA/Confluence/Stash) from production to staging to test. We'd like to update the application links (perhaps in the database?) as part of the migration. It sounds like you may have a solution for our problem.

[Remon van Gijn]

:) A bit of a while back; but I'm sure I did not script this. When the App you link -TO- is unavailable, the Administration>Application Link section in each APP provides the option to 'repair' the link, as it does detect the link it currently has is defective. This gives you the chance to change it.

[Remon van Gijn]

The comments two answers down mentioned the same as what I did: "If the application is not accessible, sometimes JIRA will notify you at the top of the Application Links page. If you click the "relocate" link it will allow you to change the URL through the UI without stopping the service."

[Marco Wlotzka]

A hack but works for me - and needs no database manipulation or shutdown.

• Make a new host entry under C:\Windows\System32\drivers\etc\hosts using an invalid IP
  0.0.0.1 jira.mycompany.org
 
• Refresh application links page in confluence - Relocate warning for JIRA comes up.
• Remove hosts entry.
• change url for your JIRA application link.

Regards

Marco

[cja_phaseone_com]

Fantastic. This is super easy and it works for me.

[Alexey Bordonos]

In case you need it the opposite way - if your Confluence have moved and you need to update links in JIRA issues.

You can do it in the database (an example for MS SQL):

update [your_jira_db].[jiraschema].[remotelink] set URL = REPLACE(CONVERT(VARCHAR(100), URL), 'old_host', 'new_host')

[Steven T. Snyder]

If the application is not accessible, sometimes JIRA will notify you at the top of the Application Links page. If you click the "relocate" link it will allow you to change the URL through the UI without stopping the service.

I don't know why you can't force the URL to change through the UI. If you don't see the option to relocate, try to do something on JIRA that results in an error reaching Confluence. That may trigger the "application is offline" status.

I know this works for Confluence because I just did it. I'm not sure about other applications.

I'm using JIRA 5.2.

[LucasA]

Hi Steven,

This also works for JIRA, but it will be possible only if JIRA/Confluence couldn't reach the other application. If the application is reachable, the only way for modifying the application link URL is via database.

Best regards,
Lucas Timm

[Sagar Sagiraju]

Hi,

can you please tell me how to change the URL of the site.? I mean its now http://localhost:port. I have been accessing it from my local machine as http://<serverip>:port . I would want to get it changed as http://confluence.mydomain.com How can i do this change.? Mine is a standalone installation of confluence 5.3. any help would be greatly appreciated.

Thanks,

Sreekar.

[Sreekar Achanta]

Hi,

can you please tell me how to change the URL of the site.? I mean its now http://localhost:port. I have been accessing it from my local machine as http://<serverip>:port . I would want to get it changed as http://confluence.mydomain.com How can i do this change.? Mine is a standalone installation of confluence 5.3. any help would be greatly appreciated.

Thanks,

Sreekar.

[Deleted user]

We're facing a similar challenge. We have our Jira instance on an internally resolved url ("http://gojira") and are going to begin making it available to public net so we'll need to modify it (http://gojira.ourcompany.com)

Dropping and re-adding the trusted application to change the URL is not an option as it orphans any existing macro/gadget references in existing pages. Ugly.

From Confluence 5.3, I found this returned what I was looking for but I'm not sure how to determine if this is exhaustive. In other words, if we change it here will that do the trick or are there other locations related to each page reference for instance, that will need to be modified for this to not break 100's of pages in our Confluence instance?

SELECT TOP 100 * FROM dbo.BANDANA WHERE BANDANAVALUE LIKE '%gojira%'

Thanks,

Steve

[Russell J Zera]

Hi Tom,

There's no way to edit the application links via UI on both, JIRA and Confluence. So you have two alternatives:

1) You can remove and re-create all of them; Or
2) You can edit them straight on the database.

Since you're doing it on a stage environment, I believe that you can do it via database. Just perform a backup before modifying any value.

In advance, to locate your application links, you can use the following query:

1 2 3

SELECT PS.id, PS.propertyvalue, PE.propertytype, PE.property_key FROM propertystring AS PS INNER JOIN propertyentry AS PE ON PS.id = PE.id WHERE PS.propertyvalue LIKE '%localhost:8080%' AND PE.property_key LIKE '%app%';

After that, stop JIRA and modify the "propertyvalue" field in the "propertystring" table according to its "id".

Start JIRA once again and check if the URL has changed on the application link screen. You may also need to modify the application link in the Confluence side, but I don't know how to do this via database.

Best regards,
Lucas Timm

By Lucas Timm (971 karma) Oct 03 at 09:58 AM

We need a little further explanation. We have a large fully utilized environment running that had to re-address our servers with IP-based addressing vs relational addressing. It will not let us create a new application link because the Server ID is already an existing link, we can't edit the Application URL, we'd like to do what you recommend, but it would require stopping the service, which we were hoping to not have to resort to. Any thoughts?