Openproject: Some important additional configurations

29.11.2019
|
0 Comments
||
|

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

openproject

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"

openproject1

Save and quit command line editor
openproject2
And restart the open project.

# sudo service openproject restart

Leave a Reply

Your email address will not be published. Required fields are marked *

Share on:
Share this...
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin
Website security
Contact Us