This section explains how to configure the jdbc.properties file used by Kyvos Manager to establish the JDBC connection with its PostgreSQL repository. This configuration ensures that Kyvos Manager can correctly access and manage its repository database.

Kyvos Manager supports and uses Postgres as its repository. Data source configuration is set in file jdbc.properties, located at kyvosmanagerdata/server/db/.

By default, Kyvos Manager uses installed Postgres as its repository. However, in cloud-based deployments, Kyvos Manager also supports using an external repository for AWS (RDS), or Azure (Flexible Server), GCP (CloudSQL).

• For automated deployment (default Path), the location of the Kyvos Manager data folder is /data/kyvos/installs/kyvosmanager_war/

• For non-automated deployments (i.e., on Prem or wizard-based deployments in a cloud environment), its location will be inside the kyvosmanager_war folder that was created initially.

Kyvos Manager has been enhanced to wait for the external repository to become fully operational during startup, similar to the behavior of the Analytical Server.

The following properties must be added or updated in the jdbc.properties file of the Kyvos Manager:

• AWS:

  • repoIdentifier- Name of the Kyvos Manager PostgreSQL Server.

• Azure:

  • repoIdentifier- Name of the Azure Database for PostgreSQL Flexible Server (Kyvos Manager).

  • resourceGroupName- Name of the resource group containing the PostgreSQL Flexible Server for Kyvos Manager.

  • repoInstallationDataDirPathPrefix= The default path is /var/lib/pgsql.

• GCP:

  • serviceAccountName- Name of the service account.

  • jdbc.url- IP of the repository

    • Enter IP of the CloudSQL Kyvos Manager repository.

    • Enter IP of the installed PostgreSQL Kyvos Manager

    • Enter IP of the bundled PostgreSQL Kyvos Manager

  • cloudProvider- Enter cloud provider name.

  • SecretStoreIdentifier: Enter the name of the secret.

  • projectName: Enter the project name.

  • repoIdentifier: Enter the name of Cloud SQL of Kyvos Manager.

  • useBundledRepo: Set the value to true or false. By default, the value true is set.

    • true: If you use bundled repository.

    • false: If you use installed/cloudSQL repository.

  • manageBundledRepoService: Set the value to true or false. By default, the value true is set.

    • true: If you use bundled repository.

    • false: If you use installed/cloudSQL repository.

  • installedRepo=
    Set the value to true or false. By default, the value is set to false.

    • true: If you use installed repository.

    • false: If you use bundled/ cloudSQL repository.

Properties of jdbc.properties

jdbc-related core properties

• jdbc.driverClassName=org.postgresql.Driver

• jdbc.dialect=org.hibernate.dialect.PostgreSQLDialect

• jdbc.url=jdbc:postgresql://localhost:45421/kmrepo

• jdbc.username=kmdbuser

• jdbc.password=

 Password encryption-related configuration

• cryptographyAlgorithm=AES_128_GCM

Cloud-specific configuration properties

• secretStoreIdentifier=

• cloudProvider=

• projectName=

• serviceAccountName=

• repoIdentifier=

• installedRepo=

  • Set the value to true or false. By default, the value false is set.

    • true: If you use installed PostgreSQL repository.

    • false: If you use bundled/cloudSQL repository.

 Bundled Postgres management-related configuration values

• useBundledRepo=true

• homePathBundledRepo=

• manageBundledRepoService=true

Installed Postgre16 Repository management-related configuration values:

• repoInstallationDataDirPathPrefix=/var/lib/pgsql

• installedRepo=
  Set the value to true or false. By default, the value false is set.

  • true: If you use installed Postgres repository.

  • false: If you use bundled/ cloudSQL repository.