Hi,
As you have found out your database only includes soilMoist1 to soilMoist4.
So the first thing you need to do is extend your schema to include
soilMoist5 (or soildMoist6 - your choice), this is covered in the section
Adding
a new type to the database
<http://weewx.com/docs/customizing.htm#add_archive_type> in the Customization
Guide <http://weewx.com/docs/customizing.htm>. Note that once you have
added your new field to the database you will need to tell WeeWX what unit
group your new field belongs to. This is covered in the section Assigning a
unit group <http://weewx.com/docs/customizing.htm#Assigning_a_unit_group>
in the Customization Guide. In your case the unit group you would add your
new field to is group_moisture rather than group_energy used in the
example. Also, you should place your code that assigns the unit group in
extensions.py rather than electricity.py used in the example. You will find
extensions.py in /home/weewx/bin/user or /usr/share/weewx/user depending on
your WeeWX install type.
Gary
On Sunday, 19 April 2020 00:14:57 UTC+10, Gerrit Otto wrote:
>
> UPDATE: I have noticed the required tables is not created in the sqlite
> database. The interceptor is capturing the data but seems not stored in
> database:
>
> Apr 18 18:10:38 gerrithome-ZBOX weewx[28509]: interceptor: MainThread: raw
> packet: {'solar_radiation': 37.88, 'dateTime': 1587219037, 'humidity_in':
> 65.0, 'temperature_out': 79.2, 'usUnits': 1, 'soil_battery_1': 1.6,
> 'soil_battery_2': 1.5, 'soil_battery_3': 1.6, 'soil_battery_4': 1.5,
> 'soil_battery_6': 1.6, 'pressure': 29.819, 'wind_dir': 224.0, 'wind_speed':
> 3.36, 'temperature_in': 76.3, 'wind_gust': 8.05, 'humidity_out': 68.0,
> 'uv': 0.0, 'wh26_battery': 0.0, 'soil_moisture_1': 69.0, 'soil_moisture_2':
> 50.0, 'soil_moisture_3': 88.0, 'soil_moisture_4': 78.0, 'soil_moisture_6':
> 61.0}
> Apr 18 18:10:38 gerrithome-ZBOX weewx[28509]: interceptor: MainThread:
> mapped packet: {'soilMoist4': 78.0, 'soilMoist3': 88.0, 'pressure': 29.819,
> 'outHumidity': 68.0, 'UV': 0.0, 'radiation': 37.88, 'soilMoist1': 69.0,
> 'dateTime': 1587219037, 'windDir': 224.0, 'outTemp': 79.2, 'windSpeed':
> 3.36, 'inHumidity': 65.0, 'inTemp': 76.3, 'windGust': 8.05, 'soilMoist2':
> 50.0, 'usUnits': 1}
> Apr 18 18:10:38 gerrithome-ZBOX weewx[28509]: manager: Added record
> 2020-04-18 18:10:00 +04 (1587219000) to database 'weewx.sdb'
> Apr 18 18:10:38 gerrithome-ZBOX weewx[28509]: manager: Added record
> 2020-04-18 18:10:00 +04 (1587219000) to daily summary in 'weewx.sdb'
>
>
>
> The value soil_moisture_6 has no table created in sqlite database.
>
> Any idea? Is it possible to maybe dump and try re-create the database?
>
> Thanks.
>
>
> On Saturday, 18 April 2020 16:32:46 UTC+4, Gerrit Otto wrote:
>>
>> I have an ecowitt weather, interceptor and mqtt extention to send
>> messages to mosquito.
>>
>> I have 5 moisture sensors connected to ecowitt. The issue I am facing is
>> that it seems the mqtt extention is only send 4 out of the 5 moisture
>> sencors to mosquito.
>>
>> The interceptor is receiving the data from the ecowitt and can see that
>> in the logs. The mosquito logs does not have an entry for the specific
>> message received.
>>
>> I am not sure where to track the mqtt extention logs - the only log entry
>> in weewx.log is:
>> restx: MQTT: Published record 2020-04-18 16:25:00 +04 (1587212700)
>>
>>
>> Messages send to mosquite and what I can see in logs and client is:
>> weather/soilMoist1_centibar
>> weather/soilMoist2_centibar
>> weather/soilMoist3_centibar
>> weather/soilMoist4_centibar
>>
>> However the below message is missing and not send from weewx to mosquito:
>> weather/soilMoist5_centibar
>>
>> Some help will be appreciated.
>>
>> Gerrit
>>
>>
>>
--
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 on the web visit
https://groups.google.com/d/msgid/weewx-user/31f1919d-0181-4d98-b7c5-2fa3c87953b0%40googlegroups.com.
