*Thanks Tom - that did the trick!* Thank you for the advice; and also, thank you very much for writing the original article. It was quite timely as the precipitation event is upon us and I continue testing Arthur Emerson's new and improved atmocomUDP v1.20 <https://github.com/captain-coredump/weewx-atmocom-udp> driver which fixed an earlier weewx rain-related issue.
[image: pi2root2pi.png] FYI & FWIW for other new users who happen upon this thread; user *root*, invoked with sudo -i can be changed back to normal user with su - username; e.g., su - pi On Sunday, February 24, 2019 at 2:13:53 PM UTC-5, Thomas Keffer wrote: > > The "sudo" only applies to the first command (echo), not the second > (sqlite3). Try running interactively: > > *sudo -i* > *echo "UPDATE archive SET rain=NULL WHERE (rain >0);" | sqlite3 backup.sdb* > > > > On Sun, Feb 24, 2019 at 10:39 AM V. Kelly Bellis <[email protected] > <javascript:>> wrote: > >> Hello, >> >> Closely following the outlined procedures at >> Cleaning up old 'bad' data >> <https://github.com/weewx/weewx/wiki/Cleaning-up-old-%27bad%27-data> >> >> After first stopping weewx, making a copy of the weewx.sdb, I'm trying to >> clean out all rainRate and rain values greater than 0 on my RPi 3B+ >> running Raspbian Linux 9 (stretch) [4.14.98-v7+], but have run into a wee >> snag: >> >> [image: read only db.PNG] >> >> >> Any advice will be much appreciated. >> >> Kind regards, >> >> Kelly >> >> -- >> 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] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- 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.
