SSH into your QNAP device and run
echo Model: $(getsysinfo model)
-- 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" |
# /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'" |
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'
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. |