發表文章

目前顯示的是有「influxdb」標籤的文章

Using local node red to get TTN lorawan data through ubidots

圖片
 This is kind of cloud data to local data storage. I have a Lorawan node sending data to TTN. I have it presented on Ubidots  . which provide a very good presentation of data and management of device and data. Ubidots also provide 2 nodes in node red, one to put data to Ubidots, one to receive data from ubidots. ubidots_out is to send data to ubidots using MQTT ubidots_in is to receive data from ubidots using MQTT Getting data to/from Ubidots has a great example: https://help.ubidots.com/en/articles/1440402-connect-node-red-with-ubidots I have 2 shorts of data on Ubidots, one is direct data integration from TTN, one my local zigbee sensor data uploaded to ubidots using node:ubidots_out. To receive the 2nd type of data correctly with ubidots in, you will need to add device label in your message payload when using ubitdots out to up load your data. Othe wise, you can still view the data on the dashboard, but won't be able to down load it. The 2nd tricky thing is the format retur...

zigbee2mqtt, node red, influxdb and grafana

圖片
 the iotstak comes with infuxDB:a data base very similar to firebase, which you don't need to setup the database every data type to make it work. But you still need to setup a name of database, this is done with a terminal and command, there is not yet web like configuration page. To access the ssh in a container, easy way is to go through portainer Once connect to ssh, type in influx to get into database, then you can use SQL like command to create you database. But luckily, there is a program:  https://github.com/CymaticLabs/InfluxDBStudio which can do the database things easier. The defaultuser:password of influxDB in IOTstack is : nordred: nodered Now, back to node red. To put data into influxDB you have to select the influxDB out the influxDB in means to get data from influxDB into nodered. then you have to config the server, the port of influxDB is 8086 Once server set, the measurement is the page where the data is loged.(you can set it here, no need to set this in influ...