MQTT

[G4KCM]

Hi,

Firstly thank you for the great work with TerrariumPi, I have for many years been using Node-Red on my home server remotely controlling my wifes Crested Gecko terrarium and was about to embark on a project to migrate it to one local controller and then I find TerrariumPi which is just perfect. So most sincerely thank you for a great project.

I have set it all up on test and will shortly install the system. I do though have a question regarding MQTT. I have a central MQTT server which I use as common hub for all the different devices around the house and would like to broadcast the sensor values and relay states from TerrariumP but I am uncertain what I have to do in order to broacast the values every thirty seconds. I looked at an earlier thread discussing MQTT but it didn't really help.

So, can you please tell me what I have to set in order to broadcast sensor and relay values once every thirty seconds?

Many Thanks - Clive

[martynwheeler]

Hey Clive, I do something similar. I have a python script running on the terrarium pi every minute that grabs data from the API https://theyosh.github.io/TerrariumPI/api/ The script then pushes the data using mqtt to a central server. I can share my script if that helps Martyn

…

On Wed, 11 May 2022, 15:04 G4KCM, ***@***.***> wrote: Hi, Firstly thank you for the great work with TerrariumPi, I have for many years been using Node-Red on my home server remotely controlling my wifes Crested Gecko terrarium and was about to embark on a project to migrate it to one local controller and then I find TerrariumPi which is just perfect. So most sincerely thank you for a great project. I have set it all up on test and will shortly install the system. I do though have a question regarding MQTT. I have a central MQTT server which I use as common hub for all the different devices around the house and would like to broadcast the sensor values and relay states from TerrariumP but I am uncertain what I have to do in order to broacast the values every thirty seconds. I looked at an earlier thread discussing MQTT but it didn't really help. So, can you please tell me what I have to set in order to broadcast sensor and relay values once every thirty seconds? Many Thanks - Clive — Reply to this email directly, view it on GitHub <#702>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABGVUFJOHVF6VRVWPL3VE7TVJO5AVANCNFSM5VVB464A> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[theyosh]

The idea is that you setup this in the notification area. There you can specify which services you want to use (MQTT) and what info you want to be sent to it. You can send a message every 30 seconds when a sensor is updated for example.

[G4KCM]

Hi theyosh thanks for the response I tried a 30 sec sensor update message containing- gecko/sensor/${name} ${value} which I thought might send all the sensors but nothing happened. Can you give me an example of what I should put there?

[martynwheeler]

That sounds even easier

…

On Wed, 11 May 2022, 17:36 TheYOSH, ***@***.***> wrote: The idea is that you setup this in the notification area. There you can specify which services you want to use (MQTT) and what info you want to be sent to it. You can send a message every 30 seconds when a sensor is updated for example. — Reply to this email directly, view it on GitHub <#702 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABGVUFNLWRFIHRJH4ANA47LVJPOZLANCNFSM5VVB464A> . You are receiving this because you commented.Message ID: ***@***.***>

[martynwheeler]

It is not clear how to set it up though. All my mqtt messages are of the form home/area/sensor = {data: value}. How is this done in terrarium pi?

…

On Wed, May 11 2022 at 09:36:37 -0700, TheYOSH ***@***.***> wrote: The idea is that you setup this in the notification area. There you can specify which services you want to use (MQTT) and what info you want to be sent to it. You can send a message every 30 seconds when a sensor is updated for example. — Reply to this email directly, view it on GitHub <#702 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABGVUFNLWRFIHRJH4ANA47LVJPOZLANCNFSM5VVB464A>. You are receiving this because you commented.Message ID: ***@***.***>

[martynwheeler]

Here is my python script which runs as a cron job every minute. It is probably overkill and the notifications built in are probably better.

#!/usr/bin/python3

# see https://github.com/alinleonard/LCD-I2C-Raspberry-Pi-2/blob/master/LCDI2C_backpack.py

# Import Libraries
import requests
import time
import paho.mqtt.client as mqtt
import json

def publishData(data):
    client = mqtt.Client()
    client.connect("192.168.86.22", 1883, 60)
    client.publish("home/front_room/ds18b20/heater", json.dumps(data));
    client.disconnect();


def main():
    r = requests.get('http://localhost:8090/api/sensors/')
    sensors = r.json()['data']
    data = {}
    for sensor in sensors:
        if sensor['name'] == 'Main Temperature':
            data['temperature'] = round(sensor['value'], 1)
        if sensor['name'] == 'Cool Area':
            pass
        if sensor['name'] == 'Humidity':
            pass
    r = requests.get('http://localhost:8090/api/relays/')
    switches = r.json()['data']
    for switch in switches:
        if switch['name'] == 'MPDMv4.1.3':
            data['heater'] = switch['value']
    publishData(data)

if __name__ == '__main__':
    main()

[G4KCM]

Thanks Martyn that's great. I had tried a notification 30 sec update message with "gecko/sensor/${name} ${value}" in it which I thought might send the values but nothing emerged. I had thoughts along using the api and telegraf or awk but your script looks lke an easier option if I can't get the message to work. Have asked theyosh if he could give me an example.

Cheers - Clive

[martynwheeler]

I think you may have to restart the terrarium pi service to connect to the MQTT broker. Mine is now sending out messages. It seems that the topic is fixed in the code in the form:
terrariumpi/sensor/update/848873668075f854bc07853fb386b4de
and the subject and message are added as fields to the MQTT data. Would be nice to be able to customise the topic but it looks good. Just need to grab the packet in node-red now.

[theyosh]

terrariumpi/sensor/update/848873668075f854bc07853fb386b4de

The last part is the ID of the sensor if you not already guessed..

[theyosh]

I guess connecting to a MQTT server should not be a problem. Then I used the sensor update message:

This will produce:

The message will contain all the available data. And the custom message is available in the variable: message.

The topics are fixed, as it will become to complex for the UI. And it does not work well with other notification services.

[sni89]

Could you add a screenshot of your node-red interface maybe? Like how things are connected? I set up a simple testsetup with a Mqtt in and a debug that won’t give me a plain text from my TP. But it does show up all messages other devices send to the broker.

[G4KCM]

[sni89]

Sorry I meant the node-red interface like

this is where I get everything to work but no messages incoming from TP. Even I did everything as described above.

[G4KCM]

Hope this helps, but if you cut and paste the flow I sent yesterday as an import into a blank node red page you will see how I extract the values.

[sni89]

Thanks a lot. i had to replace a thousand " with ', add a # in the topic and it finally works...
:)

[martynwheeler]

I also found that I need to restart after setting up the MQTT notification in order for it to connect.

…

On Wed, 11 May 2022, 22:13 TheYOSH, ***@***.***> wrote: terrariumpi/sensor/update/848873668075f854bc07853fb386b4de The last part is the ID of the sensor if you not already guessed.. — Reply to this email directly, view it on GitHub <#702 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABGVUFO7I443IYNPB2OTUH3VJQPH3ANCNFSM5VVB464A> . You are receiving this because you commented.Message ID: ***@***.***>

[G4KCM]

Thanks, all up and running appreciate the help from you both!