Johannes Grumböck jgrumboe

Note: Install https://github.com/hassio-addons/app-sqlite-web/tree/main/README.md

Automating this is a great way to keep your database lean, but a quick word of caution: Always back up your home-assistant_v2.db file before running bulk updates. If something goes wrong, you want a way back.

Since Home Assistant uses a relatively modern version of SQLite, we can use the UPDATE ... FROM syntax. This allows us to use the window functions (LAG/LEAD) to identify the bad rows and fix them in a single command.

1. Update Script for `statistics_short_term`

This script targets the short-term (last ~10 days) table. It identifies the spikes and overwrites the min, max, and mean with the interpolated averages.

Terraform aws_cloudformation_stack

The terraform aws_cloudformation_stack resource is capable to use a template_url as input. That's fine, if you like to apply some vendor CloudFormation stack, e.g. Prismacloud Read Only Role (https://docs.paloaltonetworks.com/prisma/prisma-cloud/prisma-cloud-admin/connect-your-cloud-platform-to-prisma-cloud/onboard-your-aws-account/update-an-onboarded-aws-account.html)

Since the URL, in the Prismacloud example https://s3.amazonaws.com/redlock-public/cft/rl-read-only.template, is a static URL Terraform wouldn't see any changes here and you would end up with never applied updates of the template hosted on S3. Unfortunately the aws_cloudformation_stack resource has no logic to "reapply/reload" the CF stack in some reoccuring interval. 😞

Trick CF stack with URL query string

AWS S3 allows you to append a query string to an S3 URL. Normally this is used to generate presigned URLs for authorized up- or downloads. 💡

Keybase proof

I hereby claim:

I am jgrumboe on github.
I am jgrumboe (https://keybase.io/jgrumboe) on keybase.
I have a public key ASAz_VyDiXCmq73EvRXqBuSND5E4KCdqhd8WZccyEczobAo

To claim this, I am signing this object:

Introduction

Openshift 3.11 EFK comes with fluentd-concat plugin and therefore multiline support for stacktrace-merging can be configured as shown below.

Modify config-map logging-fluentd

Open the config-map logging-fluentd in openshift-logging project. In the middle you'll see the label @INGRESS, modify/split it into two labels.

original label @INGRESS:

....

	```
	DEBUG: No dangling containers to remove
	INFO: Repository started
	{
	"renovateVersion": "35.32.2"
	}
	DEBUG: Using localDir: /mnt/renovate/gh/****/test-renovate-tfc-changelog
	DEBUG: PackageFiles.clear() - Package files deleted
	DEBUG: initRepo("****/test-renovate-tfc-changelog")
	DEBUG: Using queue: host=api.github.com, concurrency=10