How do I Manually Change The Base URL

Still need help?

The Atlassian Community is here for you.

Ask the community

This Knowledge Base article was written specifically for the Atlassian Server platform. Due to the Functional differences in Atlassian Cloud, the contents of this article cannot be applied to Atlassian Cloud applications.

Purpose

You may come across situations where you're unable to edit the Base URL through the UI. This article walks through the process of updating the Base URL through the database. An example error in the UI

"Your session has expired. You may need to re-submit the form or reload the page."

Solution

Manual manipulation of the database can be dangerous. Please make sure you have a backup of your database before you attempt these changes.


You can retrieve the base URL from the propertystring table:

select propertyvalue from propertyentry PE
join propertystring PS on PE.id=PS.id
where PE.property_key = 'jira.baseurl';

In order to update the Base URL, run the following update in your JIRA database replacing the URL and restart JIRA.


ForPostgresSQL:

update propertystring
set propertyvalue = 'http://jira.servername.com'
from propertyentry PE
where PE.id=propertystring.id
and PE.property_key = 'jira.baseurl';

For MySQL:

update propertystring, propertyentry 
set propertystring.propertyvalue = 'http://jira.servername.com' 
where propertystring.ID = propertyentry.ID 
and propertyentry.PROPERTY_KEY = 'jira.baseurl'
Description You may come across situations where you're unable to edit the Base URL through the UI. This article walks through the process of updating the Base URL through the database.
Product Jira
Platform Server
Last modified on Oct 11, 2018

Was this helpful?

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