Janik von Rotz

Wir müssen wieder lernen zu verzichten

Wir befinden uns gerade in einem umstrittenen Abstimmungskampf in der Schweiz. Wir entscheiden darüber, ob man weiterhin synthetische Pestizide in den Boden und damit ins Trinkwasser geben darf. Wie es zu dieser Abstimmung kommt und wie es unabhängig vom Entscheid aussehen könnte, möchte ich erläutern.

Read More...



Nextcloud Social Login with Gitlab

This example shows one way to configure GitLab as an OpenID Connect (OIDC) identity provider, so that only members a specific GitLab group are allowed to login.

Read More...



Paradigm shift in the handling of data

The handling of private data is the subject of controversial public debate. Everyone expresses concerns about the handling of private data, but most people pass it on to third parties via social media without hesitation. A controversy that is often left hanging in the air.

Read More...



Add Prometheus instance variable to Grafana query

Prometheus stores the instance or host name for every metric. If you want to filter your dashboard data based on the instance name you need a Grafana variable.

Read More...



IT monoculture in administration

The pressure on working methodology in public administrations and institutions is increasing. Innovation and creativity are required. A prime example was the Federal Office of Public Health (FOPH). Last summer, there was a call for the systematic collection of statistics on corona case numbers. At the time, the main means of communication at the FOPH was fax.

Read More...



Move Docker data directory to new location

The standard data directory used for docker is /var/lib/docker, and since this directory will store all your images, volumes, etc. it can become quite large.

Read More...



Parse URL in shell script

Use the bash script below to extract any segment of an URL. For example you can use it like this parse-url https://www.example.com subdomain,proto and get the subdomain and protocol of the url as reponse.

Read More...



Postgres connection URI password fails

With the psql command line tool you can either pass the connection credentials as parameters or simply as one connection string.

The general form for a connection URI is:

postgresql://\[user\[:password\]@\]\[host\]\[:port\]\[,...\]\[/dbname\]\[?param1=value1&...\]

While developing an Odoo module I could no longer execute queries using connections URIs. I always got the error psql: error: FATAL: password authentication failed for user "odoo".

Read More...



Upgrade Keycloak Docker container

Upgrading Keycloak is not so difficult as supports automatically migrating the database to a new version.

Nonetheless, Keycloak is a critical piece of software in every infrastructure. Under no circumstances you want the upgrade to fail. I will show you some upgrade preparations for a docker-based setup that ensure you can restore the service in the worst case scenario.

Read More...



Some thoughts on stress

How are you? Are you stressed?
Stupid question! Of course I am. I am f!*$&ng stressed all the time!

Not a nice way to start a blog post. But for me it also not a nice topic. This post is a ongoing series about the challenges of being self-employed.

Read More...



7