dbconfig.xml password issue

[Ranendra Das]

Hello,

I am facing a problem, I am doing JIRA upgrade from 9.12 to 10.3.3. During cdk deploy process(I am using EKS cluster with RDS postgres). I get this error

org.postgresql.util.PSQLException: FATAL: password authentication failed for user "jiradbuser"

Though I can connect to postgres from aws query tool, using the same username and password. So, I feel JIRA looses the password during encrypting it Secured Service.

Can someone tell me a solution, now to run the JIRA - I need to manually update the password in dbconfig.xml which is not ideal.

Thanks,

Ranendra 

[Benjamin · Accepted solution]

Hi @Ranendra Das ,

This should be automatic when you upgrade. Something may have been a miss. You will not be able to avoid updating the dbconfig.xml file if it's not implemented correctly. You'll still need to fix it. 

Here's the documentation to help correct the DB password encryption:

https://confluence.atlassian.com/adminjiraserver/aes-encryption-974378813.html

All the best.

[Ranendra Das]

Thanks for the reply, This is what I added in my values.yaml file(I am using Helmchart with eks) and it's working, thanks again

jira:

additionalEnvironmentVariables:

- name: ATL_DB_PASSWORD_ENCRYPTION_ALGORITHM

value: AES/CBC/PKCS5Padding

- name: ATL_DB_PASSWORD_ENCRYPTION_KEY

value: AES

- name: ATL_FORCE_CFG_UPDATE

value: "true"