Tested using Kali Linux VirtualBox 32-Bit v2020.1
Python v3.8.0
Required package:
sudo apt-get install python-scapy
Required equipment:
NIC(monitor mode enabled)
Required software
Aircrack-ng
Add connection credentials and place file in webserver where db is.
In Sniffer.py change sniff()
sniff(iface='YOUR-CARD-NAME', prn = PacketHandler, store=0)
Table Layout
CREATE TABLE `tbl_Probes` (
`MAC_Address` varchar(17) NOT NULL,
`SSID` varchar(36) NOT NULL,
`Location` varchar(36) NOT NULL,
`UserTime` datetime NOT NULL DEFAULT current_timestamp(),
`ID` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8mb4