Differences

This shows you the differences between two versions of the page.

--- projects:wifi_scanner [2019/11/30 13:15]
neil
+++ projects:wifi_scanner [2020/01/06 17:23]
neil
@@ Line 29: / Line 29: @@
 ?>
+</code>
+===== Importing the data =====
+I import the raw tcpdump logs (just a timestamp and mac address) into a simple mysql table:
+<code sql>
+create table wifi_data (seen_time datetime, mac varchar(17), unique (seen_time,mac));
+</code>
+To import the log file I run:
+<code bash>
+php import.php tcpdump.log
+</code>
+Which runs this file (note, this is accurate to the minute, rather than the second, to save space):
+<code php>
+tbd
 </code>

neil.mckillop.org