Re: [weewx-user] Digest for weewx-user@googlegroups.com - 7 updates in 4 topics

[Paul Bartholdi]

Hello,

Is sqlite3 installed?    Try

apt install sqlite3

Usually sqlite3 is in /use/bin/ . This should be in your PATH, but, just in case, replace sqlite3 with  /use/bin/sqlite3 , this should work...

Good luck!     Paul 

Le mar. 5 août 2025, 00:01, <weewx...@googlegroups.com> a écrit :

weewx...@googlegroups.com

Google Groups

Topic digest
View all topics

• How do I correct my daily rain data? - 3 Updates
• Forecast Program - 1 Update
• Connected. Waiting for data. Belchertown - 1 Update
• Forecast V3.4.ob2 Problems - 2 Updates

How do I correct my daily rain data?

dens...@yahoo.com <dens...@yahoo.com>: Aug 04 10:13AM -0700 Hardware maintenance resulted in 1.63" of daily rain data that is not real. Is there an easy way to correct this error? I am running WeeWX 5.0 on a Raspberry Pi. Thanks, Den

vince <vince...@gmail.com>: Aug 04 12:43PM -0700 https://github.com/vinceskahan/weewx-odds-and-ends/blob/master/fix-bad-rain.md is one way to do it

dens...@yahoo.com <dens...@yahoo.com>: Aug 04 01:16PM -0700 Thank you for the quick reply... I am sure my lack of Pi / SQLite knowledge is at issue here. I pasted: *echo "select datetime(dateTime,'unixepoch','localtime'),dateTime,rain,rainRate from archive order by rowid desc limit 20;" | sqlite3 weewx.sdb* into the terminal as the user Pi (pi@raspberrypi:) and get back: *bash: sqlite3: command not found.*   Adding the preface *sudo* did not change the response.   If more explicit instructions would help, please advise. Den On Monday, August 4, 2025 at 3:43:25 PM UTC-4 vince wrote:

Back to top

Forecast Program

philip....@gmail.com <philip....@gmail.com>: Aug 04 10:36AM -0700 Sorry to have to ask and its probably a question for John K or Mathew H but is there any thoughts to add UKMO datahub to the the forecast program Thanks in Advance Phil

Back to top

Connected. Waiting for data. Belchertown

Peter Schmelitschek <dreamwo...@gmail.com>: Aug 04 07:30AM -0700 I apologise to the Gurus who will sigh 'not this again!"   I have been working on getting WeeWx to work with Belchertown for several weeks and admit defeat. My head is spinning from days going in circles with ChatGPT on multiple related issues (TLS, MQTT over TCP yada yada).   Summary of my setup that I feel is relevant:   Local DNS record on Pi-Hole (with unbound) points broker (mqtt.dreamwoodestate.net) to the Traefik IP.   Mikrotik router has dst-nat pointing 8883 and 9011 to those ports on the Traefik VM. There are also Input rules to allow those ports.   Cloudflare has a proxied A record for the broker, pointing to my static IP which resolves to my HomeLab domain (dreamwoodestate.net)   Traefik (in own VM) supplies Letsencrypt certificate for use by browser wanting to securely access my website with Belchertown.   MQTT broker (Mosquitto 2.0.18) is running on its own VM also.   WeeWx also has its own VM.   So far, MQTT Explorer on my LM PC can see the broker, SSYS, broker - and all the groups below broker.   WeeWx appears to be outputting MQTT data, with rows like: DEBUG user.mqtt: data: {'dateTime': '1754316352.0', 'barometer_mbar'.... INFO weewx.restx: MQTT: Published record 2025-08-05 00:05:52 AEST (1754316352)   However, MQTT Explorer is not displaying any 'weather' messages from the WeeWx MQTT client (I think this is the way to describe it). It is subscribed to topic=weather/loop   BTW, I have chosen port '9011' for websockets as Portainer Agent is using '9001' traditionally used around WeeWx/MQTT   weexw.log is empty - don't know if that is good or bad   Browsing to my weather data is 'working' in all respects except for the MQTT driven 2 second updates (and that strange appearance of 'current temp' at the top of graphs and reports - minor problem I'm sure). Using '?debug=true' in browser shows 'MQTT: MQTT Connected. Subscribing.' as the last entry.   Hopefully there are sufficient clues and suitable obfuscation in the attached. Please let me know what other info I can provide.

Back to top

Forecast V3.4.ob2 Problems

philip....@gmail.com <philip....@gmail.com>: Aug 04 05:21AM -0700 weewx V 5.1.0 Been having problems getting downloads from UKMO for a while now but only started to look into it. It downloads 4/5 cycles Ok and then fails   025-08-04T12:50:17.090123+01:00 raspberrypi weewxd[1790]: ERROR user.forecast: UKMOThread: UKMO: missing field 'Location' 2025-08-04T12:50:17.090187+01:00 raspberrypi weewxd[1790]: INFO user.forecast: UKMOThread: UKMO: got 0 forecast records   If I then, shortly after the failure, delete forecast.sdb and reboot it downloads OK.   2025-08-04T13:02:14.535656+01:00 raspberrypi weewxd[2113]: INFO user.forecast: MainThread: UKMO: forecast version 3.4.0b2 2025-08-04T13:02:14.537368+01:00 raspberrypi weewxd[2113]: INFO user.forecast: MainThread: UKMO: interval=10800 max_age=604800 api_key=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXf051 location=354731   2025-08-04T13:05:17.618878+01:00 raspberrypi weewxd[1787]: INFO user.forecast: UKMOThread: UKMO: got 38 forecast records   It looks like a UKMO problem but why does it download OK if I delete the database shortly afterwards. Thanks Phil

steepleian <steep...@btinternet.com>: Aug 04 02:17PM +0100 Met Office have or in the process of changing data hubs so that may be the reason.   https://claydonsweather.org.uk   On 4 Aug 2025, at 13:21, philip....@gmail.com <philip....@gmail.com> wrote:      weewx V 5.1.0   Been having problems getting downloads from UKMO for a while now but only started to look into it.   It downloads 4/5 cycles Ok and then fails   025-08-04T12:50:17.090123+01:00 raspberrypi weewxd[1790]: ERROR user.forecast: UKMOThread: UKMO: missing field 'Location'   2025-08-04T12:50:17.090187+01:00 raspberrypi weewxd[1790]: INFO user.forecast: UKMOThread: UKMO: got 0 forecast records   If I then, shortly after the failure, delete forecast.sdb and reboot it downloads OK.   2025-08-04T13:02:14.535656+01:00 raspberrypi weewxd[2113]: INFO user.forecast: MainThread: UKMO: forecast version 3.4.0b2   2025-08-04T13:02:14.537368+01:00 raspberrypi weewxd[2113]: INFO user.forecast: MainThread: UKMO: interval=10800 max_age=604800 api_key=XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXf051 location=354731   2025-08-04T13:05:17.618878+01:00 raspberrypi weewxd[1787]: INFO user.forecast: UKMOThread: UKMO: got 38 forecast records   It looks like a UKMO problem but why does it download OK if I delete the database shortly afterwards.   Thanks Phil   --   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 weewx-user+...@googlegroups.com.   To view this discussion visit https://groups.google.com/d/msgid/weewx-user/f5592072-441e-4227-a84d-d401967a4517n%40googlegroups.com.

Back to top

You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page. To unsubscribe from this group and stop receiving emails from it send an email to weewx-user+...@googlegroups.com.