Time Tracking: Kimai1 on OpenBSD

#kimai #timetracking #opensource #installation

Introducation

Kimai is open source time-tracking app.
There are two major versions: Kimai1, which is GPLv3 licensed, and Kimai2, which is MIT licensed.
I'll show how to install Kimai1 in this post.

I tried to install both of Kimai1 and Kimai2.
Why also Kimai1?
It's because Kimai2 didn't have Japanese translation!
(Besides, I made pull request about it today. Aha.)

Environment

OS: OpenBSD 6.5
Database: MariaDB 10.0
Web Server: httpd
CGI: PHP-FPM powered by PHP 7.2
Time-Tracking App: Kimai 1.3.1

Tutorial

The official installation manual is here.

Requirements

First of all, you have to have:

Additionally, HTTPS is recommended.

DB server

Create database and user:

CREATE DATABASE <database> CHARACTER SET = 'utf8mb4';
GRANT ALL PRIVILEGES ON <database>.* TO <dbuser> IDENTIFIED BY '<dbpass>';

App server

Get the package:

$ ftp https://github.com/kimai/kimai/releases/download/1.3.1/kimai_1.3.1.zip

$ unzip kimai_1.3.1.zip -d kimai1

Then modify the permissions:

$ cd kimai1

# chown -R :www .
# chmod -R g+r .
# chmod -R g+rw {temporary,temporary/logfile.txt,includes}

Web server

Add configuration:

server "<fqdn>" {
        listen on $ext_addr port 80
        block return 301 "https://$SERVER_NAME$REQUEST_URI"
}
server "<fqdn>" {
        listen on $ext_addr tls port 443
        tls {
                certificate     "/etc/letsencrypt/live/<fqdn>/fullchain.pem"
                key             "/etc/letsencrypt/live/<fqdn>/privkey.pem"
        }

        root "/<...>/kimai1"
        directory index index.php

        location "/*.php" { 
                fastcgi socket "/run/php-fpm.sock"
        } 
        location "/*.php[/?]*" {
                fastcgi socket "/run/php-fpm.sock"
        }
}

Then restart the web server: