User Tools

Site Tools


projects:wifi_scanner

Differences

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

Link to this comparison view

Next revision
Previous revision
Next revision Both sides next revision
projects:wifi_scanner [2019/10/02 14:50]
neil created
projects:wifi_scanner [2020/01/06 17:23]
neil
Line 14: Line 14:
 ==== channel_changer.php ==== ==== channel_changer.php ====
 <code php> <code php>
-?php+#​!/​usr/​bin/​php 
 +<?php
 $channels = array( $channels = array(
   1,​2,​3,​4,​5,​6,​7,​8,​9,​10,​11,​ 12,​13,​36,​40,​44,​48,​52,​56,​60,​64,​100,​104,​   1,​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>​ </​code>​
  
 ===== Analysing the data ===== ===== Analysing the data =====
 I've made some graphs: I've made some graphs:
-  * [[https://​starflyer.armchairscientist.co.uk/​tmp/​wifi3.php|General scan #2 - Sat July 6th 2019 8am-11:​30am]] - All data grouped in unique MACs per minute period +  * [[https://​starflyer.armchairscientist.co.uk/​tmp/​wifi3.php|General scan #2 - Sat July 6th 2019 8am-11:​30am]] - All data grouped in unique MACs per minute period 
-  * [[https://​starflyer.armchairscientist.co.uk/​tmp/​wifi3.php|General scan #3 - Sat July 6th 2019 8am-11:​30am]] - As above, known devices/​equipment filtered - an example of identifying a group of passers ​(Orange walk outside my window at 10:40am)+  * [[https://​starflyer.armchairscientist.co.uk/​tmp/​wifi3.php|General scan #3 - Sat July 6th 2019 8am-11:​30am]] - As above, known (previously seen the hours/days before) ​devices/​equipment filtered - an example of identifying a group of passerbys ​(Orange walk outside my window at 10:40am)
   * [[https://​starflyer.armchairscientist.co.uk/​tmp/​wifi4.php|General scan #4]] - Multiple days showing the weekend and spikes, at 8am and 5pm, of people passing by to and from work.   * [[https://​starflyer.armchairscientist.co.uk/​tmp/​wifi4.php|General scan #4]] - Multiple days showing the weekend and spikes, at 8am and 5pm, of people passing by to and from work.
  
-I'm still working on analysing an entire ​uniterrupted ​month to get some general statistics on wifi use around my area.   ​Updates and code to follow.+I'm still working on analysing an entire ​uninterrupted ​month to get some general statistics on wifi use around my area.   ​Updates and code to follow.
  
  
projects/wifi_scanner.txt · Last modified: 2020/08/03 16:11 by admin