Getting liquibase working on OpenShift with generated Helm charts (missing environment variables)

[ljpeters]

Hi,

I'm trying to deploy to OpenShift, but fail to connect liquibase to the postgresql database. Postgresql is deployed as a Helm dependency. I can't get Liquibase to connect to postgresql, instead it keeps connecting to the default localhost.
I have added these lines to application.properties:

quarkus.datasource.jdbc.url=${QUARKUS_DATASOURCE_JDBC_URL:jdbc:postgresql://localhost:5432/quarkus}
quarkus.datasource.username=${QUARKUS_DATASOURCE_USERNAME:quarkus}
quarkus.datasource.password=${QUARKUS_DATASOURCE_PASSWORD:quarkus}

which cause the generated deployment.yaml to have these environment variables:

    spec:
      containers:
        - env:
            - name: QUARKUS_DATASOURCE_PASSWORD
              value: {{ .Values.app.envs.QUARKUS_DATASOURCE_PASSWORD | quote }}
            - name: QUARKUS_DATASOURCE_JDBC_URL
              value: {{ .Values.app.envs.QUARKUS_DATASOURCE_JDBC_URL | quote }}
            - name: QUARKUS_DATASOURCE_USERNAME
              value: {{ .Values.app.envs.QUARKUS_DATASOURCE_USERNAME | quote }}
            - name: QUARKUS_LIQUIBASE_ENABLED
              value: {{ .Values.app.envs.QUARKUS_LIQUIBASE_ENABLED | quote }}

But the job.yaml does not have the environment variables, only these

    spec:
      containers:
        - env:
            - name: QUARKUS_INIT_AND_EXIT
              value: "true"
            - name: QUARKUS_LIQUIBASE_ENABLED
              value: "true"

The Helm files are generated using quarkus-helm, and after that I'm setting the values through a values-tst.yml, which I refer to when I do helm install. The helm chart gets deployed, but the liquibase Job crashes because it cannot connect to the database, it uses localhost.

I can't figure out how I'm able to pass the correct connection properties to the liquibase image. The documentation states that liquibase shares the same properties as the application.
Is this a bug in the helm extension? or maybe somewhere else? Or can someone point me to the correct steps to take?

[quarkus-bot[bot]]

/cc @andrejpetras (liquibase), @geoand (liquibase,openshift), @gsmet (liquibase), @iocanel (openshift)