We got some sustained rain this afternoon; rain&rainrate seems to be
missed. First column (rain and rainrate) from my production server, second
column (rain, rainrate) from WLLDriver v0.2. All rain&rainrate are zero,
although it did rain (first columns)
mysql> select
weewx.archive.datetime,from_unixtime(weewx.archive.datetime),weewx.archive.rain,weewxtest.archive.rain,weewx.archive.rainrate,weewxtest.archive.rainrate
from weewx.archive,weewxtest.archive where
weewx.archive.datetime=weewxtest.archive.datetime order by
weewx.archive.datetime desc limit 100;
+------------+---------------------------------------+---------------+------+--------------------+----------+
| datetime | from_unixtime(weewx.archive.datetime) | rain | rain
| rainrate | rainrate |
+------------+---------------------------------------+---------------+------+--------------------+----------+
| 1594228320 | 2020-07-08 19:12:00 | 0.19999999878 | 0
| 1.19999999268 | 0 |
| 1594228260 | 2020-07-08 19:11:00 | 0 | 0
| 1.19999999268 | 0 |
| 1594228200 | 2020-07-08 19:10:00 | 0 | 0
| 1.19999999268 | 0 |
| 1594228140 | 2020-07-08 19:09:00 | 0 | 0
| 1.39999999146 | 0 |
| 1594228080 | 2020-07-08 19:08:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594228020 | 2020-07-08 19:07:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594227960 | 2020-07-08 19:06:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594227900 | 2020-07-08 19:05:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594227840 | 2020-07-08 19:04:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594227780 | 2020-07-08 19:03:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594227720 | 2020-07-08 19:02:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594227660 | 2020-07-08 19:01:00 | 0.19999999878 | 0
| 1.79999998902 | 0 |
| 1594227600 | 2020-07-08 19:00:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594227540 | 2020-07-08 18:59:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594227480 | 2020-07-08 18:58:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594227420 | 2020-07-08 18:57:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594227360 | 2020-07-08 18:56:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594227300 | 2020-07-08 18:55:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594227240 | 2020-07-08 18:54:00 | 0.19999999878 | 0
| 1.9999999878 | 0 |
| 1594227180 | 2020-07-08 18:53:00 | 0 | 0
| 1.39999999146 | 0 |
| 1594227120 | 2020-07-08 18:52:00 | 0 | 0
| 1.39999999146 | 0 |
| 1594227060 | 2020-07-08 18:51:00 | 0 | 0
| 1.39999999146 | 0 |
| 1594227000 | 2020-07-08 18:50:00 | 0 | 0
| 1.39999999146 | 0 |
| 1594226940 | 2020-07-08 18:49:00 | 0 | 0
| 1.39999999146 | 0 |
| 1594226880 | 2020-07-08 18:48:00 | 0.19999999878 | 0
| 1.39999999146 | 0 |
| 1594226820 | 2020-07-08 18:47:00 | 0 | 0
| 1.39999999146 | 0 |
| 1594226760 | 2020-07-08 18:46:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594226700 | 2020-07-08 18:45:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594226640 | 2020-07-08 18:44:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594226580 | 2020-07-08 18:43:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594226520 | 2020-07-08 18:42:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594226460 | 2020-07-08 18:41:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594226400 | 2020-07-08 18:40:00 | 0.19999999878 | 0
| 1.59999999024 | 0 |
| 1594226340 | 2020-07-08 18:39:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594226280 | 2020-07-08 18:38:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594226220 | 2020-07-08 18:37:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594226160 | 2020-07-08 18:36:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594226100 | 2020-07-08 18:35:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594226040 | 2020-07-08 18:34:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594225980 | 2020-07-08 18:33:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594225920 | 2020-07-08 18:32:00 | 0.19999999878 | 0
| 2.19999998658 | 0 |
| 1594225860 | 2020-07-08 18:31:00 | 0 | 0
| 2.19999998658 | 0 |
| 1594225800 | 2020-07-08 18:30:00 | 0 | 0
| 2.59999998414 | 0 |
| 1594225740 | 2020-07-08 18:29:00 | 0 | 0
| 2.59999998414 | 0 |
| 1594225680 | 2020-07-08 18:28:00 | 0 | 0
| 2.59999998414 | 0 |
| 1594225620 | 2020-07-08 18:27:00 | 0 | 0
| 2.59999998414 | 0 |
| 1594225560 | 2020-07-08 18:26:00 | 0.19999999878 | 0
| 2.59999998414 | 0 |
| 1594225500 | 2020-07-08 18:25:00 | 0 | 0
| 0.9999999939 | 0 |
| 1594225440 | 2020-07-08 18:24:00 | 0 | 0
| 0.9999999939 | 0 |
| 1594225380 | 2020-07-08 18:23:00 | 0 | 0
| 0.9999999939 | 0 |
| 1594225320 | 2020-07-08 18:22:00 | 0.19999999878 | 0
| 0.9999999939 | 0 |
| 1594225260 | 2020-07-08 18:21:00 | 0 | 0
| 0.9999999939 | 0 |
| 1594225200 | 2020-07-08 18:20:00 | 0 | 0
| 0.9999999939 | 0 |
| 1594225140 | 2020-07-08 18:19:00 | 0 | 0
| 1.19999999268 | 0 |
| 1594225080 | 2020-07-08 18:18:00 | 0 | 0
| 1.19999999268 | 0 |
| 1594225020 | 2020-07-08 18:17:00 | 0 | 0
| 1.39999999146 | 0 |
| 1594224960 | 2020-07-08 18:16:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594224900 | 2020-07-08 18:15:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594224840 | 2020-07-08 18:14:00 | 0 | 0
| 2.19999998658 | 0 |
| 1594224780 | 2020-07-08 18:13:00 | 0 | 0
| 2.79999998292 | 0 |
| 1594224720 | 2020-07-08 18:12:00 | 0 | 0
| 2.79999998292 | 0 |
| 1594224660 | 2020-07-08 18:11:00 | 0 | 0
| 2.79999998292 | 0 |
| 1594224600 | 2020-07-08 18:10:00 | 0 | 0
| 2.79999998292 | 0 |
| 1594224540 | 2020-07-08 18:09:00 | 0.19999999878 | 0
| 3.19999998048 | 0 |
| 1594224480 | 2020-07-08 18:08:00 | 0 | 0
| 3.19999998048 | 0 |
| 1594224420 | 2020-07-08 18:07:00 | 0 | 0
| 4.39999997316 | 0 |
| 1594224360 | 2020-07-08 18:06:00 | 0 | 0
| 4.59999997194 | 0 |
| 1594224300 | 2020-07-08 18:05:00 | 0.19999999878 | 0
| 4.59999997194 | 0 |
| 1594224240 | 2020-07-08 18:04:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594224180 | 2020-07-08 18:03:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594224120 | 2020-07-08 18:02:00 | 0.19999999878 | 0
| 2.19999998658 | 0 |
| 1594224060 | 2020-07-08 18:01:00 | 0 | 0
| 2.19999998658 | 0 |
| 1594224000 | 2020-07-08 18:00:00 | 0 | 0
| 2.79999998292 | 0 |
| 1594223940 | 2020-07-08 17:59:00 | 0 | 0
| 3.7999999768199997 | 0 |
| 1594223880 | 2020-07-08 17:58:00 | 0 | 0
| 4.39999997316 | 0 |
| 1594223820 | 2020-07-08 17:57:00 | 0.19999999878 | 0
| 4.39999997316 | 0 |
| 1594223760 | 2020-07-08 17:56:00 | 0 | 0
| 4.39999997316 | 0 |
| 1594223700 | 2020-07-08 17:55:00 | 0 | 0
| 3.19999998048 | 0 |
| 1594223640 | 2020-07-08 17:54:00 | 0.19999999878 | 0
| 3.19999998048 | 0 |
| 1594223580 | 2020-07-08 17:53:00 | 0 | 0
| 3.19999998048 | 0 |
| 1594223520 | 2020-07-08 17:52:00 | 0 | 0
| 3.19999998048 | 0 |
| 1594223460 | 2020-07-08 17:51:00 | 0 | 0
| 3.19999998048 | 0 |
| 1594223400 | 2020-07-08 17:50:00 | 0.19999999878 | 0
| 3.19999998048 | 0 |
| 1594223340 | 2020-07-08 17:49:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594223280 | 2020-07-08 17:48:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594223220 | 2020-07-08 17:47:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594223160 | 2020-07-08 17:46:00 | 0.19999999878 | 0
| 1.79999998902 | 0 |
| 1594223100 | 2020-07-08 17:45:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594223040 | 2020-07-08 17:44:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594222980 | 2020-07-08 17:43:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594222920 | 2020-07-08 17:42:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594222860 | 2020-07-08 17:41:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594222800 | 2020-07-08 17:40:00 | 0.19999999878 | 0
| 1.59999999024 | 0 |
| 1594222740 | 2020-07-08 17:39:00 | 0 | 0
| 1.59999999024 | 0 |
| 1594222680 | 2020-07-08 17:38:00 | 0 | 0
| 1.79999998902 | 0 |
| 1594222620 | 2020-07-08 17:37:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594222560 | 2020-07-08 17:36:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594222500 | 2020-07-08 17:35:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594222440 | 2020-07-08 17:34:00 | 0 | 0
| 1.9999999878 | 0 |
| 1594222380 | 2020-07-08 17:33:00 | 0 | 0
| 1.9999999878 | 0 |
+------------+---------------------------------------+---------------+------+--------------------+----------+
100 rows in set (0.01 sec)
Op woensdag 8 juli 2020 om 15:57:34 UTC+2 schreef Maarten van der Hoeven:
> Okay, got v0.2 running now. My weewx.conf stanza shows (ISS on ID=2,
> extratemp1 on ID=3).
> [WLLDriver]
> driver = user.WLLDriver
> max_tries = 5
> retry_wait = 5
> poll_interval = 5
> udp_enable = 1
> hostname = 192.168.2.33
> wl_apikey = nivwsekqwfbkhqtqwo8nximhl7zgxpcs
> wl_apisecret = *secret*
> wl_stationid = 92884
> time_out = 10
> device_id = 2:iss-3:extraTemp1
>
> Output MySQL:
> mysql> select
> datetime,from_unixtime(datetime),outtemp,windspeed,windgust,radiation,uv,et,rain,rainrate,extratemp1
>
> from weewxtest.archive order by datetime des
> c limit 5;
>
> +------------+-------------------------+--------------------+-----------+----------+-----------+------+------+------+----------+------------+
> | datetime | from_unixtime(datetime) | outtemp | windspeed |
> windgust | radiation | uv | et | rain | rainrate | extratemp1 |
>
> +------------+-------------------------+--------------------+-----------+----------+-----------+------+------+------+----------+------------+
> | 1594216440 | 2020-07-08 15:54:00 | 16.11111111111111 | NULL
> | NULL | NULL | NULL | NULL | 0 | 0 | NULL |
> | 1594216380 | 2020-07-08 15:53:00 | 16.180555555555557 | NULL
> | NULL | NULL | NULL | NULL | 0 | 0 | NULL |
> | 1594216320 | 2020-07-08 15:52:00 | 16.11111111111111 | NULL
> | NULL | NULL | NULL | NULL | 0 | 0 | NULL |
> | 1594216260 | 2020-07-08 15:51:00 | 16.097222222222225 | NULL
> | NULL | NULL | NULL | NULL | 0 | 0 | NULL |
> | 1594216200 | 2020-07-08 15:50:00 | 16.055555555555557 | NULL
> | NULL | NULL | NULL | NULL | 0 | 0 | NULL |
>
> +------------+-------------------------+--------------------+-----------+----------+-----------+------+------+------+----------+------------+
>
> 5 rows in set (0.00 sec)
>
>
> Console output (syslog):
> Jul 8 15:49:31 ubuntu weewx[3696] DEBUG user.WLLDriver: Packet received
> from WLL module {'dateTime': 1594216170, 'usUnits': 1, 'outTemp': 60.9,
> 'outHumidity': 94.4, 'dewpoint': 57.7, 'heatindex': 59.7, 'windchill':
> 59.3, 'windSpeed': None, 'windDir': None, 'windGust': None, 'windGustDir':
> None, 'barometer': 29.998, 'pressure': 29.986, 'inTemp': 70.4,
> 'inHumidity': 60.9, 'inDewpoint': 56.3}:
> Jul 8 15:49:31 ubuntu weewx[3696] INFO weewx.restx: MQTT: Published
> record 2020-07-08 15:49:30 CEST (1594216170)
> Jul 8 15:49:33 ubuntu weewx[3696] DEBUG user.WLLDriver: Rain rightnow is
> :0.0
> Jul 8 15:49:33 ubuntu weewx[3696] DEBUG user.WLLDriver: Set previous
> period rain to: 0
> Jul 8 15:49:33 ubuntu weewx[3696] DEBUG user.WLLDriver: Packet received
> from WLL module {'dateTime': 1594216173, 'usUnits': 1, 'windSpeed': None,
> 'windDir': None, 'windGust': None, 'windGustDir': None, 'rain': 0.0,
> 'rainRate': 0.0}:
> Jul 8 15:49:33 ubuntu weewx[3696] INFO weewx.restx: MQTT: Published
> record 2020-07-08 15:49:33 CEST (1594216173)
> Jul 8 15:49:36 ubuntu weewx[3696] DEBUG user.WLLDriver: Rain rightnow is
> :0.0
> Jul 8 15:49:36 ubuntu weewx[3696] DEBUG user.WLLDriver: Set previous
> period rain to: 0
> Jul 8 15:49:36 ubuntu weewx[3696] DEBUG user.WLLDriver: Packet received
> from WLL module {'dateTime': 1594216175, 'usUnits': 1, 'windSpeed': None,
> 'windDir': None, 'windGust': None, 'windGustDir': None, 'rain': 0.0,
> 'rainRate': 0.0}:
>
> Findings:
> Windspeed, windgust, UV, radiation, et, extratemp1 remain NULL
>
> JSON output of current conditions attached
>
>
>
> Op woensdag 8 juli 2020 om 12:52:19 UTC+2 schreef [email protected]:
>
>> Hi,
>>
>> Thank for your feadback.
>>
>> I pushed the v0.2 in my github. You can install it by using wee_extension
>> : https://github.com/Drealine/WLLDriver/releases/tag/0.2
>>
>> Le mardi 7 juillet 2020 à 13:52:34 UTC+2, [email protected] a écrit :
>>
>>> Rain and rainrate goes askew. First column (rain, rainrate) coming from
>>> production (weewx with Weatherlink IP, running for years), second column
>>> (rain,rainrate) coming from weewxtest (WLLArchive).
>>>
>>> mysql> select
>>> from_unixtime(weewx.archive.datetime),weewx.archive.rain,weewxtest.archive.rain,weewx.archive.rainrate,weewxtest.archive.rainrate
>>>
>>> from weewx.archive,weewxtest.archive where
>>> weewx.archive.datetime=weewxtest.archive.datetime
>>> and from_unixtime(weewx.archive.datetime) like '2020-07-06%' and
>>> weewx.archive.rainrate > 0 and weewxtest.archive.rainrate >= 0 limit 100;
>>>
>>> +---------------------------------------+---------------+------+--------------------+----------+
>>> | from_unixtime(weewx.archive.datetime) | rain | rain |
>>> rainrate | rainrate |
>>>
>>> +---------------------------------------+---------------+------+--------------------+----------+
>>> | 2020-07-06 09:25:00 | 0.19999999878 | 0.6 |
>>> 5.7999999646200004 | 11 |
>>> | 2020-07-06 09:30:00 | 0 | 0 |
>>> 1.9999999878 | 5.6 |
>>> | 2020-07-06 09:35:00 | 0 | 0 |
>>> 0.9999999939 | 2 |
>>> | 2020-07-06 09:40:00 | 0 | 0 |
>>> 0.79999999512 | 1 |
>>> | 2020-07-06 11:30:00 | 0.19999999878 | 0.8 |
>>> 9.59999994144 | 12.4 |
>>> | 2020-07-06 11:35:00 | 0 | 0.6 |
>>> 5.19999996828 | 27.8 |
>>> | 2020-07-06 11:40:00 | 0 | 0 |
>>> 1.79999998902 | 5.2 |
>>> | 2020-07-06 11:45:00 | 0 | 0 |
>>> 0.9999999939 | 1.6 |
>>> | 2020-07-06 11:50:00 | 0 | 0 |
>>> 0.79999999512 | 1 |
>>> | 2020-07-06 12:45:00 | 0 | 0.4 |
>>> 4.79999997072 | 4.8 |
>>> | 2020-07-06 12:50:00 | 0 | 0 |
>>> 1.59999999024 | 4.8 |
>>> | 2020-07-06 12:55:00 | 0 | 0 |
>>> 0.9999999939 | 1.6 |
>>> | 2020-07-06 13:30:00 | 0.19999999878 | 0.8 |
>>> 24.39999985116 | 24.4 |
>>> | 2020-07-06 13:35:00 | 0.19999999878 | 2.8 |
>>> 16.9999998963 | 128 |
>>> | 2020-07-06 13:40:00 | 0 | 0.4 |
>>> 3.9999999756 | 16 |
>>> | 2020-07-06 13:45:00 | 0 | 0 |
>>> 1.39999999146 | 3.6 |
>>> | 2020-07-06 13:50:00 | 0 | 0 |
>>> 0.9999999939 | 1.4 |
>>> | 2020-07-06 15:00:00 | 0.19999999878 | 0.6 |
>>> 16.39999989996 | 16.4 |
>>> | 2020-07-06 15:05:00 | 0 | 0.6 |
>>> 3.3999999792600004 | 30.8 |
>>> | 2020-07-06 15:10:00 | 0 | 0 |
>>> 1.39999999146 | 3.2 |
>>> | 2020-07-06 15:15:00 | 0 | 0 |
>>> 0.79999999512 | 1.4 |
>>>
>>> +---------------------------------------+---------------+------+--------------------+----------+
>>> 21 rows in set (0.86 sec)
>>>
>>>
>>> Op dinsdag 7 juli 2020 om 12:12:57 UTC+2 schreef Maarten van der Hoeven:
>>>
>>>> Same goes when records come from WLLDriver, same mismatch in
>>>> rounding/conversion
>>>>
>>>> mysql> select
>>>> from_unixtime(weewx.archive.datetime),weewx.archive.outtemp,weewxtest.archive.outtemp,weewx.archive.windspeed,weewxtest.archive.windspeed
>>>>
>>>> from weewx.archive,weewxtest.archive where
>>>> weewx.archive.datetime=weewxtest.archive.datetime and
>>>> from_unixtime(weewx.archive.datetime) like '2020-07-07 12%' and
>>>> weewxtest.archive.outtemp > -100 limit 10;
>>>>
>>>> +---------------------------------------+--------------------+--------------------+-----------+--------------------+
>>>>
>>>> | from_unixtime(weewx.archive.datetime) | outtemp |
>>>> outtemp | windspeed | windspeed |
>>>>
>>>> +---------------------------------------+--------------------+--------------------+-----------+--------------------+
>>>> | 2020-07-07 12:00:00 | 16.77777777777778
>>>> | 16.72 | 4.4704 | 4.729354838709677 |
>>>> | 2020-07-07 12:01:00 | 16.72222222222222 |
>>>> 16.714444444444446 | 4.02336 | 4.171818181818182 |
>>>> | 2020-07-07 12:02:00 | 16.72222222222222 |
>>>> 16.69142857142857 | 4.02336 | 4.038064516129032 |
>>>> | 2020-07-07 12:03:00 | 16.72222222222222
>>>> | 16.67 | 4.4704 | 4.577878787878787 |
>>>> | 2020-07-07 12:04:00 | 16.72222222222222
>>>> | 16.67 | 3.57632 | 3.422812499999999 |
>>>> | 2020-07-07 12:05:00 | 16.666666666666668
>>>> | 16.655 | 3.57632 | 3.7718749999999988 |
>>>> | 2020-07-07 12:06:00 | 16.72222222222222 |
>>>> 16.661428571428573 | 4.02336 | 3.648064516129032 |
>>>> | 2020-07-07 12:07:00 | 16.77777777777778 |
>>>> 16.69222222222222 | 4.4704 | 4.321515151515152 |
>>>> | 2020-07-07 12:08:00 | 16.88888888888889
>>>> | 16.7975 | 4.02336 | 4.036875 |
>>>> | 2020-07-07 12:09:00 | 17
>>>> | 16.9 | 4.91744 | 4.638125000000001 |
>>>>
>>>> +---------------------------------------+--------------------+--------------------+-----------+--------------------+
>>>> 10 rows in set (1.92 sec)
>>>>
>>>>
>>>> Op dinsdag 7 juli 2020 12:10:45 UTC+2 schreef Maarten van der Hoeven:
>>>>
>>>>> Did testing with WLLArchive.
>>>>>
>>>>> WLLArchive is picking up archived records, just from the point where
>>>>> records are missing.Thats good. I've stopped weewx for two days
>>>>> (weewxtest
>>>>> in my case, not production), and Weatherlink.com is queried to get the
>>>>> missing records.
>>>>>
>>>>> I see in mysql there's a mismatch in rounding, or perhaps typecasting
>>>>> between float and double. The first column (outtemp, windspeed) is from
>>>>> my
>>>>> production database (which I consider as correct, as this driver is live
>>>>> for several years now), the second column (outtemp, windspeed) is from my
>>>>> test-enviroment. Records shown are coming from WLLArchive. Maybe, not
>>>>> sure,
>>>>> this rounding-mismatched is cause by calculating temp (F->C) and
>>>>> windspeed
>>>>> (mph->m/s) within the driver itself (float? double?), instead of letting
>>>>> weewx doing the conversion. Whatever the case, I would prefer to skip the
>>>>> conversion withing the driver, and make use of the weewx-tooling thats
>>>>> available for unit-conversions. That makes is more stable, like, for
>>>>> example, I decided in the future to report my windspeed in km/h in stead
>>>>> of
>>>>> m/s. Now it's fixed in the driver to m/s, when using metricwx
>>>>>
>>>>> mysql> select
>>>>> from_unixtime(weewx.archive.datetime),weewx.archive.outtemp,weewxtest.archive.outtemp,weewx.archive.windspeed,weewxtest.archive.windspeed
>>>>>
>>>>> from weewx.archive,weewxtest.archive where
>>>>> weewx.archive.datetime=weewxtest.archive.datetime and
>>>>> from_unixtime(weewx.archive.datetime) like '2020-07-07%' and
>>>>> weewxtest.archive.outtemp > -100 limit 10;
>>>>>
>>>>> +---------------------------------------+--------------------+---------+-----------+-----------+
>>>>> | from_unixtime(weewx.archive.datetime) | outtemp | outtemp
>>>>> | windspeed | windspeed |
>>>>>
>>>>> +---------------------------------------+--------------------+---------+-----------+-----------+
>>>>> | 2020-07-07 00:00:00 | 11.38888888888889 | 11.33
>>>>> | 1.34112 | 1.39 |
>>>>> | 2020-07-07 00:05:00 | 11.38888888888889 | 11.33
>>>>> | 1.34112 | 1.2 |
>>>>> | 2020-07-07 00:10:00 | 11.38888888888889 | 11.33
>>>>> | 1.34112 | 1.53 |
>>>>> | 2020-07-07 00:15:00 | 11.333333333333334 | 11.28
>>>>> | 1.34112 | 1.62 |
>>>>> | 2020-07-07 00:20:00 | 11.333333333333334 | 11.28
>>>>> | 1.34112 | 1.26 |
>>>>> | 2020-07-07 00:25:00 | 11.277777777777777 | 11.22
>>>>> | 0.89408 | 0.92 |
>>>>> | 2020-07-07 00:30:00 | 11.222222222222223 | 11.17
>>>>> | 0.89408 | 1.09 |
>>>>> | 2020-07-07 00:35:00 | 11.166666666666666 | 11.11
>>>>> | 1.34112 | 1.26 |
>>>>> | 2020-07-07 00:40:00 | 11.11111111111111 | 11.06
>>>>> | 1.34112 | 1.23 |
>>>>> | 2020-07-07 00:45:00 | 11.11111111111111 | 11.06
>>>>> | 1.34112 | 1.28 |
>>>>>
>>>>> +---------------------------------------+--------------------+---------+-----------+-----------+
>>>>> 10 rows in set (0.88 sec)
>>>>>
>>>>>
>>>>> Op zondag 5 juli 2020 12:06:24 UTC+2 schreef [email protected]:
>>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> Yes I see. I put speed 2min on current_conditions, and UDP packet,
>>>>>> it's speed 10min.
>>>>>>
>>>>>> I fix it.
>>>>>> Thank's a lot.
>>>>>>
>>>>>> Le dimanche 5 juillet 2020 à 01:17:44 UTC+2, [email protected] a
>>>>>> écrit :
>>>>>>
>>>>>>> Updated the driver, thanks for that. Windspeed/-gust is much better
>>>>>>> now. However, I see some differences in the windgust, when it is within
>>>>>>> a
>>>>>>> UDP-packet and when it's within a current-condition-packet. Some piece
>>>>>>> of
>>>>>>> syslog, where I highlighted the difference in values. For what I
>>>>>>> understand, windgust is the max speed that occured in the last 2
>>>>>>> minutes.
>>>>>>> So I expect it to be the same when it's getting reported by UDP and
>>>>>>> current-conditions, at least within a timespan of two minutes...
>>>>>>>
>>>>>>> Jul 5 01:10:23 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet
>>>>>>> received from WLL module {'dateTime': 1593904223, 'usUnits': 17,
>>>>>>> 'outTemp':
>>>>>>> 18.11, 'outHumidity': 97.0, 'dewpoint': 17.61, 'heatindex': 19.06,
>>>>>>> 'windchill': 17.17, 'windSpeed': 3.58, 'windDir': 229, '*windGust':
>>>>>>> 6.71*, 'windGustDir': 224, 'barometer': 1009.89, 'pressure':
>>>>>>> 1009.49, 'rain': 0.0, 'rainRate': 0.0, 'inTemp': 21.5, 'inHumidity':
>>>>>>> 71.1,
>>>>>>> 'inDewpoint': 16.06}:
>>>>>>> Jul 5 01:10:23 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published
>>>>>>> record 2020-07-05 01:10:23 CEST (1593904223)
>>>>>>> Jul 5 01:10:26 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this
>>>>>>> period: 0.0
>>>>>>> Jul 5 01:10:26 ubuntu weewx[4508] DEBUG user.WLLDriver: Set
>>>>>>> Previous period rain to: 3
>>>>>>> Jul 5 01:10:26 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet
>>>>>>> received from WLL module {'dateTime': 1593904225, 'usUnits': 17,
>>>>>>> 'windSpeed': 4.02, 'windDir': 229,* 'windGust': 7.15,*
>>>>>>> 'windGustDir': 249, 'rain': 0.0, 'rainRate': 0.0}:
>>>>>>> Jul 5 01:10:26 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published
>>>>>>> record 2020-07-05 01:10:25 CEST (1593904225)
>>>>>>> Jul 5 01:10:28 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this
>>>>>>> period: 0.0
>>>>>>> Jul 5 01:10:28 ubuntu weewx[4508] DEBUG user.WLLDriver: Set
>>>>>>> Previous period rain to: 3
>>>>>>> Jul 5 01:10:28 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet
>>>>>>> received from WLL module {'dateTime': 1593904228, 'usUnits': 17,
>>>>>>> 'windSpeed': 5.36, 'windDir': 217, *'windGust': 7.15**,*
>>>>>>> 'windGustDir': 249, 'rain': 0.0, 'rainRate': 0.0}:
>>>>>>> Jul 5 01:10:28 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published
>>>>>>> record 2020-07-05 01:10:28 CEST (1593904228)
>>>>>>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this
>>>>>>> period: 0.0
>>>>>>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG user.WLLDriver: Set
>>>>>>> Previous period rain to: 3
>>>>>>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet
>>>>>>> received from WLL module {'dateTime': 1593904230, 'usUnits': 17,
>>>>>>> 'windSpeed': 5.81, 'windDir': 232, 'windGust': 7.15, 'windGustDir':
>>>>>>> 249, 'rain': 0.0, 'rainRate': 0.0}:
>>>>>>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG urllib3.connectionpool:
>>>>>>> Starting new HTTP connection (1): 192.168.2.33:80
>>>>>>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG urllib3.connectionpool:
>>>>>>> http://192.168.2.33:80 "GET /v1/current_conditions HTTP/1.1" 200
>>>>>>> None
>>>>>>> Jul 5 01:10:31 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published
>>>>>>> record 2020-07-05 01:10:30 CEST (1593904230)
>>>>>>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this
>>>>>>> period: 0.0
>>>>>>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG user.WLLDriver: Set
>>>>>>> Previous period rain to: 3
>>>>>>> Jul 5 01:10:31 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet
>>>>>>> received from WLL module {'dateTime': 1593904230, 'usUnits': 17,
>>>>>>> 'outTemp':
>>>>>>> 18.11, 'outHumidity': 97.0, 'dewpoint': 17.61, 'heatindex': 19.06,
>>>>>>> 'windchill': 17.17, 'windSpeed': 5.81, 'windDir': 232,* 'windGust':
>>>>>>> 6.71*, 'windGustDir': 224, 'barometer': 1009.89, 'pressure':
>>>>>>> 1009.49, 'rain': 0.0, 'rainRate': 0.0, 'inTemp': 21.5, 'inHumidity':
>>>>>>> 71.1,
>>>>>>> 'inDewpoint': 16.06}:
>>>>>>> Jul 5 01:10:31 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published
>>>>>>> record 2020-07-05 01:10:30 CEST (1593904230)
>>>>>>> Jul 5 01:10:33 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this
>>>>>>> period: 0.0
>>>>>>> Jul 5 01:10:33 ubuntu weewx[4508] DEBUG user.WLLDriver: Set
>>>>>>> Previous period rain to: 3
>>>>>>> Jul 5 01:10:33 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet
>>>>>>> received from WLL module {'dateTime': 1593904233, 'usUnits': 17,
>>>>>>> 'windSpeed': 5.36, 'windDir': 225, *'windGust': 7.15*,
>>>>>>> 'windGustDir': 249, 'rain': 0.0, 'rainRate': 0.0}:
>>>>>>> Jul 5 01:10:33 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published
>>>>>>> record 2020-07-05 01:10:33 CEST (1593904233)
>>>>>>> Jul 5 01:10:36 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this
>>>>>>> period: 0.0
>>>>>>> Jul 5 01:10:36 ubuntu weewx[4508] DEBUG user.WLLDriver: Set
>>>>>>> Previous period rain to: 3
>>>>>>> Jul 5 01:10:36 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet
>>>>>>> received from WLL module {'dateTime': 1593904235, 'usUnits': 17,
>>>>>>> 'windSpeed': 4.02, 'windDir': 225, *'windGust': 7.15*,
>>>>>>> 'windGustDir': 249, 'rain': 0.0, 'rainRate': 0.0}:
>>>>>>> Jul 5 01:10:36 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published
>>>>>>> record 2020-07-05 01:10:35 CEST (1593904235)
>>>>>>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this
>>>>>>> period: 0.0
>>>>>>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG user.WLLDriver: Set
>>>>>>> Previous period rain to: 3
>>>>>>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet
>>>>>>> received from WLL module {'dateTime': 1593904238, 'usUnits': 17,
>>>>>>> 'windSpeed': 3.58, 'windDir': 227, *'windGust': 7.15*,
>>>>>>> 'windGustDir': 249, 'rain': 0.0, 'rainRate': 0.0}:
>>>>>>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG urllib3.connectionpool:
>>>>>>> Starting new HTTP connection (1): 192.168.2.33:80
>>>>>>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG urllib3.connectionpool:
>>>>>>> http://192.168.2.33:80 "GET /v1/current_conditions HTTP/1.1" 200
>>>>>>> None
>>>>>>> Jul 5 01:10:38 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published
>>>>>>> record 2020-07-05 01:10:38 CEST (1593904238)
>>>>>>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this
>>>>>>> period: 0.0
>>>>>>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG user.WLLDriver: Set
>>>>>>> Previous period rain to: 3
>>>>>>> Jul 5 01:10:38 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet
>>>>>>> received from WLL module {'dateTime': 1593904238, 'usUnits': 17,
>>>>>>> 'outTemp':
>>>>>>> 18.11, 'outHumidity': 96.9, 'dewpoint': 17.61, 'heatindex': 19.06,
>>>>>>> 'windchill': 17.17, 'windSpeed': 3.58, 'windDir': 227, *'windGust':
>>>>>>> 6.71*, 'windGustDir': 224, 'barometer': 1009.89, 'pressure':
>>>>>>> 1009.49, 'rain': 0.0, 'rainRate': 0.0, 'inTemp': 21.5, 'inHumidity':
>>>>>>> 71.1,
>>>>>>> 'inDewpoint': 16.06}:
>>>>>>> Jul 5 01:10:38 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published
>>>>>>> record 2020-07-05 01:10:38 CEST (1593904238)
>>>>>>> Jul 5 01:10:41 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this
>>>>>>> period: 0.0
>>>>>>> Jul 5 01:10:41 ubuntu weewx[4508] DEBUG user.WLLDriver: Set
>>>>>>> Previous period rain to: 3
>>>>>>> Jul 5 01:10:41 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet
>>>>>>> received from WLL module {'dateTime': 1593904240, 'usUnits': 17,
>>>>>>> 'windSpeed': 3.58, 'windDir': 227,* 'windGust': 7.15*,
>>>>>>> 'windGustDir': 249, 'rain': 0.0, 'rainRate': 0.0}:
>>>>>>> Jul 5 01:10:41 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published
>>>>>>> record 2020-07-05 01:10:40 CEST (1593904240)
>>>>>>> Jul 5 01:10:43 ubuntu weewx[4508] DEBUG user.WLLDriver: Rain this
>>>>>>> period: 0.0
>>>>>>> Jul 5 01:10:43 ubuntu weewx[4508] DEBUG user.WLLDriver: Set
>>>>>>> Previous period rain to: 3
>>>>>>> Jul 5 01:10:43 ubuntu weewx[4508] DEBUG user.WLLDriver: Packet
>>>>>>> received from WLL module {'dateTime': 1593904243, 'usUnits': 17,
>>>>>>> 'windSpeed': 3.58, 'windDir': 213,* 'windGust': 7.15*,
>>>>>>> 'windGustDir': 249, 'rain': 0.0, 'rainRate': 0.0}:
>>>>>>> Jul 5 01:10:43 ubuntu weewx[4508] INFO weewx.restx: MQTT: Published
>>>>>>> record 2020-07-05 01:10:43 CEST (1593904243)
>>>>>>>
>>>>>>>
>>>>>>> Op zaterdag 4 juli 2020 om 18:09:42 UTC+2 schreef
>>>>>>> [email protected]:
>>>>>>>
>>>>>>>> Thank you !
>>>>>>>>
>>>>>>>> I'm very stupid ahah, this is an error that I put on code ! I push
>>>>>>>> to my git a fix to windSpeed and windGust.
>>>>>>>>
>>>>>>>> For others sensors, I make this change this we.
>>>>>>>>
>>>>>>>> Le samedi 4 juillet 2020 à 17:41:33 UTC+2, [email protected] a
>>>>>>>> écrit :
>>>>>>>>
>>>>>>>>> Jul 4 17:39:37 ubuntu weewx[20924] DEBUG user.WLLDriver: Packet
>>>>>>>>> received from WLL module {'dateTime': 1593877175, 'usUnits': 17,
>>>>>>>>> 'windSpeed': 5.36, 'windDir': 210, 'windGust': 8.05, 'windGustDir':
>>>>>>>>> 211,
>>>>>>>>> 'rain': 0.0, 'rainRate': 0.0}:
>>>>>>>>> Jul 4 17:39:37 ubuntu weewx[20924] INFO weewx.restx: MQTT:
>>>>>>>>> Published record 2020-07-04 17:39:35 CEST (1593877175)
>>>>>>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG user.WLLDriver: Rain
>>>>>>>>> this period: 0.0
>>>>>>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG user.WLLDriver: Set
>>>>>>>>> Previous period rain to: 0
>>>>>>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG user.WLLDriver: Packet
>>>>>>>>> received from WLL module {'dateTime': 1593877178, 'usUnits': 17,
>>>>>>>>> 'windSpeed': 4.47, 'windDir': 217, 'windGust': 8.05, 'windGustDir':
>>>>>>>>> 211,
>>>>>>>>> 'rain': 0.0, 'rainRate': 0.0}:
>>>>>>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG urllib3.connectionpool:
>>>>>>>>> Starting new HTTP connection (1): 192.168.2.33:80
>>>>>>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG urllib3.connectionpool:
>>>>>>>>> http://192.168.2.33:80 "GET /v1/current_conditions HTTP/1.1" 200
>>>>>>>>> None
>>>>>>>>> Jul 4 17:39:40 ubuntu weewx[20924] INFO weewx.restx: MQTT:
>>>>>>>>> Published record 2020-07-04 17:39:38 CEST (1593877178)
>>>>>>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG user.WLLDriver: Rain
>>>>>>>>> this period: 0.0
>>>>>>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG user.WLLDriver: Set
>>>>>>>>> Previous period rain to: 0
>>>>>>>>> Jul 4 17:39:40 ubuntu weewx[20924] DEBUG user.WLLDriver: Packet
>>>>>>>>> received from WLL module {'dateTime': 1593877178, 'usUnits': 17,
>>>>>>>>> 'outTemp':
>>>>>>>>> 17.33, 'outHumidity': 93.3, 'dewpoint': 16.22, 'heatindex': 18.06,
>>>>>>>>> 'windchill': 15.72, 'windSpeed': 10.0, 'windDir': 217, 'windGust':
>>>>>>>>> 14.0,
>>>>>>>>> 'windGustDir': 213, 'barometer': 1012.67, 'pressure': 1012.26,
>>>>>>>>> 'rain': 0.0,
>>>>>>>>> 'rainRate': 0.0, 'inTemp': 22.61, 'inHumidity': 63.2, 'inDewpoint':
>>>>>>>>> 15.28}:
>>>>>>>>> Jul 4 17:39:40 ubuntu weewx[20924] INFO weewx.restx: MQTT:
>>>>>>>>> Published record 2020-07-04 17:39:38 CEST (1593877178)
>>>>>>>>> Jul 4 17:39:42 ubuntu weewx[20924] DEBUG user.WLLDriver: Rain
>>>>>>>>> this period: 0.0
>>>>>>>>> Jul 4 17:39:42 ubuntu weewx[20924] DEBUG user.WLLDriver: Set
>>>>>>>>> Previous period rain to: 0
>>>>>>>>> Jul 4 17:39:42 ubuntu weewx[20924] DEBUG user.WLLDriver: Packet
>>>>>>>>> received from WLL module {'dateTime': 1593877180, 'usUnits': 17,
>>>>>>>>> 'windSpeed': 4.47, 'windDir': 204, 'windGust': 8.05, 'windGustDir':
>>>>>>>>> 211,
>>>>>>>>> 'rain': 0.0, 'rainRate': 0.0}:
>>>>>>>>> Jul 4 17:39:42 ubuntu weewx[20924] INFO weewx.restx: MQTT:
>>>>>>>>> Published record 2020-07-04 17:39:40 CEST (1593877180)
>>>>>>>>> Jul 4 17:39:45 ubuntu weewx[20924] DEBUG user.WLLDriver: Rain
>>>>>>>>> this period: 0.0
>>>>>>>>> Jul 4 17:39:45 ubuntu weewx[20924] DEBUG user.WLLDriver: Set
>>>>>>>>> Previous period rain to: 0
>>>>>>>>> Jul 4 17:39:45 ubuntu weewx[20924] DEBUG user.WLLDriver: Packet
>>>>>>>>> received from WLL module {'dateTime': 1593877183, 'usUnits': 17,
>>>>>>>>> 'windSpeed': 3.58, 'windDir': 214, 'windGust': 8.05, 'windGustDir':
>>>>>>>>> 211,
>>>>>>>>> 'rain': 0.0, 'rainRate': 0.0}:
>>>>>>>>> Jul 4 17:39:45 ubuntu weewx[20924] INFO weewx.restx: MQTT:
>>>>>>>>> Published record 2020-07-04 17:39:43 CEST (1593877183)
>>>>>>>>>
>>>>>>>>> MySQL-output latest 5 records
>>>>>>>>> mysql> select
>>>>>>>>> datetime,from_unixtime(datetime),outtemp,windspeed,windgust,radiation,uv,et,rain,extratemp1
>>>>>>>>>
>>>>>>>>> from archive order by datetime desc limit 5;
>>>>>>>>>
>>>>>>>>> +------------+-------------------------+-------------------+-------------------+----------+-----------+------+------+------+------------+
>>>>>>>>>
>>>>>>>>> | datetime | from_unixtime(datetime) | outtemp |
>>>>>>>>> windspeed | windgust | radiation | uv | et | rain |
>>>>>>>>> extratemp1 |
>>>>>>>>>
>>>>>>>>> +------------+-------------------------+-------------------+-------------------+----------+-----------+------+------+------+------------+
>>>>>>>>> | 1593877200 | 2020-07-04 17:40:00 | 17.33 |
>>>>>>>>> 5.195454545454546 | 14 | NULL | NULL | NULL | 0 |
>>>>>>>>> NULL |
>>>>>>>>> | 1593877140 | 2020-07-04 17:39:00 | 17.30857142857143 |
>>>>>>>>> 4.514193548387096 | 15 | NULL | NULL | NULL | 0 |
>>>>>>>>> NULL |
>>>>>>>>> | 1593877080 | 2020-07-04 17:38:00 | 17.33 |
>>>>>>>>> 6.058125000000001 | 15 | NULL | NULL | NULL | 0 |
>>>>>>>>> NULL |
>>>>>>>>> | 1593877020 | 2020-07-04 17:37:00 | 17.33
>>>>>>>>> | 6.1765625 | 17 | NULL | NULL | NULL | 0 |
>>>>>>>>>
>>>>>>>>> NULL |
>>>>>>>>> | 1593876960 | 2020-07-04 17:36:00 | 17.33
>>>>>>>>> | 6.4096875 | 18 | NULL | NULL | NULL | 0 |
>>>>>>>>>
>>>>>>>>> NULL |
>>>>>>>>>
>>>>>>>>> +------------+-------------------------+-------------------+-------------------+----------+-----------+------+------+------+------------+
>>>>>>>>>
>>>>>>>>> 5 rows in set (0.00 sec)
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Op zaterdag 4 juli 2020 om 15:40:52 UTC+2 schreef
>>>>>>>>> [email protected]:
>>>>>>>>>
>>>>>>>>>> Hm it's strange because you show that the packet including value
>>>>>>>>>> for Wind and Rain....
>>>>>>>>>>
>>>>>>>>>> On syslog, can you share packet where all sensor are display.
>>>>>>>>>>
>>>>>>>>>> Thank you
>>>>>>>>>>
>>>>>>>>>>
--
You received this message because you are subscribed to the Google Groups
"weewx-development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-development/67f36871-7e0d-41a7-9e84-d8d6891f16b3n%40googlegroups.com.
