Random thoughts, views, and rantings

I’ve created a preliminary database schema for kismet log info that I think holds all useful information from the netxml files.

CREATE TABLE networks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
bssid TEXT DEFAULT NULL,
essid TEXT DEFAULT NULL,
cloaked BOOLEAN DEFAULT NULL,
channel INTEGER DEFAULT NULL,
encryption TEXT DEFAULT NULL,
manuf TEXT DEFAULT NULL,
ipaddress TEXT DEFAULT NULL,
iptype TEXT DEFAULT NULL,
maxrate INTEGER DEFAULT NULL,
maxseenrate INTEGER DEFAULT NULL,
beaconrate INTEGER DEFAULT NULL,
llcpackets INTEGER DEFAULT NULL,
datapackets INTEGER DEFAULT NULL,
cryptpackets INTEGER DEFAULT NULL,
totalpackets INTEGER DEFAULT NULL,
datasize INTEGER DEFAULT NULL,
firsttime TEXT DEFAULT NULL,
lasttime TEXT DEFAULT NULL,
gpsminlat NUMERIC DEFAULT NULL,
gpsminlon NUMERIC DEFAULT NULL,
gpsminalt NUMERIC DEFAULT NULL,
gpsmaxlat NUMERIC DEFAULT NULL,
gpsmaxlon NUMERIC DEFAULT NULL,
gpsmaxalt NUMERIC DEFAULT NULL,
gpspeaklat NUMERIC DEFAULT NULL,
gpspeaklon NUMERIC DEFAULT NULL,
gpspeakalt NUMERIC DEFAULT NULL)

CREATE TABLE clients (
id INTEGER PRIMARY KEY AUTOINCREMENT,
netid INTEGER DEFAULT NULL,
macaddress TEXT DEFAULT NULL,
channel INTEGER DEFAULT NULL,
manuf TEXT DEFAULT NULL,
ipaddress TEXT DEFAULT NULL,
iptype TEXT DEFAULT NULL,
maxseenrate INTEGER DEFAULT NULL,
llcpackets INTEGER DEFAULT NULL,
datapackets INTEGER DEFAULT NULL,
cryptpackets INTEGER DEFAULT NULL,
totalpackets INTEGER DEFAULT NULL,
datasize INTEGER DEFAULT NULL)

Its a two table design–the networks table holds the info about the APs while the clients table holds info about seen clients. If you don’t recognize the SQL variant, its SQLite, a choice I’m thinking of making so that the database can easily be replicated/edited/utilized without running a server.

And yes, the netid in the clients table should be a foreign key to id in the networks table, but as SQLite just added support for foreign keys, I’m not sure I want to include that yet.

I’ve done lots of work behind the scenes (hence the lack of posts) on the server, and I got bored of the default Wordpress theme so I found a nice-looking one, edited it to my needs, and the site is not so boring!

The AP code work I started last year is about complete for the old gpsdrive database from 2005/2006, but I am currently researching and planning on moving the AP code to a much better database that holds more AP information; the only problem is that all the old data cannot be used.  But as Videlais and I geocache, the data will slowly build.  When I am more pleased with the quality of the code I will release it.

My “stuff” pages are almost complete; books are 100%, movies are 99%, and games are around 80%.  Those pages will be pubic eventually…maybe.

Also, the site is now open to search bots, and I’ve been watching them trickle in through my access logs.  Sadly, I lose almost all referrer info because of the frame mess I must do to get around port 80.  But its interesting seeing hits–and at least one a day is a vulnerability scan.

I have hidden all my old Nucleus and Blogger posts because I didn’t want all that info public to the search bots and whoever finds their way here.

Lastly, I have re-enabled comment posting but all comments are moderated to eliminate spam.  I don’t want to open up user registration due to spam bots and the havoc they can cause, but if someone really wants one for whatever reason, I can make it happen.

So, whats the plan?  None really, this site continues to be mainly a learning platform and a place to mess around with.  I can host things for people and it makes a nice development platform I can SSH into from anywhere.  But as far as posts go, well, I’ll update when I have something to say.  I have a couple planned out (like instructions for cloning a Backtrack4 USB persistent install) but I need to spend time writing them up.