riemers / home-assistant-config

Just my home assistant configuration, like many others, but this is mine..
6 stars 1 forks source link
hass hassbian homeassistant homeassistant-config

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!


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.