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


  • 0

QA InfluxDB2


petrkl12

Question

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

Recommended Posts

  • 0

Hi @petrkl12, congrats for the great work :)  I'm trying your QA and thinking about buying it. It’s really nice. 

 

I'm wondering if there's a way to get a value : 
- stored in a QA variable ?
- stored in a QA label ?
- stored in a Global variable ? 

Link to comment
Share on other sites

  • 0
  • Inquirer
  • 19 hours ago, jguellec said:

    I'm wondering if there's a way to get a value : 
    - stored in a QA variable ?
    - stored in a QA label ?
    - stored in a Global variable ? 

     

    No, these data are not sent to InfluxDB.

     

    • Like 1
    Link to comment
    Share on other sites

    • 0

    @petrkl12, I installed QA

    first error status 500 >> solved by https

    second error :

    Please login or register to see this code.

    No idea how to solve??

    QA Version: 1.16 27.4.2024

    InfluxDB v2.7.6

    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • @Sjakie Can you try version 1.18? (press button QA update and install new version)

     

    Link to comment
    Share on other sites

    • 0
    Posted (edited)

    @petrkl12 Update done  result same error.

    It will give for Manny devices same error

    Also for main HC3 

    Edited by Sjakie
    add
    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • coukd you share these errors? thanks

    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • Could you check what is in Influx? Is it empty or some data are there already?
    Errors are only with “0.0” numbers?

    Link to comment
    Share on other sites

    • 0
    Posted (edited)

    Yesterday I had data in InfluDB

    Today I see in dashboard the graphic started yesterday.

    Restart of HC3 and NAS

    After importing dashboard, dashboard deleted what also removed my first dashboard.

    Now I can't select value, if select in first column it will clear all other columns.

    Note: I am a first time InfluxDB user

    The errors are on all devices see pm 

    Edited by Sjakie
    restart
    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • @Sjakie Issue is with https. That error is from SSL. I have tried to switch off control of certificates but I can't test it because I don't use https...

    There is new version 1.19 (press button QA update and install new version)

     

    Link to comment
    Share on other sites

    • 0
  • Inquirer
  • ok, you will have to change settings in InfluxDB but I don’t know how. That error is not in QA.

    I think you will have to play with following commands in InfluxDB:

     

    [http]
      # Enable HTTPS. Default is false.
      https-enabled = true

      # The path to the PEM encoded certificate.
      https-certificate = "/etc/ssl/influxdb.pem"

      # The path to the PEM encoded private key.
      https-private-key = "/etc/ssl/influxdb-key.pem"

      # Use a separate private key and certificate file for each subdomain or server
      # block. The path to the file must be specified by the parameter with the
      # corresponding name.
      #
      # If you want to use mutual TLS, you must configure each client CA.
      # https-ca-certificate = "/etc/ssl/influxdb-ca.pem"

      # Minimum version of TLS to be used. By default, it’s “1.2”.
      # https-min-version = "1.2"

      # Maximum version of TLS to be used. By default, it’s “1.3”.
      # https-max-version = "1.3"

      # Skip TLS verification for clients. Use this for testing purposes only.
      # https-insecure-skip-verify = false
     

    Link to comment
    Share on other sites

    • 0

    Thanks, I tried yesterday to switch HC3 into only http >>no luck

    pitty is now I can't go back into https anymore network tab does't open. In remote all are greed out.

    So it will take some time to fix

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