No. The default Debian based distro database is /var/lib/weewx/weewx.sdb. The archive directory is only used (by default) for setup.py installs.
OP. Have you confirmed the location (and name) of your WeeWX database? What does the following command show: $ ls -ail /var/lib/weewx Gary On Wednesday, 21 June 2023 at 09:28:58 UTC+1 stefanos...@gmail.com wrote: > It should be /var/lib/weewx/archive/weewx.sdb > > Can you give us a screenshot where the weewx.sdb is?? > > Στις Τετ, 21 Ιουν 2023, 11:03 ο χρήστης Δημήτρης Βήχος < > hobbyl...@gmail.com> έγραψε: > >> debian installed. also triyng with sudo sqlite3 /var/lib/weewx/weewx.sdb >> same thing. >> >> Στις Τετάρτη 21 Ιουνίου 2023 στις 9:55:34 π.μ. UTC+3, ο χρήστης gjr80 >> έγραψε: >> >>> Have you customised your WeeWX install? You appear to be using a package >>> install so unless you have changed it your WeeWX database should be in >>> /var/lib/weewx not /var/weewx. >>> >>> Gary >>> >>> On Wednesday, 21 June 2023 at 05:48:19 UTC+1 hobbyl...@gmail.com wrote: >>> >>>> the commands with semi-colons. send me (with sudo also and with suo su >>>> ) >>>> >>>> metfm@metfm:~$ sudo sqlite3 /var/weewx/weewx.sdb >>>> SQLite version 3.34.1 2021-01-20 14:10:07 >>>> Enter ".help" for usage hints. >>>> sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch','localtime'), >>>> usUnits, rain FROM archive WHERE dateTime > 1686881600 AND dateTime <= >>>> 1686981600; >>>> Error: unable to open database "/var/weewx/weewx.sdb": unable to open >>>> database file >>>> metfm@metfm:~$ >>>> >>>> without semi-colons database open >>>> >>>> metfm@metfm:~$ sudo sqlite3 /var/weewx/weewx.sdb >>>> [sudo] password for metfm: >>>> SQLite version 3.34.1 2021-01-20 14:10:07 >>>> Enter ".help" for usage hints. >>>> sqlite> select datetime, datetime(dateTime, 'unixepoch','localtime'), >>>> rain from archive where dateTime > 1686881600 and dateTime <= 1686981600 >>>> ...> update archive set rain=12.6 where dateTime = 1686975900 >>>> ...> .quit >>>> ...> >>>> metfm@metfm:~$ sudo wee_database --rebuild-daily --from=2023-06-17 >>>> --to=2023-06-17 >>>> [sudo] password for metfm: >>>> Using configuration file /etc/weewx/weewx.conf >>>> Using database binding 'wx_binding', which is bound to database >>>> 'archive_sqlite' >>>> Daily summary for 2023-06-17 will be rebuilt. >>>> Proceed (y/n)? y >>>> Rebuilding daily summaries in database 'weewx.sdb' ... >>>> Processed 276 records to rebuild 1 daily summary in 0.12 seconds >>>> Rebuild of daily summaries in database 'weewx.sdb' complete >>>> metfm@metfm:~$ sudo /etc/init.d/weewx start >>>> Starting weewx (via systemctl): weewx.service. >>>> metfm@metfm:~$ >>>> but after restarting weewx no change in database. no 12.6 plus mm who >>>> i needs >>>> Στις Τρίτη 20 Ιουνίου 2023 στις 2:10:28 μ.μ. UTC+3, ο χρήστης gjr80 >>>> έγραψε: >>>> >>>>> At a guess I would say your sqlite3 commands were never executed due >>>>> to missing semi-colons at the end of each sqlite3 command line. Your >>>>> commands are basically fine, but you need to be careful with the >>>>> datetime/dateTime case in the commands. No need for commits as your >>>>> are not processing multiple commands as a transaction. When editing the >>>>> database you do need to be mindful of your database units and make sure >>>>> you >>>>> use the same units in your update queries. If using sqlite command line >>>>> the >>>>> easiest thing to do is to look at the usUnits field. 1=US >>>>> customary=inches, 16=Metric=cm, 17=MetricWX=mm. Whether you use sqlite3 >>>>> or >>>>> a gui tool like sqlitebrowser does not really matter, just check that >>>>> your >>>>> data was changed after you make the change and if using a gui be very >>>>> careful to not leave any fields with null strings(though this is usually >>>>> associate with deleting data rather than updating it). FWIW if using >>>>> sqlite3 I would use this sequence of commands: >>>>> >>>>> $ sqlite3 /home/weewx/archive/weewx.sdb >>>>> sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch','localtime'), >>>>> usUnits, rain FROM archive WHERE dateTime > 1686881600 AND dateTime <= >>>>> 1686981600; >>>>> sqlite> UPDATE archive SET rain=12.6 WHERE dateTime = 1686975900; >>>>> sqlite> SELECT dateTime, datetime(dateTime, 'unixepoch','localtime'), >>>>> usUnits, rain FROM archive WHERE dateTime=1686975900; >>>>> sqlite> .q >>>>> $ sudo wee_database --rebuild-daily --date=2023-06-17 >>>>> >>>>> In terms of the Seasons skin your updated data may causes changes to >>>>> rain plots (all except the 'today' plot), the June 2023 and 2023 NOAA >>>>> format reports and the statistics widget/page. All should come good in >>>>> time >>>>> (max 24 hours) provided you update your data sometime this month, but if >>>>> you want to speed things up delete all your rain plots on your WeeWX >>>>> machine. If you update your data in say July you will need to delete the >>>>> June 2023 and 2023 NOAA format reports and all subsequent NOAA format >>>>> reports to force regeneration. >>>>> >>>>> Can't speak for any other skins. >>>>> >>>>> Gary >>>>> On Tuesday, 20 June 2023 at 07:04:56 UTC+1 hobbyl...@gmail.com wrote: >>>>> >>>>> here is me commands in terminal . trying to plus 12.1 missing mm in >>>>> 17 july total rainfall >>>>> >>>>> metfm@metfm:~$ sudo sqlite3 /var/weewx/weewx.sdb >>>>> [sudo] password for metfm: >>>>> SQLite version 3.34.1 2021-01-20 14:10:07 >>>>> Enter ".help" for usage hints. >>>>> sqlite> select datetime, datetime(dateTime, 'unixepoch','localtime'), >>>>> rain from archive where dateTime > 1686881600 and dateTime <= 1686981600 >>>>> ...> update archive set rain=12.6 where dateTime = 1686975900 >>>>> ...> .quit >>>>> ...> >>>>> metfm@metfm:~$ sudo wee_database --rebuild-daily --from=2023-06-17 >>>>> --to=2023-06-17 >>>>> [sudo] password for metfm: >>>>> Using configuration file /etc/weewx/weewx.conf >>>>> Using database binding 'wx_binding', which is bound to database >>>>> 'archive_sqlite' >>>>> Daily summary for 2023-06-17 will be rebuilt. >>>>> Proceed (y/n)? y >>>>> Rebuilding daily summaries in database 'weewx.sdb' ... >>>>> Processed 276 records to rebuild 1 daily summary in 0.12 seconds >>>>> Rebuild of daily summaries in database 'weewx.sdb' complete >>>>> metfm@metfm:~$ sudo /etc/init.d/weewx start >>>>> Starting weewx (via systemctl): weewx.service. >>>>> metfm@metfm:~$ >>>>> >>>>> something missing? something im doing wrong? the exetra mm never shows >>>>> in weewx restarting and updating. >>>>> >>>>> >>>>> >>>>> Στις Σάββατο 17 Ιουνίου 2023 στις 12:11:40 μ.μ. UTC+3, ο χρήστης >>>>> Stefanos Kalaitzis έγραψε: >>>>> >>>>> First find the range of time(epoch) that you want to add the rain >>>>> Enter to weeex.sdb >>>>> >>>>> sudo sqlite3 /home/weewx/archive/weewx.sdb >>>>> >>>>> Then check what values your station recorded >>>>> >>>>> select datetime, datetime(dateTime, 'unixepoch','localtime'), rain >>>>> from archive where dateTime > 1686881600 and dateTime <= 1686981600; >>>>> >>>>> Then correct the time you want >>>>> For example >>>>> >>>>> update archive set rain=1.0 where dateTime = 1686975900; >>>>> >>>>> Then exit the db >>>>> >>>>> .quit >>>>> >>>>> Stop weewx >>>>> >>>>> After all corrections rebuild the data base for that day >>>>> >>>>> >>>>> sudo /home/weewx/bin/wee_database --rebuild-daily --from=2023-06-17 >>>>> --to=2023-06-17 >>>>> >>>>> Start weewx >>>>> >>>>> Thats what i am doing when i have to add some missing mm in my db >>>>> >>>>> >>>>> >>>>> Στις Σάβ, 17 Ιουν 2023, 11:42 ο χρήστης Δημήτρης Βήχος < >>>>> hobbyl...@gmail.com> έγραψε: >>>>> >>>>> i want like to add some mm to my daily rainfall beacuse after power >>>>> loss , my console (fine offset) have 10mm above the weewx after the >>>>> power >>>>> on again. >>>>> i had loss 10mm in my daily rain. >>>>> >>>>> thank you! >>>>> >>>>> -- >>>>> 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 weewx-user+...@googlegroups.com. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/weewx-user/e96ce7e9-1085-46f6-adf4-b82275bf4df4n%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/e96ce7e9-1085-46f6-adf4-b82275bf4df4n%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 weewx-user+...@googlegroups.com. >> > To view this discussion on the web visit >> https://groups.google.com/d/msgid/weewx-user/88595a49-17a9-4e1f-9fc1-6d884f9f1863n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/88595a49-17a9-4e1f-9fc1-6d884f9f1863n%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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/507b08ba-b0fa-4501-9abd-4f9a492bad8fn%40googlegroups.com.
