Hi, When you tried sudo exactly what command did you use? The correct placement of sudo would be:
$ echo "UPDATE archive SET windGust=NULL WHERE (windGust > 100);" | sudo sqlite3 /var/lib/weewx/tmp/weewxback.sdb Gary On Thursday, 15 November 2018 14:20:33 UTC+10, Colin Larsen wrote: > > 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.
