Lukas Wolfsteiner dotWee

Note: This originates from: https://forum.synology.com/enu/viewtopic.php?f=258&t=107508&sid=78d911737c5ecea1f9087bdab13612bf&start=15#p478281

Here are steps that I have modified to work for me. This assumes you have a shared folder named "docker" in volume1.

We need to Symlink /var/run/docker.sock to /volume1/docker/docker.sock, because Synology Docker GUI will not be able to run it when it's pointed directly to /var/run/docker.sock. Also the symlink needs to persist after reboot. To make it do so, you will need to create an automated task in your Synology DSM via "Task Scheduler".

Go to "Control Panel" > "Task Scheduler".
Click "Create" > "Scheduled Task" > "User-defined Script".
On the "Create Task: Window, make sure "User:" is selected as "root" and rename the "Task:" to whatever you like.
Click "Schedule" tab. Under "Date - Run on the following days", select "Daily". Under "Time - Frequency", select "Every 1 hour(s)" (just to be on the safe side).

Performance on Synology RAIDs

(especially while expanding)

Warning: The exact commands may not match for your particular linux OS / Synology(NAS) device. I had to customize the commands after exploring my particular system's setup.

If you're new to linux, or this is a new piece of hardware / a new synology device, jump down to the section called "Inspecting a setup"

Open Automator
Choose Quick Action as the document type
Change Workflow receives current to files or folders in Finder.app
For Action, choose Open Finder items from the left hand sidebar
Change Open with to Visual Studio Code.app (find it in Other... )
For the Icon, change Image to "Choose..." and select the Visual Stuido Code app. It'll automatically pick the icon
Save it (Cmd+S) as something like "Open in VS Code"

Usage

curl -sSL https://gist.githubusercontent.com/ttimasdf/ef739670ac5d627981c5695adf4c8f98/raw/autossh@host1 | \
  sudo tee /etc/default/autossh@example
curl -sSL https://gist.githubusercontent.com/ttimasdf/ef739670ac5d627981c5695adf4c8f98/raw/[email protected] | \
  sudo tee /etc/systemd/system/[email protected]

sudo useradd -g nogroup -s /bin/false -m tunnel
sudo -u tunnel mkdir -p ~tunnel/.ssh # and copy your private key here

Heres a snippet for using youtube-dl to download soundcloud playlists:

youtube-dl -w -o "Playlist/%(playlist_title)s (%(playlist_uploader)s) - %(playlist_id)s/%(title)s.%(ext)s" -f bestaudio --embed-thumbnail --add-metadata https://soundcloud.com/tommisch/sets

Migrate Home Assistant’s sqlite database to MySQL, specifically MariaDB (10)

After having added a decent amount of entities to my Home Assistant setup, the user interface—especially the history tab, but also the history for each entity—became very sluggish. Having to wait for up to 30 seconds to see the history graph for a single entity became the norm with an sqlite file weighing in at 6GB and millions of entries in the “events” and “states” tables.

I wanted to keep my acquired data, so I had to migrate it from the current sqlite file to a MySQL database instead of starting anew. I’ve done this using Home Assistant version 0.81 and MariaDB 10. Some parts might change in the future.

	#!/bin/bash

	# Author: Erik Kristensen
	# Email: [email protected]
	# License: MIT
	# Nagios Usage: check_nrpe!check_docker_container!_container_id_
	# Usage: ./check_docker_container.sh _container_id_
	#
	# Edited by: Paulo José de Oliveira Salgado
	# Email: [email protected]

	#!/usr/bin/env bash
	# http://tonylawrence.com/post/unix/fixing-corrupted-time-machine-backups/

	set -euf -o pipefail
	set -x

	if [[ $(whoami) != 'root' ]]; then
	echo "Please run as root" > /dev/stderr
	exit 1
	fi

Lukas Wolfsteiner dotWee

Performance on Synology RAIDs

Contents

Usage

Migrate Home Assistant’s sqlite database to MySQL, specifically MariaDB (10)

Dump Home Assistant sqlite database

	*.img
	*.raw