Jump to content

Welcome to Smart Home Forum by FIBARO

Dear Guest,

 

as you can notice parts of Smart Home Forum by FIBARO is not available for you. You have to register in order to view all content and post in our community. Don't worry! Registration is a simple free process that requires minimal information for you to sign up. Become a part of of Smart Home Forum by FIBARO by creating an account.

 

As a member you can:

  •     Start new topics and reply to others
  •     Follow topics and users to get email updates
  •     Get your own profile page and make new friends
  •     Send personal messages
  •     ... and learn a lot about our system!

 

Regards,

Smart Home Forum by FIBARO Team


[HOWTO] HC2 + Grafana (influxdb)


10der

Recommended Posts

  • Topic Author
  • @jgab

    Please login or register to see this image.

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

     

    Please login or register to see this attachment.

    Link to comment
    Share on other sites

    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.

    Link to comment
    Share on other sites

  • Topic Author
  • Please login or register to see this attachment.

     

     

    Please login or register to see this code.

     

    Edited by 10der
    Link to comment
    Share on other sites

  • Topic Author
  • Please login or register to see this attachment.

     

    Please login or register to see this code.

     

    Please login or register to see this attachment.

    Link to comment
    Share on other sites

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

     

    Thanks a lot for your help :-)

    Edited by jguellec
    Link to comment
    Share on other sites

    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 !

    • Like 1
    • Thanks 1
    Link to comment
    Share on other sites

  • Topic Author
  • 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!

    Link to comment
    Share on other sites

    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 !

    Link to comment
    Share on other sites

    • 2 months later...
  • Topic Author
  • 49 minutes ago, Fer said:

    Thanks, works perfect with HC3!

    Hc3 should work without python 

    at all

    search by forum my script 

    Link to comment
    Share on other sites

    • 1 month later...
    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).

    • Thanks 1
    Link to comment
    Share on other sites

    • 3 weeks later...

    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?

    Link to comment
    Share on other sites

    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.

    • Like 2
    • Thanks 3
    Link to comment
    Share on other sites

    • 1 month later...

    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 by SmartHomeEddy
    Link to comment
    Share on other sites

    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 by jguellec
    Link to comment
    Share on other sites

    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. 

    Link to comment
    Share on other sites

    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.

    • Thanks 1
    Link to comment
    Share on other sites

    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?)

    Link to comment
    Share on other sites

    Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.

    Guest
    Reply to this topic...

    ×   Pasted as rich text.   Paste as plain text instead

      Only 75 emoji are allowed.

    ×   Your link has been automatically embedded.   Display as a link instead

    ×   Your previous content has been restored.   Clear editor

    ×   You cannot paste images directly. Upload or insert images from URL.

    ×
    ×
    • Create New...