MQTT from emoncms not going to weewx.sdb

[bgra...@umw.edu]

I have several sensors outside of my VP2 which send MQTT data to weewx (4.10.2) and the data is stored in weewx.sdb. My soil moisture sensor seems to be sending data which is being received by the weewx server (see below) but it's not going into the db. It must be something I have set incorrectly in weewx.conf (debug file attached) but all other entries in the MQTT section are working. 

The sensor is a Seeed S2105 soil temp/moisture which sends LoRa to emoncms which then sends it to the weewx server. The soil moisture reading is "4103" via MQTT from the emoncms server. Something simple is missing here but I'm lost as to what it might be.

Thanks in advance. I can send any additional data as needed.

Bob

grattans.org/wx

MQTT section of weewx.conf:

[[[gccpm]]]
            name = signal1
           
            [[[[message]]]]
                type = individual
       
        [[[gcdose]]]
            name = signal2
           
            [[[[message]]]]
                type = individual
####################################
## Soil Moisture / Soil Temp from emoncms
####################################

[[[4103]]]
            name = soilMoisture1

    [[[[message]]]]
type = individual

#################


mosquitto.log after startting service:

1711205814: mosquitto version 2.0.18 running
1711205815: New connection from 127.0.0.1:40059 on port 1883.
1711205815: New client connected from 127.0.0.1:40059 as MQTTSubscribe-6711 (p2, c1, k60, u'None').
1711205815: No will message specified.
1711205815: Sending CONNACK to MQTTSubscribe-6711 (0, 0)
1711205815: Received SUBSCRIBE from MQTTSubscribe-6711
1711205815: CO2sensecap (QoS 0)
1711205815: MQTTSubscribe-6711 0 CO2sensecap
1711205815: Sending SUBACK to MQTTSubscribe-6711
1711205815: Received SUBSCRIBE from MQTTSubscribe-6711
1711205815: lht65a (QoS 0)
1711205815: MQTTSubscribe-6711 0 lht65a
1711205815: Sending SUBACK to MQTTSubscribe-6711
1711205815: Received SUBSCRIBE from MQTTSubscribe-6711
1711205815: emonth5/degreesf (QoS 0)
1711205815: MQTTSubscribe-6711 0 emonth5/degreesf
1711205815: Sending SUBACK to MQTTSubscribe-6711
1711205815: Received SUBSCRIBE from MQTTSubscribe-6711
1711205815: gccpm (QoS 0)
1711205815: MQTTSubscribe-6711 0 gccpm
1711205815: Sending SUBACK to MQTTSubscribe-6711
1711205815: Received SUBSCRIBE from MQTTSubscribe-6711
1711205815: gcdose (QoS 0)
1711205815: MQTTSubscribe-6711 0 gcdose
1711205815: Sending SUBACK to MQTTSubscribe-6711
1711205815: Received SUBSCRIBE from MQTTSubscribe-6711
1711205815: 4103 (QoS 0)
1711205815: MQTTSubscribe-6711 0 4103
1711205815: Sending SUBACK to MQTTSubscribe-6711
bg@n4mrv:/var/log/mosquitto$


1711203894: Received PUBLISH from nodered_471889c5b45d452e (d0, q0, r0, m0, 'emonth5/degreesf', ... (5 bytes))
1711203894: Sending PUBLISH to MQTTSubscribe-3075 (d0, q0, r0, m0, 'emonth5/degreesf', ... (5 bytes))
1711203944: Received PUBLISH from nodered_471889c5b45d452e (d0, q0, r0, m0, 'gccpm', ... (2 bytes))
1711203944: Sending PUBLISH to MQTTSubscribe-3075 (d0, q0, r0, m0, 'gccpm', ... (2 bytes))
1711203944: Received PUBLISH from nodered_471889c5b45d452e (d0, q0, r0, m0, 'gcdose', ... (3 bytes))
1711203944: Sending PUBLISH to MQTTSubscribe-3075 (d0, q0, r0, m0, 'gcdose', ... (3 bytes))
1711203944: Received PUBLISH from nodered_471889c5b45d452e (d0, q0, r0, m0, '4103', ... (4 bytes))
1711203944: Sending PUBLISH to MQTTSubscribe-3075 (d0, q0, r0, m0, '4103', ... (4 bytes))
1711203953: Received PINGREQ from MQTTSubscribe-3075

[Stefano]

I'm absolutely not an expert on weewx, but have you tried maybe starting the Section with a letter instead of a number ? Maybe it's just invalid for one of the parsers ...

And the last line of your log is a bit different than the rest of them:

1711203953: Received PINGREQ from MQTTSubscribe-3075

Are those devices on the same network ? What about network connectivity ? Poor WiFi signal ?

I assume this is what PINGREQ does (hearttbeat like):

https://www.emqx.com/en/blog/mqtt-5-0-control-packets-04-pingreq-pingresp

--
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 weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/ea0b091f-854d-4eb0-b1d6-6dc6c205494en%40googlegroups.com.

[bell...@gmail.com]

I’m pretty sure the ‘stock’ db column name is soilMoist1. So try name = soilMoist1. If that doesn’t work, set debug = 1 and attach the WeeWX log.

rich

[bgra...@umw.edu]

Many thanks for the reply. Of course the weewx name is not correct and should be soilMoist1. I have looked at this so many times that I just didn’t see the problem. Also my extra dose of dumb-ass pills could be blamed…

All is well now. Sorry to take up group time with this.

Cheers,

Bob