helm - postgresql external doesn't work

[qdupuy]

Hello,

Since the helm charts provided by wikijs, I have the following problem :

Loading configuration from /wiki/config.yml... OK
2021-09-06T14:00:28.820Z [MASTER] info: =======================================
2021-09-06T14:00:28.822Z [MASTER] info: = Wiki.js 2.5.201 =====================
2021-09-06T14:00:28.822Z [MASTER] info: =======================================
2021-09-06T14:00:28.822Z [MASTER] info: Initializing...
2021-09-06T14:00:29.170Z [MASTER] info: Using database driver pg for postgres [ OK ]
2021-09-06T14:00:29.173Z [MASTER] info: Connecting to database...
2021-09-06T14:00:29.183Z [MASTER] error: Database Connection Error: XX000 undefined:undefined
2021-09-06T14:00:29.183Z [MASTER] warn: Will retry in 3 seconds... [Attempt 1 of 10]
2021-09-06T14:00:32.187Z [MASTER] info: Connecting to database...
2021-09-06T14:00:32.196Z [MASTER] error: Database Connection Error: XX000 undefined:undefined
2021-09-06T14:00:32.197Z [MASTER] warn: Will retry in 3 seconds... [Attempt 2 of 10]
2021-09-06T14:00:35.201Z [MASTER] info: Connecting to database...
2021-09-06T14:00:35.214Z [MASTER] error: Database Connection Error: XX000 undefined:undefined
2021-09-06T14:00:35.214Z [MASTER] warn: Will retry in 3 seconds... [Attempt 3 of 10]

This is my configuration :

postgresql:
  ## Use the PostgreSQL chart dependency.
  ## Set to false if bringing your own PostgreSQL, and set secret value postgresql-uri.
  ##
  enabled: false
  ## ssl enforce SSL communication with PostgresSQL
  ## Default to false
  ##  
  # ssl: false
  ## ca Certificate of Authority
  ## Default to empty, point to location of CA
  ##
  # ca: "path to ca"
  ## postgresqlHost override postgres database host
  ## Default to postgres
  ##
  postgresqlHost: x-postgresql-ha-pgpool.databases.svc.cluster.local
  postgresqlDatabase: x_wikijs
  postgresqlUser: u_x_wikijs
  postgresqlPort: 5432
  existingSecret: x-wikijs-secrets

Here are the pod variables :

DB_SSL=false
DB_SSL_CA=
DB_PASS=X
DB_TYPE=postgres
DB_HOST=x-postgresql-ha-pgpool.databases.svc.cluster.local
DB_PORT=5432
DB_NAME=x_wikijs
DB_USER=u_x_wikijs

Is there a bug on the helm charts?

[qdupuy]

up

[Rohmilchkaese]

Push, such a shame!

[fnafox]

Well if you're using external postgres then you're not using the postgresql subchart are you?
Define your postgres configuration under externalPostgresql key in values.yaml.
https://github.com/requarks/wiki/blob/main/dev/helm/values.yaml#L119C1-L124C38

[roobre]

For reference, I believe externalPostgresql does not currently work as it is on main. I had to patch it for it to render the expected variables (PR #7036)