letscontrolit / ESPEasy

Easy MultiSensor device based on ESP8266/ESP32
http://www.espeasy.com
Other
3.3k stars 2.22k forks source link

InfluxDB / Telegraf "controller" needed #623

Open Grovkillen opened 6 years ago

Grovkillen commented 6 years ago

If we want to report to a InfluxDB without having to have a controller in-between we need to output the data according to this JSON format:

https://www.influxdata.com/integration/mqtt-monitoring/ https://github.com/influxdata/telegraf/blob/master/docs/DATA_FORMATS_INPUT.md

*Telegraf is a Agent to read (in this example) MQTT and feed that into the database.

https://www.influxdata.com/time-series-platform/telegraf/

LeeNX commented 6 years ago

@Grovkillen - This is not just output MQTT messages as JSON strings?

I had a similar need and ended up having to create another mqtt section for my ESPEasy devices and use data_format = "value" anddata_type = "float"``` as follows

 [[inputs.mqtt_consumer]]
   servers = ["tcp://127.0.0.1:1883"]

#   ## MQTT QoS, must be 0, 1, or 2
   qos = 1

 ## Topics to subscribe to
  topics = [
    "/data/ESP_Easy_Gate/#",
    "/data/ESP_Easy_BMP280/#",
  ]

#    data_format = "json"
  data_format = "value"
  data_type = "float"

This mostly works.

I was going to request a feature to output mqtt as json values, which I can give an example of?

LeeNX commented 6 years ago

Now that #1684 is mostly sorted out, now looking at the next part of my setup. How does MQTT in JSon coming?

Grovkillen commented 6 years ago

We want to release a stable and let us concentrate on next steps without users finding a nightly release corrupt their system. We need to have to redo some major parts of the firmware.

LeeNX commented 6 years ago

@Grovkillen - Thanks.

I am for stable release too!

Can we add a label or something? Noted for work on after release.

clowrey commented 5 years ago

I also would really appreciate direct to InfluxDB controller - just one less thing that has to be installed and running on server to monitor data

haldi4803 commented 5 years ago

Same here... Would be pretty cool to directly write into database instead of having one more thing to install.

Edit: I see this is possible with the HTTP Advanced Feature, which is only present in the Test Builds