DSR Roprotokol

Documentation

For DSR in Danish:

Demo:

https://agol.dk/roprotokol/frontend/app/real.html

Installation

apt-get install composer npm python-mysqldb memcached php-memcached php-mysql libapache2-mod-php nodejs  mysql-server php-mail php-mailparse  composer php-cli
# or mariadb
#  php-mysqlnd/php-mysql is needed to make PHP know the difference between numbers and strings
apt-get install  libaprutil1-dbd-mysql pkg-php-tools
# Remember to restart your web server.

a2enmod dbd rewrite include authn_dbd php7.X sudo npm install -g bower

for debug scripts

cd rowingapp/phplib; composer update

cd rowingapp/frontend; npm install

Create database:

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

Import schema:

mysql -u roprotokol -p'roprotokol' roprotokol < db_setup/mkdb.sql

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

Test Webserver:

Run cd rowingapp/ php -S localhost:8080