ESP8266 with Grafana and InfluxDB

The ghetto way to setup an IoT for your glorious Grafana Dashboard.

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes. See deployment for notes on how to deploy the project on a live system.

Prerequisites

Ingredients :

1. ESP8266
2. BM180 Barometer 
3. DHT11 or DHT22 Temperature and Humidity sensor 
3. 10k Resistors for pull up DHT
4. 100nF Capacitors 
5. 3.3V LDO regulator to supply your ESP
6. Proto board, scrap PCB, or wire to connect everything

ESP8266

Schematic

Using ESP8266 NodeMCU v3 LoLin with a simple 3.3V LDO Regulator.

GPIO used on ESP8266 NodeMCU v3:

BMP180 I2C_SCL on D1 or GPIO 5  
BMP180 I2C_SDA on D2 or GPIO 4
DHT1 I/O on D4 or GPIO 2

Place Holder

Using two different sensor to get a single data.

Flashing ESP8266

Place Holder

Place Holder

Place Holder

MQTT Broker

Manual Install

Install Mosquitto to your ubuntu server.

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

Configure your /etc/mosquitto/mosquitto.conf

# /etc/mosquitto/mosquitto.conf

pid_file /var/run/mosquitto.pid
log_dest file /var/log/mosquitto/mosquitto.log
include_dir /etc/mosquitto/conf.d
persistence true
persistence_location /var/lib/mosquitto/
allow_anonymous false
password_file /etc/mosquitto/passwd

Create a password file for your MQTT broker by running this command.

sudo mosquitto_passwd -c /etc/mosquitto/passwd someguy

After that don't forget to restart Mosquitto.

sudo systemctl restart mosquitto

Auto Install

Place Holder

Check your MQTT Broker

Before we continue we could try to check if our broker receive the payload from our ESP. Run this command on our broker server to see the payload. If there's no results, check your connection and your configuration on both devices.

mosquitto_sub -h localhost -t test -u "someguy" -P "SuperSekritPassword"

InfluxDB

Install InfluxDB 1.8.x and Telegraf on your server.

https://portal.influxdata.com/downloads/

Open your influxDB configuration at /etc/influxdb/influxdb.conf if you're using Ubuntu, and change some parameters as below.

 [http]
  # Determines whether HTTP endpoint is enabled.
  enabled = true

  # Determines whether the Flux query endpoint is enabled.
  flux-enabled = true

  # The bind address used by the HTTP service.
  bind-address = ":8086"

Dont forget to save and restart your influxdb service.

 sudo systemctl restart influxdb

To setup an authentication for your InfluxDB service, we need to make an administrator account.

user@host:~$ influx
Connected to http://localhost:8086 version 1.8.0
InfluxDB shell version: 1.8.0
> CREATE USER admin WITH PASSWORD 'SuperSekritPassword' WITH ALL PRIVILEGES
> SHOW USERS
user  admin
----  -----
admin true

And then head over again to influxdb.conf and change this parameter.

  # Determines whether user authentication is enabled over HTTP/HTTPS.
  auth-enabled = true

Now you could restart your InfluxDB again. We can test the authentication by using this command :

curl -G http://localhost:8086/query -u admin:SuperSekritPassword --data-urlencode "q=SHOW DATABASES"

If it give us a result then we're successful on setting up our InfluxDB. Now its time to setup our Telegraf service. After you finish installing Telegraf, open Telegraf configuration at /etc/telegraf/telegraf.conf if you're using ubuntu. You could use your InfluxDB user and password for Telegraf or make another influxDB user dedicated for Telegraf.

## HTTP Basic Auth
  username = "admin"
  password = "SuperSekritPassword"

After this you could save the config and restart your Telegraf service.

sudo systemctl restart telegraf

MQTT to Telegraf

After setting up everything, now we need to make MQTT to work together with InfluxDB by using Telegraf MQTT Consumer plugin.

Open your Telegraf configuration file /etc/telegraf/telegraf.conf, and search for input plugins and add the MQTT Consumer plugin.

Change the servers to our MQTT server IP addresses and port, add our test topic to sub, change the username and password to our MQTT user and pass, and data_format to json.

[[inputs.mqtt_consumer]]
  servers = ["tcp://127.0.0.1:1883"] 
  topics = [
    "telegraf/host01/cpu",
    "telegraf/+/mem",
    "sensors/#",
    "test",
  ]
  username = "admin"
  password = "SuperSekritPassword"
  data_format = "json"

Save the config and restart Telegraf service.

Grafana

Please read Place Holder for Place Holder.

Authors

• Place Holder - Place Holder - Place Holder

Place Holder

Acknowledgments

• Ayylmao