[Openbeacon-openamd] Import of 25C3 data and some summary.

[Tomasz R. <bog...@po...>]

Hello.
I wrote Python script for importing network dump from 25C3 into
PostgreSQL database: http://www.bogomips.w.tkb.pl/Import25C3.py
It assumes database as created by this script:
http://www.bogomips.w.tkb.pl/create.sql
It creates full database - so you may want to trim it for your needs.
Python script can be also used for other purposes - just replace
INSERT statements with your own code.

There were 704 strange packets - probably 2.4GHz traffic generated
few packets with matching CRC after decryption.

Some statistics:
674 unique tags.
There are four 1-hour periods without any data.

I think I know what caused strange IDs of tags visible in Leica.
Old firmware (before 25C3) had different format of packets
and when new agregator read old packets treating them as new ones
it could result in strange IDs. At least that's what it looked like
in my script before I fixed it.

From tags with 23C3 firmware 84419 packets.
Camp firmware -  2007: 67097.
24C3: 1780753.
Tags from The Last HOPE: 276923
Beta tags were responsible for 39035832 packets
Final firmware from 25C3: 49246728 packets.

BTW - there was tag with ID 349. What was that?

Packet types and their counts:
23 (from old firmware): 2209162.
24 (final 25C3 version) 26157340.
25 (beta): 38798260.
42 (tag looking for other tags): 2589213.
69 (social contacts report): 20737073.

Currently I am trying to generate some graphs.

BTW - is there any info about positions of readers?
I know that they were in almost exactly the same places like during
24C3,
but their IDs changed, so new map is needed.

Regards.

-- 
Tomasz Rybak <bog...@po...> GPG key ID: F22C D870
Fingerprint 93BC FEEC A426 3765 799F  10EE FAC1 9A2C F22C D870
http://member.acm.org/~tomaszrybak