It won't start until you do the things in https://weewx.com/docs/latest/customizing.htm#Changing_the_unit_system
Δημήτρης Βήχος schrieb am Freitag, 23. Juni 2023 um 08:37:54 UTC+2: > 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/b747747d-64df-4322-b78f-932b41841fdfn%40googlegroups.com.
