Tutorial - Book of Knowledge

Migrate Synapse from sqlite3 to PostgreSQL on Synology NAS

Introduction We assume that we alrerady have a running synapse Docker container and that that instance has been setup to use sqlite3 (the default setting). Creating PostgreSQL container We want to add this to the docker-compose file: postgres: container_name: postgres image: postgres ports: - 5438:5432 environment: - POSTGRES_

Database

Run a Matrix home server on Synology NAS

Matrix is an open network for secure, decentralized communicationcan. It allows you to reate chatrooms, direct chats and chat bots, complete with end-to-end encryption, file transfer, audio/video calls, synchronised conversation history, formatted messages, read receipts and more. This idea is that you can make your own home server as

Synology

Connect to Synology NAS via SSH using VSCode

Connect to the NAS using PuTTy A bit silly, but first you need to connect via SSH using PuTTy Edit TCP Forwarding Navigate to etc/ssh/ and edit the file sshd_config using vim (vim sshd_config). Press i to enter insert mode, then go down through the file until

Docker

Setup member newsletter for Ghost with Mailgun

Run Ghost via docker Enable members Setup Mailgun Get an account Create and verify your domain Edit config file docker exec -it ghost bash and then, once you are inside your container, use vim config.production.json to edit your configuration Press i to enter insert mode, and then add

Database

Migrate Home Assistant SQLite to MySQL in MariaDB container

Setting up MySQL database Create database named DB_HomeAssistant making sure it is of type utf8_bin Create user homeassistant and give it the correct privileges Converting db file to query sqlite3 home-assistant_v2.db .dump \ | sed -re 's/^PRAGMA .+OFF/SET FOREIGN_KEY_CHECKS=0;SET UNIQUE_CHECKS=0/

FireFly

Personal finances with Firefly on Synology NAS via Docker

Introduction to Firefly Firefly III is an open-source personal finances manager. It was built by James Cole, and you can support the development on the platform here. James is also upkeeping a really good documentation which you can (should) explore. Creating a database for Firefly First and foremost, Firefly needs

BitWarden

Self-host password vault with Bitwarden on Synology NAS via Docker

Creating a Bitwarden container Create the Bitwarden container where you usually keep your containers. In this example we will use /volume1/docker/bitwarden/. Access your NAS via SSH, and then create the docker container with the following setup: docker run -d \ --name=bitwarden \ --restart=always \ -v /volume1/docker/bitwarden/data/

Database

Connect phpmyadmin Docker container to an existing MariaDB Docker container

First of all, you must have a working MariaDB container. This will run on a specific port, i.e. 192.168.0.80:3306 Creating a phpmyadmin Docker container First of all, download phpmyadmin/phpmyadmin:latest from the Docker app on your Synology NAS Once the image is downloaded, double

Tutorial

Self-host on LetsEncrypt server with SSL certificates

Getting a domain First of all, you need to buy a domain mydomain.com When self-hosting, we want to make sure our website can be reached securely via https and for this we need the domain to go through CloudFlare. Setting up CloudFlare Log in on CloudFlare Add a new

Database

Create a MariaDB container and manage databases

Creating the MariaDB container docker create \ --name=mariadb \ -e PUID=1027 \ -e PGID=100 \ -e MYSQL_ROOT_PASSWORD=rootpassword \ -e TZ=Europe/Stockholm \ -e MYSQL_DATABASE=db_name \ -e MYSQL_USER=db_username \ -e MYSQL_PASSWORD=db_password \ -p 3306:3306 \ -v /volume1/docker/mariadb:/config \ --restart unless-stopped \ linuxserver/mariadb

Home Assistant

Update Home Assistant to the latest version

Access via SSH as root Stop the Home Assistant container with docker stop hass Remove the Home Assistant Container with docker rm hass Pull the latest Home Assistant version with docker pull homeassistant/home-assistant Open Docker from the Synology DSM Create a new container with the following settings: Admin privileges

Tutorial

Run a Ghost blog on Synology NAS via Docker

Step 1: Setup domain name and DDNS We want to make sure that https://ghost.mydomain.com will reach our Synology NAS correctly. To do this, follow this tutorial. Step 2: Prepare Docker Open the Docker package, go on Registry and search for docker. Double click on it to download

Tutorial

Password protect Node-RED running in Docker container

First of all we need to enable admin authentication on NodeRED. To do this, open the file settings.json from the container folder and comment out these lines: adminAuth: { type: "credentials", users: [{ username: "admin", password: "my-password", permissions: "*" }] }, Now here is where things

Synology

Remove Abnormal User from Synology NAS

Some time ago the Synology Health Monitor started giving me a warning with error message "one or more abnormal users have been found in the authentication file". In my case it was a leftover from an old package I installed (Couchpotato) which created a user that was now

Synology

Root access to Synology NAS via SSH

After setting up PuTTY, it is very easy to gain access to the NAS: Connect to the NAS Insert NAS username Insert NAS password After logging in, type sudo -i. This will allow to gain root access Insert password of root account login as: alex //1. alex@192.xxx.x.

Synology

Gain SSH access to Synology NAS

Step 1: Allow SSH access Access Synology DSM Control Panel > Terminal & SNMP > Enable SSH service Take note of the SSH port (default: 6589) Press Apply Now the NAS is ready to be accessed via SSH. To do this it is necessary to use a free software called