Set Custom Database Credentials

You can set database credentials for all seven database connections in the Helm chart that you use to used to set up the Acrolinx Platform.

You'll use the following properties to set each type of database connection:

Property	Database Connection
`platform.persistence.properties`	Terminology Reporting Analytics
`platform.persistence.credentials`	Targets Reuse

To set custom credentials for a database, do the following:

Edit the Helm chart for database type, user, password and URL settings. It'll look something like this:

### Top part of the helm chart left out here

apiVersion: helm.cattle.io/v1
kind: HelmChart
metadata:
  name: acrolinx
  namespace: acrolinx-system
spec:
  repo: https://acrolinx.github.io/helm/
  chart: acrolinx-platform
  version: "1.3.15+2022.12"
  set:
    ### Guidance package, image and other platform settings left out here

  valuesContent: |-
    platform:
      features: [targets, new-reuse]
      spec:
        languageServers:
          - name: default
            languages: [ en, de ]
        configuration:
          coreserver.properties: ""
      ### Database settings ###
      persistence:
        properties:
          terminology:
            dbType: POSTGRES
            jdbcUser: terminology
            jdbcPassword: terminology
            jdbcUrl: jdbc:postgresql://<your-postgres-host>:5432/terminology
          reporting:
            dbType: POSTGRES
            jdbcUser: reporting
            jdbcPassword: reporting
            jdbcUrl: jdbc:postgresql://<your-postgres-host>:5432/reporting
          jreport.sys:
            dbType: POSTGRES
            jdbcUser: jreport
            jdbcPassword: jreport
            jdbcUrl: jdbc:postgresql://<your-postgres-host>:5432/jreport
          jreport.realm:
            dbType: POSTGRES
            jdbcUser: jreport
            jdbcPassword: jreport
            jdbcUrl: jdbc:postgresql://<your-postgres-host>:5432/jreport
          jreport.prof:
            dbType: POSTGRES
            jdbcUser: jreport
            jdbcPassword: jreport
            jdbcUrl: jdbc:postgresql://<your-postgres-host>:5432/jreport

        credentials:
          target:
            DB_URL: jdbc:postgresql://<your-postgres-host>:5432/target
            DB_USERNAME: target
            DB_PASSWORD: admin
          reuse:
            DB_URL: jdbc:postgresql://<your-postgres-host>:5432/reuse
            DB_USERNAME: reuse
            DB_PASSWORD: reuse

Reapply the Helm chart with kubectl apply -f <helm-chart.yaml>.

Additional Information

Don't set the persistence.installTestDB propertyto true. Either remove it entirely or set it to false.
Be careful with the chart formatting. Be sure to leave the structure of the maps as is. For example, don't use flattened combined keys like persistence.properties.jreport.proft.dbtype: POSTGRES.
We don't support a mixed setup with some internal and some external databases. As soon as external credentials are configured, the internal database is shut off.

How can we help?

Search

Additional Information