Wireless Networks

We will begin by gathering data about wireless networks around us.

This can be done with a number of different programs. I'll use Aircrack's airodump-ng utility.

Start by putting the wireless card in monitor mode:

iwconfig # without wireless card pluged in
iwconfig # with wireless card plugged in
ifconfig wlan1 down 
ifconfig wlan1 up

Now begin monitoring, and dump information from the wireless card:

airmon-ng start wlan1
airodump-ng wlan1 -w output_file

Now you can open output_file.csv with a script or with a spreadsheet viewer.

Database

Use SQLite, and you don't have to install anything - it comes with Kali.

In one window, running a script that inserts a random record every 2 seconds.

Insertion script is as follows:

<source lang="python"> import sqlite3 import time import string import random from generators import id_generator, mac_generator

def id_generator(size=6, chars=string.ascii_uppercase): """This returns a random string""" return .join(random.choice(chars) for _ in range(size))

def mac_generator(): """This returns a random MAC address""" return .join([ id_generator(2)+':' for i in range(5) ]+[id_generator(2)])

if __name__=="__main__":

# connect to sqlite database conn = sqlite3.connect('wifidata.db')

# get a pointer in the database c = conn.cursor()

try: # create the table c.execute("CREATE TABLE wifidata (device_key, device_mac, device_signalstr)") except sqlite3.OperationalError: pass

# now insert 60 random records into the database for z in range(60): time.sleep(1)

random_key = id_generator(size=8) random_mac = mac_generator() random_strength = random.randint(1,100)

print "Inserting record (%s, %s, %d)"%(random_key, random_mac, random_strength)

c.execute( "INSERT INTO wifidata VALUES ('%s', '%s', %d)"%(random_key, random_mac, random_strength) )

# save (commit) the changes conn.commit()

# close the connection conn.close()

In another window, running a script that queries the database and shows its contents

Display script is as follows: