do I also need to change the rainRate in the database to the latest value, 15.6mm also today, or since it is a new day, it falls back to 0mm?
Markus Lösch schrieb am Donnerstag, 5. Juni 2025 um 15:13:38 UTC+2: > thanks for that explanation, I currently tried it with the sqlitebrowser, > but when I want to open the database, I receive the following error: > > > > > > > > > *sudo sqlitebrowser /var/lib/weewx/weewx.sdbqt.qpa.xcb: could not connect > to displayqt.qpa.plugin: Could not load the Qt platform plugin "xcb" in "" > even though it was found.This application failed to start because no Qt > platform plugin could be initialized. Reinstalling the application may fix > this problem.Available platform plugins are: eglfs, linuxfb, minimal, > minimalegl, offscreen, vnc, xcb.Aborted* > > > I copied the database on my windows machine and opened it with "DB Browser > for SQLite" and checked the fields rain and rainRate in the table "archive" > > [image: sqlite_browser.PNG] > > [image: export_csv.PNG] > here I can insert the values manually according to the exported csv. > > I think it takes me more then one intervall (5 Minutes) to insert all the > values. > I would think the best thing is to stop weewx after the latest intervall, > insert all the values, copy the file back, start weewx again. > > after that I run > weectl database rebuild-daily --date=2025-06-04 that the database is > rebuild for yesterday. > > would that be the right thing to do? > > > Rainer Lang schrieb am Donnerstag, 5. Juni 2025 um 12:07:41 UTC+2: > >> if it's only rain data from yesterday, you can look them up in your >> dashboard at ecowitt.net - assuming you have your console post there >> And then I would install sqlitebrowser (unless it's already part of your >> Linux installation) and edit and save the data directly in the database >> (make a safety copy of the database before 😉) >> >> try >> >> sudo sqlitebrowser /var/lib/weewx/weewx.sdb >> >> or whatever is your weewx database location >> (you have to open it with root rights, otherwise you will not be able to >> change fields) >> >> if it's not included, install it first >> >> sudo apt install sqlitebrowser (assuming apt is your package manager) >> >> find your time (it's EPOCH format - maybe ww.epochconverter.com would be >> helpful) - locate the rain and rainrate fields and change then accordingly >> - hint: for changed dsts to be accepted, you have to click with the mouse >> into another field >> >> Make sure that you save your changes between weewx dabatase activities - >> let's between minute 2 and 4 of your (assumed) 5 minute weewx archiving >> cycle >> e.g. weewx archives at xx:00, xx:05, xx:10 etc. - you save your sqlite >> browser changes at xx:02 - xx:04 etc. - not to interfere with weewx >> or >> once you have done the changes, shutdown weewx after the archiving, save >> your sqlitebrowser changes and restart weewx >> >> you will have to rebuild the database indexes for yesterday for the data >> to become visible in your skin (--> weectl database) >> >> >> On 05.06.2025 11:25, Markus Lösch wrote: >> >> Thanks Rainer, I disabled now the customized server also. At least, it >> seems to run pretty good now with the GW1000 Driver, I also had some >> entries in the database, so I wait for the next rain and see if it is >> working properly. >> >> I will have a look at it, it is quite huge and a lot to read, but when I >> do have some time in the evening, I will do it ;) >> >> >> But if you can maybe answer me my question, if it is possible to import >> the missing rain data of yesterday, and if there is any extension needed, >> that would be appreciated :-) >> >> Rainer Lang schrieb am Donnerstag, 5. Juni 2025 um 09:25:41 UTC+2: >> >>> if you take the time to read the Ecowitt WiKi >>> >>> >>> https://meshka.eu/Ecowitt/dokuwiki/doku.php?id=start#data_flow_between_sensors_consoles_application_software_and_internet_weather_services >>> to understand how Ecowitt (clone) consoles communicate >>> >>> and also the weewx chapter in the Ecowitt WiKi >>> >>> https://meshka.eu/Ecowitt/dokuwiki/doku.php?id=dataloggers#weewx >>> you will get a better understanding of what you are doing and what you >>> have to do >>> also where (and how) to store your rain data >>> there are several ways/options how to do this >>> >>> in short >>> 1. you don't need the customized server when using the local Ecowitt API >>> driver (a.k.a. GW1000 driver) >>> 2. there is also an extended version of the Interceptor driver which >>> even provides data the local Ecowitt API driver does not (and cannot) >>> provide. >>> The "bare-metal" version of the Interceptor driver as available in >>> Matthews repository is hopeless with a modern Ecowitt station and needs >>> quite a few adaptations >>> which a German developer has thankfully made and it works perfectly. >>> 3. there are several advantages to using the GW1000 drivers, especially >>> to catch correct data as the customized server posting is (downward) >>> limited to 8 seconds, >>> whereas the local Ecowitt API driver can theoretically poll data on a >>> one-second basis if this is wanted and considered to provide added value. >>> On 05.06.2025 09:09, Markus Lösch wrote: >>> >>> oh and another question I forgot to ask... >>> I set the customizued server to enabled for the Interceptor Driver. Now, >>> I assume, for the GW1000 driver it is not needed anymore, right ? >>> >>> Markus Lösch schrieb am Donnerstag, 5. Juni 2025 um 09:06:05 UTC+2: >>> >>>> Thanks guys, I switched now to GW1000 Driver. Test driver also seems to >>>> be looking quite good. >>>> >>>> Is there any chance to add the rain data in the database? I had 15.3mm >>>> rain yesterday, which is also the week, month and year totatl, since I >>>> started the weather station on tuesday night. >>>> [image: rain.PNG] >>>> >>>> >>>> vince schrieb am Mittwoch, 4. Juni 2025 um 23:08:17 UTC+2: >>>> >>>> In case you switch to the nice gw1000 driver via Ian's link, here's my >>>> old config for my WS85 which is similar to your WS90, as well as the >>>> incantation to test the driver interactively. Be a little forewarned this >>>> was quite a while ago and I decommissioned the ecowitt haptic sensor >>>> because it wasn't too accurate, but the weewx setup did work as I recall. >>>> Your paths vs. the example --test-driver below will vary if you did a >>>> dpkg >>>> installation. >>>> >>>> [GW1000] >>>> # This section is for the Ecowitt Gateway driver. >>>> >>>> # How often to poll the API, default is every 20 seconds: >>>> poll_interval = 20 >>>> >>>> # The driver to use: >>>> driver = user.gw1000 >>>> ip_address = 192.168.2.87 # gw1200 >>>> port = 45000 >>>> [[field_map_extensions]] >>>> outTempBatteryStatus = wh26_batt >>>> batteryStatus1 = wh31_ch1__batt >>>> batteryStatus2 = wh31_ch2__batt >>>> batteryStatus3 = wh31_ch3__batt >>>> batteryStatus4 = wh31_ch4__batt >>>> batteryStatus5 = wh31_ch5__batt >>>> batteryStatus8 = wh51_ch1__batt >>>> soilTemp1 = temp9 # wh34 >>>> ######batteryStatus8 = wh34_ch1__batt >>>> rain = p_rain >>>> stormRain = p_rainevent >>>> rainRate = p_rainrate >>>> dayRain = p_rainday >>>> weekRain = p_rainweek >>>> monthRain = p_rainmonth >>>> yearRain = p_rainyear >>>> >>>> windBatteryStatus = ws85_batt >>>> >>>> # PYTHONPATH=~/weewx/src python3 >>>> ~/weewx-data/bin/user/gw1000.py --test-driver --ip-address=192.168.2.87 >>>> # 2024-08-30 11:01:19 PDT (1725040879): 'dateTime': >>>> '1725040879', 'daymaxwind': '2.9', 'extraHumid1': '56', 'extraHumid2': >>>> '54', 'extraHumid3': '56', 'extraHumid4': '59', 'extraHumid5': '70', >>>> 'extraTemp1': '23.3', 'extraTemp2': '22.2', 'extraTemp3': '22.1', >>>> 'extraTemp4': '22.0', 'extraTemp5': '21.8', 'extraTemp9': '17.8', >>>> 'inHumidity': '53', 'inTemp': '22.5', 'outHumidity': '77', 'outTemp': >>>> '19.5', 'p_dayRain': '0.0', 'p_monthRain': '34.3', 'p_rain': 'None', >>>> 'p_rainRate': '0.0', 'p_stormRain': '0.0', 'p_weekRain': '1.0', >>>> 'p_yearRain': '42.4', 'pressure': '1006.5', 'relbarometer': '1006.5', >>>> 'soilMoist1': '41', 'usUnits': '17', 'wh31_ch1_batt': '0', 'wh31_ch1_sig': >>>> '4', 'wh31_ch2_batt': '0', 'wh31_ch2_sig': '4', 'wh31_ch3_batt': '0', >>>> 'wh31_ch3_sig': '4', 'wh31_ch4_batt': '0', 'wh31_ch4_sig': '4', >>>> 'wh31_ch5_batt': '0', 'wh31_ch5_sig': '4', 'wh32_batt': '0', 'wh32_sig': >>>> '4', 'wh51_ch1_batt': '1.4', 'wh51_ch1_sig': '4', 'windDir': '280', >>>> 'windGust': '1.2', 'windSpeed': '1.1', 'wn34_ch1_batt': '1.5', >>>> 'wn34_ch1_sig': '4', 'ws85_batt': '3.08', 'ws85_sig': '4' >>>> >>>> >>>> On Wednesday, June 4, 2025 at 2:01:24 PM UTC-7 Steeple Ian wrote: >>>> >>>> There is a fork of the GW1000 driver here which was synced with Gary's >>>> main branch just before he went 'off air'. It is a better bet than the >>>> Interceptor driver. I have GW1000, GW2000 and GW3000 devices and they all >>>> wrk perfectly. >>>> >>>> https://github.com/Millardiang/weewx-gw1000 >>>> >>>> On Wednesday, June 4, 2025 at 10:37:53 PM UTC+2 Markus Lösch wrote: >>>> >>>> Also after some rain now, nothing shows up at rain. There is also >>>> nothing written down in the database… >>>> Anyone that can help? >>>> >>>> chin0x schrieb am Mittwoch, 4. Juni 2025 um 14:47:06 UTC+2: >>>> >>>> Hey guys, >>>> >>>> I've been going through some discussions but not quite sure if I did >>>> everything rigth. >>>> >>>> Due to the circumstances that the GW1000 Driver is all of a sudden not >>>> available anymore, I decided to use the Interceptor driver when I changed >>>> from "Simulation" to "Productive" mode yesterday evening. >>>> >>>> I found out that the rain is not available in the database and saw some >>>> discussions about it. >>>> What I now did was adding some values to the Interceptor Stanza in the >>>> weewx.conf: >>>> [Interceptor] >>>> driver = user.interceptor >>>> device_type = ecowitt-client >>>> port = 8000 >>>> [[sensor_map_extensions]] >>>> rain = drain_piezo >>>> rainRate = rrain_piezo >>>> supplyVoltage = wh90batt >>>> referenceVoltage = ws90cap_volt >>>> >>>> But it shows me no rain in my skins. Currently it is not raining, but >>>> there was rain this morning. Is the data only filling the actuall rain >>>> into >>>> the database or also the data from this morning? If not from this morning, >>>> how can I insert that data afterwards ? >>>> >>>> in the log it shows me the following entries: >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter runtime=80319 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter heap=94012 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter vpd=0.071 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter rrain_piezo=0.000 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter erain_piezo=0.157 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter hrain_piezo=0.008 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter drain_piezo=0.157 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter wrain_piezo=0.157 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter mrain_piezo=0.157 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter yrain_piezo=0.157 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter srain_piezo=1 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter ws90cap_volt=2.5 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter ws90_ver=155 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter wh90batt=3.14 >>>> Jun 4 14:46:10 weewx weewxd[1727]: INFO user.interceptor: unrecognized >>>> parameter interval=16 >>>> >>>> so rain is showing some values here... >>>> >>>> -- >>> 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/032b665e-e83b-48dc-90c9-dff2c1f781aen%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/032b665e-e83b-48dc-90c9-dff2c1f781aen%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/4bfbe008-6e49-4331-8d26-382520910d2dn%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/4bfbe008-6e49-4331-8d26-382520910d2dn%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/a7ecf5bb-7cdf-44fb-9bce-53acdfb335c0n%40googlegroups.com.
