domoticz, influxdb and grafana

[mlamie]

Can the wiki page be of any help?
https://www.domoticz.com/wiki/HttpLink

[hrikken]

Use node-red and mqtt. Works perfect.


Verzonden vanaf mijn iPhone met Tapatalk Pro

[sincze]

Can the wiki page be of any help?
https://www.domoticz.com/wiki/HttpLink

I also followed the wiki and had the same results. no data points

Sent from my SM-G925F using Tapatalk

[fergalom]

seems to be a new specific data push to InfluxDB in the latest betas - same location as the http / fibarolink data push

[kiwi]

Hum Influxdb is really pretty cool. Really I'd would like to have the option to send all data to InfluxDB instead of choosing all things, one per one... :/

[sincze]

Can the wiki page be of any help?
https://www.domoticz.com/wiki/HttpLink

I also followed the wiki and had the same results. no data points

Sent from my SM-G925F using Tapatalk

A finally:
http://localhost:8086/write?db=domoticz ... ecision=ms

Gives me results in influxdb no more nasty 400 error messages.

Grafana3.png (124.35 KiB) Viewed 5947 times

Grafana2.JPG (75.9 KiB) Viewed 5947 times

[mlamie]

yes, followed wiki also, no data point

but i think its because of the wrong date. I have no clue where the 1970 year comes from

I tried this weekend to setup InfluxDB via the Domoticz HTTP wiki page, it is a bit outdated but I did succeed. I used InfluxDB 1.2.
1) For example the the built-in web administration GUI is deprecated in InfluxDB 1.2 and is disabled by default. I used the CLI and works.
P.s. I found you can still use the administration GUI, you have to enable it in the influxdb.conf file

Code: Select all

[admin]
  # Determines whether the admin service is enabled.
enabled = true

2) The Domoticz setup details on the wiki page are for InfluxDB 0.8. At the bottom of the wiki page I found the url and data fields for InfluxDB 0.9 which also works for InfluxDB 1.2.

If I or someone else has time a wiki page update would be nice. Adding the screenshots from sincze could be usefull.

Regarding the incorrect date, on the InfluxDB website it is stated that InfluxDB uses the host’s local time in UTC to assign timestamps to data and for coordination purposes. So there is no need to search on InfluxDB time correction. You have to validate your host time configuration.

In case you use a Raspberry Pi use raspi-config.

What time and date is the host on?
If you use the command line interface and a Pi with Raspbian use:

Code: Select all

date --utc

[sincze]

Let me first build some more screens before starting at the wiki.

Grafana_OTGW.JPG (72.35 KiB) Viewed 5897 times

[Nhzz]

I'm also playing with Grafana, already got some graphs in it. Real neat.

What I am trying to do is to make the graph for cumulative usage start at zero for every time-interval I select.

Currently I have the following query for a single metric:

Code: Select all

SELECT mean("value") FROM "youless" WHERE $timeFilter GROUP BY time($interval) fill(null)

What I want is to subtract the lowest value from that interval, so it only counts the values from within that interval. That way the graph starts at zero and you know exactly what the usage is in that interval. To get the lowest value from that interval I use:

Code: Select all

SELECT min("value") FROM "youless" WHERE $timeFilter GROUP BY time($interval) fill(null)

So I thought combining those two (with subquery) like this should work:

Code: Select all

SELECT mean("value") - (SELECT min("value") FROM "youless" WHERE $timeFilter GROUP BY time($interval) fill(null)) FROM "youless" WHERE $timeFilter GROUP BY time($interval) fill(null)

Unfortunately this doesnt work. The query is not accepted as a subquery, although the query itself works just fine.

Anyone can give me a push in the right direction?

[Nhzz]

No one?

[Trigun]

sorry mate can't help you, whish I could.

is there perhaps a chance you can help me out?
I am looking all over the internet for a solution to put my smart meter data in Grafana.
I already have everything up and running, within domoticz it works perfectly but I can't seem to get it to work in Grafana.
I am using Grafana in combination with Influx.

Thanks in advance!

[grubstake]

There is a problem with the InfluxDB Data Push option, it correctly uploads all the device information but the date is not correctly being loaded in InfluxDB.

It appears to be something like the data push posting date/time with without declaring "precision". In any case, the date ends up being "null" which ends up starting with 1/1/1970.

See: https://github.com/influxdata/influxdb/issues/6041

Anyway, a query in the influxDB shell shows the least significant digits of time counting up from the time the data load was started on a new database, but the date is never correct:

Code: Select all

> select "value" from "Humidity"
name: Humidity
--------------
time				value
1970-01-01T00:00:00.024077824Z	32
1970-01-01T00:00:00.039430144Z	47
1970-01-01T00:00:00.046879232Z	33
1970-01-01T00:00:00.153165824Z	47
1970-01-01T00:00:00.376367104Z	32
1970-01-01T00:00:00.399168512Z	32
1970-01-01T00:00:00.671788544Z	32
1970-01-01T00:00:00.694589952Z	32
1970-01-01T00:00:00.944408576Z	32
1970-01-01T00:00:00.967209984Z	32
1970-01-01T00:00:01.239830016Z	32
1970-01-01T00:00:01.262631424Z	32
1970-01-01T00:00:01.296697856Z	32
1970-01-01T00:00:01.319499264Z	32
1970-01-01T00:00:01.592119296Z	32
1970-01-01T00:00:01.614920704Z	32
1970-01-01T00:00:01.62981888Z	47
1970-01-01T00:00:01.887540736Z	32
1970-01-01T00:00:01.910342144Z	33

It's not a problem with Grafana, its just that Grafana charts default to a time range that doesn't include timestamps way back in 1970.

Very frustrating.

[hrikken]

sorry mate can't help you, whish I could.

is there perhaps a chance you can help me out?
I am looking all over the internet for a solution to put my smart meter data in Grafana.
I already have everything up and running, within domoticz it works perfectly but I can't seem to get it to work in Grafana.
I am using Grafana in combination with Influx.

Thanks in advance!

I've used the combination Node-Red and MQTT (
mosquitto) where Domoticz pushes the data to the Misquitto broker and Node-Red pushes thes values to InfluDB. Node-red has all the necessary modules to do the job. It worksvery reliable too. I push all data that come from a smart meter every second to 2 InfluxDB servers simutaneously. Works flawless. Succes!



Verzonden vanaf mijn iPhone met Tapatalk Pro