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.

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.

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

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

connect to Grafana UI in a web browser :

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

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

link here

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

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