Andreas
February 11, 2017, 7:58pm
1
@mhies (Bienenstockwaage Blog ) asked in January:
I would like to build a new version of my setup and will be happy to leave my architecture with a MySQL database and evaluation with Tableau behind by moving towards MQTT + InfluxDB + Grafana. The beehive is located in the garden of our house, Wi-Fi access and power is not an issue.swarm.hiveeyes.org as a backend and try out an MQTT client on the RPi.
He is now starting to publish measurement readings of his RaspberryPi-based Beelogger Version 2 to the collaborative backend platform. Cheers, Markus!
Python is used to publish data via MQTT:
@mhies fragte:
Ich würde gerne eine neue Version meines Setups bauen und gerne weg von meiner Architektur mit MySQL Datenbank und Auswertung mit Tableau hin zu MQTT + InfluxDB + Grafana. Die Beute steht in Hausnähe, Anschluss über WLAN und Strom ist kein Thema.
Ich habe mal auf der Hiveeyes Seite geschaut und würde gerne die Shared Platform swarm.hiveeyes.org als Backend nutzen und auf dem RPi einen MQTT Client ausprobieren.
So war es von Anfang an gedacht, dass wir an dieser Stelle etwas e…
He currently uses the call sign "MUC-MH-B99".
See also:
Some impressions:
The Python code used for reading and publishing sensor data can be found on GitHub and is also GPL-licensed - thanks a bunch, Markus!
#!/usr/bin/env python
# =======================================================
# RPi-Beelogger Version 2.0, Code 1.0, February 27th 2017
# https://github.com/beelogger/RPi-Beelogger
#
# RPi-Beelogger is using:
#
# - ABElectronics Delta-Sigma Pi 8-Channel ADC
# - Integrated 4 x load cells CZL601-50kg to determine the total weight and distribution
# - Integrated 8 x Temperature sensor D18B20 1-wire
#
# Setup: python setup.py install
# Run: sudo rpi-beelogger &
# =======================================================
import os
import sys
import ow
import csv
import math
show original
Markus just sent some annotations from real world events after following the documentation . It worked like a charm, thanks!
For doing that, he also used a little Python program he is sharing with us - thanks again!:
## Set-MQTT-Annotations Version 1.0, March 8th 2017
#! /bin/bash
#!/usr/bin/python
import time
import sched
import datetime
import os
import sys
import json
import paho.mqtt.client as mqtt
#
# alle Zeitangaben in UTC!!!!!!
#
# MQTT broker host
mqtt_broker = 'swarm.hiveeyes.org'
# MQTT bus topic
mqtt_topic_template = u'{realm}/{network}/{gateway}/{node}/{kind}.json'
show original
