Collect utilities data automatically

Update by @tiltec:

• Influxdb writing works, but lags a bit because of high load
• Grafana looks nice, but dashboard could be saved in some git repo
• Electricity counter readout works nicely
• gas counter readout works so-so but is not installed right now
• water counter readout does not work, needs better approach

Therefore, the main goal is now (Summer 2018) to improve the water counter readout. @tiltec and @navlisilvan were interested in it, possibly with support from @NerdyProjects.

This issue can be closed when gas and water usage are displayed in grafana.yunity.org

---

@nicksellen wrote originally:

I experienced the pain of collecting and calculating (well, Bodhi did that bit) the utility data this morning, so got motiviation to help the automation of this.

Progress is underway by @NerdyProjects (and maybe @tiltec) but not ready yet. The steps are something like:

• 1. put sensors on the things that need to have data collected (and whatever else is need with the magic circuitboards)
• 2. have a raspberry pi with app that reads the data from the magic circuitboard (UAVCAN stuff?) (in progress I think)
• 3. send the data to influxdb
  • 3.1 stablize sending of data
    • option A ... via ssh, add more stable auto ssh reconnecting (via autossh package...)
    • option B ... via direct http (need to fiddle with influxdb permissions etc and expose it publically)
  • 3.2 decide on the format (absolute values or increments)
  • 3.3 maybe provide a mechanism to capture lost values manually if the pi stops collecting
• 4. write grafana dashboard to show it nicely
• 5. embed nice dashboard on kanthaus.online site