Preparing for a password-based SSL connection (WebSphere Application Server)

You need to prepare your environment to set up an SSL connection between the Content Engine and the PostgreSQL database server.

Before you begin

You need to configure an SSL connection with the PostgreSQL database server from the WebSphere® Application Server console. For more information, see the topic Configuring an SSL connection with your database server.

About this task

If you want to use an SSL connection with your PostgreSQL database, you must import the SSL certificate from the database server. You can then configure an SSL-enabled connection to GCD and object store databases that use PostgreSQL.

Your PostgreSQL provider might have different terms or controls for the following steps. Consult the documentation for your provider for more information.

Procedure

Follow the steps to if you plan to enable SSL communication between Content Platform Engine and PostgreSQL server in a WebSphere Application Server environment:

  1. On your PostgreSQL provider, enable SSL connection based on traditional password authentication.
  2. On your PostgreSQL provider, generate a root certificate or a server Certificate Authority (CA) certificate.
  3. Download the root certificate.
    root.crt
  4. In the Content Platform Engine client machine, install the certificate file that you downloaded from the server in a folder of your choice.

What to do next

You can now configure the Content Platform Engine GCD and object store data sources to use SSL connection with the PostgreSQL database.