Sending data to Influxdb

prune998 · October 18, 2015, 8:57pm

Hi all,

I’ve seen many threads/apps dealing with sending some metrics (temp and humidity sensors) to different backends.
I’m an Influxdb user and would like to create a smartapp to send data into a remote influxdb.

I’m actualy trying to push the data using a plain URL call but I’m not sure it’s really efficient. Also, I’m new to Groovy (while I’m good at python or Go).

IS there any Groovy binding to Influxdb ? Or is it possible to use the Java client within smartthings ?

btk · October 18, 2015, 9:43pm

The ST groovy environment is limited in what libaries it can use. You’re not going to be able to import any external libraries. If you can do it with an HTTP/REST call, that’s going to be the way to go. That’s what I’m using to get my data into Logstash and Graphite.

prune998 · October 21, 2015, 2:34am

Thanks @btk
Do you have any smartapp example to show ?
Thanks.

btk · October 21, 2015, 8:04pm

Sure. Both are linked below. It should be noted that the “Log to Graphite” SmartApp is actually sending its data to a Backstop instance, which then sends it along to Graphite.

github.com

bkeifer/smartthings/blob/master/Logstash Event Logger/LogstashEventLogger.groovy

/**
 *  Event Logger
 *
 *  Copyright 2015 Brian Keifer
 *
 *  Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except
 *  in compliance with the License. You may obtain a copy of the License at:
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software distributed under the License is distributed
 *  on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License
 *  for the specific language governing permissions and limitations under the License.
 *
 */
definition(
    name: "Logstash Event Logger",
    namespace: "bkeifer",
    author: "Brian Keifer",
    description: "Log SmartThings events to a Logstash server",

This file has been truncated. show original

github.com

bkeifer/smartthings/blob/master/Log to Graphite/LogToGraphite.groovy

/**
 *  Log to Graphite
 *
 *  Copyright 2014 Brian Keifer
 *
 *  Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except
 *  in compliance with the License. You may obtain a copy of the License at:
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 *  Unless required by applicable law or agreed to in writing, software distributed under the License is distributed
 *  on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License
 *  for the specific language governing permissions and limitations under the License.
 *
 *  Based on "Xively Logger" by Patrick Stuart (patrick@patrickstuart.com)
 *
 */
definition(
    name: "Log to Graphite",
    namespace: "bkeifer",

This file has been truncated. show original

prune998 · October 21, 2015, 8:32pm

Your code is really clear. I’ll use it to create an Influxdb shipper.
Many thanks !

jdrews · March 21, 2016, 2:34am

@prune998 did you ever make an Influxdb shipper? I’d like to get my hands on it if so.

prune998 · March 21, 2016, 11:28am

Yes.
I did rework it just 2 days ago… it’s not the best code and may be improved to track any sensor type, but it’s what I have for the moment.

What is the best solution to share the smartapp ?

prune998 · March 21, 2016, 11:42am

I just pusblished the smartApp. Will let you know if/when ST accept to publish it…

tintin · March 21, 2016, 11:48pm

Would you be able to ‘publish’ the influxdb shipper here - via Github similar to @btk above - so that we can try earlier than waiting for ST to go through its process - many thanks

prune998 · March 22, 2016, 12:59am

There you go guys. Don’t hesitate to do some pull requests
git@github.com:prune998/st2influx.git
https://github.com/prune998/st2influx.git

tintin · March 22, 2016, 1:01am

Many thanks - looking forward to exploring further and some new insights!

prune998 · March 24, 2016, 12:02pm

I added a little bit more details and a picture of the result in the github repo.
I also added my Grafana Dashboard to ease the setup if you are using this dashboard…

jdrews · March 26, 2016, 1:29am

@prune998 Were you able to get HTTPS working with influxdb and write from SmartThings SmartApp? I’m getting the following error in the SmartThings logs while using your smartapp. I confirmed I can write to influxdb from remote with curl although I need to pass a -k flag to ignore self signed cert issues.

something went wrong: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

EDIT: Doing some more digging. Looks like this is a SmartThings issue… It can’t accept self signed certificates. I wonder if it will take a Let’s Encrypt cert…

prune998 · March 26, 2016, 1:57am

Well, let us know if you are able to use your cert. I’m using a valid cert so i never had this issue. But that’s a good catch.

At least switch to plain http for testing… And let me know if it is working for you. Did you set up Grafana too ?

jdrews · March 26, 2016, 2:45am

Got it working after turning off HTTPS.

I did setup Grafana and your dashboard json is working thanks!

snootched · March 29, 2016, 6:27pm

Thanks for the work on this - set it up this past weekend, and looks great so far!
I as well, ran into the SSL issue with SmartThings. I disabled https, and successfully had it populating influxdb.
I went as far as getting a valid cert issued from GoDaddy and installing, however, am still receiving the errors other have posted.

I have been searching which certs SmartThings will accept, with little success so far. Major browsers seem to be happy with the certificate. Will keep plugging away.

Thanks for the work!

EDIT: found the solution to my problem. Apparently with GoDaddy switching over from SHA-1 to SHA-2, not all java installations are updated. So I had to insert the crossover cert into the chain… now smartthings can connect without any problems. For reference, anyone hitting the same issue with GoDaddy certs: http://tozny.com/blog/godaddys-ssl-certs-dont-work-in-java-the-right-solution/

spyd4r · April 8, 2016, 11:26am

I got InfluxDB up on my server, does it need to be exposed to the Internet or does the hub talk locally in the network to the DB?

prune998 · April 8, 2016, 11:50am

Sadly, It’s not the hub that connects to Influxdb.
The SmartApp is running in the SmartThings and no the hub. (as far as I know of)

So, yes, you need to expose Influxdb to the internet… That’s why I recommand using httpS and login/pass. You may also add a firewall rule to limit the IP range that can connect, but I don’t know if this is possible.
If anybody have knowledge of the IP range used by ST servers, you’re welcome to comment.

spyd4r · April 8, 2016, 11:51am

Thanks for the update, that’s what i figured… sure would be nice to have that local processing that was sold to us…

prune998 · April 8, 2016, 12:08pm

yep… local processing seems pretty limited right now, with almost “no way” to extend it… sounds like it wasn’t designed to work this way at the begining and developers are not able to deliver the marketing promises…

Topic		Replies	Views
Exporting ST data after groovy How-To logging , aftergroovy	0	962	November 30, 2022
[NEEDS UPDATING] InfluxDB Logger Community Created SmartApps smartapp , charts , logging , requires_server	111	19320	May 10, 2023
REST API or alternative for subscribing to device events General Discussion developers	4	1665	August 1, 2019
SmartThings Data Visualisation using InfluxDB and Grafana Projects & Stories smartapp_misc , smartapp , charts , logging	134	42152	August 15, 2023
Getting data from sensors General Discussion developers	8	2279	March 3, 2020

Sending data to Influxdb

Related topics