ampaze

-- Use at your own risk, I am not responsible if you lose data or break your system!
-- This is based on self hosted Plausible v2.0.0 and self hosted Matomo 5.0.1

-- EXPORT from Matomo MySQL
-- Best to start screen before running the export
-- mysql -u <user> -p <db> < plausible-matomo-import-events.sql > plausible-matomo-import-events.tsv

-- IMPORT into clickhouse
-- Again best to use screen
-- cat plausible-matomo-import-events.tsv | docker exec -i plausible-analytics-plausible_events_db-1 clickhouse-client -q "INSERT INTO plausible_events_db.events_v2 FORMAT TabSeparatedWithNames"

ampaze

# /etc/udev/rules.d/999-passthrough-formats.rules
KERNEL=="hdmi_audio", ACTION=="change", ATTR{state}=="HDMI=1", RUN+="/bin/bash -c '/home/osmc/.kodi/userdata/passthrough-format-from-edid.sh %p >> /var/log/edit_passthrough_detection_errors.log 2>&1'"

ampaze

How to cross compile the WireGuard® kernel module for QNAP® Arm® devices

Prerequisites

Information about your QNAP device

SSH into your QNAP device and run

echo Model: $(getsysinfo model)

ampaze

As Kodi is called with sudo -u osmc environment variables are not retained and as a result not available in Kodi.

The easiest way I have found to set environment variables like for example no_proxy is to add them to /etc/environment and then configure sudo to include /etc/environment on every invocation.

You need SSH access to the device

ssh osmc@device

sudo sh -c 'echo "Defaults env_file=/etc/environment" > /etc/sudoers.d/osmc-environment'

ampaze

For this to work, you need to precompress your files:

> brotli -q 11 file.css file.cssbr

The file extensions needs to end with br without any delimiter, this is to make the nginx config less cumbersome.