How do I Manually Change The Base URL

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

Difficulty following the UI Configuring JIRA Options.

Receiving the following error in the UI

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

Resolution

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'
Last modified on Sep 20, 2017

Was this helpful?

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