BWCE Mon configuration for connecting to SSL enabled PostgreSQL Database

BWCE Mon configuration for connecting to SSL enabled PostgreSQL Database

book

Article ID: KB0074753

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect Container Edition 2.4.x, 2.5.x

Description

Currently we do not explicitly set SSL parameter in BWCE Mon when url with SSL is provided, but same can be achieved by setting environment variable exposed by PostgreSQL. Add the property PGSSLMODE=require while starting BWCE Mon container which will instruct postgres client/driver to use SSL connection.

Here is example command showing the usage of PGSSLMODE:

docker run -p 18080:8080 -e PERSISTENCE_TYPE="postgres" -e DB_URL="postgresql://postgres:admin@x.x.x.x:5432/bwcemon" -e PGSSLMODE="require" bwcemon245

Issue/Introduction

BWCE Mon configuration for connecting to SSL enabled PostgreSQL Database

Environment

- BWCE Mon - PostgreSQL

Additional Information

Link to PostgreSQL Environment Variables Documentation:

https://www.postgresql.org/docs/9.3/libpq-envars.html