How do I manually change the base URL
When having issues with following the UI Configuring the Server Base URL, you receive the following error in the UI
"Your session has expired. You may need to re-submit the form or reload the page."
Manual manipulation of the database can be dangerous. Please make sure you have a backup of your database before you attempt these changes.
Retrieve the base URL from the bandana table:
select BANDANAVALUE from BANDANA where BANDANACONTEXT = '_GLOBAL' and BANDANAKEY = 'atlassian.confluence.settings';
update BANDANA set BANDANAVALUE = "<string_from_above_step>" where BANDANAKEY = 'atlassian.confluence.settings';
Alternatively, if you're certain your baseUrl value is not anywhere else in the output, one can use the replace function to make the job a lot faster:
update BANDANA set BANDANAVALUE = replace(BANDANAVALUE, '<old baseUrl>', '<new baseUrl>') where BANDANACONTEXT = '_GLOBAL' and BANDANAKEY = 'atlassian.confluence.settings';