Openproject: Some important additional configurations

1. Database migration from ec2 to RDS

Backup and restore DB

# pg_dump -Fc -v -h [instance endpoint] -U [master_username] [database] > [database].dump

createdb [new database name]

# pg_restore -v -h [instance endpoint] -U [master_username] -d [new database name] [database].dump

In below file changes required with following directives

# vi /etc/openproject/conf.d/00_addon_postgres

export DATABASE_URL="postgres://:@:5432/"

# openproject restart

2. Set S3 bucket for storage for attachments

# vi /etc/openproject/conf.d/other

Comment the below line

#export ATTACHMENTS_STORAGE_PATH="/var/db/openproject/files"

And, add the below directives at the end of file

export OPENPROJECT_ATTACHMENTS__STORAGE=fog
export OPENPROJECT_FOG_DIRECTORY="myprojectbucket"
export OPENPROJECT_FOG_CREDENTIALS_PROVIDER="AWS"
export OPENPROJECT_FOG_CREDENTIALS_AWS__ACCESS__KEY__ID="AKIA5ETJJ6AFRZEUQELV"
export OPENPROJECT_FOG_CREDENTIALS_AWS__SECRET__ACCESS__KEY="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"
export FOG_CREDENTIALS_REGION="us-east-1"

Save and quit command line editor

And restart the open project.

# sudo service openproject restart