[en] Set Custom Database Credentials

[en] 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.

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

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

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

[en] 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

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

[en] Additional Information

[en] Don't set the persistence.installTestDB propertyto true. Either remove it entirely or set it to false.
[en] 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.
[en] 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.

Wie können wir helfen?

Suche

[en] Additional Information