1 from django.shortcuts import render
2 from django.http import HttpResponse, HttpRequest
9 from django.views.decorators.csrf import csrf_exempt
12 dir_list = os.listdir("logs/")
13 connection = sqlite3.connect("logs/"+dir_list[0])
14 #connection.row_factory = lambda cursor, row: row[0]
15 cursor = connection.cursor()
16 rows = cursor.execute(query).fetchall()
21 #if request.method == 'POST':
23 if request.path == "/devices/views/all_views.json":
25 dev_count=list(load_db("select count(device) from devices where type='Wi-Fi AP'"))
26 (devcount,) = dev_count[0]
27 uuid_members = uuid_members + "{ \"kismet.devices.view.description\": \"IEEE802.11 Access Points\", \"kismet.devices.view.id\": \"phydot11_accesspoints\", \"kismet.devices.view.size\": "+str(devcount)+" },"
28 dev_count=list(load_db("select count(device) from devices where phyname='IEEE802.11'"))
29 (devcount,) = dev_count[0]
30 uuid_members = uuid_members + "{ \"kismet.devices.view.description\": \"IEEE802.11 devices\", \"kismet.devices.view.id\": \"phy-IEEE802.11\", \"kismet.devices.view.size\": "+str(devcount)+" },"
31 dev_count=list(load_db("select count(device) from devices where type='RTL433'"))
32 (devcount,) = dev_count[0]
33 uuid_members = uuid_members + "{ \"kismet.devices.view.description\": \"RTL433 devices\", \"kismet.devices.view.id\": \"phy-RTL433\", \"kismet.devices.view.size\": "+str(devcount)+" },"
34 dev_count=list(load_db("select count(device) from devices where type='Z-wave'"))
35 (devcount,) = dev_count[0]
36 uuid_members = uuid_members + "{ \"kismet.devices.view.description\": \"Z-Wave devices\", \"kismet.devices.view.id\": \"phy-Z-Wave\", \"kismet.devices.view.size\": "+str(devcount)+" },"
37 dev_count=list(load_db("select count(device) from devices where type='BR/EDR'"))
38 (devcount,) = dev_count[0]
39 uuid_members = uuid_members + "{ \"kismet.devices.view.description\": \"Bluetooth devices\", \"kismet.devices.view.id\": \"phy-Bluetooth\", \"kismet.devices.view.size\": "+str(devcount)+" },"
40 dev_count=list(load_db("select count(device) from devices where type='UAV'"))
41 (devcount,) = dev_count[0]
42 uuid_members = uuid_members + "{ \"kismet.devices.view.description\": \"UAV devices\", \"kismet.devices.view.id\": \"phy-UAV\", \"kismet.devices.view.size\": "+str(devcount)+" },"
43 dev_count=list(load_db("select count(device) from devices where type='NrfMousejack'"))
44 (devcount,) = dev_count[0]
45 uuid_members = uuid_members + "{ \"kismet.devices.view.description\": \"NrfMousejack devices\", \"kismet.devices.view.id\": \"phy-NrfMousejack\", \"kismet.devices.view.size\": "+str(devcount)+"},"
46 dev_count=list(load_db("select count(device) from devices where type='BTLE'"))
47 (devcount,) = dev_count[0]
48 uuid_members = uuid_members + "{ \"kismet.devices.view.description\": \"BTLE devices\", \"kismet.devices.view.id\": \"phy-BTLE\", \"kismet.devices.view.size\": "+str(devcount)+" },"
49 dev_count=list(load_db("select count(device) from devices where phyname='AMR'"))
50 (devcount,) = dev_count[0]
51 uuid_members = uuid_members + "{ \"kismet.devices.view.description\": \"RTLAMR devices\", \"kismet.devices.view.id\": \"phy-RTLAMR\", \"kismet.devices.view.size\": "+str(devcount)+" },"
52 dev_count=list(load_db("select count(device) from devices where phyname='ADSB'"))
53 (devcount,) = dev_count[0]
54 uuid_members = uuid_members + "{ \"kismet.devices.view.description\": \"RTLADSB devices\", \"kismet.devices.view.id\": \"phy-RTLADSB\", \"kismet.devices.view.size\": "+str(devcount)+" },"
55 dev_count=list(load_db("select count(device) from devices where phyname='802.15.4'"))
56 (devcount,) = dev_count[0]
57 uuid_members = uuid_members + "{ \"kismet.devices.view.description\": \"802.15.4 devices\", \"kismet.devices.view.id\": \"phy-802.15.4\", \"kismet.devices.view.size\": "+str(devcount)+" },"
58 dev_count=list(load_db("select count(device) from devices where phyname='RADIATION'"))
59 (devcount,) = dev_count[0]
60 uuid_members = uuid_members + "{ \"kismet.devices.view.description\": \"RADIATION devices\", \"kismet.devices.view.id\": \"phy-RADIATION\", \"kismet.devices.view.size\": "+str(devcount)+" },"
61 total_dev=list(load_db("select count(device) from devices"))
62 (devcount,) = total_dev[0]
63 uuid_members=uuid_members+"{ \"kismet.devices.view.description\": \"All devices\", \"kismet.devices.view.id\": \"all\", \"kismet.devices.view.size\": "+str(devcount)+" },"
64 uuid_list = list(load_db("select uuid from datasources"))
65 for uuid in uuid_list:
67 uuid_count = list(load_db("select count(*) from data where datasource='"+str(single_uuid)+"'"))
68 (single_uuid_count,) = uuid_count[0]
69 uuid_members = uuid_members + "{\"kismet.devices.view.description\": \"Devices seen by datasource "+single_uuid+"\","
70 uuid_members = uuid_members + "\"kismet.devices.view.id\": \"seenby-"+single_uuid+"\","
71 uuid_members = uuid_members + "\"kismet.devices.view.size\": "+str(single_uuid_count)+"},"
72 uuid_members=uuid_members[:-1]
73 uuid_members=uuid_members+"]"
74 return HttpResponse(uuid_members, content_type='text/json')
75 elif request.path == "/system/user_status.json":
76 user_status = open('dbview/user_status.json')
77 return HttpResponse(user_status, content_type='text/json')
78 elif request.path == "/session/check_setup_ok":
79 return HttpResponse('Login configured in user config')
80 elif request.path == "/session/check_login":
81 return HttpResponse('Login valid')
82 elif request.path == "/dynamic.js":
83 devices = load_db("select distinct(typestring) from datasources")
84 load_file = open('static/dynamic.js')
85 return HttpResponse(load_file, content_type='application/javascript')
86 elif request.path == "/gps/location.json":
87 user_status = open('dbview/gps_status.json')
88 return HttpResponse(user_status, content_type='text/json')
89 elif request.path == "/alerts/wrapped/last-time/0/alerts.json":
90 alerts = list(load_db("select cast(json as text) from alerts"))
91 alert_string="{\"kismet.alert.list\": ["
93 (single_alert,) = alert
94 alert_string = alert_string + single_alert + ","
95 alert_string = alert_string[:-1]
96 alert_string = alert_string + "] ,\"kismet.alert.timestamp\": "+str(time.time())+"}"
97 return HttpResponse(alert_string, content_type='text/json')
98 elif request.path == "/phy/phy80211/ssids/views/ssids.json":
99 ssid_count = list(load_db("select count(device) from devices where type='Wi-Fi AP'"))
100 ssid_list = "{ \"recordsTotal\": "+str(ssid_count[0][0])+", \"data\": ["
101 ssids = list(load_db("select cast(device as text) from devices where type='Wi-Fi AP'"))
103 (single_ssid,) = ssid
104 ssid_json = json.loads(single_ssid)
106 ssid_list = ssid_list + "{"
107 ssid_list = ssid_list + "\"dot11.ssidgroup.first_time\": \"" + str(ssid_json['dot11.device']['dot11.device.last_beaconed_ssid_record']['dot11.advertisedssid.first_time']) +"\","
108 ssid_list = ssid_list + "\"dot11.ssidgroup.ssid_len\": \"" + str(ssid_json['dot11.device']['dot11.device.last_beaconed_ssid_record']['dot11.advertisedssid.ssidlen'])+"\","
109 ssid_list = ssid_list + "\"dot11.ssidgroup.crypt_set\": \"" + str(ssid_json['dot11.device']['dot11.device.last_beaconed_ssid_record']['dot11.advertisedssid.crypt_set'])+"\","
110 ssid_list = ssid_list + "\"dot11.ssidgroup.advertising_devices_len\": \"" + str(ssid_json['dot11.device']['dot11.device.num_advertised_ssids'])+"\","
111 ssid_list = ssid_list + "\"dot11.ssidgroup.probing_devices_len\": \"" + str(ssid_json['dot11.device']['dot11.device.num_probed_ssids'])+"\","
112 ssid_list = ssid_list + "\"dot11.ssidgroup.ssid\": \"" + str(ssid_json['dot11.device']['dot11.device.last_beaconed_ssid_record']['dot11.advertisedssid.ssid'])+"\","
113 ssid_list = ssid_list + "\"dot11.ssidgroup.responding_devices_len\": \"" + str(ssid_json['dot11.device']['dot11.device.last_beaconed_ssid_record']['dot11.advertisedssid.probe_response'])+"\","
114 ssid_list = ssid_list + "\"dot11.ssidgroup.last_time\": \"" + str(ssid_json['dot11.device']['dot11.device.last_beaconed_ssid_record']['dot11.advertisedssid.last_time'])+"\""
115 ssid_list = ssid_list + "},"
117 ssid_list = ssid_list[:-1]
119 ssid_list = ssid_list[:-2]+ "}], \"draw\": 3, \"recordsFiltered\": "+str(ssid_count[0][0])+" }"
120 return HttpResponse(ssid_list, content_type='text/json')
121 elif request.path == "/system/status.json":
122 user_status = open('dbview/status.json')
123 return HttpResponse(user_status, content_type='text/json')
124 elif request.path == "/alerts/alerts_view.json":
126 total_alerts=list(load_db("select count(json) from alerts"))
127 (alert_count,) = total_alerts[0]
128 alerts = list(load_db("select cast(json as text) from alerts"))
129 alert_string="{\"recordsTotal\": "+str(alert_count)+",\"data\": ["
131 (single_alert,) = alert
132 alert_string = alert_string + single_alert + ","
133 alert_string = alert_string[:-1]
134 alert_string = alert_string + "], \"draw\": 6,\"recordsFiltered\": "+str(alert_count)+"}"
135 return HttpResponse(alert_string, content_type='text/json')
136 elif request.path == "/messagebus/last-time/0/messages.json":
137 messages = list(load_db("select * from messages DESC limit 30"))
138 message_string="{\"kismet.messagebus.list\": ["
139 for message in messages:
140 message_string = message_string + "{"
141 message_string = message_string + "\"kismet.messagebus.message_string\": \"" + message[4] + "\","
143 if message[3] == "INFO":
145 if message[3] == "LOW":
147 if message[3] == "MEDIUM":
149 if message[3] == "HIGH":
151 if message[3] == "CRITICAL":
153 if message[3] == "ERROR":
155 message_string = message_string + "\"kismet.messagebus.message_flags\": \"" + str(flag) + "\","
156 message_string = message_string + "\"kismet.messagebus.message_time\": \"" + str(message[0]) + "\""
157 message_string = message_string + "},"
158 message_string = message_string[:-1]
159 message_string = message_string + "], \"kismet.messagebus.timestamp\": "+str(time.time())+" }"
160 return HttpResponse(message_string, content_type='text/json')
161 elif request.path == "/channels/channels.json":
162 user_status = open('dbview/channels.json')
163 return HttpResponse(user_status, content_type='text/json')
164 elif request.path == "/devices/views/all/devices.json":
165 #for key, value in request.POST.items():
167 # print(key+" = "+value)
174 #gotta figure out paging
176 total_dev=list(load_db("select count(device) from devices"))
177 (dev_count,) = total_dev[0]
178 dev_string = "{ \"recordsTotal\": "+str(dev_count)+", \"data\": ["
179 dev_list = list(load_db("select cast(device as text) from devices limit 126"))
180 for device in dev_list:
182 dev_string = dev_string + dev + ","
183 dev_string = dev_string[:-1]
184 dev_string = dev_string + "],\"draw\": 5,\"recordsFiltered\": "+str(dev_count)+"}"
185 return HttpResponse(dev_string, content_type='text/json')
186 elif request.path == "/eventbus/events.ws":
187 return HttpResponse("[]", content_type='text/json')
188 elif request.path == "/devices/multikey/as-object/devices.json":
189 #ClientMap incomplete.... figure out where the rest of the JSON comes from
192 for key, value in request.POST.items():
193 search_json=json.loads(value)
194 for device in search_json['devices']:
195 device_json = list(load_db("select cast(device as text) from devices where devkey='"+str(device)+"'"))
197 device_json_x = json.loads(str(tmp[0]))
198 multikey = multikey + "\""+str(device)+"\": {"
199 for field in search_json['fields']:
200 if (field[0:6] == "kismet"):
201 multikey = multikey + "\""+field+"\": \""+device_json_x[field]+"\","
202 multikey = multikey + "\"dot11.device.client_map\": {},"
203 multikey = multikey[:-1]
204 multikey = multikey + "},"
205 multikey = multikey[:-1]
206 multikey = multikey + "}"
207 return HttpResponse(multikey, content_type='text/json')