We want to call the POSK function payload into function payload and insert it into SQL.
the yellow Highlighted number needs to combine with the second payload msg into the POSK column.
Update and problem fixed!
For everybody that will encouter this, the problem was at the sensor side because of the folder of the sensor! We created some metal brackets for it and they where exactly the same diameter. The fact that the mount squeezed the sensor made it return the lowest value.
Just needed to adjust the hole and everything was ok!
I want to thank @FcNanoLed. I had long thought about a serial gateway. This would be a way to add I/O to a linux computer. In the process of trying to help, I built up a linux machine running virtual box. In the virtual machine I ran Home Assistant The not well documented part of that was to connect the USB port of the computer to the virtual machine (settings-->USB-->USB Device Filters) (note that one can buy a refurbished PC for about the same price as an equivalently configured RPi)
So thanks for the inspiration!
You write "...clicking is heard..." Is that a single click or a click click click ...?
After getting the LOW signal, wait a period of time and if it's still low, send the message that there is a flame. Likewise for a HIGH signal.
Perhaps instead of a relay, an opto-isolator?
I'm having the same / a simular issue of temperature related readings, but at a different temperature level (for me it must be > 14 degree). I massure the dew point as well (temperature = orange, dew point = yellow). It looks to be more related to water in the air than only to temperature.
@zboblamont have you been finally been able to find a solution?
https://github.com/mysensors/MySensors/pull/1562 switches to using libgpiod instead of the earlier interface. I have not tested it myself but it looks good.