STRLCPY/wifi_db

■ ■ ■ ■ ■ ■

README.md

		skipped 149 lines
150	150
151	151		- [ ] Table files, if file exists skip (full path)
152	152
	153	+	- [ ] Get HTTP POST passwords
	154	+
	155	+	- [ ] DNS querys
	156	+
153	157		---------
154	158
155	159		This program is a continuation of a part of: https://github.com/T1GR3S/airo-heat
		skipped 9 lines

■ ■ ■ ■ ■ ■

database_utils.py

		skipped 175 lines
176	176		wps_config_methods_keypad))
177	177		return int(0)
178	178		except sqlite3.IntegrityError as error:
	179	+	# TODO: Update info if there is more, like AP
179	180		# errors += 1
180	181		if verbose:
181		-	print("insertWPS" + str(error))
	182	+	print("insertWPS " + str(error))
182	183		return int(0)
183	184		except sqlite3.Error as error:
184	185		if verbose:
		skipped 258 lines

■ ■ ■ ■ ■ ■

wifi_db.py

		skipped 117 lines
118	118		or ('kismet.netxml' in file)
119	119		or ('.log.csv' in file)):
120	120		files.append(file)
121		-
122		-	files.sort()
	121	+	# Sorted reverse to cap last
	122	+	files.sort(key=os.path.splitext, reverse=True) #by name and extension
123	123		print(files)
124	124
125	125		counter = 0
		skipped 8 lines
134	134		hcxpcapngtool, tshark)
135	135
136	136		else: # it is a file
137		-	process_capture(ouiMap, capture_aux, database,
	137	+	process_capture(ouiMap, capture, database,
138	138		verbose, fake_lat, fake_lon,
139	139		hcxpcapngtool, tshark)
140	140
		skipped 60 lines

■ ■ ■ ■ ■ ■

wifi_db_aircrack.py

		skipped 394 lines
395	395		wmgt = 'wlan.mgt'
396	396		try:
397	397		bssid = pkt.wlan.sa
	398	+	bssid = bssid.upper()
398	399		except Exception:
399	400		errors += 1
400	401		try:
		skipped 32 lines
433	434		except Exception:
434	435		errors += 1
435	436
436		-	database_utils.insertWPS(cursor, verbose, bssid, wlan_ssid,
	437	+	errors += database_utils.insertWPS(cursor, verbose, bssid, wlan_ssid,
437	438		wps_version, wps_device_name,
438	439		wps_model_name, wps_model_number,
439	440		wps_config_methods,
		skipped 94 lines

■ ■ ■ ■ ■ ■

wifi_db_database.sql

		skipped 58 lines
59	59		wps_model_number TEXT NOT NULL,
60	60		wps_config_methods TEXT NOT NULL,
61	61		wps_config_methods_keypad TEXT NOT NULL,
62		-	CONSTRAINT KeyWPS PRIMARY KEY (bssid),
63		-	CONSTRAINT RelationshipWPS FOREIGN KEY (bssid) REFERENCES AP (bssid) ON UPDATE CASCADE ON DELETE CASCADE
	62	+	CONSTRAINT KeyWPS PRIMARY KEY (bssid)
	63	+	/CONSTRAINT RelationshipWPS FOREIGN KEY (bssid) REFERENCES AP (bssid) ON UPDATE CASCADE ON DELETE CASCADE/
64	64		);
65	65
66	66
		skipped 28 lines
95	95		mac TEXT NOT NULL,
96	96		file TEXT NOT NULL,
97	97		hashcat TEXT,
98		-	CONSTRAINT Key6 PRIMARY KEY (bssid,mac,file),
99		-	CONSTRAINT FRelationship4 FOREIGN KEY (bssid) REFERENCES AP (bssid) ON UPDATE CASCADE ON DELETE CASCADE,
100		-	CONSTRAINT FRelationship5 FOREIGN KEY (mac) REFERENCES Client (mac) ON UPDATE CASCADE ON DELETE CASCADE
	98	+	CONSTRAINT Key6 PRIMARY KEY (bssid,mac,file)
	99	+	/*CONSTRAINT FRelationship4 FOREIGN KEY (bssid) REFERENCES AP (bssid) ON UPDATE CASCADE ON DELETE CASCADE,
	100	+	CONSTRAINT FRelationship5 FOREIGN KEY (mac) REFERENCES Client (mac) ON UPDATE CASCADE ON DELETE CASCADE*/
101	101		);
102	102
103	103		CREATE TABLE IF NOT EXISTS Identity
		skipped 1 lines
105	105		bssid TEXT NOT NULL,
106	106		mac TEXT NOT NULL,
107	107		identity TEXT NOT NULL,
108		-	CONSTRAINT Key7 PRIMARY KEY (bssid,mac,identity),
109		-	CONSTRAINT FRelationship6 FOREIGN KEY (bssid) REFERENCES AP (bssid) ON UPDATE CASCADE ON DELETE CASCADE,
110		-	CONSTRAINT FRelationship7 FOREIGN KEY (mac) REFERENCES Client (mac) ON UPDATE CASCADE ON DELETE CASCADE
	108	+	CONSTRAINT Key7 PRIMARY KEY (bssid,mac,identity)
	109	+	/*CONSTRAINT FRelationship6 FOREIGN KEY (bssid) REFERENCES AP (bssid) ON UPDATE CASCADE ON DELETE CASCADE,
	110	+	CONSTRAINT FRelationship7 FOREIGN KEY (mac) REFERENCES Client (mac) ON UPDATE CASCADE ON DELETE CASCADE*/
111	111		);
112	112

Remove FOREIGN KEY in cap process, sort folder rev