CogNet Repository

The CogNet Repository is a part of the CogNet 802.11 Testbed. It is a MySQL database running on the same server as the CogNet Controller. Tables within it are created with the following MySQL commands by the Data Processing Module:

CREATE TABLE `<tablename>` 
(
        `Day` int unsigned,
        `Hour` int unsigned,
        `Minute` int unsigned,
        `Second` int unsigned,
        `Microseconds` int unsigned,
        `Epoch Time` int unsigned,
        `Packet Length` int unsigned,
        `Prism Msg Code` int unsigned,
        `Prism Msg Length` int unsigned,
        `Prism Device` varchar (20),
        `Prism Host Time` int unsigned,
        `Prism MAC Time` int unsigned,
        `Prism Channel` int unsigned,
        `Prism RSSI` int unsigned,
        `Prism SQ` int unsigned,
        `Prism Signal` int unsigned,
        `Prism Noise` int unsigned,
        `Prism Data Rate` int unsigned,
        `Prism IsTX` int unsigned,
        `Prism Frame Length` int unsigned,
        `80211 Type` int unsigned,
        `80211 Subtype` int unsigned,
        `80211 To DS` tinyint (1),
        `80211 From DS` tinyint (1),
        `80211 More Frag` tinyint (1),
        `80211 Retry` tinyint (1),
        `80211 Power Mgmt` tinyint (1),
        `80211 More Data` tinyint (1),
        `80211 WEP` tinyint (1),
        `80211 Order` tinyint (1),
        `80211 Duration` int unsigned,
        `80211 Source Address` varchar (20),
        `80211 Destination Address` varchar (20),
        `80211 BSSID` varchar(20),
        `80211 Transmitter Address` varchar (20),
        `80211 Receiver Address` varchar (20),
        `80211 Frag Number` int unsigned,
        `80211 Seq Number` int unsigned,
        `80211 Mgmt Hexdump` text,
        `LLC DSAP` int unsigned,
        `LLC SSAP` int unsigned,
        `LLC Org Code` int unsigned,
        `LLC Type` varchar (20),
        `IP Version` int unsigned,
        `IP Header Length` int unsigned,
        `IP Type of Service` int unsigned,
        `IP Total Length` int unsigned,
        `IP ID` int unsigned,
        `IP DF Flag` tinyint (1),
        `IP MF Flag` tinyint (1),
        `IP Fragment Offset` int unsigned,
        `IP TTL` int unsigned,
        `IP Protocol` varchar (20),
        `IP Header Checksum` int unsigned,
        `IP Source Address` varchar (20),
        `IP Destination Address` varchar (20),
        `IP Options Hexdump` text,
        `TCP Seq Number` int unsigned,
        `TCP Ack Number` int unsigned,
        `TCP Data Offset` int unsigned,
        `TCP Flags` int unsigned,
        `TCP Window` int unsigned,
        `TCP Checksum` int unsigned,
        `TCP Options Hexdump` text,
        `TCP or UDP Source Port` varchar (20),
        `TCP or UDP Destination Port` varchar (20),
        `UDP Length` int unsigned,
        `UDP Checksum` int unsigned
) TYPE=MyISAM;  

ALTER TABLE `<tablename>` ADD INDEX ( `Epoch Time` );

Notes on the CogNet Repository:

PHPMyAdmin is installed on the server, allowing easy access to the database.
Maximum table size is limited only by the maximum file size permitted by the filesystem on which the MySQL database is stored.