One of the most difficult problems I’ve attempted to resolve in the last few years, is how to capture and record (into mysql database) data received from 433mhz sensors..<\/p>\n\n\n\n
rtl_433 -M utc -F json -G<\/p>\n\n\n\n
{“time” : “2019-09-25 19:11:54”, “model” : “Acurite tower sensor”, “id” : 2766, “sensor_id” : 2766, “channel” : “A”, “temperature_C” : 22.700, “humidity” : 44, “battery_low” : 0}<\/p>\n\n\n\n
{“time” : “2019-09-25 19:12:01”, “model” : “Acurite Lightning 6045M”, “id” : 253, “channel” : “A”, “temperature_F” : 72.100, “humidity” : 41, “strike_count” : 26, “storm_dist” : 27, “active” : 1, “rfi” : 0, “ussb1” : 0, “battery” : “OK”, “exception” : 0, “raw_msg” : “c0fd6fa9d12d9a1b88”}<\/p>\n\n\n\n
{“time” : “2019-09-25 19:12:04”, “model” : “Smoke detector GS 558”, “id” : 8078, “unit” : 14, “learn” : 0, “code” : “63f1ce”}<\/p>\n\n\n\n
Trying to parse and collect the data using LiveCode has proven to be difficult. First problem with rtl receiver, is it isn’t seen as a com port, or other readable device. It is seen as its own terminal device. I’ve tried piping, didn’t work. Basically everything I’ve tried, hasn’t worked.<\/p>\n\n\n\n
The best advice I have received to is send data out to flat file, then read the file. Which basically mean lots of file activity and parsing. Unsure if I am willing to do that for what should be a simple task. That would cause a great deal of read\/write activity on the SD drives and possibly wear out the drive faster.<\/p>\n\n\n\n
Heard of a new program that outputs the data to files specific to the device id, trying to find it. Will keep everyone informed.<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
One of the most difficult problems I’ve attempted to resolve in the last few years, is how to capture and record (into mysql database) data received from 433mhz sensors.. rtl_433 -M utc -F json -G {“time” : “2019-09-25 19:11:54”, “model” : “Acurite tower sensor”, “id” : 2766, “sensor_id” : 2766, “channel” : “A”, “temperature_C” : … Continue reading “rtl_433 mhz”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33,32],"tags":[],"class_list":["post-468","post","type-post","status-publish","format-standard","hentry","category-livecode","category-programming"],"_links":{"self":[{"href":"https:\/\/www.n4n.us\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/468","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.n4n.us\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.n4n.us\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.n4n.us\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.n4n.us\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=468"}],"version-history":[{"count":2,"href":"https:\/\/www.n4n.us\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/468\/revisions"}],"predecessor-version":[{"id":476,"href":"https:\/\/www.n4n.us\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/468\/revisions\/476"}],"wp:attachment":[{"href":"https:\/\/www.n4n.us\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=468"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.n4n.us\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=468"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.n4n.us\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=468"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}