opencon

Requirements

the following software is requirement on your server to be able to run this app

• nginx
• docker
• docker compose
• postgresql 14+

Installation

• checkout this repository
• run docker compose build
• setup .env file (from .env.sample)
• setup global nginx (see configuration file in config/nginx.global.conf.sample
• run docker compose up -d

currently and by default, the database has been setup on host machine visible from docker containers on host.docker.internal

this is defined at the top of .env file as

DB_HOST=host.docker.internal
DB_USERNAME=opencon_user	# or any other your username
DB_PASSWORD=__your_password__
DB_NAME=opencon_db		# or any other database name
DB_PORT=5432

create database db_name with read/write/create_tables privilege for your_user

as postgres admin

create role opencon_user with login createdb password '123';

as opencon_user

psql -U opencon_user template1
create database opencon_db

bootstrap

• run docker compose up -d

from your browser open target url and login with username/password defined in .env

ADMIN_USERNAME=your_admin_username ADMIN_PASSWORD=your_admin_password

click to sync button to sync initial content from sfscon.it