QA InfluxDB2

[petrkl12 203]

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" />

 

 

 

 

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 November 19, 2023 by petrkl12

[petrkl12 203]

There is no impact if you have valid or invalid licence key. QA should work.

Are there any errors/warnings in log?

[jostrih 0]

I was checking the logs.There was error 404 - [09.07.2022] [23:35:38] [ERROR] [QA_INFLUXDB2_39]: [ERROR] sendDataToInfluxDB2 - Status is ERR - Status - 404 Data: other,sectionName=Prizemi,deviceID=21,roomName=Kuchyn,deviceType=FGWP102,deviceName=Mycka power=0.4 1657402538 ResData:

I've just tried to create a new bucket, with a name without "_" character and it is working great. Thank you to kick me the right way

This is my first Fibaro installation at home and I forget about the roots (to check the logs)

[petrkl12 203]

Super, my QAs are without errors ?

[kjt 3]

Hi, Which licence i needed? And where, and how can i get one?

 

another: How can exclude ALL devices except outlet? What is a syntax? I would like to measure the energy consumption.

 

Thx

[Fabir 64]

@petrkl12

Hello

Thank you verry much for your great work and providing this QA..

 

I would like to use it for the Influxdb in the cloud. Without the need for a linux device in the LAN

 

https://www.influxdata.com/influxcloud-trial/?utm_source=bing&utm_medium=cpc&utm_campaign=2020-09-03_Cloud_Traffic_Brand-InfluxDB_INTL&utm_term=influxdb%20cloud&msclkid=b77d1825669519b02f717b4e1b2e6de3

 

Do you know if this is possible and what changes need to bee done?

[petrkl12 203]

I never tested this scenario.

So you have to try it - you need these params for cloud:

 

IP_InfluxDB2 ie. 192.168.1.111

Port_InfluxDB2 ie. 8086

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

 

 

[Fabir 64]

@petrkl12

Thank you for your help

 

I will try.

 

The QA also tells:  No valid QA license key!

Where can I get a vaild licence key?

Edited November 10, 2022 by Fabir

[Tomislav Barbarić 1]

Has anyone managed to connect to InfluxDB cloud?

 

I have different errors:

[ERROR] sendDataToInfluxDB2 - Status is ERR - Status - 308 Data: (when connecting to eu-central-1-1.aws.cloud2.influxdata.com, port 80)

[ERROR] sendDataToInfluxDB2 - Connection ERR - Connection timed out Data (when connecting to eu-central-1-1.aws.cloud2.influxdata.com, port 8086)

 

Error in saveToInfluxSystemInfo: std::runtime_error: 'Invalid argument'

 

IP_InfluxDB2 - we need use host instead of IP (

Please login or register to see this link.

) - but with or without "https"?

Port_InfluxDB2 - there isn't any info in influxd cloud documentation about port. I tried 8086 and 80

Organization - organization name or organization ID?

Bucket and Token API - I think this is clear

[PSi 5]

On 1/10/2023 at 2:43 PM, Tomislav Barbarić said:

Has anyone managed to connect to InfluxDB cloud?

 

I have different errors:

[ERROR] sendDataToInfluxDB2 - Status is ERR - Status - 308 Data: (when connecting to eu-central-1-1.aws.cloud2.influxdata.com, port 80)

[ERROR] sendDataToInfluxDB2 - Connection ERR - Connection timed out Data (when connecting to eu-central-1-1.aws.cloud2.influxdata.com, port 8086)

 

Error in saveToInfluxSystemInfo: std::runtime_error: 'Invalid argument'

 

IP_InfluxDB2 - we need use host instead of IP (

Please login or register to see this link.

) - but with or without "https"?

Port_InfluxDB2 - there isn't any info in influxd cloud documentation about port. I tried 8086 and 80

Organization - organization name or organization ID?

Bucket and Token API - I think this is clear

Hi, 

Experiencing a similar situation, any solution for that?

[01.02.2023] [15:59:06] [ERROR] [QA_INFLUXDB2_222]: [ERROR] Error in fibaro.setTimeout: std::runtime_error: 'Invalid argument'

[ppeterr 202]

It works like a charm overhere, locally ofcourse.

 

I think it is not intended to connect to a cloud service.

[PSi 5]

4 hours ago, ppeterr said:

It works like a charm overhere, locally ofcourse.

 

I think it is not intended to connect to a cloud service.

There are some things needed to get it working with InfluxDB Cloud:

- use hostname without https://

- Use Port 443

- patch main file (add "s"): 

w="https://"..bn.."

[petrkl12 203]

@PSi is it working with your modification in cloud?

[PSi 5]

10 minutes ago, petrkl12 said:

@PSi is it working with your modification in cloud?

yes, I can see the data flowing!

[petrkl12 203]

56 minutes ago, PSi said:

yes, I can see the data flowing!

ok, I will do some changes in my source code to support cloud

[petrkl12 203]

5 hours ago, petrkl12 said:

ok, I will do some changes in my source code to support cloud

@PSi

new QA version for test sent to your PM

[PSi 5]

4 hours ago, petrkl12 said:

@PSi

new QA version for test sent to your PM

Working!

[Fabir 64]

@petrkl12Hi, thank you very much for making your QA working with influxdb Cloud. Will this be working with HC3 and also HC3L?

[petrkl12 203]

2 hours ago, Fabir said:

@petrkl12Hi, thank you very much for making your QA working with influxdb Cloud. Will this be working with HC3 and also HC3L?

Yes, it should work in HC3, HC3L and Yubii

[petrkl12 203]

first post was updated with new version that supports cloud database (and also description how to install)

 

for existing Influx QA you can just click on button QA Update and everything will be updated immediately or you can wait for night auto update

 

Edited February 2, 2023 by petrkl12

[Fabir 64]

@petrkl12Still no luk in my case.

 

How can your QA write data into the cloud influxdb, without knowing the user name and the password from influxdb cloud?

Edited February 3, 2023 by Fabir