无线抓包 结果数据调整

[unissoft-bj]

最新抓包进程全部用shell script做

wlcap -> sed剔除 -> awk（行合并）（-> 写入mysql） 10分钟为一个周期，10分钟的txt文件约20k~50k 分成3个列：mac/timestamp/rssi+ssid(多个,写在一个field,varchar(256))

table结构需要调整一下

mac timestamp（10s取整） rssi^ssid（多个写在一个field）

00:1b:77:1c:92:55,1431862890,-75|-77|-86|-93|-88|-87|-46|-44|-45|-46|-44|-46|-47|-47|-85|-82|-87|-44|-46|-44|-46|-74

66:46:61:97:f8:37,1431862940,-106

4c:bc:a5:0d:81:4c,1431863000,-101^FAST_78D082|-101^FAST_78D082

fc:19:10:32:75:94,1431862900,-106

98:b8:e3:55:3d:78,1431863300,-91^shangdao|-89^shangdao|-91^shangdao|-90^shangdao|-88^shangdao|-88^shangdao

[unissoft-bj]

DROP TABLE IF EXISTS 802_11_packet; /_!40101 SET @saved_cs_client = @@character_setclient */; /!40101 SET character_setclient = utf8 /; CREATE TABLE 802_11_packet ( id int(11) NOT NULL AUTO_INCREMENT, mac varchar(17) DEFAULT NULL, pkttime varchar(10) DEFAULT NULL, pktsignal varchar(2048) DEFAULT NULL, create_t datetime DEFAULT NULL, src_ip_mac varchar(17) DEFAULT NULL, PRIMARY KEY (id), KEY packettime (pkttime), KEY mac (mac) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; /_!40101 SET character_set_client = @saved_cs_client */;