[HOWTO] HC2 + Grafana (influxdb)

[10der 829]

@jgab

Please login or register to see this image.

/monthly_2020_08/image.png.6f70a2dcac70d1bed85102279793ad87.png" />

 

Please login or register to see this attachment.

[jguellec 14]

I have another question for you @

Please login or register to see this link.

 

Please login or register to see this link.

 

 

Can you please give me an example of query for Grafana, with this new scene ? I tried the following, but it says « no data »... (the data source is working correctly) 

Please login or register to see this attachment.

[10der 829]

Please login or register to see this attachment.

 

 

Please login or register to see this code.

 

Edited August 10, 2020 by 10der

[10der 829]

Please login or register to see this attachment.

 

Please login or register to see this code.

 

Please login or register to see this attachment.

[jguellec 14]

It’s working perfectly. Now I have my data in Grafana ! 

 

Thanks a lot for your help 

Edited August 10, 2020 by jguellec

[10der 829]

u r welcome!

[jguellec 14]

Thanks to you @10der, I’m starting to have a nice dashboard in Grafana ?

 

Please login or register to see this attachment.

 

I have (again ?) a quick question for you ! In this function : 

saveToInflux(measurement_name, value, deviceID, deviceName, roomName, sectionName)

 

Let’s say I want to display a Grafana Panel with the Fibaro software version (ex.: 5.040.37). I noticed that it wasn’t possible to have a String in « value ». Only numbers. Is this an Influxdb limitation ? 

 

Have a great end of day !

[10der 829]

3 minutes ago, jguellec said:

Let’s say I want to display a Grafana Panel with the Fibaro software version (ex.: 5.040.37). I noticed that it wasn’t possible to have a String in « value ». Only numbers. Is this an Influxdb limitation ? 

AFAIR yes, but let me check... maybe tomorow.

 

PS: cool dashboard. realy cool!

[jguellec 14]

1 minute ago, 10der said:

AFAIR yes, but let me check... maybe tomorow.

 

PS: cool dashboard. realy cool!

 

Take your time, no rush ?

 

Thanks for the dashboard, wouldn't have been possible without your support !

[Fer 0]

Thanks, works perfect with HC3!

[10der 829]

49 minutes ago, Fer said:

Thanks, works perfect with HC3!

Hc3 should work without python 

at all

search by forum my script 

[Nick_Clever 1]

On 8/15/2020 at 10:26 PM, jguellec said:

Thanks to you @10der, I’m starting to have a nice dashboard in Grafana ?

 

Please login or register to see this attachment.

 

I have (again ?) a quick question for you ! In this function : 

saveToInflux(measurement_name, value, deviceID, deviceName, roomName, sectionName)

 

Let’s say I want to display a Grafana Panel with the Fibaro software version (ex.: 5.040.37). I noticed that it wasn’t possible to have a String in « value ». Only numbers. Is this an Influxdb limitation ? 

 

Have a great end of day !

 

Thanks a lot @10der for sharing all your insights.

Congratulations @jguellecfor creating this fantastic Grafana DB to visualize the Fibaro HC data. Is there a chance you would share the dashboard here 

Please login or register to see this link.

 ? I would love to use yours as a template to configure mine - once I managed to get the scene @10der shared to deliver the data (but I am working on this now).

[kukulkan97 0]

Hi @10der! Thanks for the guidance! I have a question, I just started studying, so there are a lot of questions , but first. Grafana does not see the Influx database. What could be the mistake?

[jguellec 14]

On 11/29/2020 at 7:54 PM, Nick_Clever said:

 

Thanks a lot @10der for sharing all your insights.

Congratulations @jguellecfor creating this fantastic Grafana DB to visualize the Fibaro HC data. Is there a chance you would share the dashboard here 

Please login or register to see this link.

 ? I would love to use yours as a template to configure mine - once I managed to get the scene @10der shared to deliver the data (but I am working on this now).

Thanks @Nick_Clever. I’ve been away for few weeks, haven’t seen your message before, sorry. 

 

I’ve shared the dashboard on grafana :

Please login or register to see this link.

 

And I also attach the .json file here, if anyone’s interested. 

 

I made some updates, but feel free to use it. 

 

Please login or register to see this attachment.

 

Please login or register to see this attachment.

[SmartHomeEddy 789]

Today I thought I would install Influxdb and Grafana to develop good looking dashboard like in this post.

 

I tried to install Influxdb on my Synology NAS with Docker. Docker and I are not so good friends. Instructions are always a bit different with my Docker and it always works a bit different or not. In this case "not". Some frustration and removed the containers. 

 

Is for example Influx on a Raspberry Pi a more stable option? Anyone an advice?

 

 

Edited January 31, 2021 by SmartHomeEddy

[jguellec 14]

Hi @SmartHomeEddy,

 

I have no experience with influxdb on a Raspberry but what is the problem with docker on the NAS ? I personally have influxdb installed in a docker container on my Synology and it's very stable.

 

If it can help, I used this image with default settings :

Please login or register to see this link.

 

Good luck

 

Edited February 3, 2021 by jguellec

[SmartHomeEddy 789]

Thanks

 

I used the official InfluxDB docker image. But the instruction didn't exactly match the real thing. As soon as I started the terminal, there were errors. Couldn't create anything, no users, no databases. etc. Bummer, it looked like it was doable. I will give i a seconds try this weekend with your link. 

[jguellec 14]

Ok, let me know. You don't have a lot of things to configure. Just install the image, create the DB for the HC3 datas, and you're done. Then you just configure a datasource in Grafana and that's it.

Please login or register to see this attachment.

[RH_Dreambox 175]

@SmartHomeEddy

Here's an excellent guide to getting started with Influx and Grafana on a Raspberry Pi.

Please login or register to see this link.

 

[SmartHomeEddy 789]

53 minutes ago, jguellec said:

just configure a datasource in Grafana and that's it.

 

Thanks, yes it looks doable. Didn't got to Grafana, installed it but needed to get further with InfluxDB. But what could go wrong  

 

If it can work stable on Synology / Docker, then that is the easy route. But if for example a Raspberry Pi gives more stability, no problem, I switch to Raspberry Pi.

 

Will give it a second try on Docker, otherwise the Raspberry Pi will be the next route. 

 

(Then have to order the Raspberry Pi, I see a RaspberryPi 4 Model B should be OK, @RH_Dreambox any advise on the amount of internal memory?)