I've configured Influx Data push from Domoticz (More Options/DataPush) and had initial SUCCESS; verified data is being sent an received/queried by InfluxDB, but FAILED - no luck at all querying the data and getting charts in Grafana. Would greatly appreciate guidance from the pioneers before me, in particular examples of exact queries or suggestions re: Grafana.
Here's my setup:
Domoticz on RPi3 with sensors from MySensors, and ESP Easy, running reliably several months. I configured several sensors as a test in Influx Data Push, and successful eliminating config errors showing in Domoticz Logs. I can now see the Domoticz log showing all configured device info going out, example:
Code: Select all
2017-04-07 13:25:45.136 MQTT: Topic: domoticz/in, Message: {"idx":65,"nvalue":0,"svalue":"18.0;32;0"}
2017-04-07 13:25:45.143 HttpLink: sending global variable temp with value: 64.4
2017-04-07 13:25:45.172 HttpLink: response
2017-04-07 13:25:45.255 InfluxLink: value Temperature,idx=65,name=Ambient-ESP-Node-1 value=64.4
2017-04-07 13:25:45.255 InfluxLink: value Humidity,idx=65,name=Ambient-ESP-Node-1 value=32
InfluxDB & Grafana Installed and configured on separate Linux (Ubuntu) box. Created 'domoticz' database in Influx. Configured data source in Grafana linked to 'domoticz' database successfully.
Failed to create any chart in Grafana that would display data values with hours of fiddling, although query editor was correctly seeing data fields like "Temperature", "Humidity" etc. Chart area always showed spinner with any query, Googling suggests a 'stuck' query.
Decided to fall back to confirm Influx was really getting the data, ran through the Influx docs and ran command line queries and got results confirming the data structure and devices were certainly there
">show series" included:
Code: Select all
name: Temperature
-----------------
_key idx name
Temperature,idx=63,name=Radio2-Proto-MS-Shop 63 Radio2-Proto-MS-Shop
Temperature,idx=18,name=Outdoor@House-NA 18 Outdoor@House-NA
Temperature,idx=69,name=Outlet-ESP-Node-1 69 Shop-ESP-Node-1
Temperature,idx=65,name=Ambient-ESP-Node-1 65 House-ESP-Node-1
> select * from "Temperature" shows values are there...
Code: Select all
time idx name value
899584 63 Radio2-Proto-MS-Shop 54
1348096 63 Radio2-Proto-MS-Shop 59.5
3990016 63 Radio2-Proto-MS-Shop 55.2
4172800 63 Radio2-Proto-MS-Shop 56.3
5989376 65 House-ESP-Node-1 64.8
6526464 63 Radio2-Proto-MS-Shop 59.7
Yet in Grafana chart creation, although the relevant device names, etc are seen and selectable in the query, with a resulting query (among innumerable variants) like:
Code: Select all
SELECT "value" FROM "Temperature" WHERE "name" = 'Radio2-Proto-MS-Shop' AND $timeFilter GROUP BY time(5m)
Set chart time range to past 5 years. Produces a blank chart and never-ending spinner in the upper right corner.
SO..... I i figure InfluxDB seems to be working and have the data, and thought maybe my Grafana install was botched, so I installed another instance of Grafana, from scratch, on a rPi3 and connected it to the same Influx database... No problem connecting to database. Same spinner, no data displayed.
Opinions?
Am I botching this query in Grafana?
Is something wrong with my Grafana config?
Is the spinner always there with any graph query in Grafana that produces no data?
Is there something wrong with the "time" data shown in the InfluxDB command line query above?
Any ideas greatly appreciated.
Thanks, Tim