Confluence JDBC Connection; nested exception Connection to confluence.svc:5432 refused in kubernetes

[PKAR]

Environment : Killercoda

DB : Crunchy Postgres

Below externally (from postgres-client pod) able to connect DB

Error below

[Yevhen]

@PKAR in your test pod you are using a different hostname while Confluence tries to connect to 

pgatlaciandb-primary.confluence.svc

[PKAR]

yes, pgatlaciandb-ha.confluence.svc but I tested with both, same result.

You can try in killerkoda, I already send you the link for simulate

[Yevhen]

I doubt it's a product issue. Just make sure you use the right hostname. By the way, you may need to set https://github.com/atlassian/data-center-helm-charts/blob/main/src/main/charts/confluence/values.yaml#L900 to true otherwise confluence.cfg.xml won't be re-generated.

[Yevhen]

root@confluence-0:/var/atlassian/application-data/confluence#
root@confluence-0:/var/atlassian/application-data/confluence# psql -h pgatlaciandb-ha -U confluence confluence_db
Password for user confluence:
psql (16.3 (Ubuntu 16.3-0ubuntu0.24.04.1), server 14.6)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, compression: off)
Type "help" for help.

confluence_db=#

Works for me.

[PKAR]

I modified  forceConfigUpdate: trure in values but same error. Even from POD I think it will connect.

Running ENv GUI: https://d6517e19-1112-4164-bcd8-79936d4099fe-10-244-8-164-32599.papa.r.killercoda.com/bootstrap/selectsetupstep.action

Running env CLI: https://d6517e19-1112-4164-bcd8-79936d4099fe-10-244-8-164-40205.papa.r.killercoda.com/#/root

[Yevhen]

You still have 

jdbc:postgresql://pgatlaciandb-primary.confluence.svc:5432/confluence_db

in your values file.

Also, I am not sure if NodePort and Killercoda way of exposing services works well with Confluence. 

I have tried your configuration and Confluence pod passes readiness probe. Can you share output from kubectl get pods?