QA InfluxDB2 / InfluxDB3

[petrkl12 228]

QA for regular exporting data from HC3 to InfluxDB 2.x or InfluxDB 3.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 or InluxDB 3.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: (same QA for InfluxDB2 or InfluxDB3)

Please login or register to see this attachment.

 

Icon:

 

Please login or register to see this image.

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

 

 

 

      

 

 

 

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     (default value http, for cloud usually https)

VersionInflux ie. V2 (default V2 for InfluxDB2 or V3 for InfluxDB3)e.

Organization ie. Your Organization From InfluxDB2 or Your Database for InfluxDB3
Bucket ie. Your Bucket From InfluxDB2 or empty for InfluxDB3
TokenAPI ie. Your TokenAPI From InfluxDB2 or InfluxDB3

 

Please login or register to see this attachment.

 

 

 

 

Edited February 25 by petrkl12

[jguellec 15]

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 ? 

[petrkl12 228]

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.

 

[Sjakie 156]

@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

[petrkl12 228]

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

 

[Sjakie 156]

@petrkl12 Update done  result same error.

It will give for Manny devices same error

Also for main HC3 

Edited May 22, 2024 by Sjakie
add

[petrkl12 228]

coukd you share these errors? thanks

[petrkl12 228]

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

[Sjakie 156]

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 May 23, 2024 by Sjakie
restart

[petrkl12 228]

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

 

[Sjakie 156]

@petrkl12, done same error.

[petrkl12 228]

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
 

[Sjakie 156]

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

[Brors94 115]

On 2/8/2022 at 6:27 PM, petrkl12 said:

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

 

 

 

Please login or register to see this link.

 

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.

 

 

 

 

Is it any information on how the incl/excl quickappvars works?

I only want to send temperature data and energy data to start with 🤔

So how do I make it stop sending everything first? 😅

and I guess inn the includevice i just type ids like this:  1003,1004,1005 ?  🤔

 

 

I have to say this quickapp is NICE!

Linked my influx with grafana and got this to check my temperatures on my waterboiler as an example

Please login or register to see this attachment.

 

 

 

 

 

Edited October 6, 2024 by Brors94

[jguellec 15]

Hi @petrkl12 hope you are doing great ! I'm using your QA for a few years now and it works great ! However, I've notice that it triggers frequent (and many) 500 errors , such as : 

 

[QA_INFLUXDB2_614]: [ERROR] sendDataToInfluxDB2 - Status is ERR - Status - 500 Data:

 

I am not quite sure if it's a recent behavior or if it was there from the start. Maybe you have an idea how I can correct that ? 

 

Have a nice day !

[petrkl12 228]

is it full error message? if there is nothing else it will be internal error in InluxDB - for example your server is overloaded…

[jguellec 15]

Thanks for your quick reply. I'll try to screenshot the full errors next time, basically it as a device name and few stuff after the "500 Data:"

 

At the moment I don't have any errors, so I guess you're probably right with the gateway overloaded 😃

[petrkl12 228]

Important information for users running InfluxDB in Docker/containers.

 

( btw.InfluxDB 2 and InfluxDB 3 have diffrent database structure, etc.   )

 

[petrkl12 228]

new version with support of Influx DB3 (version 1.52 or above) - download in first post or via auto update in QA