Pushing smart meter data to InfluxDB database

Topics (not sure which fora)
when not sure where to post, post here and mods will move it to right forum.

Moderators: leecollings, remb0

Post Reply
JosFr
Posts: 6
Joined: Sunday 20 November 2022 10:27
Target OS: Linux
Domoticz version:
Contact:

Pushing smart meter data to InfluxDB database

Post by JosFr »

After succesfully connecting my Smart Meter to Domoticz and retrieving Power and Gas values from the meter, I'm now trying to store these values in an InfluxDB database. I set up the database, created a user, retrieved the InfluxDB authorization token and with these values configured the Data push/InfluxDB General Settings. I then added added links for Gas, Power/Delivery 1 and Power/Usage 1. This results in a connection with the database as a "influx query 'import "influxdata/influxdb/schema" schema.measurements(bucket: "domoticz")' command shows. The schema however only shows "Gas-usage" as result.

The wiki page (https://www.domoticz.com/wiki/Influxdb) gives little help on this topic, so what should be the schema for the database and should I create this by hand or will Domoticz take care of that?
User avatar
waltervl
Posts: 5904
Joined: Monday 28 January 2019 18:48
Target OS: Linux
Domoticz version: 2024.7
Location: NL
Contact:

Re: Pushing smart meter data to InfluxDB database

Post by waltervl »

From what I understand (I do not use influxdb) you just make an influxdb database (with user and token) and push the data.
Domoticz will create the necessary fields in influxdb.
What does the domoticz log file say when power data is pushed?
Domoticz running on Udoo X86 (on Ubuntu)
Devices/plugins: ZigbeeforDomoticz (with Xiaomi, Ikea, Tuya devices), Nefit Easy, Midea Airco, Omnik Solar, Goodwe Solar
Post Reply

Who is online

Users browsing this forum: Google [Bot] and 1 guest