technicalpickles / picklehome

Configuration & Planning for my Home Automation systems
14 stars 0 forks source link

Grafana + Influxdb #58

Closed technicalpickles closed 5 years ago

technicalpickles commented 6 years ago

I'm looking to get some better search history stuff in general, to find error logs and whatnot.

https://community.home-assistant.io/t/complete-guide-on-setting-up-grafana-influxdb-with-home-assistant-using-official-docker-images/42860

technicalpickles commented 6 years ago

The component doesn't handle creating the database:

I couldn't tell what was causing this until I tried to configure grafana to use the database, and it was saying it wasn't found.

I had to do this manually:

$ docker-compose exec influxdb /bin/bash
root@a1a91ab3ea3f:/# influx
influx          influx_inspect  influx_stress   influx_tsm      influxd
root@a1a91ab3ea3f:/# influx -precision rfc3339
Connected to http://localhost:8086 version 1.4.3
InfluxDB shell version: 1.4.3
> CREATE DATABASE home_assistant

https://docs.influxdata.com/influxdb/v1.5/introduction/getting-started/

technicalpickles commented 6 years ago

Something seems to be working:

Most of the values there don't actually seem to be numeric things for easy graphing tho 🤔 In particualr, I'd expect the sensors from ecobee to be visible. That may explain why the guide linked explicitly includes entities rather than just letting the default.

Also, there were some kinda random entities:

technicalpickles commented 6 years ago

Okay, it seems I misunderstood the interface. That'll teach me for not learning things 😅 The 'temperature' I was trying to search before was actually units, and the default from the component is entity ids.

technicalpickles commented 6 years ago

https://seanb.co.uk/2017/07/influxdb-with-home-assistant/ looks helpful too

technicalpickles commented 6 years ago

It'd be helpful to setup some hostname aliases + vhosts, so I don't have to remember what port grafana is on 😅

technicalpickles commented 6 years ago

Also, looks like I should be able to add prometheus as a data source

technicalpickles commented 5 years ago

I'm using prometheus as the datasource now.