Updating the database password in a Jira DC environment
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
This article will clarify how to handle the transition if you need to change the database password for the Jira DB user and wonder how it affects Jira DC.
Updating the external database user password should not cause existing connections to be dropped; therefore, if you so wish, you can update the password in Jira using a rolling-restart strategy.
Detailed steps:
- Update the password in the database directly or with the help of your DBA.
- Stop Jira in one of your nodes.
- Update the '<Jira_home>/dbconfig.xml' with the new password and start Jira on this node again.
If you've followed the strategies outlined in Encrypting database password, you may need to decrypt and re-encrypt the password. - Once the node is available again, repeat the last two steps for the remaining nodes, one at a time.