04
Mar/24Remove Windows Family Account
A quick post to a video on how to remove a Microsoft Family account from a computer. When you disable an account from logging into the computer, their profile and all associate files remain on the computer. This is not … Continue reading
05
Feb/24Solar Assistant With EMQX Data Bridge
Overview My Growatt inverter has been lacking the integration to control the charging of the battery from the grid in Home Assistant. The feature exists in it’s own app and platform but it’s a real pain in the back side … Continue reading
01
Jan/24Moes Zigbee Thermostat
Overview I have an electric underfloor heating in one of the rooms. It uses the old version of the ProWarm Pro Digital Thermostat. It has the usual controls for a non connected thermostat such as schedule and manual heating controls. … Continue reading
04
Dec/23Smart Bulbs With Light Switches
Borrowing this idea from Tom McGuinness. This is the ultimate setup to allow features of a smart bulb like changing colours, Zigbee/Matter repeater and still retain the functional use of your light switch. The concept is to disconnect the bulb … Continue reading
06
Nov/23MariaDB/MySQL Database Size Sensor In Home Assistant
A quick little tip to get the size of your database into Home Assistant. The example below will get the Home Assistant database size from MySQL. This should also work for MariaDB using the Recorder integration. Assuming the database schema … Continue reading
02
Oct/23DigitalOcean Managed (Clustered) Database With WordPress
Overview I have an existing WordPress site running on DigitalOcean on a self managed instance (Droplet). It was time for an OS upgrade and generally I like to start from scratch rather than doing an in place upgrade. Ideally, I … Continue reading
04
Sep/23MySQL Consider increasing innodb_redo_log_capacity
Overview I started getting the following warnings in the log from MySQL: 2023-03-18T05:12:59.566053Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity. Redo logs are stored transactions that are used to … Continue reading
07
Aug/23Salt Level For Water Softener With ESPHome
overview We got a water softener installed near the water mains coming into the house. It’s a “dumb” softener so that it does not rely on using electricity. This means it will continue to work in a power outage but … Continue reading