yes, you are correct - the REC is written to the archive table, but the data in the REC is the average of the LOOP data over the archive period.(if software generation is used).
On Monday, 17 February 2020 22:54:30 UTC+2, ed100 wrote: > > Andrew: Isn't the data in the REC what is written to the archive table? > > I have MQTT updating my homepage every 10 sec. archive table gets new data > every 5 minutes. > > > > On Friday, February 7, 2020 at 4:15:46 PM UTC-6, ed100 wrote: >> >> Belchertown skin is great and serves the data on website 192.168.1.200 >> just fine. I just can't get MQTT to update the loops - it connects and >> waits. >> I have read and tried several of the things mentioned on the net but no >> joy yet. >> There are no error msgs that I have found. What am I missing? >> >> from http://192.168.1.200/weewx/belchertown/index.html >> Connected. Waiting for data. Last Updated February 7, 2020, 3:22:00 PM >> >> belchertown: version 1.1b8 >> restx: MQTT: service version is 0.19 >> Initializing weewx version 4.0.0b11 >> Using Python 3.7.3 (default, Apr 3 2019, 05:39:12) #012[GCC 8.2.0] >> Platform Linux-4.19.93-v7l+-armv7l-with-debian-10.2 >> Raspberry rpi4 >> Weewx is running on 192.168.1.190 (dedicated for weather things) >> webserver is running on 192.168.1.200 >> pi is user on both. >> >> 192.168.1.200 is NAS for all my boxes, 5 raspberrys, two ubuntu boxes, >> two Arduino boxes. >> 192.168.1.190 is setup and running out in our yard where the windspeed, >> winddir, rain, temp etc are measured. >> Data is stored in an mariadb and served by ngnix running on 192.168.1.200. >> >> from /etc/mosquitto/conf.d/myconfig.conf on 192.168.1.200: >> >> persistence false >> >> # mqtt >> listener 1883 >> protocol mqtt >> >> # websockets >> listener 9001 >> protocol websockets >> >> allow_anonymous true >> >> acl_file /etc/mosquitto/acl >> >> log_type all >> =================================================================== >> from /etc/mosquitto/acl on 192.168.1.200: >> # Allow anonymous access to the sys >> topic read $SYS/# >> >> # Allow anonymous to read weather >> topic weather/# >> >> # weewx readwrite to the loop >> user pi >> topic weather/# >> >> ========================================== >> >> from weewx.conf: >> >> station_type = BCRobotics >> station_url = http://192.168.1.200 >> >> [[MQTT]] >> server_url = mqtt://192.168.1.200:1883/ >> topic = weather/loop >> unit_system = US >> binding = archive, loop >> aggregation = aggregate >> >> [[Belchertown]] >> skin = Belchertown >> enable = true >> HTML_ROOT = /var/www/html/weewx/belchertown >> [[[Extras]]] >> belchertown_root_url = "http://192.168.1.200"; >> theme = auto >> theme_toggle_enabled = 1 >> site_title = "Banjo's Wx Home" (Banjo is our dog, a lab -- >> He checks the weather on his Ipaw.) >> home_page_header = "Banjo's Wx Conditions" >> mqtt_websockets_enabled = 1 >> mqtt_websockets_host = "192.168.1.200" >> mqtt_websockets_port = 9001 >> mqtt_websockets_topic = "weather/loop" >> mqtt_websockets_ssl = 0 >> disconnect_live_website_visitor = 900000 >> log_failure = true >> log_success = true >> >> >> ================================================================== >> sudo tail -25 /var/log/mosquitto/mosquitto.log on 192.168.1.200 >> 1581110894: New connection from 192.168.1.190 on port 1883. >> 1581110894: New client connected from 192.168.1.190 as weewx_c7c0a139 >> (c1, k60). >> 1581110894: No will message specified. >> 1581110894: Sending CONNACK to weewx_c7c0a139 (0, 0) >> 1581110894: Received PUBLISH from weewx_c7c0a139 (d0, q0, r0, m0, >> 'weather/loop/loop', ... (824 bytes)) >> 1581110894: Received DISCONNECT from weewx_c7c0a139 >> 1581110894: Client weewx_c7c0a139 disconnected. >> >> ========================================================================= >> from mosquitto_sub -v -t '#' (on 192.168.1.200) >> weather/loop/loop {"dateTime": "1581110268.0", "usUnits": "1.0", >> "windSpeed_mph": "23.5736", "windDir": "225.0", "outTemp_F": >> "48.44069175713479", "rainRate_inch_per_hour": "0.0", "pressure_inHg": >> "29.537724517082214", "inTemp_F": "48.44069175713479", "inHumidity": >> "40.10936680311917", "outHumidity": "40.10936680311917", "extraTemp1_F": >> "29.0", "altimeter_inHg": "30.025126837815904", "appTemp_F": >> "30.718254859246187", "barometer_inHg": "30.032273523343694", >> "beaufort_count": "5.0", "cloudbase_foot": "5707.996577917219", >> "dewpoint_F": "25.30550681429903", "heatindex_F": "48.44069175713479", >> "humidex_F": "48.4406917571348", "inDewpoint_F": "25.30550681429903", >> "maxSolarRad_Wpm2": "337.7856265409849", "windchill_F": >> "40.906702199301414", "hourRain_in": "0.02794", "rain24_in": >> "0.44704000000000005", "dayRain_in": "0.16763999999999998"} >> >> >> ===================================================================================== >> from sudo tail -f /var/log/syslog (on 192.168.1.190) >> >> Feb 7 15:18:23 raspberrypi weewx[10773] INFO weewx.restx: MQTT: >> Published record 2020-02-07 15:18:00 CST (1581110280) >> Feb 7 15:18:24 raspberrypi weewx[10773] INFO weewx.cheetahgenerator: >> Generated 10 files for report Belchertown in 0.93 seconds >> Feb 7 15:18:24 raspberrypi weewx[10773] INFO weewx.reportengine: Copied >> 2 files to /var/www/html/weewx/belchertown >> Feb 7 15:18:28 raspberrypi weewx[10773] INFO weewx.restx: MQTT: >> Published record 2020-02-07 15:18:23 CST (1581110303) >> Feb 7 15:18:29 raspberrypi weewx[10773] INFO weeutil.rsyncupload: >> rsync'd 18 files (765,224 bytes) in 0.45 seconds >> Feb 7 15:18:34 raspberrypi weewx[10773] INFO weewx.restx: MQTT: >> Published record 2020-02-07 15:18:28 CST (1581110308) >> Feb 7 15:18:39 raspberrypi weewx[10773] INFO weewx.restx: MQTT: >> Published record 2020-02-07 15:18:33 CST (1581110313) >> Feb 7 15:18:44 raspberrypi weewx[10773] INFO weewx.restx: MQTT: >> Published record 2020-02-07 15:18:39 CST (1581110319) >> >> ======================================================================================================================================= >> from sudo netstat -tulpn | grep 1883 on 192.168.1.200: >> tcp 0 0 0.0.0.0:1883 0.0.0.0:* >> LISTEN 567/mosquitto >> tcp6 0 0 :::1883 :::* >> LISTEN 567/mosquitto >> >> on 192.168.1.190: >> tcp 0 0 0.0.0.0:1883 0.0.0.0:* >> LISTEN 589/mosquitto >> tcp6 0 0 :::1883 :::* >> LISTEN 589/mosquitto >> >> -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/b3ef8c08-5b22-4007-b097-dd215aeb33c3%40googlegroups.com.
