Change the Base URL of Jira server in the database

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

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.


For PostgresSQL:

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'

For Oracle:

update propertystring
set propertyvalue='http://jira.servername.com'
where id=(select id from propertyentry where property_key = 'jira.baseurl');
DescriptionYou 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.
ProductJira
PlatformServer
Last modified on Apr 23, 2020

Was this helpful?

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