Disclaimer
Please, proceed carefully following the tips published in this blog, specially when Main Power is involved. I'm not responsible for any damages caused by what is written in this blog.Thank you
IoT - smartHome (181 posts)
-
OpenHAB 4 - Inline upgrade to Java 17 and OpenHAB 4 M3 on WINDOWS - Home Automation System -
OpenHAB 4 - Inline upgrade to Java 17 and OpenHAB 4 M2 - Home Automation System -
OpenHAB 4 - Data migration from OpenHAB 3 with Docker - Home Automation System -
OpenHAB 4 - Testing new version with DOCKER - Home Automation System -
OpenHAB 4 - New Version Release - Home Automation System -
OpenHAB 3 - WINDOWS release UPDATE - Home Automation System -
OpenHAB 3 - WINDOWS setup - Home Automation System -
OpenHAB 3 - SMART Christmas tree 2022 - Home Automation System -
OpenHAB 3 - Example for rules triggers by DateTime item - Part 3 - Home Automation System -
OpenHAB 3 - Example for rules triggers by DateTime item - Part 2 - Home Automation System -
OpenHAB 3 - Example for rules triggers by DateTime item - Part 1 - Home Automation System -
OpenHAB 3 - Rules triggers by DateTime item - Home Automation System -
OpenHAB 3 - Widgets for Android - Home Automation System -
OpenHAB 3 - Create new page with YAML source code - Home Automation System -
OpenHAB 3 - TABLET - Alarm details page - Home Automation System -
OpenHAB 3 - Real use case for alarm notification - Home Automation System -
OpenHAB 3 - FLOORPLAN page for garden - Home Automation System -
Home Automation System - OpenHAB 3 - Grafana dashboard update -
Home Automation System - OpenHAB 3 Migration - 52. System Info in OpenHAB - Monitoring rules -
Home Automation System - OpenHAB 3 Migration - 52. System Info in OpenHAB - UI -
Home Automation System - OpenHAB 3 Migration - 52. System Info in OpenHAB -
Home Automation System - OpenHAB 3 Migration - 51. Tablet autorecharge with HabPanelViewer, openHAB and Sonoff -
Home Automation System - OpenHAB 3 Migration - 50. HabPanelViewer configuration for OpenHAB -
Home Automation System - OpenHAB 3 Migration - 49. HabPanelViewer setup on Android tablet -
Home Automation System - OpenHAB 3 Migration - 48. OpenHAB control panel on tablet -
Home Automation System - OpenHAB 3 Migration - 47. Let's create a Floorplan page step by step Part 2 -
Home Automation System - OpenHAB 3 Migration - 47. Let's create a Floorplan page step by step Part 1 -
Home Automation System - OpenHAB 3 Migration - 46. My first Floorplan example -
Home Automation System - OpenHAB 3 Migration - 45. Speedtest integration in OpenHAB Part 2 -
Home Automation System - OpenHAB 3 Migration - 45. Speedtest integration in OpenHAB -
Home Automation System - OpenHAB 3 Migration - 44. Tasmota Buttons Multipress -
Home Automation System - An article from our partner IQS - Industrial Quick Search -
Home Automation System - OpenHAB 3 Migration - 43. Auto reconnection to OpenHab Cloud -
Home Automation System - OpenHAB 3 Migration - 42. My Grafana Dashboards -
Home Automation System - OpenHAB 3 Migration - 41. Grafana Dashboards -
Home Automation System - OpenHAB 3 Migration - 40. OpenHAB and InfluxDB (docker) backup procedure -
Home Automation System - OpenHAB 3 Migration - 39. Current status and next steps -
Home Automation System - OpenHAB 3 Migration - 38. SMART Christmas tree -
Home Automation System - OpenHAB 3 Migration - 37. XIAOMI VACUUM robot commands -
Home Automation System - OpenHAB 3 Migration - 36. XIAOMI Robot maintenance check -
Home Automation System - OpenHAB 3 Migration - 35. Last update items check -
Home Automation System - OpenHAB 3 Migration - 34. Energy consumption ALARM and MONITOR -
Home Automation System - OpenHAB 3 Migration - 33. Energy consumption and photovoltaic production -
Home Automation System - OpenHAB 3 Migration - 32. Gas Alarm and Google Home Pt 2 -
Home Automation System - OpenHAB 3 Migration - 32. Gas Alarm and Google Home Pt 1 -
Home Automation System - OpenHAB 3 Migration - 31. Google Home as OpenHAB speaker -
Home Automation System - OpenHAB 3 Migration - 30. Amazon Alexa Integration Part2 -
Home Automation System - OpenHAB 3 Migration - 30. Amazon Alexa Integration Part1 -
Home Automation System - OpenHAB 3 Migration - 29. Google Home Integration -
Home Automation System - OpenHAB 3 Migration - 28. ESP8266 Wifi Repeater -
Home Automation System - OpenHAB 3 Migration - 27. ESP8266 and Tasmota light sensor Part 2 -
Home Automation System - OpenHAB 3 Migration - 27. ESP8266 and Tasmota light sensor Part 1 -
Home Automation System - OpenHAB 3 Migration - 26. Custom ESP8266 with a MQ-4 gas sensor Part 2 -
Home Automation System - OpenHAB 3 Migration - 26. Custom ESP8266 with a MQ-4 gas sensor Part 1 -
Home Automation System - OpenHAB 3 Migration - 25. Xiaomi Mi Robot Vacuum integration Part 2 -
Home Automation System - OpenHAB 3 Migration - 25. Xiaomi Mi Robot Vacuum integration Part 1 -
Home Automation System - OpenHAB 3 Migration - 24. Xiaomi Yeelight RGB Lamp Part 3 -
Home Automation System - OpenHAB 3 Migration - 24. Xiaomi Yeelight RGB Lamp Part 2 -
Home Automation System - OpenHAB 3 Migration - 24. Xiaomi Yeelight RGB Lamp Part 1 -
Home Automation System - OpenHAB 3 Migration - 23. Groups to manage InfluxDB persistence -
Home Automation System - OpenHAB 3 Migration - 22. Functional model -
Home Automation System - OpenHAB 3 Migration - 21. OpenHAB 3.1 Stable Update -
Home Automation System - OpenHAB 3 Migration - 20. Wifi Info Sonoff Tasmota with MQTT Part 2 -
Home Automation System - OpenHAB 3 Migration - 20. Wifi Info Sonoff Tasmota with MQTT -
Home Automation System - OpenHAB 3 Migration - 19. Sonoff 4ch textual definition Part 2 -
Home Automation System - OpenHAB 3 Migration - 19. Sonoff 4ch with Tasmota - textual definition -
Home Automation System - OpenHAB 3 Migration - 18. Network Check with rule - Part 3 -
Home Automation System - OpenHAB 3 Migration - 18. Network Check - Part 2 -
Home Automation System - OpenHAB 3 Migration - 18. Network Check - Part 1 -
Home Automation System - OpenHAB 3 Migration - 17. First RULE and Sonoff summary -
Home Automation System - OpenHAB 3 Migration - 16. OpenHAB Profiles Part 2 -
Home Automation System - OpenHAB 3 Migration - 16. OpenHAB Profiles Part 1 -
Home Automation System - OpenHAB 3 Migration - 15. Historical data check on InfluxDB/Grafana -
Home Automation System - OpenHAB 3 Migration - 14. Item migration - Historical data -
Home Automation System - OpenHAB 3 Migration - 13. Test with Grafana for SONOFF TASMOTA -
Home Automation System - OpenHAB 3 Migration - 12. Migration of SONOFF TASMOTA Part 4 -
Home Automation System - OpenHAB 3 Migration - 11. Migration of SONOFF TASMOTA Part 3 -
Home Automation System - OpenHAB 3 Migration - 10. Migration of SONOFF TASMOTA Part 2 -
Home Automation System - OpenHAB 3 Migration - 09. Migration of SONOFF TASMOTA Part 1 -
Home Automation System - OpenHAB 3 Migration - 08. TasmoAdmin Setup via Docker -
Home Automation System - OpenHAB 3 Migration - 07. Semantic model definition -
Home Automation System - OpenHAB 3 Migration - 06. Influxdb Retention Policy -
Home Automation System - OpenHAB 3 Migration - 05. Mosquitto with Auth through Docker -
Home Automation System - OpenHAB 3 Migration - 04. InfluxDB Restore su RPI -
Home Automation System - OpenHAB 3 Migration - 03. Docker, Portainer, InfluxDB on RPI -
Home Automation System - OpenHAB 3 Migration - 02. OpenHabian setup on RPI -
Home Automation System - OpenHAB 3 Migration - 01. Planning -
Home Automation System - OpenHAB 3 - 30. Email notification using Rules Part 4 -
Home Automation System - OpenHAB 3 - 30. Custom PUSH notification using Rules with Telegram Part 3 -
Home Automation System - OpenHAB 3 - 30. Custom PUSH notification using Rules Part 2 -
Home Automation System - OpenHAB 3 - 30. Custom PUSH notification using Rules Part 1 -
Home Automation System - OpenHAB 3 - 29. InfluxDB metadata - table name and attributes -
Home Automation System - OpenHAB 3 - 28. InfluxDB, data management with RP/CQ -
Home Automation System - OpenHAB 3 - 27. The profiles, a nice and useful feature -
Home Automation System - OpenHAB 3 - 26. Amazon Alexa integration -
Home Automation System - OpenHAB 3 - 25. Google Home Integration Part 2 -
Home Automation System - OpenHAB 3 - 25. Google Home Integration Part 1 -
Home Automation System - OpenHAB 3 - 24. GPIO Binding - INPUT/OUTPUT Example with Rule -
Home Automation System - OpenHAB 3 - 23. GPIO Binding - INPUT Example -
Home Automation System - OpenHAB 3 - 22. GPIO Binding - OUTPUT Example -
Home Automation System - OpenHAB 3 - 21. GPIO Binding -
Home Automation System - OpenHAB 3 - 20. MQTT Custom Payload with transformations -
Home Automation System - OpenHAB 3 - 19. HTTP Binding -
Home Automation System - OpenHAB 3 - 18. PUSH notifications using API -
Home Automation System - OpenHAB 3 - 17. Useful API examples -
Home Automation System - OpenHAB 3 - 16. API for Dummies -
Home Automation System - OpenHAB 3 - 15. Home Automation with rules Part 2 -
Home Automation System - OpenHAB 3 - 15. Home Automation with rules Part 1 -
Home Automation System - OpenHAB 3 - 14. RPI 4 Bruphny Kit assembly -
Home Automation System - OpenHAB 3 - 13. SONOFF POW - A simple power measurement -
Home Automation System - OpenHAB 3 - 12. MQTT for Dummies -
Home Automation System - OpenHAB 3 - 11. Mosquitto, a MQTT Broker with Docker -
Home Automation System - OpenHAB 3 - 10. Interactive Floorplan -
Home Automation System - OpenHAB 3 - 09. Semantic Model Part 2 -
Home Automation System - OpenHAB 3 - 09. Semantic Model Part 1 -
Home Automation System - OpenHAB 3 - 08. OpenHAB Remote Binding: connected together -
Home Automation System - OpenHAB 3 - 07. Migrating an InfluxDB database -
Home Automation System - OpenHAB 3 - 06. Dashboard with Grafana and InfluxDB -
Home Automation System - OpenHAB 3 - 05. Persistence with InfluxDB -
Home Automation System - OpenHAB 3 - 04. InfluxDB-Docker Get Started -
Home Automation System - OpenHAB 3 - 03. Sitemap -
Home Automation System - OpenHAB 3 - 02. MQTT Test Part 2 -
Home Automation System - OpenHAB 3 - 02. MQTT Test Part 1 -
Home Automation System - OpenHAB 3 - 01. Initial setup -
Home Automation System - Gazebo lights and external temperature with Sonoff Basic -
Home Automation System - Temperature sensor with SONOFF mini - Two sensors -
Home Automation System - Temperature sensor with SONOFF mini - Hardware connection -
Home Automation System - Temperature sensor with SONOFF mini - Software setup -
Home Automation System - First time with Sonoff Mini - Flashing TASMOTA -
Home Automation System - PZEM004T with SONOFF and TASMOTA - The Video -
Home Automation System - PZEM004T with SONOFF and TASMOTA -
Home Automation System - Let's talk to OpenHAB... -
Home Automation System - Welcome to our new voice assistant -
Home Automation System - Let's continue with packages -
Home Automation System - Let's make it cleaner -
Home Automation System - Automating a floor lamp -
Home Automation System - Two PZEM-004T and a single ESP8266 -
Home Automation System - SONOFF 4 Channel integration with OpenHAB -
Home Automation System - SONOFF 4 Channel -
Home Automation System - Energy consumption monitor...the definitive release -
Home Automation System - Energy consumption monitor...mqtt protocol -
Home Automation System - Energy consumption monitor...the first test -
Home Automation System - Alarm and OpenHAB...Let's build it -
Home Automation System - Alarm and OpenHAB...my idea -
Home Automation System - My first sensors... -
Home Automation System - Dashboards with Grafana -
Home Automation System - Openhab persistence service with InfluxDB -
Home Automation System - New mailbag... -
Home Automation System - OpenHAB v.2, a better network monitoring with groups -
Home Automation System - Using groups in OpenHAB v.2 -
Home Automation System - OpenHAB v.2 and local network monitoring -
Home Automation System - Checking TASMOTA firmware updates with OpenHAB v.2 -
Home Automation System - External buttons and switches on the SONOFF Basic with TASMOTA -
Home Automation System - MQTT, SONOFF and OpenHAB v. 2 -
Home Automation System - New Item: SONOFF Dev -
Home Automation System - It's time for OpenHAB 2 -
Home Automation System - New items arrived... -
Home Automation System - SONOFF Tasmota firmware upgrade using OTA -
Home Automation System - MQTT and RF433 to monitor photovoltaic production -
Home Automation System - SONOFF and TASMOTA, small configuration error -
Home Automation System - SONOFF and MQTT together -
Home Automation System - SONOFF and MQTT -
Home Automation System - OpenHAB 2 on Raspberry PI 3 -
Home Automation System - Configuring SONOFF Basic -
Home Automation System - New mailbag... -
Home Automation System - Configuring the SONOFF with Tasmota Firmware -
Home Automation System - The first SONOFF - Uploading firmware -
Home Automation System - Discovering sonoff -
Rf 433 Mhz data "sniffing" -
Data acquisition - Let's take a look... -
Data acquisition - Photovoltaic production -
Data Acquisition - Remote Gas Detector -
Data acquisition - The Receiver -
My first project - data acquisition system -
Arduino Low Cost Wireless Link -
Music Server on Raspberry PI -
My new Raspberry PI 2 -
Ethernet Shield Test -
First experiment: a simple gas detector -
Arduino Uno Rev 3 Starter Kit -
A new adventure...
Home Automation System - Dashboards with Grafana
by Marco Lamanna
I chose InfluxDB as persistence engine in OpenHAB also because it is easy to integrate with Grafana, an open source visualization suite that let us build interactive web dashboards.
I installed Grafana on my Raspberry PI3, where already run OpenHAB and InfluxDB, using the Openhabian configuration tool (openhabian-config), choosing "optional components".
Then, I'm able to reach the suite through http on port 3000.
Here you can find a very good guide about Grafana and InfluxDB setup and configuration
https://community.openhab.org/t/influxdb-grafana-persistence-and-graphing/13761#grafana-setup
The process to build dashboards is very easy...as long as you define your InfluxDB data source.
Every dashboard is a set of rows and objects; to fetch your data you have to choose among all the measurements in InfluxDB...
Here is my example dashboard where I put:
- at top left, ping time of my local network devices;
- at top right, speedtest results;
- at bottom, weather data, fetched from the OpenWeatherMap service