Sure, I did a write-up for you, with the json on my blog: http://iotplay.blogspot.com/2016/07/switching-geyser-onoff-with-rules-on.html JR01, Just got a chance to read and study your blog - it was just what I needed to understand the flow - thank you for sharing. I am in the process of using espeas...

.@crsherman, yeah, would not mind sharing my .jsons. My RPi is down currently, busy with refurbishment of the breadboards for ESP8266 to sensors - building into vera board solutions to take out instability, need to fire RPi up again next 3 days, then I will upgrade to the latest cool version 0.14.3...

Controlling geyser with MQTT ? = yes. In an 'MQTT out' node, make the topic the below, and pass 1 into it via a flow: /ESP03/GPIO/2 Means the following: Send to ESP03, to the GPIO, for pin 2, and switch it on. Remember to make your MQTT subscribe template on the ESP: /%sysname%/# And the name of th...

crsherman, I see you say you are also interested in the UI tool I used on NodeRed, not much to it, check out this node: http://flows.nodered.org/node/node-red-contrib-ui . Once loaded & wired-up, you fire it up on mobile browser on your home wireless with: http://localhost:1880/ui On my blog I ...

In the mean time, some help to get the MySQL going: below is what I have in a function node, receiving for instance humidity from MQTT, and prior to a MySQL node. ValA = msg.payload ; msg.topic = "INSERT INTO `SysTaskVal2day` (`idSystem`, `idTask`, `tmstamp`, `val`) VALUES (1,1,now(),"+Va...

.@crsherman, yeah, would not mind sharing my .jsons. My RPi is down currently, busy with refurbishment of the breadboards for ESP8266 to sensors - building into vera board solutions to take out instability, need to fire RPi up again next 3 days, then I will upgrade to the latest cool version 0.14.3...

Here is a visual of the Node-Red nodes and flow to construct the UI. I also have more pages on it, to report the costs of warm water, then I ping the ESP's every 5min to check if they are alive, then write this into the MySQL if not alive, so when I do analytics, I know when not to trust the data. ...