How do change the server URL of an application link in Stash?

[Matthew Studley]

The DNS rules in our lab have recently changed, so instead of referencing http://server:8080/jira, I now must reference http://server.region.country.company.com:8080/jira. This has broken our application links. I have a lot of projects setup between JIRA and Stash and I don't want to upset the commit, branch, and pull request information that makes the integration so awesome. 

I know you can't edit this in the UI, and i imagine this has to be in Stash's database somewhere. The schema is different than JIRA so the instructions found on https://answers.atlassian.com/questions/92503 don't apply. 

I'm poking through the database to find it; If anyone knows off the top of their head, that would be great!

Thanks!

[Matthew Studley · Accepted solution]

I found it. It's in Stash's plugin_setting table. 

Use the following query to find the correct row, and remember the ID of it:

SELECT id, key_value FROM plugin_setting
WHERE key_value LIKE '%<your old server URL>%';

Then use update to change it:

UPDATE plugin_setting SET key_value = '<Your NEW Server URL>'
WHERE id = <ID from query above>;

Reboot stash for settings to take effect.