home-assistant-config

Just my home assistant configuration, like many others, but this is mine..

I have placed readme's on the sections. So hop over there to see if its of value for you too!

• Automations
• Packages

---

How to see all ip's from all containers (needed it sometimes)

docker inspect --format='{{.Name}} - {{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' $(docker ps -aq)

Make a secrets file for travis, will replace _url screts with dummy urls.

for i in `cut -f1 -d":" secrets.yaml`;do;echo $i: $(cat /dev/urandom | tr -dc 'a-zA-Z0-9' | fold -w 32 | head -n 1);done | sed 's/_url:.*/_url: https:\/\/www.some.url.com/' > travis_secrets.yaml

Recorder purging by hand if the db gets too big: In dev page do a recorder.purge with:

{
  "keep_days":"1",
  "repack":"true"
}

Then wait for some time, last time it was 3.5gb for me. After this it was 2.5gb (still too much) but after a restart it was down to 300mb!

SELECT entity_id, SUM(LENGTH(attributes)) size, COUNT(*) count, SUM(LENGTH(attributes))/COUNT(*) avg
FROM states
GROUP BY entity_id
ORDER BY size DESC;

If you run this on the database you can see which entity id's is spamming the logs.