Grafana

heatweb_grafana.json Grafana
heatweb_grafana1.json 1. Current Architecture
heatweb_grafana2.json 2. Proposed
heatweb_grafana3.json 3. Proposed
grafana1.json Sandbox
heatweb_morden_hall_schematic.json Morden Schematic
heatweb_morden_hall_schematic_dash.json Schematic Dashboard
heatweb_morden_hall_1.json Wiring 1
heatweb_morden_hall_dashboard_1.json Dashboard 1

• https://grafana.com/
• https://grafana.com/go/grafanaconline/2022/design-spark-air-quality-monitoring-use-case/
• https://grafana.com/blog/2021/06/15/resources-for-easy-diy-iot-projects-with-grafana-arduino-prometheus-and-loki/
• https://grafana.com/blog/2022/06/24/monitoring-a-hard-water-softener-at-home-with-grafana-cloud/

Reasons for Using Grafana

• Freemium model, with a free forever plan alongside commercial packages
• Quick to setup
• Community Edition that runs in Docker on a controller, as well as online, and as a hosted service
• Scalable
• Secure
• Technical support
• Removes need for further cloud infrastructure, by providing core functions of data storage, visualisation and alarming
• Works with both time series and static data
• Compatible with all data types
• Powerful query construction
• Repeating objects and panels allow for dynamic dashboarding
• Organisation and user management

Points to Consider

• HVAC equipment (and IoT in general) often differs from server architecture (Grafana origins) in regards to data bandwidths, with some devices connected on SIM cards or radios with very little data use available.
• Needs to remain compatible with the standard 5 level MQTT structure (Network_Id / Node_Id / Device_Id / Group / Key) so that dashboards based on named devices can be shared easily. The Network_Id will be the only variable that changes. http://heatweb.co.uk/w/index.php?title=Heat_Network_Protocol
• With limited data bandwidth, installations can make use of a data concentrator, a controller that generates summary statistics and alarms from groups of devices on a local network, that can then be sent over the limited uplink bandwidth.
• It is required to make use of a data request function (a sync), whereby all (or specific) data on a device can be requested for publishing. This allows for high resolution historic data held on a controller that would not normally be published, to be remotely requested, published, and then accessed in the even of problems. Such a function would also apply to detailed system data and files.
• Two-way communication is required, with a need to implement user commands. Examples include remote control over central heating, or the facility to switch equipment between on / off / auto states. Security needs to be considered with control dashboards locked to unauthorised users. Logging of control requests (commands) is required. In the existing protocol, the data groups cmd and set are used for commands and persistent settings respectively.

Installation

sudo docker run -d -p 3000:3000 --name=grafana --restart=always --net mqtt -v grafana-storage:/var/lib/grafana grafana/grafana-oss

See https://github.com/heatweb/plumbing-controller/blob/main/scripts/docker-setup.sh

Setting up for reverse proxy

Open a console into container.

Shell into Grafana and edit ini. May need to install nano

apk update 
apk add nano

nano /usr/share/grafana/conf/defaults.ini

Scroll down and alter to...

# The public facing domain name used to access grafana from a browser
domain = hwwiki.ddns.net

# Redirect to correct domain if host header does not match domain
# Prevents DNS rebinding attacks
enforce_domain = false

# The full public facing url
#root_url = %(protocol)s://%(domain)s:%(http_port)s/
root_url = %(protocol)s://%(domain)s:/dashboard/

# Serve Grafana from subpath specified in `root_url` setting. By default it is set to `false` for compatibility reasons.
serve_from_sub_path = true

At the bottom you can also set an anonymous login to allow access without a password.

Restart container