Indigo Domotics

Warning as of February 27th, 2018 - Rachio has apparently started throttling API requests which may cause the plugin to fail. The issues have been addressed in v1.1.3 of the plugin available in the Plugin Store. We highly recommend that everyone upgrade to v1.1.3 or later to avoid issues. Also, check out the docs for the plugin to learn about some new Events you can use to be notified when there are communication and control issues.

We've also created a sub-forum for the Rachio plugin and we've locked this topic. If you have any questions, start a new topic instead. This will help others more easily find answers to questions they may have.

--------------------------------------------------------

This plugin integrates the Rachio sprinkler controllers into Indigo as a standard Indigo Sprinkler. The plugin is hosted on our Github account - check out the repository for details on how to install and use the plugin and you can also download the latest release from there.

I've tested this plugin against the 16-zone controller so I'm pretty confident that it will handle any number of zones up to 16. However, I haven't yet installed it permanently at my home, so it hasn't really been fully tested under normal working conditions. I intend to do that install this weekend (4/29/2017) so it should get a better workout after that. If anyone already has one give it a try and let me know if you have any issues.

Thank you! I coincidentally had just purchased one.

Definitely let me know how it goes when you start using it. You might want to put it into standby mode at first so Indigo is the only thing doing the irrigation, then introduce Rachio schedules later (that's the approach I'm going to take I think). I like all the intelligence built-in to it, but I'm also a little worried about my landscape dying...

[UPDATE] - I've decided to just let Indigo do all the control rather than try to mix the two approaches.

Thank you Jay. I got one of these as a gift a few weeks ago. I've installed the plugin but won't know how well it works until after this weekends soaking by mother nature

Oh cool... definitely looking forward to trying this out.

Jay,

This looks like a great plugin. Thanks for taking the time to put it together for the community!

Unfortunately, I'm getting the following error after inputting the API token into the plugin's configuration. Thinking the extra "/" might be the culprit:
...device//forecast?units=US

Code: Select all

Rachio Sprinklers Debug         Connection to Rachio API server failed with exception:
Traceback (most recent call last):
  File "plugin.py", line 112, in _make_api_call
    r.raise_for_status()
  File "/Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/PlugIns/requests/models.py", line 848, in raise_for_status
    raise HTTPError(http_error_msg, response=self)
HTTPError: 404 Client Error: Not Found for url: https://api.rach.io/1/public/device//forecast?units=US

Thx so much!

Here's the latest: modified the plugin to remove the extra "/" and now faced with this:

Code: Select all

Rachio Sprinklers Error         Connection to Rachio API server failed with exception: HTTPError. Check the log file for full details.
   Rachio Sprinklers Debug         Connection to Rachio API server failed with exception:
Traceback (most recent call last):
  File "plugin.py", line 112, in _make_api_call
    r.raise_for_status()
  File "/Library/Application Support/Perceptive Automation/Indigo 7/IndigoPluginHost.app/Contents/PlugIns/requests/models.py", line 848, in raise_for_status
    raise HTTPError(http_error_msg, response=self)
HTTPError: 403 Client Error: Forbidden for url: https://api.rach.io/1/public/device/forecast?units=US

Anyone else experiencing the same original error or this one?

I had something like that - I deleted and recreated the sprinkler device within Indigo and it resolved the problem...

It looks like somehow the rachio api device UUID is missing from the device state (look at the "id" state in the states list). Are you sure you have your device configured correctly? The double // gives the best clue since there's supposed to be a UUID in between them.

norcoscia wrote:

I had something like that - I deleted and recreated the sprinkler device within Indigo and it resolved the problem...

norcoscia, This was it. Thanks for the tip!

Jay, All seems to be working now – thanks again for the great contribution.

Hi Jay - thanks for the plug in - seems to be working but every once in a while I get this in my log - any ideas - pict below shows device fields are being updated?

Code: Select all

Apr 30, 2017, 2:51:11 AM
   SQL Logger                      creating table device_history_1790308249 for "Rachio Sprinkler"
   SQL Logger Error                exception trying to create table device_history_1790308249 ("Rachio Sprinkler")
   SQL Logger Error                duplicate column name: id
   SQL Logger Error                CREATE TABLE device_history_1790308249 ( id #AUTO_INCR_KEY, ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP, "activeschedule" TEXT, "activezone" INTEGER, "activezone_ui" TEXT, "address" TEXT, "current_calculatedprecip" REAL, "current_cloudcover" REAL, "current_cloudcover_ui" TEXT, "current_currenttemperature" REAL, "current_currenttemperature_ui" TEXT, "current_dewpoint" REAL, "current_dewpoint_ui" TEXT, "current_humidity" REAL, "current_humidity_ui" TEXT, "current_iconurl" TEXT, "current_precipintensity" REAL, "current_precipprobability" REAL, "current_precipprobability_ui" TEXT, "current_weathersummary" TEXT, "current_weathertype" TEXT, "current_weathertype_clear_day" BOOL, "current_weathertype_clear_night" BOOL, "current_weathertype_cloudy" BOOL, "current_weathertype_fog" BOOL, "current_weathertype_partly_cloudy_day" BOOL, "current_weathertype_partly_cloudy_night" BOOL, "current_weathertype_rain" BOOL, "current_weathertype_sleet" BOOL, "current_weathertype_snow" BOOL, "current_weathertype_sun" BOOL, "current_weathertype_wind" BOOL, "current_windspeed" INTEGER, "elevation" REAL, "id" TEXT, "instandbymode" BOOL, "latitude" REAL, "longitude" REAL, "model" TEXT, "name" TEXT, "paused" BOOL, "schedulemodetype" TEXT, "serialnumber" TEXT, "status" TEXT, "t0forecast_calculatedprecip" REAL, "t0forecast_cloudcover" REAL, "t0forecast_cloudcover_ui" TEXT, "t0forecast_dewpoint" REAL, "t0forecast_dewpoint_ui" TEXT, "t0forecast_humidity" REAL, "t0forecast_humidity_ui" TEXT, "t0forecast_iconurl" TEXT, "t0forecast_precipintensity" REAL, "t0forecast_precipprobability" REAL, "t0forecast_precipprobability_ui" TEXT, "t0forecast_temperaturemax" REAL, "t0forecast_temperaturemax_ui" TEXT, "t0forecast_temperaturemin" REAL, "t0forecast_temperaturemin_ui" TEXT, "t0forecast_weathersummary" TEXT, "t0forecast_weathertype" TEXT, "t0forecast_weathertype_clear_day" BOOL, "t0forecast_weathertype_clear_night" BOOL, "t0forecast_weathertype_cloudy" BOOL, "t0forecast_weathertype_fog" BOOL, "t0forecast_weathertype_partly_cloudy_day" BOOL, "t0forecast_weathertype_partly_cloudy_night" BOOL, "t0forecast_weathertype_rain" BOOL, "t0forecast_weathertype_sleet" BOOL, "t0forecast_weathertype_snow" BOOL, "t0forecast_weathertype_sun" BOOL, "t0forecast_weathertype_wind" BOOL, "t0forecast_windspeed" REAL, "t10forecast_calculatedprecip" REAL, "t10forecast_cloudcover" REAL, "t10forecast_cloudcover_ui" TEXT, "t10forecast_dewpoint" REAL, "t10forecast_dewpoint_ui" TEXT, "t10forecast_humidity" REAL, "t10forecast_humidity_ui" TEXT, "t10forecast_iconurl" TEXT, "t10forecast_precipintensity" REAL, "t10forecast_precipprobability" REAL, "t10forecast_precipprobability_ui" TEXT, "t10forecast_temperaturemax" REAL, "t10forecast_temperaturemax_ui" TEXT, "t10forecast_temperaturemin" REAL, "t10forecast_temperaturemin_ui" TEXT, "t10forecast_weathersummary" TEXT, "t10forecast_weathertype" TEXT, "t10forecast_weathertype_clear_day" BOOL, "t10forecast_weathertype_clear_night" BOOL, "t10forecast_weathertype_cloudy" BOOL, "t10forecast_weathertype_fog" BOOL, "t10forecast_weathertype_partly_cloudy_day" BOOL, "t10forecast_weathertype_partly_cloudy_night" BOOL, "t10forecast_weathertype_rain" BOOL, "t10forecast_weathertype_sleet" BOOL, "t10forecast_weathertype_snow" BOOL, "t10forecast_weathertype_sun" BOOL, "t10forecast_weathertype_wind" BOOL, "t10forecast_windspeed" REAL, "t11forecast_calculatedprecip" REAL, "t11forecast_cloudcover" REAL, "t11forecast_cloudcover_ui" TEXT, "t11forecast_dewpoint" REAL, "t11forecast_dewpoint_ui" TEXT, "t11forecast_humidity" REAL, "t11forecast_humidity_ui" TEXT, "t11forecast_iconurl" TEXT, "t11forecast_precipintensity" REAL, "t11forecast_precipprobability" REAL, "t11forecast_precipprobability_ui" TEXT, "t11forecast_temperaturemax" REAL, "t11forecast_temperaturemax_ui" TEXT, "t11forecast_temperaturemin" REAL, "t11forecast_temperaturemin_ui" TEXT, "t11forecast_weathersummary" TEXT, "t11forecast_weathertype" TEXT, "t11forecast_weathertype_clear_day" BOOL, "t11forecast_weathertype_clear_night" BOOL, "t11forecast_weathertype_cloudy" BOOL, "t11forecast_weathertype_fog" BOOL, "t11forecast_weathertype_partly_cloudy_day" BOOL, "t11forecast_weathertype_partly_cloudy_night" BOOL, "t11forecast_weathertype_rain" BOOL, "t11forecast_weathertype_sleet" BOOL, "t11forecast_weathertype_snow" BOOL, "t11forecast_weathertype_sun" BOOL, "t11forecast_weathertype_wind" BOOL, "t11forecast_windspeed" REAL, "t12forecast_calculatedprecip" REAL, "t12forecast_cloudcover" REAL, "t12forecast_cloudcover_ui" TEXT, "t12forecast_dewpoint" REAL, "t12forecast_dewpoint_ui" TEXT, "t12forecast_humidity" REAL, "t12forecast_humidity_ui" TEXT, "t12forecast_iconurl" TEXT, "t12forecast_precipintensity" REAL, "t12forecast_precipprobability" REAL, "t12forecast_precipprobability_ui" TEXT, "t12forecast_temperaturemax" REAL, "t12forecast_temperaturemax_ui" TEXT, "t12forecast_temperaturemin" REAL, "t12forecast_temperaturemin_ui" TEXT, "t12forecast_weathersummary" TEXT, "t12forecast_weathertype" TEXT, "t12forecast_weathertype_clear_day" BOOL, "t12forecast_weathertype_clear_night" BOOL, "t12forecast_weathertype_cloudy" BOOL, "t12forecast_weathertype_fog" BOOL, "t12forecast_weathertype_partly_cloudy_day" BOOL, "t12forecast_weathertype_partly_cloudy_night" BOOL, "t12forecast_weathertype_rain" BOOL, "t12forecast_weathertype_sleet" BOOL, "t12forecast_weathertype_snow" BOOL, "t12forecast_weathertype_sun" BOOL, "t12forecast_weathertype_wind" BOOL, "t12forecast_windspeed" REAL, "t13forecast_calculatedprecip" REAL, "t13forecast_cloudcover" REAL, "t13forecast_cloudcover_ui" TEXT, "t13forecast_dewpoint" REAL, "t13forecast_dewpoint_ui" TEXT, "t13forecast_humidity" REAL, "t13forecast_humidity_ui" TEXT, "t13forecast_iconurl" TEXT, "t13forecast_precipintensity" REAL, "t13forecast_precipprobability" REAL, "t13forecast_precipprobability_ui" TEXT, "t13forecast_temperaturemax" REAL, "t13forecast_temperaturemax_ui" TEXT, "t13forecast_temperaturemin" REAL, "t13forecast_temperaturemin_ui" TEXT, "t13forecast_weathersummary" TEXT, "t13forecast_weathertype" TEXT, "t13forecast_weathertype_clear_day" BOOL, "t13forecast_weathertype_clear_night" BOOL, "t13forecast_weathertype_cloudy" BOOL, "t13forecast_weathertype_fog" BOOL, "t13forecast_weathertype_partly_cloudy_day" BOOL, "t13forecast_weathertype_partly_cloudy_night" BOOL, "t13forecast_weathertype_rain" BOOL, "t13forecast_weathertype_sleet" BOOL, "t13forecast_weathertype_snow" BOOL, "t13forecast_weathertype_sun" BOOL, "t13forecast_weathertype_wind" BOOL, "t13forecast_windspeed" REAL, "t1forecast_calculatedprecip" REAL, "t1forecast_cloudcover" REAL, "t1forecast_cloudcover_ui" TEXT, "t1forecast_dewpoint" REAL, "t1forecast_dewpoint_ui" TEXT, "t1forecast_humidity" REAL, "t1forecast_humidity_ui" TEXT, "t1forecast_iconurl" TEXT, "t1forecast_precipintensity" REAL, "t1forecast_precipprobability" REAL, "t1forecast_precipprobability_ui" TEXT, "t1forecast_temperaturemax" REAL, "t1forecast_temperaturemax_ui" TEXT, "t1forecast_temperaturemin" REAL, "t1forecast_temperaturemin_ui" TEXT, "t1forecast_weathersummary" TEXT, "t1forecast_weathertype" TEXT, "t1forecast_weathertype_clear_day" BOOL, "t1forecast_weathertype_clear_night" BOOL, "t1forecast_weathertype_cloudy" BOOL, "t1forecast_weathertype_fog" BOOL, "t1forecast_weathertype_partly_cloudy_day" BOOL, "t1forecast_weathertype_partly_cloudy_night" BOOL, "t1forecast_weathertype_rain" BOOL, "t1forecast_weathertype_sleet" BOOL, "t1forecast_weathertype_snow" BOOL, "t1forecast_weathertype_sun" BOOL, "t1forecast_weathertype_wind" BOOL, "t1forecast_windspeed" REAL, "t2forecast_calculatedprecip" REAL, "t2forecast_cloudcover" REAL, "t2forecast_cloudcover_ui" TEXT, "t2forecast_dewpoint" REAL, "t2forecast_dewpoint_ui" TEXT, "t2forecast_humidity" REAL, "t2forecast_humidity_ui" TEXT, "t2forecast_iconurl" TEXT, "t2forecast_precipintensity" REAL, "t2forecast_precipprobability" REAL, "t2forecast_precipprobability_ui" TEXT, "t2forecast_temperaturemax" REAL, "t2forecast_temperaturemax_ui" TEXT, "t2forecast_temperaturemin" REAL, "t2forecast_temperaturemin_ui" TEXT, "t2forecast_weathersummary" TEXT, "t2forecast_weathertype" TEXT, "t2forecast_weathertype_clear_day" BOOL, "t2forecast_weathertype_clear_night" BOOL, "t2forecast_weathertype_cloudy" BOOL, "t2forecast_weathertype_fog" BOOL, "t2forecast_weathertype_partly_cloudy_day" BOOL, "t2forecast_weathertype_partly_cloudy_night" BOOL, "t2forecast_weathertype_rain" BOOL, "t2forecast_weathertype_sleet" BOOL, "t2forecast_weathertype_snow" BOOL, "t2forecast_weathertype_sun" BOOL, "t2forecast_weathertype_wind" BOOL, "t2forecast_windspeed" REAL, "t3forecast_calculatedprecip" REAL, "t3forecast_cloudcover" REAL, "t3forecast_cloudcover_ui" TEXT, "t3forecast_dewpoint" REAL, "t3forecast_dewpoint_ui" TEXT, "t3forecast_humidity" REAL, "t3forecast_humidity_ui" TEXT, "t3forecast_iconurl" TEXT, "t3forecast_precipintensity" REAL, "t3forecast_precipprobability" REAL, "t3forecast_precipprobability_ui" TEXT, "t3forecast_temperaturemax" REAL, "t3forecast_temperaturemax_ui" TEXT, "t3forecast_temperaturemin" REAL, "t3forecast_temperaturemin_ui" TEXT, "t3forecast_weathersummary" TEXT, "t3forecast_weathertype" TEXT, "t3forecast_weathertype_clear_day" BOOL, "t3forecast_weathertype_clear_night" BOOL, "t3forecast_weathertype_cloudy" BOOL, "t3forecast_weathertype_fog" BOOL, "t3forecast_weathertype_partly_cloudy_day" BOOL, "t3forecast_weathertype_partly_cloudy_night" BOOL, "t3forecast_weathertype_rain" BOOL, "t3forecast_weathertype_sleet" BOOL, "t3forecast_weathertype_snow" BOOL, "t3forecast_weathertype_sun" BOOL, "t3forecast_weathertype_wind" BOOL, "t3forecast_windspeed" REAL, "t4forecast_calculatedprecip" REAL, "t4forecast_cloudcover" REAL, "t4forecast_cloudcover_ui" TEXT, "t4forecast_dewpoint" REAL, "t4forecast_dewpoint_ui" TEXT, "t4forecast_humidity" REAL, "t4forecast_humidity_ui" TEXT, "t4forecast_iconurl" TEXT, "t4forecast_precipintensity" REAL, "t4forecast_precipprobability" REAL, "t4forecast_precipprobability_ui" TEXT, "t4forecast_temperaturemax" REAL, "t4forecast_temperaturemax_ui" TEXT, "t4forecast_temperaturemin" REAL, "t4forecast_temperaturemin_ui" TEXT, "t4forecast_weathersummary" TEXT, "t4forecast_weathertype" TEXT, "t4forecast_weathertype_clear_day" BOOL, "t4forecast_weathertype_clear_night" BOOL, "t4forecast_weathertype_cloudy" BOOL, "t4forecast_weathertype_fog" BOOL, "t4forecast_weathertype_partly_cloudy_day" BOOL, "t4forecast_weathertype_partly_cloudy_night" BOOL, "t4forecast_weathertype_rain" BOOL, "t4forecast_weathertype_sleet" BOOL, "t4forecast_weathertype_snow" BOOL, "t4forecast_weathertype_sun" BOOL, "t4forecast_weathertype_wind" BOOL, "t4forecast_windspeed" REAL, "t5forecast_calculatedprecip" REAL, "t5forecast_cloudcover" REAL, "t5forecast_cloudcover_ui" TEXT, "t5forecast_dewpoint" REAL, "t5forecast_dewpoint_ui" TEXT, "t5forecast_humidity" REAL, "t5forecast_humidity_ui" TEXT, "t5forecast_iconurl" TEXT, "t5forecast_precipintensity" REAL, "t5forecast_precipprobability" REAL, "t5forecast_precipprobability_ui" TEXT, "t5forecast_temperaturemax" REAL, "t5forecast_temperaturemax_ui" TEXT, "t5forecast_temperaturemin" REAL, "t5forecast_temperaturemin_ui" TEXT, "t5forecast_weathersummary" TEXT, "t5forecast_weathertype" TEXT, "t5forecast_weathertype_clear_day" BOOL, "t5forecast_weathertype_clear_night" BOOL, "t5forecast_weathertype_cloudy" BOOL, "t5forecast_weathertype_fog" BOOL, "t5forecast_weathertype_partly_cloudy_day" BOOL, "t5forecast_weathertype_partly_cloudy_night" BOOL, "t5forecast_weathertype_rain" BOOL, "t5forecast_weathertype_sleet" BOOL, "t5forecast_weathertype_snow" BOOL, "t5forecast_weathertype_sun" BOOL, "t5forecast_weathertype_wind" BOOL, "t5forecast_windspeed" REAL, "t6forecast_calculatedprecip" REAL, "t6forecast_cloudcover" REAL, "t6forecast_cloudcover_ui" TEXT, "t6forecast_dewpoint" REAL, "t6forecast_dewpoint_ui" TEXT, "t6forecast_humidity" REAL, "t6forecast_humidity_ui" TEXT, "t6forecast_iconurl" TEXT, "t6forecast_precipintensity" REAL, "t6forecast_precipprobability" REAL, "t6forecast_precipprobability_ui" TEXT, "t6forecast_temperaturemax" REAL, "t6forecast_temperaturemax_ui" TEXT, "t6forecast_temperaturemin" REAL, "t6forecast_temperaturemin_ui" TEXT, "t6forecast_weathersummary" TEXT, "t6forecast_weathertype" TEXT, "t6forecast_weathertype_clear_day" BOOL, "t6forecast_weathertype_clear_night" BOOL, "t6forecast_weathertype_cloudy" BOOL, "t6forecast_weathertype_fog" BOOL, "t6forecast_weathertype_partly_cloudy_day" BOOL, "t6forecast_weathertype_partly_cloudy_night" BOOL, "t6forecast_weathertype_rain" BOOL, "t6forecast_weathertype_sleet" BOOL, "t6forecast_weathertype_snow" BOOL, "t6forecast_weathertype_sun" BOOL, "t6forecast_weathertype_wind" BOOL, "t6forecast_windspeed" REAL, "t7forecast_calculatedprecip" REAL, "t7forecast_cloudcover" REAL, "t7forecast_cloudcover_ui" TEXT, "t7forecast_dewpoint" REAL, "t7forecast_dewpoint_ui" TEXT, "t7forecast_humidity" REAL, "t7forecast_humidity_ui" TEXT, "t7forecast_iconurl" TEXT, "t7forecast_precipintensity" REAL, "t7forecast_precipprobability" REAL, "t7forecast_precipprobability_ui" TEXT, "t7forecast_temperaturemax" REAL, "t7forecast_temperaturemax_ui" TEXT, "t7forecast_temperaturemin" REAL, "t7forecast_temperaturemin_ui" TEXT, "t7forecast_weathersummary" TEXT, "t7forecast_weathertype" TEXT, "t7forecast_weathertype_clear_day" BOOL, "t7forecast_weathertype_clear_night" BOOL, "t7forecast_weathertype_cloudy" BOOL, "t7forecast_weathertype_fog" BOOL, "t7forecast_weathertype_partly_cloudy_day" BOOL, "t7forecast_weathertype_partly_cloudy_night" BOOL, "t7forecast_weathertype_rain" BOOL, "t7forecast_weathertype_sleet" BOOL, "t7forecast_weathertype_snow" BOOL, "t7forecast_weathertype_sun" BOOL, "t7forecast_weathertype_wind" BOOL, "t7forecast_windspeed" REAL, "t8forecast_calculatedprecip" REAL, "t8forecast_cloudcover" REAL, "t8forecast_cloudcover_ui" TEXT, "t8forecast_dewpoint" REAL, "t8forecast_dewpoint_ui" TEXT, "t8forecast_humidity" REAL, "t8forecast_humidity_ui" TEXT, "t8forecast_iconurl" TEXT, "t8forecast_precipintensity" REAL, "t8forecast_precipprobability" REAL, "t8forecast_precipprobability_ui" TEXT, "t8forecast_temperaturemax" REAL, "t8forecast_temperaturemax_ui" TEXT, "t8forecast_temperaturemin" REAL, "t8forecast_temperaturemin_ui" TEXT, "t8forecast_weathersummary" TEXT, "t8forecast_weathertype" TEXT, "t8forecast_weathertype_clear_day" BOOL, "t8forecast_weathertype_clear_night" BOOL, "t8forecast_weathertype_cloudy" BOOL, "t8forecast_weathertype_fog" BOOL, "t8forecast_weathertype_partly_cloudy_day" BOOL, "t8forecast_weathertype_partly_cloudy_night" BOOL, "t8forecast_weathertype_rain" BOOL, "t8forecast_weathertype_sleet" BOOL, "t8forecast_weathertype_snow" BOOL, "t8forecast_weathertype_sun" BOOL, "t8forecast_weathertype_wind" BOOL, "t8forecast_windspeed" REAL, "t9forecast_calculatedprecip" REAL, "t9forecast_cloudcover" REAL, "t9forecast_cloudcover_ui" TEXT, "t9forecast_dewpoint" REAL, "t9forecast_dewpoint_ui" TEXT, "t9forecast_humidity" REAL, "t9forecast_humidity_ui" TEXT, "t9forecast_iconurl" TEXT, "t9forecast_precipintensity" REAL, "t9forecast_precipprobability" REAL, "t9forecast_precipprobability_ui" TEXT, "t9forecast_temperaturemax" REAL, "t9forecast_temperaturemax_ui" TEXT, "t9forecast_temperaturemin" REAL, "t9forecast_temperaturemin_ui" TEXT, "t9forecast_weathersummary" TEXT, "t9forecast_weathertype" TEXT, "t9forecast_weathertype_clear_day" BOOL, "t9forecast_weathertype_clear_night" BOOL, "t9forecast_weathertype_cloudy" BOOL, "t9forecast_weathertype_fog" BOOL, "t9forecast_weathertype_partly_cloudy_day" BOOL, "t9forecast_weathertype_partly_cloudy_night" BOOL, "t9forecast_weathertype_rain" BOOL, "t9forecast_weathertype_sleet" BOOL, "t9forecast_weathertype_snow" BOOL, "t9forecast_weathertype_sun" BOOL, "t9forecast_weathertype_wind" BOOL, "t9forecast_windspeed" REAL, "timezone" TEXT, "utcoffset" INTEGER, "zone1" BOOL, "zone2" BOOL, "zone3" BOOL, "zone4" BOOL, "zone5" BOOL, "zone6" BOOL, "zone7" BOOL, "zone8" BOOL);
   SQL Logger Error                exception trying to insert row into table device_history_1790308249 ("Rachio Sprinkler") -- unable to modify table
   SQL Logger Error                no such table: device_history_1790308249
   SQL Logger Error                INSERT INTO device_history_1790308249 ("activeschedule", "activezone", "activezone_ui", "address", "current_calculatedprecip", "current_cloudcover", "current_cloudcover_ui", "current_currenttemperature", "current_currenttemperature_ui", "current_dewpoint", "current_dewpoint_ui", "current_humidity", "current_humidity_ui", "current_iconurl", "current_precipintensity", "current_precipprobability", "current_precipprobability_ui", "current_weathersummary", "current_weathertype", "current_weathertype_clear_day", "current_weathertype_clear_night", "current_weathertype_cloudy", "current_weathertype_fog", "current_weathertype_partly_cloudy_day", "current_weathertype_partly_cloudy_night", "current_weathertype_rain", "current_weathertype_sleet", "current_weathertype_snow", "current_weathertype_sun", "current_weathertype_wind", "current_windspeed", "elevation", "id", "instandbymode", "latitude", "longitude", "model", "name", "paused", "schedulemodetype", "serialnumber", "status", "t0forecast_calculatedprecip", "t0forecast_cloudcover", "t0forecast_cloudcover_ui", "t0forecast_dewpoint", "t0forecast_dewpoint_ui", "t0forecast_humidity", "t0forecast_humidity_ui", "t0forecast_iconurl", "t0forecast_precipintensity", "t0forecast_precipprobability", "t0forecast_precipprobability_ui", "t0forecast_temperaturemax", "t0forecast_temperaturemax_ui", "t0forecast_temperaturemin", "t0forecast_temperaturemin_ui", "t0forecast_weathersummary", "t0forecast_weathertype", "t0forecast_weathertype_clear_day", "t0forecast_weathertype_clear_night", "t0forecast_weathertype_cloudy", "t0forecast_weathertype_fog", "t0forecast_weathertype_partly_cloudy_day", "t0forecast_weathertype_partly_cloudy_night", "t0forecast_weathertype_rain", "t0forecast_weathertype_sleet", "t0forecast_weathertype_snow", "t0forecast_weathertype_sun", "t0forecast_weathertype_wind", "t0forecast_windspeed", "t10forecast_calculatedprecip", "t10forecast_cloudcover", "t10forecast_cloudcover_ui", "t10forecast_dewpoint", "t10forecast_dewpoint_ui", "t10forecast_humidity", "t10forecast_humidity_ui", "t10forecast_iconurl", "t10forecast_precipintensity", "t10forecast_precipprobability", "t10forecast_precipprobability_ui", "t10forecast_temperaturemax", "t10forecast_temperaturemax_ui", "t10forecast_temperaturemin", "t10forecast_temperaturemin_ui", "t10forecast_weathersummary", "t10forecast_weathertype", "t10forecast_weathertype_clear_day", "t10forecast_weathertype_clear_night", "t10forecast_weathertype_cloudy", "t10forecast_weathertype_fog", "t10forecast_weathertype_partly_cloudy_day", "t10forecast_weathertype_partly_cloudy_night", "t10forecast_weathertype_rain", "t10forecast_weathertype_sleet", "t10forecast_weathertype_snow", "t10forecast_weathertype_sun", "t10forecast_weathertype_wind", "t10forecast_windspeed", "t11forecast_calculatedprecip", "t11forecast_cloudcover", "t11forecast_cloudcover_ui", "t11forecast_dewpoint", "t11forecast_dewpoint_ui", "t11forecast_humidity", "t11forecast_humidity_ui", "t11forecast_iconurl", "t11forecast_precipintensity", "t11forecast_precipprobability", "t11forecast_precipprobability_ui", "t11forecast_temperaturemax", "t11forecast_temperaturemax_ui", "t11forecast_temperaturemin", "t11forecast_temperaturemin_ui", "t11forecast_weathersummary", "t11forecast_weathertype", "t11forecast_weathertype_clear_day", "t11forecast_weathertype_clear_night", "t11forecast_weathertype_cloudy", "t11forecast_weathertype_fog", "t11forecast_weathertype_partly_cloudy_day", "t11forecast_weathertype_partly_cloudy_night", "t11forecast_weathertype_rain", "t11forecast_weathertype_sleet", "t11forecast_weathertype_snow", "t11forecast_weathertype_sun", "t11forecast_weathertype_wind", "t11forecast_windspeed", "t12forecast_calculatedprecip", "t12forecast_cloudcover", "t12forecast_cloudcover_ui", "t12forecast_dewpoint", "t12forecast_dewpoint_ui", "t12forecast_humidity", "t12forecast_humidity_ui", "t12forecast_iconurl", "t12forecast_precipintensity", "t12forecast_precipprobability", "t12forecast_precipprobability_ui", "t12forecast_temperaturemax", "t12forecast_temperaturemax_ui", "t12forecast_temperaturemin", "t12forecast_temperaturemin_ui", "t12forecast_weathersummary", "t12forecast_weathertype", "t12forecast_weathertype_clear_day", "t12forecast_weathertype_clear_night", "t12forecast_weathertype_cloudy", "t12forecast_weathertype_fog", "t12forecast_weathertype_partly_cloudy_day", "t12forecast_weathertype_partly_cloudy_night", "t12forecast_weathertype_rain", "t12forecast_weathertype_sleet", "t12forecast_weathertype_snow", "t12forecast_weathertype_sun", "t12forecast_weathertype_wind", "t12forecast_windspeed", "t13forecast_calculatedprecip", "t13forecast_cloudcover", "t13forecast_cloudcover_ui", "t13forecast_dewpoint", "t13forecast_dewpoint_ui", "t13forecast_humidity", "t13forecast_humidity_ui", "t13forecast_iconurl", "t13forecast_precipintensity", "t13forecast_precipprobability", "t13forecast_precipprobability_ui", "t13forecast_temperaturemax", "t13forecast_temperaturemax_ui", "t13forecast_temperaturemin", "t13forecast_temperaturemin_ui", "t13forecast_weathersummary", "t13forecast_weathertype", "t13forecast_weathertype_clear_day", "t13forecast_weathertype_clear_night", "t13forecast_weathertype_cloudy", "t13forecast_weathertype_fog", "t13forecast_weathertype_partly_cloudy_day", "t13forecast_weathertype_partly_cloudy_night", "t13forecast_weathertype_rain", "t13forecast_weathertype_sleet", "t13forecast_weathertype_snow", "t13forecast_weathertype_sun", "t13forecast_weathertype_wind", "t13forecast_windspeed", "t1forecast_calculatedprecip", "t1forecast_cloudcover", "t1forecast_cloudcover_ui", "t1forecast_dewpoint", "t1forecast_dewpoint_ui", "t1forecast_humidity", "t1forecast_humidity_ui", "t1forecast_iconurl", "t1forecast_precipintensity", "t1forecast_precipprobability", "t1forecast_precipprobability_ui", "t1forecast_temperaturemax", "t1forecast_temperaturemax_ui", "t1forecast_temperaturemin", "t1forecast_temperaturemin_ui", "t1forecast_weathersummary", "t1forecast_weathertype", "t1forecast_weathertype_clear_day", "t1forecast_weathertype_clear_night", "t1forecast_weathertype_cloudy", "t1forecast_weathertype_fog", "t1forecast_weathertype_partly_cloudy_day", "t1forecast_weathertype_partly_cloudy_night", "t1forecast_weathertype_rain", "t1forecast_weathertype_sleet", "t1forecast_weathertype_snow", "t1forecast_weathertype_sun", "t1forecast_weathertype_wind", "t1forecast_windspeed", "t2forecast_calculatedprecip", "t2forecast_cloudcover", "t2forecast_cloudcover_ui", "t2forecast_dewpoint", "t2forecast_dewpoint_ui", "t2forecast_humidity", "t2forecast_humidity_ui", "t2forecast_iconurl", "t2forecast_precipintensity", "t2forecast_precipprobability", "t2forecast_precipprobability_ui", "t2forecast_temperaturemax", "t2forecast_temperaturemax_ui", "t2forecast_temperaturemin", "t2forecast_temperaturemin_ui", "t2forecast_weathersummary", "t2forecast_weathertype", "t2forecast_weathertype_clear_day", "t2forecast_weathertype_clear_night", "t2forecast_weathertype_cloudy", "t2forecast_weathertype_fog", "t2forecast_weathertype_partly_cloudy_day", "t2forecast_weathertype_partly_cloudy_night", "t2forecast_weathertype_rain", "t2forecast_weathertype_sleet", "t2forecast_weathertype_snow", "t2forecast_weathertype_sun", "t2forecast_weathertype_wind", "t2forecast_windspeed", "t3forecast_calculatedprecip", "t3forecast_cloudcover", "t3forecast_cloudcover_ui", "t3forecast_dewpoint", "t3forecast_dewpoint_ui", "t3forecast_humidity", "t3forecast_humidity_ui", "t3forecast_iconurl", "t3forecast_precipintensity", "t3forecast_precipprobability", "t3forecast_precipprobability_ui", "t3forecast_temperaturemax", "t3forecast_temperaturemax_ui", "t3forecast_temperaturemin", "t3forecast_temperaturemin_ui", "t3forecast_weathersummary", "t3forecast_weathertype", "t3forecast_weathertype_clear_day", "t3forecast_weathertype_clear_night", "t3forecast_weathertype_cloudy", "t3forecast_weathertype_fog", "t3forecast_weathertype_partly_cloudy_day", "t3forecast_weathertype_partly_cloudy_night", "t3forecast_weathertype_rain", "t3forecast_weathertype_sleet", "t3forecast_weathertype_snow", "t3forecast_weathertype_sun", "t3forecast_weathertype_wind", "t3forecast_windspeed", "t4forecast_calculatedprecip", "t4forecast_cloudcover", "t4forecast_cloudcover_ui", "t4forecast_dewpoint", "t4forecast_dewpoint_ui", "t4forecast_humidity", "t4forecast_humidity_ui", "t4forecast_iconurl", "t4forecast_precipintensity", "t4forecast_precipprobability", "t4forecast_precipprobability_ui", "t4forecast_temperaturemax", "t4forecast_temperaturemax_ui", "t4forecast_temperaturemin", "t4forecast_temperaturemin_ui", "t4forecast_weathersummary", "t4forecast_weathertype", "t4forecast_weathertype_clear_day", "t4forecast_weathertype_clear_night", "t4forecast_weathertype_cloudy", "t4forecast_weathertype_fog", "t4forecast_weathertype_partly_cloudy_day", "t4forecast_weathertype_partly_cloudy_night", "t4forecast_weathertype_rain", "t4forecast_weathertype_sleet", "t4forecast_weathertype_snow", "t4forecast_weathertype_sun", "t4forecast_weathertype_wind", "t4forecast_windspeed", "t5forecast_calculatedprecip", "t5forecast_cloudcover", "t5forecast_cloudcover_ui", "t5forecast_dewpoint", "t5forecast_dewpoint_ui", "t5forecast_humidity", "t5forecast_humidity_ui", "t5forecast_iconurl", "t5forecast_precipintensity", "t5forecast_precipprobability", "t5forecast_precipprobability_ui", "t5forecast_temperaturemax", "t5forecast_temperaturemax_ui", "t5forecast_temperaturemin", "t5forecast_temperaturemin_ui", "t5forecast_weathersummary", "t5forecast_weathertype", "t5forecast_weathertype_clear_day", "t5forecast_weathertype_clear_night", "t5forecast_weathertype_cloudy", "t5forecast_weathertype_fog", "t5forecast_weathertype_partly_cloudy_day", "t5forecast_weathertype_partly_cloudy_night", "t5forecast_weathertype_rain", "t5forecast_weathertype_sleet", "t5forecast_weathertype_snow", "t5forecast_weathertype_sun", "t5forecast_weathertype_wind", "t5forecast_windspeed", "t6forecast_calculatedprecip", "t6forecast_cloudcover", "t6forecast_cloudcover_ui", "t6forecast_dewpoint", "t6forecast_dewpoint_ui", "t6forecast_humidity", "t6forecast_humidity_ui", "t6forecast_iconurl", "t6forecast_precipintensity", "t6forecast_precipprobability", "t6forecast_precipprobability_ui", "t6forecast_temperaturemax", "t6forecast_temperaturemax_ui", "t6forecast_temperaturemin", "t6forecast_temperaturemin_ui", "t6forecast_weathersummary", "t6forecast_weathertype", "t6forecast_weathertype_clear_day", "t6forecast_weathertype_clear_night", "t6forecast_weathertype_cloudy", "t6forecast_weathertype_fog", "t6forecast_weathertype_partly_cloudy_day", "t6forecast_weathertype_partly_cloudy_night", "t6forecast_weathertype_rain", "t6forecast_weathertype_sleet", "t6forecast_weathertype_snow", "t6forecast_weathertype_sun", "t6forecast_weathertype_wind", "t6forecast_windspeed", "t7forecast_calculatedprecip", "t7forecast_cloudcover", "t7forecast_cloudcover_ui", "t7forecast_dewpoint", "t7forecast_dewpoint_ui", "t7forecast_humidity", "t7forecast_humidity_ui", "t7forecast_iconurl", "t7forecast_precipintensity", "t7forecast_precipprobability", "t7forecast_precipprobability_ui", "t7forecast_temperaturemax", "t7forecast_temperaturemax_ui", "t7forecast_temperaturemin", "t7forecast_temperaturemin_ui", "t7forecast_weathersummary", "t7forecast_weathertype", "t7forecast_weathertype_clear_day", "t7forecast_weathertype_clear_night", "t7forecast_weathertype_cloudy", "t7forecast_weathertype_fog", "t7forecast_weathertype_partly_cloudy_day", "t7forecast_weathertype_partly_cloudy_night", "t7forecast_weathertype_rain", "t7forecast_weathertype_sleet", "t7forecast_weathertype_snow", "t7forecast_weathertype_sun", "t7forecast_weathertype_wind", "t7forecast_windspeed", "t8forecast_calculatedprecip", "t8forecast_cloudcover", "t8forecast_cloudcover_ui", "t8forecast_dewpoint", "t8forecast_dewpoint_ui", "t8forecast_humidity", "t8forecast_humidity_ui", "t8forecast_iconurl", "t8forecast_precipintensity", "t8forecast_precipprobability", "t8forecast_precipprobability_ui", "t8forecast_temperaturemax", "t8forecast_temperaturemax_ui", "t8forecast_temperaturemin", "t8forecast_temperaturemin_ui", "t8forecast_weathersummary", "t8forecast_weathertype", "t8forecast_weathertype_clear_day", "t8forecast_weathertype_clear_night", "t8forecast_weathertype_cloudy", "t8forecast_weathertype_fog", "t8forecast_weathertype_partly_cloudy_day", "t8forecast_weathertype_partly_cloudy_night", "t8forecast_weathertype_rain", "t8forecast_weathertype_sleet", "t8forecast_weathertype_snow", "t8forecast_weathertype_sun", "t8forecast_weathertype_wind", "t8forecast_windspeed", "t9forecast_calculatedprecip", "t9forecast_cloudcover", "t9forecast_cloudcover_ui", "t9forecast_dewpoint", "t9forecast_dewpoint_ui", "t9forecast_humidity", "t9forecast_humidity_ui", "t9forecast_iconurl", "t9forecast_precipintensity", "t9forecast_precipprobability", "t9forecast_precipprobability_ui", "t9forecast_temperaturemax", "t9forecast_temperaturemax_ui", "t9forecast_temperaturemin", "t9forecast_temperaturemin_ui", "t9forecast_weathersummary", "t9forecast_weathertype", "t9forecast_weathertype_clear_day", "t9forecast_weathertype_clear_night", "t9forecast_weathertype_cloudy", "t9forecast_weathertype_fog", "t9forecast_weathertype_partly_cloudy_day", "t9forecast_weathertype_partly_cloudy_night", "t9forecast_weathertype_rain", "t9forecast_weathertype_sleet", "t9forecast_weathertype_snow", "t9forecast_weathertype_sun", "t9forecast_weathertype_wind", "t9forecast_windspeed", "timezone", "utcoffset", "zone1", "zone2", "zone3", "zone4", "zone5", "zone6", "zone7", "zone8") VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s);


Jay,

Thank you for the plugin! Small request, if possible. Could issuing a Rain Delay be possible via the plugin?

Currently, I have a script to issue a manual Rain Delay, when the weather conditions requires it (e.g, is actually raining, or rain is in the forecast for today and tomorrow). This is needed, as in South Florida, the weather changes from min-to-min and I have a Davis weather station that more realistically let's me determine what's going on than the Rachio built-in rain delay calculation.

Doing everything with the plugin will make things neater

JP

norcoscia wrote:

Hi Jay - thanks for the plug in - seems to be working but every once in a while I get this in my log - any ideas - pict below shows device fields are being updated?

Code: Select all

Apr 30, 2017, 2:51:11 AM
   SQL Logger                      creating table device_history_1790308249 for "Rachio Sprinkler"
   SQL Logger Error                exception trying to create table device_history_1790308249 ("Rachio Sprinkler")


That's an error with the SQL Logger plugin - it can't create the table for the new sprinkler device (maybe a permission issue?). Try restarting that plugin to see if the problem resolves itself.

roquej wrote:

Could issuing a Rain Delay be possible via the plugin?

That is possible (the API supports it). I don't have time to work on it now, but I'd be more than happy to accept a pull request on Github if someone else wants to add it. You can also add it as an enhancement request on Github and the next time someone is in there they may pick up that change as well.

jay (support) wrote:

norcoscia wrote:

Hi Jay - thanks for the plug in - seems to be working but every once in a while I get this in my log - any ideas - pict below shows device fields are being updated?

Code: Select all

Apr 30, 2017, 2:51:11 AM
   SQL Logger                      creating table device_history_1790308249 for "Rachio Sprinkler"
   SQL Logger Error                exception trying to create table device_history_1790308249 ("Rachio Sprinkler")


That's an error with the SQL Logger plugin - it can't create the table for the new sprinkler device (maybe a permission issue?). Try restarting that plugin to see if the problem resolves itself.

The actual problem is that the Rachio plugin has a device field named "id":

Code: Select all

            <Field type="menu" id="id">
                <Label>Device:</Label>
                <List class="self" method="availableControllers"/>
            </Field>


Which causes the SQL logger plugin to barf because it's not protecting the column names. This previously came up in this thread:

viewtopic.php?f=216&t=17347&hilit=sql#p128763

The quick fix is to rename the field in the Rachio plugin. The long term fix is to change the SQL Logger plugin so that it guards all SQL column names based on device fields.