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, <[email protected]> a écrit : > [email protected] > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/weewx-user/topics> > Google > Groups > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> > [image: > Google Groups Logo] > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> > Topic digest > View all topics > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/weewx-user/topics> > > - How do I correct my daily rain data? > <#m_-2364729864974807108_group_thread_0> - 3 Updates > - Forecast Program <#m_-2364729864974807108_group_thread_1> - 1 Update > - Connected. Waiting for data. Belchertown > <#m_-2364729864974807108_group_thread_2> - 1 Update > - Forecast V3.4.ob2 Problems <#m_-2364729864974807108_group_thread_3> > - 2 Updates > > How do I correct my daily rain data? > <http://groups.google.com/group/weewx-user/t/f6d049c51c322e1b?utm_source=digest&utm_medium=email> > [email protected] <[email protected]>: 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 <[email protected]>: 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 > > [email protected] <[email protected]>: 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 <#m_-2364729864974807108_digest_top> > Forecast Program > <http://groups.google.com/group/weewx-user/t/14b54b6e395bfe3c?utm_source=digest&utm_medium=email> > [email protected] <[email protected]>: 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 <#m_-2364729864974807108_digest_top> > Connected. Waiting for data. Belchertown > <http://groups.google.com/group/weewx-user/t/1aaeae370fc2c6cb?utm_source=digest&utm_medium=email> > Peter Schmelitschek <[email protected]>: 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 <#m_-2364729864974807108_digest_top> > Forecast V3.4.ob2 Problems > <http://groups.google.com/group/weewx-user/t/8588d15d9070c4b5?utm_source=digest&utm_medium=email> > [email protected] <[email protected]>: 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 <[email protected]>: 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, [email protected] <[email protected]> > 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 [email protected]. > > To view this discussion visit > https://groups.google.com/d/msgid/weewx-user/f5592072-441e-4227-a84d-d401967a4517n%40googlegroups.com > . > Back to top <#m_-2364729864974807108_digest_top> > You received this digest because you're subscribed to updates for this > group. You can change your settings on the group membership page > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/weewx-user/join> > . > To unsubscribe from this group and stop receiving emails from it send an > email to [email protected]. > -- 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 visit https://groups.google.com/d/msgid/weewx-user/CAJ2AkW-bWKi4gGmhSTUMhAW%2BPRQ8iMt-aZZ5VnmN7dQDD7karw%40mail.gmail.com.
