DSR Roprotokol

Documentation

For DSR in Danish:

Demo: login 2001, pw demo

all content related to rowers are ramdomly generated

https://agol.dk/roprotokol/frontend/app/index.shtml

Installation

apt install composer npm memcached php-memcached php-mysql php-gd php-zip libapache2-mod-php nodejs  mariadb-server php-mail php-mailparse  composer php-cli ntp
#  php-mysqlnd/php-mysql is needed to make PHP know the difference between numbers and strings
apt install  libaprutil1-dbd-mysql pkg-php-tools php-fpdf mdbtools postfix postfix-sqlite automysqlbackup php-curl certbot python3-certbot-apache
apt install opendkim opendkim-tools # php-tcpdf
# Remember to restart your web server.
usermod -a -G opendkim postfix

mkdir -p /var/spool/postfix/opendkim/
chown opendkim.opendkim /var/spool/postfix/opendkim/

apt install ffproxy # to update terminals that are not on the internet. a2enmod ssl dbd rewrite include authn_dbd a2enmod php8.X # where X is the php version

mkdir -p /data/backup/automysqlbackup/{latest,daily,monthly,weekly} chgrp roprotokol -R /data/backup/automysqlbackup/ chmod 2750 /data/backup/automysqlbackup/*

sudo npm install -g bower

cd rowingapp/backend; composer update cd phplib; composer update

sudo mkdir /data chown roprotokol.roprotokol /data cd /data;git clone https://github.com/dsroklub/roprotokol.git

cd /data/roprotokol/rowing/backend; composer update

cd /data/roprotokol/rowingapp/frontend; npm install

sudo chown www-data.www-data /data/roprotokol/externaladmin/uploads

init git hooks

cp /data/roprotokol/configuration/git/hooks/* /data/roprotokol/.git/hooks cd /data/roprotokol/; . .git/hooks/post-commit

Create database:

sudo mysqladmin -p --default-character-set=utf8mb4 create roprotokol echo "CREATE USER 'roprotokol'@'localhost' IDENTIFIED BY 'roprotokol'; CREATE USER 'apacheauth'@'localhost' IDENTIFIED BY 'XXXX';"|mysql -u root -p echo "GRANT ALL PRIVILEGES ON roprotokol.* TO 'roprotokol'@'localhost'; FLUSH PRIVILEGES;"|mysql -u root -p mysql -u roprotokol -p'roprotokol' roprotokol < /data/roprotokol/db_setup/mkdb.sql echo "GRANT ALL PRIVILEGES ON roprotokol.authentication TO 'apacheauth'@'localhost';GRANT SELECT ON roprotokol.Member TO 'apacheauth'@'localhost'; "|mysql -u root -p echo "GRANT SELECT ON roprotokol.MemberRights TO 'apacheauth'@'localhost';GRANT SELECT ON roprotokol.Member TO 'apacheauth'@'localhost'; "|mysql -u root -p

grant super on . to roprotokol@localhost ;

Import schema:

Copy config.ini.template to config.ini and adjust