Hello, I am a beginner in node red and would like to save the data from the dht22 sensor in mysql and display via chart. I have already tried a lot but unfortunately without success.
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!
@Eme
Thank you for coming back to report how you solved your problem! Your comments will help other people.
I am a big fan of Frugal Tech and I think MySensors is great for that.
Alas, MySensors is not well supported anymore. Right now I'm having problems linking to the home page It's people like you and me that will keep MySensors going.
Thanks for your help.
OSD
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 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!