Database Configuration in Containerized OPA, and solution.yml

Mike Arceri

In composed Docker containers I am finding I have to manually create database configurations (Cordys System and Cordys Logger) that are present out of the box on a standard OPA installation. The actual SQL database is initialized without issue, but as far as I know, you need these relational database configurations to be able to actually create any applications. These are not present in the LDAP container.

As well, the documentation is fuzzy about how to construct a proper solution.yml to create a container with an application .cap package. This is my goal - to compose a docker container that works immediately. I have acquired the all-settings.yml from the container, and I see intuitively only a small number of things that can be preset (document store stuff mostly) - and no examples.

Anyone doing this, please share any tips and tricks. Every bit of knowledge is appreciated.

-Mike

Thanneeru_Raju

Hi @Mike Arceri, in containers the default/platform datasource configuration (system) is created only in-memory, you will not see it in ldap.

When we create the service containers through solution yml, we can use the datasource name as system. For example like below.

Sample for creating a wsapps service container in org1 organization.

config_ordinal: 210
platform:
  organizations:
    org1:
      services:
        instances: WSapps
        WSapps:
          kind: com.cordys.cpc.bsf.connector.BsfConnector
          initializeDatabase: true
          dataSource: system

Sample for creating document store service container in system org

config_ordinal: 210

platform:

  services:

    instances: DocStore

    DocStore: 

      kind: com.cordys.documentstore.applicationconnector.DocumentStoreConnector

  content:

    default: xdsConn

    xdsConn:

      kind: PlatformRepository
connectionName: system

      rootFolder: RajuXDS

Sample for creating a custom Datasource configuration through solution yml

config_ordinal: 210

platform:

  database:

    dataSources:

      MyDSO:

        connection: MyDSO

    connections:

      MyDSO:

        kind: PostgreSql

        connectionString: jdbc:postgresql://dbhost:port/myDB

        database: myDB

        jdbcDriver: org.postgresql.Driver

        jdbcXaDriver: org.postgresql.xa.PGXADataSource

        password: password

        userName: postgres

To run a container which includes your application caps, first we need to build an application image by copying your cap files, this is documented already in AppWorks cloud deployment guide, https://support.opentext.com/csm?id=kb_article_view&sysparm_article=KB0843962
Check Section "Building the Application image"