Grafana / Influxdb / Chronograf setup with Fibaro and Domoticz

[julesmartens 0]

Hi all,

 

On the Fibaro forum I seen various examples of people who succesfully configured Influxdb/grafana to work together with Fibaro. All with the goal to have improved logging of historic state changes of HC2.

One of the solutions are provided by @bpannier, see github 

Please login or register to see this link.

.

In all solutions I found I see that a scene is used to push data from HC2 into the influxdb.

 

Influxdb also comes with chronograf, I guess this is a new feature. Chronograf seems an additional package that should make it easier (no CLI) to manage databases and visualization.

I found a section about Fibaro in the default chronograf config file , see screenshot.

So it seems that chronograf can pull information from Fibaro HC2 instead of HC2 pushing information to the database.

 

Does anyone have experience with this / know how to configure this properly to make this work?

I get an error 401 (no access) instead of 200 (success). If I test the fibaro API I can see data in browser even without using username/credentials (See screenshot)

 

It also seems that Chronograf is limited in what it can pull from Fibaro. 

state changes of devices seems possible, globals seems not possible or at least I couldnt find it.

 

Next to Fibaro I run Domoticz to read out my p1 port of "slimme meter".  Domoticz has a build in function to push data to Influxdb.

 

I now wonder;

> should I use Chronograf (it seems a handy tool)

> should I push data from HC2/Domoticz to Influx or should I (potentially Partially) pull data from Chronograf?

> Is it possible (and smart) to mix push and pull strategy?

> does anybody have experience / instructions how to configure this all? (I have the influxdb/grafana/chronograf as default config running on a Docker on my Synology NAS).

 

Thanks!

 

Regards,

Jules

Please login or register to see this attachment.

 

Please login or register to see this attachment.

Edited August 19, 2019 by julesmartens
masked some personal items in screenshot

[10der 830]

Use poll not push IMHO

use 

Please login or register to see this link.

 for it 

so, create cron with shell and grab what you wish via calling this method 

it’s more simplest 

 

For example 

Please login or register to see this attachment.

Edited August 20, 2019 by 10der

[julesmartens 0]

Hi 10der,

 

Thanks this is also a bit what I expected.

Do you use chronograf to configure the communication between influxdb and HC2?

On the homepage of Influxdb, telegraf seems to be the central tool to configure the database (

Please login or register to see this link.

)

 

Could you maybe share some screenshots of your configuration so I have a reference.

I'm new in Influxdb/grafana/chronograf. I need to figure out;

> how to setup the database (create new db in telegraf?)

> how to setup communication between HC2 and database (config file of telegraf?)

> how to setup, define the devices and globals that I would like to pull data from.

 

Do you need user credentials to pull data from HC2 into the db? 

 

Regards,

Jules

 

[10der 830]

1st I am not used any tools for this 

2nd I am story all HC data to local MySQL data base cuz this data used NOT only for graph for example some devices at home build weather forecast etc 

3td you can used simple python script for grabbing data from HC2 and store it in InFlUX dB for Grafana cuz as I know influx dB is native dB for Grafana 

if you still can’t moving on with this ok I can help you write script 

16 minutes ago, julesmartens said:

Do you need user credentials to pull data from HC2 into the db? 

 

Sure, without creds you can’t get any data from HC2, alas 

[Tomislav Barbarić 1]

Did you resolve this?

I'm trying to make some dashboards in Grafana, but I'm beginner too.

I successfully installed Grafana, InfluxDB and Telegraf, but now I don't know what to do next.

I can see Fibaro input plugin on:

Please login or register to see this link.

[kukulkan97 0]

On 8/21/2019 at 2:02 AM, 10der said:

2nd I am story all HC data to local MySQL data base cuz this data used NOT only for graph

@10derHi! Sorry, can you could you please explain how you do it? Thank you!