Create SSL Connection in Docker Compose to Remote DB

Edit docker-compose.yml

Change the DB url in the docker compose file add &ssl=true at the end:

jdbc:postgresql://172.17.0.1:5432/iriusprod?user=iriusprod&password=alongandcomplexpassword2523&ssl=true

Add volumes to tomcat section in docker compose file:

 - "./scripts/:/etc/irius/scripts.d/"
 - "./postgres/ca/server.crt:/etc/irius/server.crt"

Add additional directories in the same directory as the docker-compose.yml file

Make 3 directories for organization:

mkdir postgres
mkdir postgres/ca
mkdir scripts

and put the server.crt file in the postgres/ca directory

Create a script to import the certificate

Create a script to import the certificate into the docker container:

touch scripts/DBSSLscript.sh
chmod u+x scripts/DBSSLscript.sh
vim scripts/DBSSLscript.sh

Script contents:

#!/bin/bash

keytool -import -alias server -file /etc/irius/server.crt -keystore /usr/lib/jvm/java-1.8-openjdk/jre/lib/security/cacerts -storepass changeit -noprompt