opencon

Requirements

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

• nginx
• docker
• docker compose
• postgresql 14+

Changes introduced/removed in this release:

• Added anonymous users
• Removed Pretixx integration
• Removed access control module

Installation

• checkout this repository
• run docker compose build
• setup .env file (from .env.example)
• setup .env.docker from .env.docker.example (this file contains different database location, by default, but anything else can be overridden)
• setup global nginx (see configuration file in config/nginx.global.conf.sample
• run docker compose build
• 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 and .env.docker files as

DB_HOST=localhost
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

and

DB_HOST=host.docker.internal

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

Program Data

When the project is started, the database is empty. The program will automatically create the necessary tables.

Conference data is pulled from the sfscon.it API via crontab in the conferences container every 5 minutes.

Therefore, the content will be available to users within 5 minutes or on request through the admin panel.