nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

LucasA

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

All comments

LucasA

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".

Best regards,
Lucas Timm

Tom Annear

Thanks Lucas!

Best Regards

Tom

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?

Steven T. Snyde

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,

Thanks,

Sreekar.

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.

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

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')

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."

cja_phaseone_com

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

link

update

localhost

application