Tom and Vince, Thanks for support. For the second day now, the weather station has been working with RPi without failures Thanks
BR, Andrei четверг, 12 марта 2026 г. в 22:13:29 UTC+3, Vince Skahan: > oops - yes. No quote at the end. Thanks. (typo) > > On Thursday, March 12, 2026 at 12:04:11 PM UTC-7 Tom Keffer wrote: > >> Thanks, Vince. Forgot about the nologin entry. >> >> *sudo -u weewx bash* >> >> >> is what you want. (No double quote at the end.) >> >> >> On Thu, Mar 12, 2026 at 11:57 AM Vince Skahan <[email protected]> wrote: >> >>> Andrei - you are probably going to get an error if you run Tom's sudo >>> command.... >>> >>> # From Tom's instructions >>> $ sudo su weewx >>> This account is currently not available. >>> >>> # If you get that error, sudo to weewx a little differently >>> $ sudo -u weewx bash" >>> >>> # and verify you're weewx >>> $ id >>> uid=103(weewx) gid=103(weewx) >>> groups=103(weewx),4(adm),20(dialout),24(cdrom),27(sudo),29(audio),44(video),46(plugdev),60(games),100(users),101(netdev),992(render),996(input),1001(gpio),1002(i2c),1003(spi) >>> >>> If you are uid=weewx you should be able to run the sqlite3 commands >>> without permission issues... >>> >>> >>> On Thursday, March 12, 2026 at 11:40:39 AM UTC-7 Tom Keffer wrote: >>> >>>> You can certainly do that if you don't care about the data in your >>>> database. >>>> >>>> The reason why the command did not work is because you did not log in >>>> as user 'weewx'. You were logged in as user 'pi'. See the instructions I >>>> sent in the last email. >>>> >>>> On Thu, Mar 12, 2026 at 11:38 AM ANDREI ROZWADOWSKI < >>>> [email protected]> wrote: >>>> >>>>> I've installed sqlite3 >>>>> After that, I executed several commands and got the following result: >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> *pi@raspberrypi:~ $ sqlite3 /var/lib/weewx/weewx.sdbsqlite> SELECT >>>>> datetime(dateTime,'unixepoch','localtime') FROM archive WHERE >>>>> date(dateTime,'unixepoch','localtime') > "2026-04-01";SQLite version >>>>> 3.46.1 >>>>> 2024-08-13 09:16:08Enter ".help" for usage hints.sqlite> SELECT >>>>> datetime(dateTime,'unixepoch','localtime') FROM archive WHERE >>>>> date(dateTime,'unixepoch','localtime') > "2026-04-01";2052-10-17 >>>>> 16:52:002053-02-18 08:32:002128-04-25 09:27:00sqlite> DELETE FROM archive >>>>> WHERE date(dateTime,'unixepoch','localtime') > "2026-04-01";Runtime >>>>> error: >>>>> attempt to write a readonly database (8)* >>>>> >>>>> Tell me, please, maybe it will be easier.: 1. Stop weewx. 2. Delete >>>>> the weewx .sdb file 3. Restart weewx ?? >>>>> >>>>> -- >>>>> >>>> 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/bb1d9b91-5889-4900-abbd-5d7ff4ba17een%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/bb1d9b91-5889-4900-abbd-5d7ff4ba17een%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>> 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/7b8bede6-8e5c-4869-9a6c-a79115fb1b9dn%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/7b8bede6-8e5c-4869-9a6c-a79115fb1b9dn%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- 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/e3fa9eb7-eb3e-4cc5-8e1f-27ac8e3c344cn%40googlegroups.com.
