Versions Compared

Version Old Version 1 New Version Current
Changes made by

Sarabjeet Kaur

Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

By default, Kyvos Manager uses bundled Postgres as its repository. However, in cloud-based deployments, Kyvos Manager also supports using an external repository for AWS (RDS), or Flexible serverAzure (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.

...

Configuring jdbc.properties

You can configure jdbc properties for:

For fresh deployment

  • Automated deployment

    • Bundled Postgres: No manual configuration is necessary in jdbc.properties since it works well with default configuration values provided in jdbc.properties.

    • External Repository (AWS RDS, Flexible server): No manual configuration is required in jdbc.properties as everything is configured automatically.

...

  • Wizard based deployment

    • Bundled Postgres: No manual configuration changes are required in the jdbc.properties as everything works well with default provided configuration values in jdbc.properties

    • External Repository (AWS:RDS, Azure: Flexible server):

      • Before configuring the jdbc.properties file, ensure that Kyvos Manager is not started.

      • Replace the server name in jdbc url with the FQDN server name of the external repository instance, port and SSL.
        For example, jdbc.url=jdbc:postgresql://kyvosmanager-postgresserver-5122.postgres.database.azure.com:5432/kmrepo?sslmode=require

      • jdbc.username should be kmdbuser.

      • Set the value of useBundledRepo and manageBundledRepoService to ‘false.’

Upgrade or Repository Switching (in between bundled and external)

  • Depending on whether switching from bundled to external or external to bundled, you need to set some properties while values and making values of irrelevant properties as blank.

Changing jdbc.properties

...

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFFAE6

Important

  • When you switch to an external repository, such as the Kyvos Manager repository, while currently using bundled Postgres, data migration from the bundled Postgres to the external repository becomes a prerequisite and a manual activity.

  • You must use the export and import commands for database.

Case 2

Update the following properties when migrating from external repository to bundled Postgres:

Anchor
External-Repository-to-Bundles-Postgres
External-Repository-to-Bundles-Postgres

...

Panel
panelIconIdatlassian-info
panelIcon:info:
bgColor#FFFAE6

Important

  • When you switch to a bundled repository as the Kyvos Manager repository while currently using the external repository, data migration from the external repository to a bundled repository becomes a prerequisite and a manual activity.

  • You must use the export and import commands for database.

Case 3

Update the following properties when migrating from Flexible Server to Single Server:

Anchor
Flexible-Server-to-Single-Server
Flexible-Server-to-Single-Server

  • jdbc.url

  • jdbc.username

Panel
panelIconIdatlassian-note
panelIcon:note:
bgColor#DEEBFF

Note

In the jdbc file,

  • If using Single Server, you must add @servername in the username field.

  • If using Flexible Server, you must remove @servername from the username field in the jdbc file.

Other properties

The username and password must be updated if they are not the default.

...

Panel
panelIconIdatlassian-warning
panelIcon:warning:
bgColor#FFEBE6

Warning

  • Do not modify the values for jdbc.driverClassName and jdbc.dialect properties. Kyvos Manager currently only supports Postgres as its repository and is certified to use it.

  • When changing the database server or switching between bundled and external, update the IP, port, or SSL attributes as applicable in the jdbc.url.
    jdbc.url=jdbc:postgresql://localhost:45421/kmrepo

  • The value of the ‘localhost’ must be REPLACED with the ACTUAL hostname or IP.