SCENE. How to write to InfluxDb

[10der 832]

Please login or register to see this code.

 

a special thanks @tinman ?

 

 

Please login or register to see this attachment.

 

Please login or register to see this attachment.

 

 

 

 

[drboss 107]

Please login or register to see this image.

/monthly_2020_06/grafana.png.75e34df6ebeb73619b4d174df798fccb.png" />

and Icon from HC2 user  

[Guest DigitalT]

@10der

Love the script, thank you! 

 

Some suggestions to add for newbies like me in both HC3 and scripting,

 

-  What to add into declerations? 

- Add examples in comments where to change or add multiple devices?

- Add a example of the expected URL to influxDB from the script

- I also use InfluxDB protected with password so I added the variable and changed this in the code  :

Please login or register to see this code.

 

[Marek_F 0]

Hello

When I try to execute scene, I receive below error. Any idea?

 

Please login or register to see this attachment.

[ArjanP 0]

Hey, i'm feeling really stupid. But is this a scene in HC3 or a QuickApp?

[claudent 0]

Dear, I have copied and pasted the script into a scene edit window but cannot save it. Am I doing something wrong?

[SmartHomeEddy 898]

Did you add a declaration?

[claudent 0]

On 6/1/2020 at 9:03 PM, drboss said:

Honestly i am newbie and was not aware about it. Actually i found a declaration script, saved, but getting following error message: [23.03.2021] [18:42:04] [DEBUG] [SCENE12]: {"data":"{\"code\":\"unauthorized\",\"message\":\"Unauthorized\"}","status":401,"headers":{"Content-Length":"48","X-Platform-Error-Code":"unauthorized","Date":"Tue, 23 Mar 2021 17:42:00 GMT","Content-Type":"application/json; charset=utf-8"}}

 

[SmartHomeEddy 898]

Sounds like you have an authorization in your Influx database

[claudent 0]

Thanks for prompt reply, indeed I have login and pwd, actually i have set it in the script using local dbUser and local dbPass and have also adapted the local url 

 local url = "http://" .. host .. ":" .. port .. "/write" .. urlencode("?db=" .. dbName) .. ("&u=" .. dbUser).. ("&p=" .. dbPass), but still facing this error. Would it be better to have influxdb without login/pwd?

 

[SmartHomeEddy 898]

11 minutes ago, claudent said:

but still facing this error. Would it be better to have influxdb without login/pwd?

 

It would make it somewhat easier 

[claudent 0]

Thanks, but actually it looks like login/pwd is mandatory on influxdb (at least what i am using, on docker).

[claudent 0]

Have created a new login/pwd free influxdb, but still have the same error.

[hater 43]

able to use user and password

 

Please login or register to see this code.

 

[claudent 0]

Thank you, but still getting error message. Actually i have a HC3 and my influxdb is running on docker (NAS Synology). A bit lost with this error message.

I have set login/pwd accordingly, but still not working.

 

[27.03.2021] [21:34:19] [DEBUG] [SCENE15]: {"status":401,"headers":{"X-Platform-Error-Code":"unauthorized","Date":"Sat, 27 Mar 2021 20:34:19 GMT","Content-Length":"48","Content-Type":"application/json; charset=utf-8"},"data":"{\"code\":\"unauthorized\",\"message\":\"Unauthorized\"}"}[27.03.2021] [21:34:19] [DEBUG] [SCENE15]: Wrong status '401' in response!

[JcBorgs 52]

13 hours ago, claudent said:

Thank you, but still getting error message. Actually i have a HC3 and my influxdb is running on docker (NAS Synology). A bit lost with this error message.

I have set login/pwd accordingly, but still not working.

 

[27.03.2021] [21:34:19] [DEBUG] [SCENE15]: {"status":401,"headers":{"X-Platform-Error-Code":"unauthorized","Date":"Sat, 27 Mar 2021 20:34:19 GMT","Content-Length":"48","Content-Type":"application/json; charset=utf-8"},"data":"{\"code\":\"unauthorized\",\"message\":\"Unauthorized\"}"}[27.03.2021] [21:34:19] [DEBUG] [SCENE15]: Wrong status '401' in response!

@claudent I do believe that the difference is what version of Influx you are running. I have two RaspBerryPi, one running InfluxDB 1.8 (32bit) and one running InfluxDb 2.0 (64bit).

 

I see the exact same error messages on the InfuxDb 2.0 which is related to that this version have a different authentication system. I have so far not been able to solve that and have given up and only use the InfluxDB 1.8.

 

 

[claudent 0]

Thanks alot for your feedback, I will try influxdb 1.8 and see what will be the result.

[claudent 0]

I get it to work with influxdb 1.8, thanks alot.

[JcBorgs 52]

2 hours ago, claudent said:

I get it to work with influxdb 1.8, thanks alot.

Nice to hear that it worked! 

 

[claudent 0]

I really appreciate your support.

 

[Forall 2]

Hi, maybe stupid question but does this run locally so that you should have influxdb and grafana on e.g. a raspberry?