Run the installation as root
I'll be using a dedicated PSQL host for OpenProject.
Create a new database
CREATE DATABASE openproject;Create a new DB user
CREATE USER openproject WITH PASSWORD '***********';Make the new user the owner of the new database
ALTER DATABASE openproject OWNER TO openproject;Make sure to add the OpenProject host IP and DB username to the pg_hba.conf file to allow the remote host to connect to the DB.
Install dependencies to add the OpenProject repo
apt update && \
apt install apt-transport-https ca-certificates wget gpgImport the PGP key used to sign OPF packages
wget -qO- https://dl.packager.io/srv/opf/openproject/key | gpg --dearmor > /etc/apt/trusted.gpg.d/packager-io.gpgAdd the repo
wget -O /etc/apt/sources.list.d/openproject.list \
https://dl.packager.io/srv/opf/openproject/stable/15/installer/debian/12.repoUpdate APT repos and install
apt update && \
apt install openproject