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


Question

Posted (edited)

QA for regular exporting data from HC3 to InfluxDB 2.x

 

30 days trial period - than you need license key: 30EUR via Paypal account

Please login or register to see this code.

For license key I need your HC3 (or HC3L or Yubii) serial number: HC3-xxxxxxxx

Ideally include your device serial number and QA name in the payment note.

 

QA is sending data based on events and also in regular intervals from HC3/HCL/Yubii to InluxDB 2.x. It generates data to Influx with minimum delay.

There is data about HC3 system (cpu,ram), info about scenes (start, stop), geofence events and a lot of details about devices. In QA variables there is possibility to define include/exclude measurements/IDs/… (default all data are sent to Influx)

 

QA:

Please login or register to see this attachment.

 

Icon:

 

Please login or register to see this image.

/monthly_2022_02/InfluxDB.png.b9f88eff9645ffa375849b159f905636.png" />

 

 

 

image.png.a91e9e69e4f6d09147fe9d4e734d473e.png

 

Please login or register to see this attachment.

 

QA variables - you have to setup -

IP_InfluxDB2 ie. 192.168.1.111 (or server/database address without https:// or http:// )

Port_InfluxDB2 ie. 8086   (for cloud database usually 443)

HttpType ie. http     (defaul value http, for cloud usually https)

Organization ie. YourOrganizationFromInfluxDB2
Bucket ie. YourBucketFromInfluxDB2
TokenAPI ie. YourTokenAPIFromInfluxDB2
 

Please login or register to see this attachment.

 

 

 

 

Edited by petrkl12
  • Like 6
  • Thanks 1

Recommended Posts

  • 0
Posted (edited)

Perfect, in the meanwhile i am running influxDB v2 in a docker on my nas.

Tomorrow I will link Grafana to it and then come back to it to fill the database and visualize the data

 

It looks promising!

 

I'll be back. Thanks for this.

 

@tjeerdhage #tagging you on this topic

Edited by ppeterr
  • 0
  • Inquirer
  • Posted

    You have QA in PM

    • Like 1
    • 0
    Posted

    I hope for beta too

    thanks

    • 0
  • Inquirer
  • Posted
    4 hours ago, minsad79 said:

    I hope for beta too

    thanks

    QA in PM

    • 0
    Posted

    Got it up and running,  now lets see how to get it into grafana :)

     

     

    Please login or register to see this attachment.

    • 0
  • Inquirer
  • Posted

    Super :)

    it could be perfect to share with us your new dashboards in Grafana

     

    • 0
    Posted
    6 minutes ago, petrkl12 said:

    Super :)

    it could be perfect to share with us your new dashboards in Grafana

     

     

    Ofcourse, i tried to import the old dashboard thats based on influx 1...

    But it needs some work on my side, since the entry's are different. 

    • 0
    Posted

    Well, i could need a little hint. I am trying to make a query from within influxdb. To use it in grafana -> flux.

    This is a little new for me, but i thought i'd just make one in influxdb, and use that line for flux.

    But all the entry's are there, but it doesnt bring up the data.

     

     

     

    Please login or register to see this attachment.

    • 0
    Posted

    Some of them are giving data....uhmm this needs some investigation

     

     

    Please login or register to see this attachment.

    • 0
    Posted

    I worked it out, it needs a different query order then the standard settings in influxdb.

    Doing it like this, and then select per device ID brings up the correct numbers.

     

     

    Please login or register to see this attachment.

    • 0
    Posted

    I reproduced my dashboard, almost oke.

     

     

    Please login or register to see this attachment.

    • Like 2
    • 0
    Posted (edited)

    Okay, my first impression up till now. Compared to my old situation.

    The old situation is still running, on an RPI with influx 1. The data is transferred to Grafana.

    The new situation with this QA. 2 Dockers on my synology NAS. InfluxDB 2 - Grafana with FLux Beta as Query Language.

    The load on the HC3 at initial startup seems very low. The latency for the new data being showed in grafana seems a lot faster.

    Not sure how to measure this. But it's about 1.5 minutes faster.

    Using InfluxDB2 compared to v1 is very nice. All results and data can be reviewed in the dashboard itself. So selecting the events from the HC3 is really easy. I like it.

     

    So, for now - lets see how stable it is for the coming weeks. And i hope to see more users showing their results. And give me some ideas.

    This is how I ended up with the data.

     

    great work @petrkl12

     

     

    Please login or register to see this attachment.

    Edited by ppeterr
    • Like 2
    • Thanks 1
    • 0
  • Inquirer
  • Posted

    There should be almost everything from HC3 incl. press buttons on remotes, start/end scenes  etc. :)

     

    • 0
    Posted

    So far it runs without any problems. Very responsive with the incoming data, and low impact on the system.

    I have not noticed any hickups till now. The update system also seems to work well from the QA itself.

    I am still discovering events and triggers in the influx database. I plan to do more with that.

     

    Again, I hope to get inspiration from other user experiences.

    I also really like the setup with influx and grafana on my synology.

    Although it probably also runs perfectly on an rpi.

     

    nice!!

    • 0
  • Inquirer
  • Posted (edited)

    some examples - Grafana

    Please login or register to see this attachment.

    Edited by petrkl12
    • 0
    Posted
    On 2/9/2022 at 10:06 AM, petrkl12 said:

    it could be perfect to share with us your new dashboards in Grafana

    :P

    Please login or register to see this attachment.

    • Like 2
    • 0
  • Inquirer
  • Posted

    changes are possible to do in sec if we have data ? thanks for inspiration

    Please login or register to see this attachment.

     

    • Like 1
    • Thanks 1
    • 0
    Posted
    On 2/9/2022 at 4:27 AM, petrkl12 said:

    QA variables - you have to setup -

    IP_InfluxDB2 ie. 192.168.1.111

    Port_InfluxDB2 ie. 8086

    Organization ie. YourOrganizationFromInfluxDB2
    Bucket ie. YourBucketFromInfluxDB2
    TokenAPI ie. YourTokenAPIFromInfluxDB2

     

    Hi - I'm very much the noob with this so was hoping for some assistance. Would you perhaps have a guide as to how this is setup?

     

    I have a Pi running influxdb and a database called PiData but I'm unsure about what the organisation, bucket and token API is.

    Is this some kind of cloud connection to influx or something?

    Any examples / documentation would be great

     

    Thanks,

     

    Anthony

     

     

    • 0
    Posted

    @Anth

     

    This guide helped me a lot, ofcourse it contains some parts that are not usefull for you.

    But is gives the basic setup for influx and grafana also.

     

     

    • 0
    Posted

    Just installed it, but on the Edit&Preview tab I see No valid QA license key!

    And there is no update, no data in InfluxDB. 

    Join the conversation

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

    Guest
    Answer this question...

    ×   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...