Book of Knowledge
  • Home
  • Author
Subscribe
Tagged

Home Assistant

A collection of 3 posts

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/

  • Alex Camilleri
Alex Camilleri Apr 10, 2020 • 1 min read
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

  • Alex Camilleri
Alex Camilleri Jul 26, 2019 • 1 min read
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

  • Alex Camilleri
Alex Camilleri Jun 27, 2019 • 1 min read
Book of Knowledge © 2026
Powered by Ghost