Oh.... The database was root:weewx
chown weewx:weewx fixed that part. On Thursday, January 22, 2026 at 10:55:58 PM UTC-5 Jim Wilkerson wrote: > Well, now I have managed to make my database read-only: > > Jan 22 22:54:02 linux-3wjh weewxd[7035]: ERROR weewx.manager: Unable to > add record 2026-01-22 13:00:00 EST (1769104800)> > > Can I use the weectl database command to fix this? > On Wednesday, January 21, 2026 at 12:27:56 AM UTC-5 Jim Wilkerson wrote: > >> Hi, thanks for the tip. >> >> I removed the old reports in >> >> /var/www/html/weewx >> >> Reinstalled 5.2.0 (openSUSE 15.6 repos) >> >> Noticed that my weewx.conf was still >> >> # Do not modify this. It is used when installing and updating weewx. >> version = 4.10.2 >> >> Fixed that with the new weewx.conf from the 5.2.0 install >> >> # This configuration file was created by ... >> version = 5.2.0 >> >> As per >> >> https://www.weewx.com/docs/5.2/usersguide/where/ >> >> I set the skins to the absolute path on my system >> >> [StdReport] >> >> # Where the skins reside, relative to WEEWX_ROOT >> SKIN_ROOT = /usr/share/weewx/weewx_data/skins >> >> # Where the generated reports should go, relative to WEEWX_ROOT >> HTML_ROOT = /var/www/html/weewx >> >> The web page runs again (also had an Apache issue to resolve) but the >> Monthly reports still show the gaps as prevoius, example: >> >> MONTHLY CLIMATOLOGICAL SUMMARY for Nov 2025 NAME: Cary, NC USA ELEV: 348 >> feet LAT: 35-47.90 N LONG: 078-50.46 W TEMPERATURE (F), RAIN (in), WIND >> SPEED (mph) HEAT COOL AVG MEAN DEG DEG WIND DOM DAY TEMP HIGH TIME LOW TIME >> DAYS DAYS RAIN SPEED HIGH TIME DIR >> --------------------------------------------------------------------------------------- >> >> 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 >> 26 27 42.6 52.1 14:30 32.9 00:00 22.4 0.0 0.00 0.9 15.0 16:30 338 28 36.7 >> 46.2 14:00 28.8 07:30 28.3 0.0 0.00 0.9 18.0 10:30 329 29 34.9 45.5 14:00 >> 23.9 07:00 30.1 0.0 0.00 0.3 9.0 10:30 98 30 44.9 54.9 13:00 36.8 02:00 >> 20.1 0.0 0.25 0.1 7.0 14:00 304 >> --------------------------------------------------------------------------------------- >> >> 39.3 54.9 30 23.9 29 100.8 0.0 0.25 0.5 18.0 28 338 >> >> That data had been showing on the other system (which was mostly a mirror >> as this one) >> >> One thing I do notice though is before I was only seeing Monthly Data up >> to May 2023, now I see it 27 Dec 2024. >> >> I working on learning the sqlite syntax.... I assume the above command is >> a generic example... >> >> On Tuesday, January 20, 2026 at 4:22:24 PM UTC-5 Tom Keffer wrote: >> >>> Not a lot of information here, but assuming you're running the Seasons >>> report, and assuming that by "Monthly report" you mean the NOAA reports, >>> one thing you could try is deleting all of the generated files and let >>> WeeWX recreate them. This will ensure that what you're seeing is what is >>> truly in the database. >>> >>> As for seeing what records are in the database, that could be a very >>> long list indeed --- perhaps hundreds of thousands or even millions of >>> records. For a shorter summar, you could ask it for which months it has any >>> record at all. Assuming that you are using SQLite and that you have the >>> tool "sqlite3" installed, use it to look inside the database. Assuming that >>> you did a package install (not pip), then this would look like: >>> >>> *sqlite3 /var/lib/weewx/weewx.sdb* >>> sqlite> *select distinct >>> strftime("%Y-%m",dateTime,'unixepoch','localtime') from archive;* >>> sqlite> *.quit* >>> >>> Depending on how long you've been using your database, this could a >>> hundred lines or so. >>> >>> If you want even finer detail and wish to see which days have data, you >>> could do >>> >>> sqlite> *select distinct date(dateTime,'unixepoch','localtime') from >>> archive;* >>> >>> But be prepared, this could list thousands of lines. >>> >>> I've made a lot of assumptions above. If any are wrong come back with >>> more information. >>> >>> -tk >>> >>> On Mon, Jan 19, 2026 at 9:34 PM Jim Wilkerson <[email protected]> wrote: >>> >>>> I recent had an event where I needed to move my weewx database to a >>>> different drive. >>>> >>>> I had first started the backup system, which had not been up since >>>> about May 2023. >>>> >>>> Once I copied the database over to the new location and restarted >>>> weewx, all starts but when I look in the web UI the Monthly Reports show >>>> no >>>> data from 28 May 2023 (the last time the system was apparently up, until >>>> 25 >>>> Nov 2025/ >>>> >>>> How can I list the database records to make sure they are intact, then >>>> get the historical data to be viewable once more on the Web UI reports? >>>> >>>> Weewx version 5.2.0 >>>> openSUSE LEAP 15.6 >>>> >>>> <code> >>>> # weectl database check >>>> Using configuration file /etc/weewx/weewx.conf >>>> Checking daily summary tables version... >>>> Daily summary tables are at version 4.0. >>>> Interval Weighting Fix is not required.</code> >>>> >>>> -- >>>> 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/4d2b261f-4c39-428f-92f4-4b804e9562cfn%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/4d2b261f-4c39-428f-92f4-4b804e9562cfn%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/10a75094-16d1-4813-be91-5e13df4d6160n%40googlegroups.com.
