Differences

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

--- projects:wifi_scanner [2019/10/02 14:51]
neil [Analysing the data]
+++ projects:wifi_scanner [2020/01/06 17:23]
neil
@@ Line 14: / Line 14: @@
 ==== channel_changer.php ====
 <code php>
-?php
+#!/usr/bin/php
+<?php
 $channels = array(
 ,2,3,4,5,6,7,8,9,10,11, 12,13,36,40,44,48,52,56,60,64,100,104,
@@ Line 28: / 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