Having issue after database restore in test environment.

Question

We restore our test environment database from production backup (to get the latest data in test). After this when we started the application we noticed that it is redirecting to the production URL. We updated base URL in bandana table for BANDANAKEY = 'atlassian.confluence.settings' as well but this is not fixing the issue. We appreciate any pointers to solve this. Thanks.

Mitsu Chatrola · Answer

We are able to fix this issue. We had SSO enabled via plugin.  We enabled default login for the application as suggested here and it fixed our issue - https://confluence.atlassian.com/confkb/enable-default-login-page-to-bypass-saml-in-confluence-data-center-957972845.html

Mitsu Chatrola · Answer

Hi Jeroen,

Yes I have tried above query and "DELETE from BANDANA WHERE BANDANAKEY = 'atlassian.confluence.smtp.mail.accounts' "  as well but still I am having the same issue. As soon as I login to application, it redirects me to production URL. I have restarted the application after DB changes.

Jeroen Poismans · Answer

Hi Mitsu, Just to make sure, you used this query to update the baseURL on database? update BANDANA set BANDANAVALUE = replace(BANDANAVALUE, ' ', '') where BANDANACONTEXT = '_GLOBAL' and BANDANAKEY = 'atlassian.confluence.settings'; If so, you also performed a restart after that? What could also cause this: Changing baseUrl makes sure that all relative links are corrected to the correct instance. However, if in the pages links are created directly to other pages using a full url, these are NOT corrected. So a best practice here is not using browser links to link pages to each other, they never get corrected when baseURL changes. Hope this helps!