Grafana 面板监控 Helium 网络中的LoRaWAN温湿度终端

  Rejeee温湿度传感器 --> Helium热点AP --> HeliumConsole --> MQTTBroker --> Telegraf --> InfluxDB --> Grafana 

sudo apt-get update
sudo apt-get install mosquitto mosquitto-clients
sudo apt-get clean

sudo vim  /etc/mosquitto/conf.d/default.con

allow_anonymous false
password_file /etc/mosquitto/passwd

mosquitto_passwd -b /etc/mosquitto/passwd heliumconsole heliumconsole123

mosquitto_passwd -b /etc/mosquitto/passwd telegraf telegraf123

service mosquitto stop
service mosquitto start
service mosquitto status

curl -sL https://repos.influxdata.com/influxdb.key | sudo apt-key add -
source /etc/lsb-release
echo "deb https://repos.influxdata.com/${DISTRIB_ID,,} ${DISTRIB_CODENAME} stable" | sudo tee /etc/apt/sources.list.d/influxdb.list

sudo apt-get update && sudo apt-get install influxdb
sudo service influxdb start
sudo systemctl status influxd.service 

create database rejeee_TH
use rejeee_TH<br>
create user rejeee_TH with password 'rejeee_TH123' with all privileges<br>
exit

sudo apt-get update && sudo apt-get install telegraf
sudo service telegraf start
sudo service telegraf status

sudo vim /etc/telegraf/telegraf.conf

    urls = ["http://127.0.0.1:8086"]<br>
    database = "rejeee_TH"<br>
    username = "rejeee_TH"<br>
    password = "rejeee_TH123"

sudo vim /etc/telegraf/telegraf.d/mqtt.conf

servers = "tcp://127.0.0.1:1883"
qos = 0
connection_timeout = "30s"
topics =  "helium/#" 
username = "telegraf"
password = "telegraf123"
data_format = "json"
json_string_fields = "name","hotspot_name","spreading"

sudo systemctl reload telegraf.service
sudo systemctl status telegraf.service

apt-get install  grafana

sudo systemctl enable grafana-server
sudo systemctl start grafana-server

sudo systemctl status grafana-server.service

sudo service grafana-server restart

{
{{#decoded}}{{#payload}}"power": {{power}},
"temp_value": {{temp_value}},
"hum_value": {{hum_value}},{{/payload}}{{/decoded}}
"name": "{{name}}",
{{#hotspots}}"hotspot_name": "{{name}}",
"rssi": {{rssi}},
"snr": {{snr}},
"channel": {{channel}},
"fcnt":{{fcnt}},
"spreading": "{{spreading}}"{{/hotspots}}
}

{
"power": 30,
"temp_value": 25.6,
"hum_value": 58,
"name": "Rejeee_TH",
"hotspot_name": "inxxxsting-honexxxuckle-gxxse",
"rssi": -86.0,
"snr": 12.199999809265137,
"channel": 399,
"fcnt":1712,
"spreading": "SF7BW125"
}

influx -username rejeee_TH -password rejeee_TH123
use rejeee_TH
select * from mqtt_consumer limit 5