Skip to content

Latest commit

 

History

History
132 lines (81 loc) · 3.84 KB

readme.md

File metadata and controls

132 lines (81 loc) · 3.84 KB

Coffee Machine

In the decorative art school of Paris, we are almost 1K users for 1 coffee machine. You can imagine the length of the queue each time we want one.

The idea is to monitor the activity of the machine to determine what is the best moment to go downstair.

I choose to only track when the machine take some watter from to avoid privacy issues with cameras of microphones.

So I plug ready-made for sensor with en ESP32. Connected to a InfluxDB install on a Raspberry Pi and connected to a ghost network over all the building.

Then with Grafana i can embed the chart.

The next step will be to train a model to predicte the ideal moment to take the coffee break.

web web

RaspberryPi

Setup Wifi wlan0

edit wpa_supplicant.conf to setup wifi.

sudo nano /etc/network/wpa_supplicant/wpa_supplicant.conf

country=FR
ctrl_interface=DIR=/var/run/wpa_supplicant GROUP=netdev
ap_scan=1

update_config=1
network={
    scan_ssid=1
    ssid="SSId"
    psk="PASS"
}

ap_scan=1 is mendatory for hidden ssid network.

Install Grafana port :3000

based on Grafana documentation

add :

wget -q -O - https://packages.grafana.com/gpg.key | sudo apt-key add -

echo "deb https://packages.grafana.com/oss/deb stable main" | sudo tee -a /etc/apt/sources.list.d/grafana.list

install :

sudo apt update && sudo apt install -y grafana

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

test Grafana UI :

http://<ip address>:3000

Install InfluxDB port :8086

based on hackster.io

Influx documentation

add :

wget -qO- https://repos.influxdata.com/influxdb.key | gpg --dearmor | sudo tee /etc/apt/trusted.gpg.d/influxdb.gpg > /dev/null

export DISTRIB_ID=$(lsb_release -si); export DISTRIB_CODENAME=$(lsb_release -sc)

echo "deb [signed-by=/etc/apt/trusted.gpg.d/influxdb.gpg] https://repos.influxdata.com/${DISTRIB_ID,,} ${DISTRIB_CODENAME} stable" | sudo tee /etc/apt/sources.list.d/influxdb.list > /dev/null

install :

sudo apt update && sudo apt install influxdb2 influxdb2-cli -y

sudo systemctl enable influxdb && sudo systemctl start influxdb

test Influx UI:

http://<ip address>:8086

Add Influx in Grafana Data Source

connect to Grafana UI in a web browser :

⚙️→ Data Sources → Add data source → "InfluxDB"

IDENTIFIER    VALUE
name what you want
language InfluxQL
URL http://< ipaddress >:8086
Basic auth ✅ with credentials ✅
User go to influxdb → About → User ID
Password Password of this user
HTTP Headers Add new
Header Authorization
Value should be similar as : Token Wh_a6EjGQvkwvTaAeVE7qq AAvhYo4Z491ai25gtjjKoX_CV99zZ_zyBObn9SHKxaBwrPsfHRwCdos5tBAtgPu6g==
Database < name of bucket >
User go to influxdb → About → User ID
Password Password of this user
HTTP Methode GET

Embedded Grafana on Web Page

Setup Grafana :

allow anonymous connection

sudo nano /etc/grafana/grafana.ini --line

L.300 → allow_embedding = true

L.477 →

[auth.anonymous]
enabled = true

org_name = < you org >

org_role = Viewer

ESP

link here

http://<ip address>:8086 Data → Sources → Arduino

http://<ip address>:8086 Data → API Tokens VmKT8a91HltXeKR5LTSQdfSI9NneqmHc8fsGKqZRkTuYTMXQI8wAFLB1z7iBYp-JnAn1NIi6ZJCdPDnSEbwr7w==