Install strichliste

For strichliste to run, PHP 7.1 or higher is required. You should have a webserver running which supports mod_php or php-fpm.

Installing

1. Go to the Github project to download the latest release. It comes already with a bundled front-end.
2. Extract the package content to your target directory (e.g. tar xvfz strichliste.tar.gz -C /var/www/strichliste.yourdomain.tld)
3. Configure your database (e.g. mysql)
4. Configure webserver (nginx or apache)
5. Change strichliste.yaml config to your needs (optional)

Database configuration

The ORM used in Strichliste supports multiple database backends such as:

• MySQL / MariaDB (recommended)
• Oracle
• Microsoft SQL Server
• PostgreSQL
• SQLite (not recommended)

If you want to use another database than sqlite, just adjust the DATABASE_URL variable in your .env file in your root directory according to the Doctrine ORM recommendations.

For example, to configure mysql/mariadb:

DATABASE_URL="mysql://strichliste:32YourPassWord42@localhost/strichliste"

Create a database and a separate user:

CREATE DATABASE strichliste;
CREATE USER 'strichliste'@'localhost' IDENTIFIED BY '32YourPassWord42';
GRANT ALL PRIVILEGES ON strichliste.* TO 'strichliste'@'localhost';
FLUSH PRIVILEGES;

Afterwards just run the following commands to create the schema:

php bin/console doctrine:schema:create

You’re done!

Sqlite (testing only)

Sqlite should only be used for testing. sqlite does not support most of the database transactional features which are needed to handle concurrent request.

If you really want to use this, execute the following steps:

php bin/console doctrine:database:create
php bin/console doctrine:schema:create

You now have a database-file in var/app.db

Configuring NGINX

Config examples for nginx can be found here:

• https://github.com/strichliste/strichliste-backend/blob/master/examples/nginx_ssl.conf (with SSL)
• https://github.com/strichliste/strichliste-backend/blob/master/examples/nginx.conf (without SSL)

Configuring Apache

• https://github.com/strichliste/strichliste-backend/blob/master/examples/apache.conf (without SSL)
• TODO: SSL-Config

Common Pitfalls

• Check your folder owner/group if you’re using sqlite as your database! Otherwise strichliste can’t write to it.

Commands

Import strichliste 1 database

To import your old strichliste 1 database, copy the database.sqlite-file to the strichliste2 directory and run:

php bin/console app:import database.sqlite

After import the terminal outputs “Import done!”