ESP32 WIFI-sniffer 📶 Publish to RPi4(MySQL) via MQTT

The purpose of this project is to measure and predict(not yet finished) the crowd density around using #esp32 and #raspberrypi4. The ESP32 will first connect to WIFI and get the current time from SNTP, then switch to AP+STA mode to scan the signals around and publish messages simultaneously. All the data will be published to a server running MQTT Broker and MySQL database (Raspberry Pi 4 in my case).

This project demonstrates how to measure (maybe predict later lol) crowd density using ESP32 and Raspberry Pi 4, which has important implications for smart cities, traffic management, and public health domains. In the future, I hope to improve the prediction model of crowd density and add more features and interactivity. Thank you for watching my video, if you like my project, please give me a like or leave a comment.

Big thanks to https://github.com/ETS-PoliTO/esp32-sniffer

#firmware :
The ESP32 is programmed in the FreeRTOS framework with ESP-IDF v5.2.
#wifi :
I managed to connect the ESP32 to the roaming WIFI in the university (NYCU), which is encrypted with WPA2-Enterprise (EAP-PEAP).
#mysql :
It is actually called “MariaDB” but they are basically the same thing. Also, I run the database in Docker so I won’t mess things up.