Previous Topic: Create the OTK/OIDC Database (Oracle)Next Topic: Create an Identity Provider for CA Directory

Single Sign-On Service › SSO Getting Started Guide › SSO Using CloudMinder as an OAuth Authorization Server › Create the OTK/OIDC Database (PostgreSQL)

Create the OTK/OIDC Database (PostgreSQL)

This section applies for tenant deployments where the OTK/OIDC database is PostgreSQL-driven.

Note: Perform this procedure for each tenant for which you configure CA CloudMinder as an external IdP using OAuth. Perform this procedure only once for each tenant, even if the tenant has many OAuth clients.

Follow these steps:

  1. Connect to the CA CloudMinder PostgreSQL database as the system user.

    For example, connect with the psql client.

  2. Open the following file: 
    postgres_oidc.sql
  3. Save a copy of the file, using a filename that represents the tenant for which you are configuring OAuth. For example: 
    postgres_oidc_forwardinc.sql
  4. Replace all instances of <OTKDB-USERNAME> with a user name that is unique to the current tenant.
  5. Replace all instances of <OTKDB-DB> with a database name that is unique to the current tenant.
  6. Replace <OTKDB-PASSWORD> with a password you choose.
  7. Make a note of the username and password for use later in the configuration process.
  8. Save and close the file.
  9. Execute the modified version of the script.
  10. Click Commit.