Hak5 1806 – WiFi Auditing with SQL and Pollution Monitoring with Arduino
Analyzing WiFi Packet Captures with the power of SQL using a new free tool from Security Tube! Plus, pollution monitoring using an Arduino? Shannon reports. All that and more, this time on Hak5!
Analyzing WiFi Packets with SQL
When I think analyzing packets, I think Wireshark. As you may have seen in Shannon’s HakTip series, Wireshark is an amazing network protocol analyzer — but sometimes you need just a bit more power. Now thanks to Vivek of Security Tube, it’s now quite simple to convert your standard .pcap packet capture formatted files into SQLite databases or even XML. The Pcap2XML/Sqlite tool does just that. This command line Windows program will convert packet captures with ease.
So now, for example, instead of using a Wireshark filter to list all probe requests with “wlan.fc.type_subtype eq 4” I can issue the following SQL statement: “SELECT DISTINCT addr2 FROM MACHeaders WHERE type = 0 AND subtype = 4;”
Pollution Monitoring with Arduino
Using this code and schematic, your Arduino will print a number between 0-1023 to the serial monitor, which you can then use to track pollution levels in your area. The gas sensor will detect ammonia, alcohol, CO2, sulfur, benzene vapor, smoke and other gases harmful to humans.