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
03
Apr/23Disable FireFox Download Panel Automatically Opening
A change was made to FireFox where if you download a file, the download box opens and steals focus from the website. To disable this, go to about:config and search for browser.download.alwaysOpenPanel and set it to false by double clicking … Continue reading
01
Aug/22Let’s Encrypt With HaProxy
Overview Using EFF’s goal to encrypt the Internet has spawned a project to issue TLS certificates is a great idea and opens up certificates for everyone and not just for those with money. To balance certificates being miss used, EFF … Continue reading
04
Jul/22Home Assistant Continuous Integration Workflow
Overview Development pipelines such as version control to deploying changes automatically. In Home Assistant’s case, you can make changes in YAML text files anywhere and Home Assistant can pick up the changes and automatically load them. Tools I use GitHub … Continue reading
06
Jun/22MySQL caching_sha2_password: the specified module could not be found.
Upgrading from MySQL 5.x to 8 has caused an error with existing accounts. The fix is to set the authentication to use. More details can be found here. MySQL 8.0.11 error connect to caching_sha2_password the specified module could not be … Continue reading
05
Jul/21Home Assistant: Condition Based Auto Entities Card
Overview I was looking for a way to show / hide information based on states or attributes of an entity. Example use cases: Show any windows / doors which are open. List any low battery devices. Pre-Requisite Optional: Home Assistant … Continue reading