No data after update: MQTT does not connect (emonSD-17Jun2015)

David_Rowlands · 2017-03-10T11:28:34.964Z

Hi All

This is my first post to this forum so hopefully it’s in the right place.

I updated my emonPi this morning using the button on the admin page since then none of the nodes are updating.

emonhub.log shows:-

2017-03-10 11:08:12,744 DEBUG    RFM2Pi     947 NEW FRAME : OK 5 122 255 54 4 176 3 235 89 0 0 0 0 0 0 0 0 0 0 0 0 59 8 0 0 (-0)
2017-03-10 11:08:12,749 DEBUG    RFM2Pi     947 Timestamp : 1489144092.74
2017-03-10 11:08:12,749 DEBUG    RFM2Pi     947 From Node : 5
2017-03-10 11:08:12,750 DEBUG    RFM2Pi     947    Values : [-134, 1078, 944, 235.78154528999997, 0, 0, 0, 0, 0, 0, 2107]
2017-03-10 11:08:12,751 DEBUG    RFM2Pi     947 Sent to channel(start)' : ToEmonCMS
2017-03-10 11:08:12,752 DEBUG    RFM2Pi     947 adding frame to buffer => [1489144092.744364, 5, -134, 1078, 944, 235.78154528999997, 0, 0, 0, 0, 0, 0, 2107]
2017-03-10 11:08:12,753 DEBUG    RFM2Pi     947 Sent to channel(end)' : ToEmonCMS
2017-03-10 11:08:12,814 INFO     MQTT       Connecting to MQTT Server
2017-03-10 11:08:12,928 INFO     MQTT       Connecting to MQTT Server
2017-03-10 11:08:13,033 INFO     MQTT       Connecting to MQTT Server
2017-03-10 11:08:13,138 INFO     MQTT       Connecting to MQTT Server
2017-03-10 11:08:13,242 INFO     MQTT       Connecting to MQTT Server
2017-03-10 11:08:13,346 INFO     MQTT       Connecting to MQTT Server
2017-03-10 11:08:13,450 INFO     MQTT       Connecting to MQTT Server
2017-03-10 11:08:13,454 INFO     MQTT       Unexpected disconnection

The mqtt section of emonhub.conf file:-

    Type = EmonHubMqttInterfacer
    [[[init_settings]]]
        mqtt_host = 127.0.0.1
        mqtt_port = 1883
        mqtt_user = ''
        mqtt_passwd = ''

    [[[runtimesettings]]]
        pubchannels = ToRFM12,
        subchannels = ToEmonCMS,

        # emonhub/rx/10/values format
        # Use with emoncms Nodes module
        node_format_enable = 1
        node_format_basetopic = emonhub/

        # emon/emontx/power1 format - use with Emoncms MQTT input
        # http://github.com/emoncms/emoncms/blob/master/docs/RaspberryPi/MQTT.md
        nodevar_format_enable = 0
        nodevar_format_basetopic = emon/

Mosquitto is logging the following error:-

Mar 10 11:11:31 emonpi mosquitto[19012]: New connection from 127.0.0.1.
Mar 10 11:11:31 emonpi mosquitto[19012]: Invalid protocol "MQTT" in CONNECT from 127.0.0.1.
Mar 10 11:11:31 emonpi mosquitto[19012]: Socket read error on client (null), disconnecting.

David_Rowlands · 2017-03-10T17:38:52.303Z

It turns out I needed to upgrade mosquitto from V3.1 to V3.1.1

https://community.openenergymonitor.org/t/emonhub-install/954/4

glyn.hudson · 2017-03-10T19:19:36.286Z

Hi @David_Rowlands,

Good fix! Yes this was an annoying issue,

I see your running emonSD-17June 2015. I would recomend updating to the latest emonSD image, there have been lots of bug and security fixes.

Your data can be migrated using the built in Emoncms backup module, see:

Guide | OpenEnergyMonitor

Import / Backup

Import data from existing emonPi Emoncms accounts