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:

• httpd as web server
• php-fpm
• MariaDB as database server

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:

# rcctl restart httpd

Now we can run the web installer with browsers.
Let's go to https://<fqdn>.

Web Installer

Follow the guidance:

* Caution: Replace localhost with 127.0.0.1 as needed.

Installation is now ready.
It starts by clicking the "Install" button.

We have reached the login form.
The initial settings are:

• Username: admin
• Password: changeme

OK!
Remove the installer:

$ rm -rf installer

Than's all!

Conclusion

These are usage screenshot examples.
Unique and cool design. I sometimes feel kinda nostalgia somehow... :)

Thank you for your reading.
Happy computing.