Hi all I know this is a simple fix but my sql/linux skills need a hand.
I'm trying to get rid of errant data in windGust using the example in Github. I copied the weewx.sdb file to /var/lib/weewx/tmp (after creating tmp), and ran the commands below with an "unable to open database file error". Did a chmod 666 thinking it might be permissions but still no go. Also tried sudo. What did I miss? *pi@raspberrypi*:*/var/lib/weewx/tmp $* ls -l total 1180 -rw-rw-rw- 1 root root 1208320 Nov 15 17:07 weewxback.sdb *pi@raspberrypi*:*/var/lib/weewx/tmp $* echo "UPDATE archive SET windGust=NULL WHERE (windGust > 100);" | sqlite3 /var/lib/weewx/tmp/weewxback.sdb Error: near line 1: unable to open database file *pi@raspberrypi*:*/var/lib/weewx/tmp $* -- 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]. For more options, visit https://groups.google.com/d/optout.
