OpenHAB/MQTT Tips & Hints

[kolaf]

@Yveaux Excellent, this is just what I needed, thank you.

I started looking at your Perl script since this seems like the most active solution for openhab integration. I have a couple questions if you don't mind.

Why do you have two versions of the gateway script, and which version should I use as a basis when adding serial support?

Does your gateway take care of node ID assignments? I guess I will figure out that by reading more of code :-)

I'm thinking that I will fork your project to add a serial option to your script, controlled by some kind of commandline argument.

[Yveaux]

@kolaf said:

@Yveaux Excellent, this is just what I needed, thank you.

Glad I could help!

Why do you have two versions of the gateway script, and which version should I use as a basis when adding serial support?

The serial format changed from MySensors 1.3 (protocol 1) to 1.4beta (protocol 2). I was lazy and just cloned the 1.3 version to add 1.4 support (the 2-version). Wouldn't be hard to support both, but I really wrote this script for my own usage. It's not documented and I tried to help Damme in the past to build MQTT support. I'm primarily on 1.4b btw, with some 1.3 setup for backwards sniffer support...
If more people start using it I should do some things the nice way ;-)

Does your gateway take care of node ID assignments? I guess I will figure out that by reading more of code :-)

Not at the moment. Shouldn't be hard to implement though, but when you implement it you run into another issue of mapping the node-ID's onto the MQTT topic tree, or accessing the right topic from OpenHAB.
Sticking to fixed Node ID's seemed to make more sense to me.

I'm thinking that I will fork your project to add a serial option to your script, controlled by some kind of commandline argument.

Feel free to fork, but the current code is based on AnyEvent. Not that I like it, but it seemed to have the best MQTT support. There is some hacking in the script to get things working, for which I don't know how they behave when switching to serial.

[Yveaux]

Btw. there's one important thing to understand when using the Perl script. When it receives values from a sensor node through the gateway it's easy to publish the value in the topic-tree.
When a value has to be sent to an actuator node, the story is different as the script has to know which topic to subscribe to at the MQTT broker.
Currently when a mysensor node requests a value from the gateway the script automagically translates this into a subscription of the corresponding topic with the MQTT broker. The dimmer node for example, calls gw.request(childID, V_DIMMER) from setup to subscribe itself to dimmer messages.
Note that sometimes this request gets lost (CRC error or so) and the subscription fails. While not supported by the MySensors library, a robust implementation should wait for a response after requesting this value and retry when it doesn't come.
The Perl script stores all current subscriptions persistent (file subscriptions.storage) so restarting the Perl script will not force you to restart all nodes to subscribe again.

[Yveaux]

And another small one; an RGB dimmer!

MQTT topics (exposed by the MQTT perl script. Node 118 = 3-channel dimmable light):

/mySensors/118/0/V_DIMMER          dimmable light RED, accepting integer value between 0 and 100
/mySensors/118/1/V_DIMMER          dimmable light GREEN, accepting integer value between 0 and 100
/mySensors/118/2/V_DIMMER          dimmable light BLUE, accepting integer value between 0 and 100

Items:

Dimmer Light_R      {mqtt=">[server:/mySensors/118/0/V_DIMMER:state:*:default]"}
Dimmer Light_G      {mqtt=">[server:/mySensors/118/1/V_DIMMER:state:*:default]"}
Dimmer Light_B      {mqtt=">[server:/mySensors/118/2/V_DIMMER:state:*:default]"}
Color Light_RGB 	"RGB Dimmer" 	(Lights)

Rules to distribute colorwheel value over R,G,B dimmers:

rule "Set RGB value"
when
        Item Light_RGB changed
then
        var HSBType hsbValue = Light_RGB.state as HSBType
        postUpdate( Light_R, hsbValue.red.intValue )
        postUpdate( Light_G, hsbValue.green.intValue )
        postUpdate( Light_B, hsbValue.blue.intValue )
end

No button control here; just using the colorwheel and on/off buttons in the GUI.

Enjoy!

[Damme]

rule to calculate absolute humidity and dew point from degree Celsius and rH%

import java.lang.Math
import java.lang.Integer
import java.lang.Double


rule "Calculate absolute humidity (g h2o / m3 air) and dew point"
when
    Item temp1 changed or
    Item hum1 changed
then
    var temp = temp1.state as DecimalType
    var hum = hum1.state as DecimalType
	
    var t1 = (17.271*temp.floatValue) / (237.7+temp.floatValue) + Math::log(hum.floatValue*0.01)
    var dew = (237.7 * t1) / (17.271 - t1)
    var Number c1 = ((17.67*temp.floatValue)/(temp.floatValue+243.5))
    var abs = (Math::pow(Math::E,c1.doubleValue)*6.112*2.1674*hum.floatValue) /(273.15+temp.floatValue)
	
    Dewpoint1.postUpdate(dew)
    AbsHum1.postUpdate(abs)
end

[Yveaux]

@Damme Nice calculation example! Thanks!

[Dany]

Hi everyone!

I'm new in the topic. I find it very interesting the world of mysensors.
I would like to ask whether there is a description of someone that I can set my mqtt openHAB bindings eg .: an Arduino LED dimmer ?

I already read http://forum.mysensors.org/topic/303/mqtt broker-gateway
I made a Humidity sensor node, and Relay node, too.

It would be good if we had a basic description or example project for beginners from all sensor type. :)

[pgo]

It is not rocket science to get the openHAB running w/MQTT gateway, see for example my post with DS/Light/Relay in http://forum.mysensors.org/topic/115/implementing-multiple-sensors/60

But sure, it would be great to put a wiki with all sensor settings for openHAB together on one page. I needed to read/search for some days to put the knowledge together...

Example of the openhab screenshots on mobile https://github.com/pgo-sk/mysensors/wiki/Home-automation-using-mysensors-and-openHAB
There you see also the mapping of the sensor

[adi32k]

How can I make openhad respod to gw.request(sensor, V_HEATER_SW,0);

I have a relay actuator sketch and in setup() I have this

for (int sensor=1 ; sensor<=NUMBER_OF_RELAYS;sensor++)
{
gw.present(sensor, S_HEATER);
gw.request(sensor, V_HEATER_SW,0);
}

practically I would like openhab to respond to the gw.request with the actual state of the relay.

My item definition is the follwing. I am able to ON and OFF the relay, but I need to find a way to get the values from openhab of the relays when the relay actuator arduino reboots.

Switch Incalzire_Releu_GF_Living2 "Incalzire Releu Living 2" <heating> (Incalzire) {mqtt=">[mysensor:MyMQTT/3/2/V_HEATER_SW:command:ON:1],>[mysensor:MyMQTT/3/2/V_HEATER_SW:command:OFF:0]"}

[raditv]

is there any sample code for controlling RGB led here?

[Chaotic]

Sorry to Necro this thread but had a question,

I believe I read somewhere that you can use a serial gateway connected to a pi and have openhab/mqtt run on the pi?

How would one go about setting this up? Currently I have 2 Unos one running as the serial gateway. I plan to replace the serial gateway with a nano I'm still waiting on that.

I just got the pi last night so I'm still working on getting everything up and running on that but I'd rather just connect the gateway directly to the pi rather than have to get a wifi/ethernet module for one of the arduinos.

Also probably outside the scope of this thread (and thats fine) but anyone have a good guide for setting up the pi for openhab/MQTT?

[mhortman]

@Chaotic , Try this..
https://github.com/abouillot/HomeAutomation/tree/master/piGateway
Worked great for me

[Sweebee]

@mhortman Didn't work for me:

sudo wget http://repo.mosquitto.org/debian/mosquitto-wheezy.list~
--2015-03-27 10:46:51--  http://repo.mosquitto.org/debian/mosquitto-wheezy.list~
Resolving repo.mosquitto.org (repo.mosquitto.org)... 85.119.83.194, 2001:ba8:1f1:f271::2
Connecting to repo.mosquitto.org (repo.mosquitto.org)|85.119.83.194|:80... connected.
HTTP request sent, awaiting response... 403 Forbidden
2015-03-27 10:46:51 ERROR 403: Forbidden.'

[quocanhcgd]

My house have 4 floor, i have plan build one gateway for each floor. Each floor has 4-5 sensors (temp, hum, relay, light, door, RF light). Each sensors use NRF24 to connect with gateway. Gateway connect to RAS by ethernet.
My question:

• Can i build 2 gateway mqtt connect to openhab?
  if not, what my solution to solve ?
  Thanks

[rachmat aditiya27]

you can build more than 1 gateway for that, but rather than mqtt. I think it's better to use ethernet or serial gateway because mqtt gateway has lot of problem, I tried it for months. You can forward mqtt from fhem to mosquito.

[siod]

@Yveaux
could you please post your arduino code of controlling your RGB (I guess it´s a RGB LED Strip!?)?

Thanks for your help!!

[siod]

I build up a mqtt gateway and configured it in openhab.cfg. Now I would like to set up a mosquitto server on a raspberry pi, too. Is it possible to add this new MQTT server to the openhab.cfg beside the already set up MQTT gateway?

[tomkxy]

Why not setup the Mosquitto broker connect OpenHab to it and use the MQTTClientGateway which connects as a client to the Mosquitto broker. Has been discussed at several places in the forum already. You can find the MQTTClientGateway in the development branch.

[John Connolly]

This post is deleted!

[siod]

@tomkxy
I´m reading in the forums for weeks now, but I don´t get it to work. I´ve succesfully set up Mosquitto on my raspi, also openHAB is running there. MQTTEthernetGateway (from Startpage) is pingable. One sensor is running and working.

I don´t know how to get the MQTTEthernetGateway communicate with the Mosquitto Broker. I´ve read about "bridging" what made me more confused as I already was.

So, right now, when I subscribe to MyMQTT/# using "mosquitto_sub -t MyMQTT/#" on my Raspi I don´t see any communication coming in.

What do I have to do to get the MQTTEthernetGateway (=MQTTClientGateway I suppose!?!) connecting to Mosquitto?

Or: must I setup the MQTTEthernetGateway like this: http://forum.mysensors.org/topic/524/mqtt-client-gateway instead of using the sketch from http://www.mysensors.org/build/mqtt_gateway?

Thanks for your help!!