Sending data to Influxdb

prune998 · 2015-10-18 20:57:20 UTC

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 · 2015-10-18 21:43:42 UTC

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 · 2015-10-21 02:34:25 UTC

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

btk · 2015-10-21 20:04:38 UTC

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 · 2015-10-21 20:32:42 UTC

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

jdrews · 2016-03-21 02:34:23 UTC

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

prune998 · 2016-03-21 11:28:19 UTC

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 · 2016-03-21 11:42:09 UTC

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

tintin · 2016-03-21 23:48:46 UTC

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 · 2016-03-22 00:59:05 UTC

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 · 2016-03-22 01:01:16 UTC

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

prune998 · 2016-03-24 12:02:37 UTC

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 · 2016-03-26 01:29:01 UTC

@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 · 2016-03-26 01:57:17 UTC

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 · 2016-03-26 02:45:31 UTC

Got it working after turning off HTTPS.

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

snootched · 2016-03-29 18:27:25 UTC

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 · 2016-04-08 11:26:30 UTC

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 · 2016-04-08 11:50:38 UTC

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 · 2016-04-08 11:51:38 UTC

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

prune998 · 2016-04-08 12:08:11 UTC

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…