Change the Base URL of Jira server in the database
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
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';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');