I reverted to sqlite and the data populates as expected. I'll look at making backups now...
Regards, Tommy On Sunday, August 24, 2025 at 4:35:48 PM UTC-4 Pablo Sanchez wrote: > Ah, that does make sense why you want to piggyback off of your existing > Maria DB installation. > > Have a look at https://github.com/benbjohnson/litestream as a method to > continuously back up the DB to a remote server. > > Personally, I rsync the entire weemx data directory to another server. I > may lose some data but probably not relevant. ;) > > Cheers! > --- > pablo > > > On August 24, 2025 16:21:59 tommy Teague <[email protected]> wrote: > >> Thank you all for the quick replies. >> >> I use Maria for several home automation projects here at the house so >> figured it was a no brainer. I use this Windows PC as a common file >> location and DB server, OTA TV recording, etc. etc. >> >> Could I store the sqlite file on a network drive to cut down on the rpi >> sdcard writes? Or just live with the data loss risk and perform backups? >> >> Regards, >> >> Tommy >> >> On Sunday, August 24, 2025 at 4:16:34 PM UTC-4 Tom Keffer wrote: >> >>> Indeed. See the wiki article on SQLite vs MySQL >>> <https://github.com/weewx/weewx/wiki/SQLite-vs-MySQL> on just this >>> subject. >>> >>> On Sun, Aug 24, 2025 at 12:48 PM Pablo Sanchez <[email protected]> >>> wrote: >>> >>>> Tommy, >>>> >>>> As it is a new installation, it be worth trying SQLite. >>>> >>>> As a database geek, I also run SQLite. There is no need to incur the >>>> overhead of setting up and running MariaDB/MySQL for a single-user >>>> environment. SQLite is light weight and self-contained. If you want to >>>> query it, you can install a client and muck around. >>>> >>>> Cheers! >>>> >>>> --- >>>> pablo >>>> >>>> >>>> >>>> On 2025-08-24 15:25, Tom Keffer wrote: >>>> >>>> Another user reported a similar problem >>>> <https://groups.google.com/g/weewx-user/c/pbDm1jFNkwQ/m/EvqWMwaqAQAJ> last >>>> year. The point of commonality is MariaDB running on Windows. >>>> >>>> This is not a configuration that I can recreate (nor is it supported). >>>> I suspect the problem has something to do with the case-insensitive nature >>>> of Windows, but I don't really know. >>>> >>>> Unless you have some compelling reason to use MariaDB (or MySQL), I >>>> would strongly suggest that you just use sqlite3. >>>> >>>> -tk >>>> >>>> >>>> On Sun, Aug 24, 2025 at 12:09 PM tommy Teague <[email protected]> >>>> wrote: >>>> >>>>> Howdy >>>>> >>>>> Newbie here. Recently found and installed weewx to connect to Acurite >>>>> 5n1 USB display >>>>> Everything is working except the reports have a couple issues. >>>>> >>>>> weewx 5.1 running on rpi zero 2 w - Ubuntu Server 24.04.3 LTS fully >>>>> updated >>>>> MariaDB 10.11.2 running on Windows 11 >>>>> weewx.conf setup to connect to mysql using ID/PW: weewx/weewx >>>>> >>>>> On the monthly report I'm seeing: >>>>> >>>>> 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 87.6 96.0 >>>>> 15:30 >>>>> 75.2 00:00 $day.heatdeg.sum.format($Temp,$NONE,add_label=False) >>>>> $day.cooldeg.sum.format($Temp,$NONE,add_label=False) 0.00 3.3 9.9 12:49 0 >>>>> 21 82.9 100.3 16:40 71.8 06:50 >>>>> $day.heatdeg.sum.format($Temp,$NONE,add_label=False) >>>>> $day.cooldeg.sum.format($Temp,$NONE,add_label=False) 0.00 1.5 11.4 19:45 >>>>> 292 22 79.4 93.6 14:50 72.1 05:30 >>>>> $day.heatdeg.sum.format($Temp,$NONE,add_label=False) >>>>> $day.cooldeg.sum.format($Temp,$NONE,add_label=False) 0.00 1.1 10.4 16:35 >>>>> 14 >>>>> 23 77.4 89.9 12:05 73.9 13:20 >>>>> $day.heatdeg.sum.format($Temp,$NONE,add_label=False) >>>>> $day.cooldeg.sum.format($Temp,$NONE,add_label=False) 1.70 1.0 9.9 17:03 >>>>> 90 >>>>> 24 76.3 89.8 14:30 70.3 07:05 >>>>> $day.heatdeg.sum.format($Temp,$NONE,add_label=False) >>>>> $day.cooldeg.sum.format($Temp,$NONE,add_label=False) 0.03 2.2 8.3 11:42 >>>>> 354 >>>>> >>>>> On the yearly report I'm seeing: >>>>> >>>>> MEAN MEAN DEG DEG >= <= <= <= YR MO MAX MIN MEAN DAYS DAYS HI DAY LOW >>>>> DAY 90 32 32 0 >>>>> ------------------------------------------------------------------------------------------------ >>>>> >>>>> 2025 01 2025 02 2025 03 2025 04 2025 05 2025 06 2025 07 2025 08 >>>>> $month.outTemp.meanmax.format($Temp,$NONE,add_label=False) >>>>> $month.outTemp.meanmin.format($Temp,$NONE,add_label=False) 80.5 >>>>> $month.heatdeg.sum.format($Temp,$NONE,add_label=False) >>>>> $month.cooldeg.sum.format($Temp,$NONE,add_label=False) 100.3 21 70.3 24 >>>>> $month.outTemp.max_ge($Hot).format($Count,$NONE,add_label=False) >>>>> $month.outTemp.max_le($Cold).format($Count,$NONE,add_label=False) >>>>> $month.outTemp.min_le($Cold).format($Count,$NONE,add_label=False) >>>>> $month.outTemp.min_le($VeryCold).format($Count,$NONE,add_label=False) >>>>> 2025 >>>>> 09 2025 10 2025 11 2025 12 >>>>> ------------------------------------------------------------------------------------------------ >>>>> >>>>> $year.outTemp.meanmax.format($Temp,$NONE,add_label=False) >>>>> $year.outTemp.meanmin.format($Temp,$NONE,add_label=False) 80.5 >>>>> $year.heatdeg.sum.format($Temp,$NONE,add_label=False) >>>>> $year.cooldeg.sum.format($Temp,$NONE,add_label=False) 100.3 Aug 70.3 Aug >>>>> $year.outTemp.max_ge($Hot).format($Count,$NONE,add_label=False) >>>>> $year.outTemp.max_le($Cold).format($Count,$NONE,add_label=False) >>>>> $year.outTemp.min_le($Cold).format($Count,$NONE,add_label=False) >>>>> $year.outTemp.min_le($VeryCold).format($Count,$NONE,add_label=False) >>>>> Any fixes for these items? >>>>> Regards, >>>>> Tommy >>>>> -- >>>>> 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/71b7628d-6a56-4dfe-81cb-1937db075e12n%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/71b7628d-6a56-4dfe-81cb-1937db075e12n%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/CAPq0zEB%2B%2BHHAtExoacTem8d-LF29E8yKdfXWncLwd9VQh7aeYA%40mail.gmail.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEB%2B%2BHHAtExoacTem8d-LF29E8yKdfXWncLwd9VQh7aeYA%40mail.gmail.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/2e4152d6-2d5d-4a50-94b3-92072e27be17%40hillsandlakes.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/2e4152d6-2d5d-4a50-94b3-92072e27be17%40hillsandlakes.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/3379112e-55d9-4043-ad31-2bd18ee46f1bn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/3379112e-55d9-4043-ad31-2bd18ee46f1bn%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/0c42505e-a3cc-46fd-a2b1-aab792b26845n%40googlegroups.com.
