changed in weewx.conf from US to METRICWX. weewx never starts. i ll trying one more time.
Στις Παρασκευή 23 Ιουνίου 2023 στις 9:22:44 π.μ. UTC+3, ο χρήστης Rainer Lang έγραψε: > what exactly did you do ? > migrated the (data from the) old database into a new database with > METRICWX as described in Tom's link in the customization guide ? > (by the way, the unit system nam is METRICWX and *NOT* METRIXCW - could > this be the reason for weewx not coming up ?) > > Can you please set DEBUG=3 in weewx.conf, restart weewx and provide the > syslog data here .... > Some information will be there ... > On 23.06.2023 08:03, Δημήτρης Βήχος wrote: > > changed from US default to METRIXCW weewx dont startup > > Στις Πέμπτη 22 Ιουνίου 2023 στις 10:15:13 μ.μ. UTC+3, ο χρήστης Tom Keffer > έγραψε: > >> See the section *Changing the unit system in an existing database >> <https://weewx.com/docs/latest/customizing.htm#Changing_the_unit_system>* >> in the Customization Guide. >> >> On Wed, Jun 21, 2023 at 12:45 PM Δημήτρης Βήχος <hobbyl...@gmail.com> >> wrote: >> >>> finaly i did it with sqlitebrowser easily! thank you! >>> is there way my data base appears values to mm and C for temp, instead >>> to inches and F ? >>> >>> Στις Τετάρτη 21 Ιουνίου 2023 στις 4:17:58 μ.μ. UTC+3, ο χρήστης Rainer >>> Lang έγραψε: >>> >>>> At the end of the day it doesn't matter where the weewx.sdb is located >>>> - as long as weewx and wee_database via weewx.conf and sqlite3 via the >>>> path >>>> in the command know/are told >>>> where it is located. >>>> >>>> You can still check with sqlitebrowser what your entry in your database >>>> for the respective EPOCH timestamp is (see my earlier mail) - and you can >>>> change it manually >>>> (provided you start it with sudo sqlitebrowser /var/lib/weewx/weewx.sdb >>>> [in your case]). >>>> That's the pragmatic approach. >>>> >>>> Of course you can still try to figure out why your SQL command doesn't >>>> seem to have been successful. >>>> >>>> On 21.06.2023 13:24, Δημήτρης Βήχος wrote: >>>> >>>> my database is on /var/lib/weewx/weewx.sdb >>>> >>>> metfm@metfm:~$ ls -ail /var/lib/weewx >>>> σύνολο 18692 >>>> 264962 drwxr-xr-x 1 root root 18 Ιουν 21 14:20 . >>>> 269 drwxr-xr-x 1 root root 592 Φεβ 26 18:30 .. >>>> 270727 -rwxrwxrwx 1 root root 19140608 Ιουν 21 14:20 weewx.sdb >>>> metfm@metfm:~$ >>>> >>>> Στις Τετάρτη 21 Ιουνίου 2023 στις 11:49:35 π.μ. UTC+3, ο χρήστης gjr80 >>>> έγραψε: >>>> >>>>> 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+...@googlegroups.com. >>>> >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/weewx-user/f4d024d3-7dca-4a12-961f-1a3d85c05a07n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/f4d024d3-7dca-4a12-961f-1a3d85c05a07n%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/c3acfded-0eb0-447b-a7b5-8685d47bd54an%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/c3acfded-0eb0-447b-a7b5-8685d47bd54an%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/e87f8828-ac81-483c-9a5d-11af079bf123n%40googlegroups.com > > <https://groups.google.com/d/msgid/weewx-user/e87f8828-ac81-483c-9a5d-11af079bf123n%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/21bd0cea-e109-412d-beaf-a4e46433aa9cn%40googlegroups.com.
