Update: Display TTN-Gateway status

After migrating my TTN gateway to the new The Things Stack Community Edition (see previous blog post) my script to display the gateway status stopped working. The reason behind was, that the new stack does not provide the noc api which was used in the script.

After searching in the TTN forum I found the thread New API for gateway mapping, status and info. Using this API I just need to change one line in my script and now it works again.

-  cmd = "curl -s http://noc.thethingsnetwork.org:8085/api/v2/gateways/eui-b827ebfffe06902a | jq -r '.timestamp'"

+  cmd = "curl -s https://mapper.packetbroker.net/api/v2/gateways/netID=000013,tenantID=ttn,id=eui-b827ebfffe06902a | jq -r '.updatedAt'"

The updated script is available in the github repo.

Migrate TTN-Gateway to The Things Stack Community Edition (aka V3)

 I just migrate my TTN-gateway to the new The Things Stack Community Edition (aka V3). 

I followed the instructions I found in the thread on GitHub.

1. Create a new gateway on the things network (link)
2. Change the server url in your local_conf.json to eu1.cloud.thethings.network
3. Restart the gateway

Unfortunately the new stack does not provide a NOC api - so my script to output the gateway status to a OLED stop working. I will invest into this next.

Photovoltaic dashboard with Grafana

I have a SolarEdge Inverter which is monitored by a energy meter (SolarEdge SE-MTR-3Y-400V-A). The energy meter gets measurements from the inverter and measures voltage and current at the house entry point.

SolarEdge provide a monitoring service and a mobile app to monitor the system. An example is shown here:

To be able to monitor and evaluate the measurements by myself I use the following applications:

• mbmd - to read the measurements from the inverter and energy meter
• nodered - to calculate some derived values 
• mqtt - to "transport" the measurements between the apps
• telegraf - to write the measurements into influxdb
• influxdb - to store the measurements
• grafana - to display the measurements

The result looks like this (a snapshot is available here):

Configuration 

mbmd

The mbmd reads the measurements from the inverter and (via the inverter) from the energy meter.

pi@racknode:/etc $ more mbmd.yaml
# REST api, use 127.0.0.1 to restrict to localhost
api: 0.0.0.0:8080

# mqtt config
mqtt:
  broker: my.mqtt.server:1883
  topic: mbmd
#  user:
#  password:
  clientid: mbmd
  qos: 0
  homie: ""
  # homie: homie


# adapters are referenced by device
adapters:
- device: inverter.ip.addr:1502

# list of devices
devices:
- name: inverter
  type: SE
  id: 1
  subdevice: 0 # use subdevice to access SunSpec subdevices
- name: powermeter
  type: SE
  id: 1
  subdevice: 1 # use subdevice to access SunSpec subdevices

Node-Red

To calculate the "self consumption" and split the measured power in Import/Export I create a Node-Red flow:

Here is the corresponding flow code.

Telegraf

The telegraf is configured to transfer the mqtt messages to the influxdb. 

The config is available here.

Grafana

A snapshot of the dashboard is available here and also the dashboard.json is available.

TTN-Gateway in a box

During the last days I worked on the installation of my TTN-Gateway into a case. This is the result:

Beside the LoraWAN hardware I have installed an OLED display and 3 sensors (1x Si7021, 2x DS18B20). The OLED display is connected via I2C, the sensors via 1-wire and I2C.

The sensor data is read by Python3 Script and published with MQTT. The OLED is also controlled by a Python3 script. Both scripts run as systemd-service.

The software is available on github.

[Update] NetCologne DSL Spectrum @Home

After a support call, it is better, but still worse than before.

Download: 2458 kbit/s
Upload: 383 kbit/s

[Update] NetCologne DSL Spectrum @Home

I thought it can not be worse but since yesterday ...

Down: 1113 kbit/s
Up: 636 kbit/s

NetCologne DSL Spectrum @Home

In order to document it - and to wallow in self-pity.

Download: 4862 kbit/s
Upload: 639 kbit/s