Is there a way to change the server base URL from either SQL or via a configuration file?
I'm working on automating the testing of our disaster recovery and this is the only aspect that I have left requiring human intervention. If there is an option for doing this, it would make my life a lot easier. I've searched the DB schema for anything with server, base, and url in it but have not found anything.
Thanks, Nic. My question was actually about Confluence. I should have said so explicitly even though I tagged it as such. But your answer got me to thinking, if it's not in someplace obvious as in Jira, then it's got to be someplace that is not obvious. It is in fact in the BANDANA table and stored within a string column that contains XML. Add that info to your answer and I'll accept it. Please leave the info about JIRA as well because people coming hear from Google might be looking for that as well.
SELECT [BANDANAID] ,[BANDANACONTEXT] ,[BANDANAKEY] ,[BANDANAVALUE] FROM [Confluence].[dbo].[BANDANA] WHERE [BANDANAVALUE] LIKE '%domain.com%'
SELECT * FROM [Jira].[dbo].[propertyentry] as [e] INNER JOIN [Jira].[dbo].[propertystring] as [s] on [s].[ID] = [e].[ID ] WHERE [s].[propertyvalue] like '%domain.com%'
For people coming in to actually replace these (instead of just looking at them)
JIRA - replace the whole property (specify the new url, including http/https)
UPDATE propertystring SET propertyvalue = 'https://NEW.URL.com' WHERE id in (select id from propertyentry where property_key like '%baseurl%');
Confluence - replace just the slice (the field is a CLOB) that contains the host portion. You don't need to specify http/https here as the SQL will only replace the portion of the URL that you enter. Just specify your old URL and new URL.
update BANDANA set BANDANAVALUE = replace(BANDANAVALUE, 'OLD.URL.com', 'NEW.URL.com') where BANDANACONTEXT = '_GLOBAL' and BANDANAKEY = 'atlassian.confluence.settings';
Hi my Community friends! For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs