The initialize script does not include ssl settings

[waterfoul]

This results in errors any time the psql command is used if ssl enforcement is enabled. See

https://github.com/jhpyle/docassemble/blob/master/Docker/initialize.sh#:~:text=export%20PGHOST%3D%22%24%7BDBHOST,unset%20PGDATABASE

[jhpyle]

The latest version has some changes for this (system update required).

I tried a test with deploying docassemble on EC2 attached to RDS, with SSL enforced on the server side.

CONTAINERROLE=web:celery:cron:rabbitmq:log:redis:mail
DAHOSTNAME=testsecret.docassemble.org
TIMEZONE=America/New_York
USEHTTPS=true
EC2=true
USELETSENCRYPT=true
[email protected]
DBHOST=database-1.crqpsahysol6.us-west-2.rds.amazonaws.com
DBNAME=docassemble
DBUSER=postgres
DBPASSWORD=s95pqSECRETjevYWf
DBSSLMODE=verify-full
DBSSLROOTCERT=us-west-1-bundle.pem

I downloaded us-west-1-bundle.pem from Amazon and put it in my Docker volume for /usr/share/docassemble/certs.

Let me know if you have any further problems. Sorry about all the issues.

[jhpyle]

I am closing this for now but if there are new issues with PostgreSQL and SSL, feel free to reopen. Thanks for letting me know about the issue.