postgres support: raintale-celery.service missing EnvironmentFile=/etc/raintale.conf

[ato]

After enabling postgres support according to the documentation jobs get stuck with status "Waiting" and raintale-celery service logs the following error:

Nov 16 07:52:32 localhost.localdomain celery[71877]: psycopg2.OperationalError: FATAL: password authentication failed for user "raintale"

Fixed by adding this line to [Service] section in /etc/systemd/system/raintale-celery.service:

EnvironmentFile=/etc/raintale.conf

and then restarting with:

sudo systemctl daemon-reload
sudo systemctl restart raintale-celery

[shawnmjones]

Very nice! I left it out because it was not needed for SQLite, but that totally makes sense for postgres installs. I'll include this fix. Thank you.

[shawnmjones]

I am removing this from the project as part of the IIPC 2021 Grant project closeout. It still needs to be reviewed by a third party.