You won't have any success using mysql for querying a sqlite database, so first things first: what kind of database are you using with WeeWX?
Pete Geenhuizen schrieb am Freitag, 12. Dezember 2025 um 15:12:31 UTC+1: > First off, I know absolutely nothing about databases and haven't install > anything related to a database, up to now. > > Using Thomas' instructions from > https://github.com/weewx/weewx/wiki/Switching-to-the-new-wview_extended-schema > > # mysql command not found, > > so I installed mysql-8.0.43-1.el9_6.x86_64 > > when I run the command > > # mysql> GRANT select, update, create, delete, insert ON weewx_new.* TO > weewx@localhost; > > I ended up with a file called GRANT, but not weewx.sdb_new > > So I guess that I'm completely out of my depth with not a clue what to do > next. > > Any pointers on what to do next would be greatly appreciated. > > Pete > > > On 12/11/25 16:01, vince wrote: > > Try 2 - google groups deleted my previous reply for unknown reasons. > > If you have 11 years of old data you likely have the original old wview > compatible schema so I'd recommend you convert your db to the new > wview_extended schema and rebuild-daily. There are lots of threads here > with how to do that using 'weectl database'. In particular, Belchertown > needs a few elements missing from the old schema. While you can add them > each manually, it's (to me) easier to just upgrade the db and not need to > worry it. Regardless, you'll need to rebuild-daily afterward to build the > summary tables. > > Seasons and Belchertown each have their own NOAA trees that need to be > generated one time on first startup if you didn't pre-seed your output HTML > tree with previously generated files. That can take some time, once. > Seasons typically is lightning fast once this is done, so if it took 145 > seconds the first time, this might have been why. It should speed up after > the NOAA files for your old data have been generated. > > On Thursday, December 11, 2025 at 11:02:19 AM UTC-8 Pete Geenhuizen wrote: > >> I downloaded v1.6 several days ago so I guess since then some additional >> fixes were done, anyway I replaced belchertown.py with the one listed here >> ad that solved that problem. >> >> Once I had everything working I decided to test the configuration by >> copying over my existing database with 11 years of observations to ensure >> that once I attached my weather station everything wold work seamlessly, >> however that is not to be, I now get this error >> >> >> I'm testing this new installation in simulator mode, and have copied my >> existing database file with, 11 years of observations which I would hate to >> loose, over to test that everything is working, but unfortunately am now >> getting this error. >> >> Now when I start up weewx I get this database error, more info in the >> attached log >> >> Dec 10 08:56:20 localhost weewxd[1246977]: INFO weewx.engine: Main loop >> exiting. Shutting engine down. >> Dec 10 08:56:20 localhost weewxd[1246977]: INFO weewx.engine: Shutting >> down StdReport thread >> Dec 10 08:56:40 localhost weewxd[1246977]: ERROR weewx.engine: Unable to >> shut down StdReport thread >> Dec 10 08:56:40 localhost weewxd[1246977]: CRITICAL __main__: Database >> OperationalError exception: database is locked >> Dec 10 08:56:40 localhost weewxd[1246977]: CRITICAL __main__: **** >> Waiting 2 minutes then retrying... >> Dec 10 08:56:41 localhost weewxd[1246977]: INFO weewx.cheetahgenerator: >> Generated 12 files for report SeasonsReport in 145.34 seconds >> >> I found some suggestions on line to fix this but none have worked. >> >> Thanks >> >> Pete >> >> >> On 12/9/25 16:30, Danny Ciarniello wrote: >> >> The uploaded version of belchertown.py looks like the one that comes with >> the v1.6 release. That version had a number of issues that have since been >> fixed. Replacing belchertown.py with the one vince pointed to should, >> hopefully, fix the problem. >> >> On Tuesday, December 9, 2025 at 12:48:44 PM UTC-8 vince wrote: >> >>> Your weewx.conf works ok versus the uajqq version in github, but the >>> belchertown.py that you uploaded here looks like it's not that version. >>> >>> In the belchertown.py skin you uploaded line 244 is the locale error >>> if belchertown_debug: >>> log.error( >>> * f"Locale: Error using locale >>> {self.generator.skin_dict["Extras"]["belchertown_locale"]}. "* >>> f"This locale may not be installed on your >>> system and you may see unexpected results. " >>> f"Belchertown skin JavaScript will try to use >>> this locale. Full error: %{error}" >>> ) >>> >>> But around line 222 (much different) in >>> https://github.com/uajqq/weewx-belchertown-new/blob/master/bin/user/belchertown.py >>> >>> I see: >>> >>> if belchertown_debug: >>> log.error( >>> f"Error using locale {belchertown_locale}. " >>> "This locale may not be installed on your system >>> and you may see unexpected results. " >>> f"Python could not set the requested locale, but >>> Belchertown skin JavaScript will attempt to use the provided locale string. >>> Full error: {error}" >>> ) >>> >>> So my wild guess is you have some hacked/previous/miscellaneous/unknown >>> version of the forked skin. Perhaps try installing the real one ? >>> >>> On Tuesday, December 9, 2025 at 11:47:26 AM UTC-8 Pete Geenhuizen wrote: >>> >>>> I downloaded the v1.6 skin from here >>>> https://github.com/uajqq/weewx-belchertown-new. >>>> Attached is the output from weectl.debug >>>> Thanks for your help. >>>> Pete >>>> >>>> >>>> On 12/9/25 12:40, vince wrote: >>>> >>>> "*using the new 1.6 forked version of the Belchertown skin*" - without >>>> knowing 'which' forked version it might be difficult for people to help. >>>> >>>> How about running "weectl debug" and attaching the output so folks can >>>> see your setup.... >>>> >>>> Based on the error you mention, best guess is you have [ something ] >>>> with a mismatched number of [ and ] brackets. >>>> >>>> On Tuesday, December 9, 2025 at 8:23:25 AM UTC-8 Pete Geenhuizen wrote: >>>> >>>>> I trying to update my Rock 8 weewx v4 to Rocky 9 weewx v5 using the >>>>> new >>>>> 1.6 forked version of the Belchertown skin. >>>>> >>>>> I'm testing this out in simulator mode, and it sees to start fine >>>>> until >>>>> it does an update which start with this error >>>>> >>>>> ERROR weewx.reportengine: Caught unrecoverable exception in generator >>>>> 'weewx.cheetahgenerator.CheetahGenerator' >>>>> >>>>> ERROR weewx.reportengine: **** f-string: unmatched '[' >>>>> (belchertown.py, line 244) >>>>> >>>>> and goes down hill from there >>>>> >>>>> Attached is a copy of the last run.. >>>>> >>>>> I have very limited programming skills and zero knowledge of python, >>>>> so >>>>> I'm hoping that someone help me fix the problem. >>>>> >>>>> Thanks >>>>> >>>>> Pete >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Unencumbered by the thought process. >>>>> -- Click and Clack the Tappet brothers >>>>> >>>> -- >>>> 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/22eccf9d-e3f5-4345-9da5-481f0451d17bn%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/22eccf9d-e3f5-4345-9da5-481f0451d17bn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>>> >>>> -- >>>> Unencumbered by the thought process. >>>> -- Click and Clack the Tappet brothers >>>> >>>> >>>> -- >> 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/122a7232-eda2-441b-8d1e-caf3e59c0cc6n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/122a7232-eda2-441b-8d1e-caf3e59c0cc6n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> -- >> Unencumbered by the thought process. >> -- Click and Clack the Tappet brothers >> >> -- > 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/9152e81d-b589-4b3a-89de-5a4f57c12645n%40googlegroups.com > > <https://groups.google.com/d/msgid/weewx-user/9152e81d-b589-4b3a-89de-5a4f57c12645n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > -- > Unencumbered by the thought process. > -- Click and Clack the Tappet brothers > > -- 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/92a04861-b46c-4bdb-8e6b-a69d52fecb09n%40googlegroups.com.
