the apiserver had troubles connecting to the PSQL

[Najafov007]

Hello there, I recently wanted to test dtrack and made it run. We ran it ou openshift with helm chart. Now I want to connect to dbase postgre. that also was deployed on our cluster. How can we connect it?
Originally posted by @pshakespeare in #3575 (comment)

[nscuro]

See here for general configuration guidance: https://docs.dependencytrack.org/getting-started/database-support/

Note that for containers, the properties are set via environment variables, as explained here: https://docs.dependencytrack.org/getting-started/configuration/#api-server

If you're using the Helm chart, the following should be in your custom values.yaml:

apiServer:
  extraEnv:
  - name: ALPINE_DATABASE_MODE
    value: "external"
  - name: ALPINE_DATABASE_URL
    value: "jdbc:postgresql://postgres.example.com:5432/dtrack"
  - name: ALPINE_DATABASE_DRIVER
    value: "org.postgresql.Driver"
  - name: ALPINE_DATABASE_USERNAME
    value: "dtrack"
  - name: ALPINE_DATABASE_PASSWORD
    value: "dtrack"

Obviously replace the PostgreSQL hostname postgres.example.com with the domain or IP address of your Postgres Pod, and change username and password as needed.

If you deployed PostgreSQL in Kubernetes, you should be able to leverage its service discovery via DNS, so something like this:

jdbc:postgresql://postgres.your-namespace.svc.cluster.local:5432/dtrack

where your-namespace is the k8s namespace in which you deployed PostgreSQL.