jhpyle
The initialize script does not include ssl settings
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
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.
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.