1 /*
2 *
3 * Autopsy Forensic Browser
4 *
5 * Copyright 2012 Basis Technology Corp.
6 *
7 * Copyright 2012 42six Solutions.
8 * Contact: aebadirad <at> 42six <dot> com
9 * Project Contact/Architect: carrier <at> sleuthkit <dot> org
10 *
11 * Licensed under the Apache License, Version 2.0 (the "License");
12 * you may not use this file except in compliance with the License.
13 * You may obtain a copy of the License at
14 *
15 * http://www.apache.org/licenses/LICENSE-2.0
16 *
17 * Unless required by applicable law or agreed to in writing, software
18 * distributed under the License is distributed on an "AS IS" BASIS,
19 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
20 * See the License for the specific language governing permissions and
21 * limitations under the License.
22 */
23 package org.sleuthkit.autopsy.recentactivity;
24
26 import java.io.File;
27 import java.io.FileInputStream;
28 import java.io.IOException;
29 import java.net.MalformedURLException;
30 import java.net.URL;
31 import java.nio.MappedByteBuffer;
32 import java.nio.channels.FileChannel;
33 import java.nio.charset.Charset;
34 import java.sql.ResultSet;
35 import java.text.SimpleDateFormat;
36 import java.util.Date;
37 import java.util.List;
38 import java.util.StringTokenizer;
39 import java.util.logging.Level;
41 import java.util.regex.Matcher;
42 import java.util.regex.Pattern;
48
53 class Util {
54
55 private static Logger logger = Logger.getLogger(Util.class.getName());
56
57 private Util() {
58 }
59
60 public static boolean pathexists(String path) {
61 File file = new File(path);
62 boolean exists = file.exists();
63 return exists;
64 }
65
66 public static String utcConvert(String utc) {
67 SimpleDateFormat formatter = new SimpleDateFormat("MM-dd-yyyy HH:mm");
68 String tempconvert = formatter.format(new Date(Long.parseLong(utc)));
69 return tempconvert;
70 }
71
72 public static String readFile(String path) throws IOException {
73 FileInputStream stream = new FileInputStream(new File(path));
74 try {
75 FileChannel fc = stream.getChannel();
76 MappedByteBuffer bb = fc.map(FileChannel.MapMode.READ_ONLY, 0, fc.size());
77 /*
78 * Instead of using default, pass in a decoder.
79 */
80 return Charset.defaultCharset().decode(bb).toString();
81 } finally {
82 stream.close();
83 }
84 }
85
86 public static String getBaseDomain(String url) {
87 String host = null;
88 //strip protocol
89 String cleanUrl = url.replaceFirst("/.*:\\/\\//", "");
90
91 //strip after slashes
92 String dirToks[] = cleanUrl.split("/\\//");
93 if (dirToks.length > 0) {
94 host = dirToks[0];
95 }
96 else {
97 host = cleanUrl;
98 }
99
100 //get the domain part from host (last 2)
101 StringTokenizer tok = new StringTokenizer(host, ".");
102 StringBuilder hostB = new StringBuilder();
103 int toks = tok.countTokens();
104
105 for (int count = 0; count < toks; ++count) {
106 String part = tok.nextToken();
107 int diff = toks - count;
108 if (diff < 3) {
109 hostB.append(part);
110 }
111 if (diff == 2) {
112 hostB.append(".");
113 }
114 }
115
116
117 return hostB.toString();
118 }
119
120
121 public static String extractDomain(String value) {
122 if (value == null) {
123 return "";
124
125 }
126 String result = "";
127 // String domainPattern = "(\\w+)\\.(AC|AD|AE|AERO|AF|AG|AI|AL|AM|AN|AO|AQ|AR|ARPA|AS|ASIA|AT|AU|AW|AX|AZ|BA|BB|BD|BE|BF|BG|BH|BI|BIZ|BJ|BM|BN|BO|BR|BS|BT|BV|BW|BY|BZ|CA|CAT|CC|CD|CF|CG|CH|CI|CK|CL|CM|CN|CO|COM|COOP|CR|CU|CV|CW|CX|CY|CZ|DE|DJ|DK|DM|DO|DZ|EC|EDU|EE|EG|ER|ES|ET|EU|FI|FJ|FK|FM|FO|FR|GA|GB|GD|GE|GF|GG|GH|GI|GL|GM|GN|GOV|GP|GQ|GR|GS|GT|GU|GW|GY|HK|HM|HN|HR|HT|HU|ID|IE|IL|IM|IN|INFO|INT|IO|IQ|IR|IS|IT|JE|JM|JO|JOBS|JP|KE|KG|KH|KI|KM|KN|KP|KR|KW|KY|KZ|LA|LB|LC|LI|LK|LR|LS|LT|LU|LV|LY|MA|MC|MD|ME|MG|MH|MIL|MK|ML|MM|MN|MO|MOBI|MP|MQ|MR|MS|MT|MU|MUSEUM|MV|MW|MX|MY|MZ|NA|NAME|NC|NE|NET|NF|NG|NI|NL|NO|NP|NR|NU|NZ|OM|ORG|PA|PE|PF|PG|PH|PK|PL|PM|PN|PR|PRO|PS|PT|PW|PY|QA|RE|RO|RS|RU|RW|SA|SB|SC|SD|SE|SG|SH|SI|SJ|SK|SL|SM|SN|SO|SR|ST|SU|SV|SX|SY|SZ|TC|TD|TEL|TF|TG|TH|TJ|TK|TL|TM|TN|TO|TP|TR|TRAVEL|TT|TV|TW|TZ|UA|UG|UK|US|UY|UZ|VA|VC|VE|VG|VI|VN|VU|WF|WS|XXX|YE|YT|ZA|ZM|ZW(co\\.[a-z].))";
128 // Pattern p = Pattern.compile(domainPattern,Pattern.CASE_INSENSITIVE);
129 // Matcher m = p.matcher(value);
130 // while (m.find()) {
131 // result = value.substring(m.start(0),m.end(0));
132 // }
133
134
135 try {
136 URL url = new URL(value);
137 result = url.getHost();
138 } catch (MalformedURLException ex) {
139 //do not log if not a valid URL, and handle later
140 //Logger.getLogger(Util.class.getName()).log(Level.SEVERE, null, ex);
141 }
142
143
144 //was not a valid URL, try a less picky method
145 if (result == null || result.trim().isEmpty()) {
146 return getBaseDomain(value);
147 }
148
149 return result;
150 }
151
152 public static String getFileName(String value) {
153 String filename = "";
154 String filematch = "^([a-zA-Z]\\:)(\\\\[^\\\\/:*?<>\"|]*(?<!\\[ \\]))*(\\.[a-zA-Z]{2,6})$"; //NON-NLS
155
156 Pattern p = Pattern.compile(filematch, Pattern.CASE_INSENSITIVE | Pattern.DOTALL | Pattern.COMMENTS);
157 Matcher m = p.matcher(value);
158 if (m.find()) {
159 filename = m.group(1);
160
161 }
162 int lastPos = value.lastIndexOf('\\');
163 filename = (lastPos < 0) ? value : value.substring(lastPos + 1);
164 return filename.toString();
165 }
166
167 public static String getPath(String txt) {
168 String path = "";
169
170 //String drive ="([a-z]:\\\\(?:[-\\w\\.\\d]+\\\\)*(?:[-\\w\\.\\d]+)?)"; // Windows drive
171 String drive = "([a-z]:\\\\\\S.+)"; //NON-NLS
172 Pattern p = Pattern.compile(drive, Pattern.CASE_INSENSITIVE | Pattern.COMMENTS);
173 Matcher m = p.matcher(txt);
174 if (m.find()) {
175 path = m.group(1);
176
177 } else {
178
179 String network = "(\\\\(?:\\\\[^:\\s?*\"<>|]+)+)"; // Windows network NON-NLS
180
181 Pattern p2 = Pattern.compile(network, Pattern.CASE_INSENSITIVE | Pattern.DOTALL);
182 Matcher m2 = p2.matcher(txt);
183 if (m2.find()) {
184 path = m2.group(1);
185 }
186 }
187 return path;
188 }
189
190 public static long findID(Content dataSource, String path) {
191 String parent_path = path.replace('\\', '/'); // fix Chrome paths
192 if (parent_path.length() > 2 && parent_path.charAt(1) == ':') {
193 parent_path = parent_path.substring(2); // remove drive letter (e.g., 'C:')
194 }
195 int index = parent_path.lastIndexOf('/');
196 String name = parent_path.substring(++index);
197 parent_path = parent_path.substring(0, index);
198 //String query = "select * from tsk_files where parent_path like \"" + parent_path + "\" AND name like \"" + name + "\"";
199
200 FileManager fileManager = Case.getCurrentCase().getServices().getFileManager();
201 List<AbstractFile> files = null;
202 try {
203 files = fileManager.findFiles(dataSource, name, parent_path);
204 } catch (TskCoreException ex) {
205 logger.log(Level.WARNING, "Error fetching 'index.data' files for Internet Explorer history."); //NON-NLS
206 }
207
208 if (files == null || files.isEmpty()) {
209 return -1;
210 }
211 return files.get(0).getId();
212 }
213
214 public static boolean checkColumn(String column, String tablename, String connection) {
215 String query = "PRAGMA table_info(" + tablename + ")"; //NON-NLS
216 boolean found = false;
217 ResultSet temprs;
218 try {
219 SQLiteDBConnect tempdbconnect = new SQLiteDBConnect("org.sqlite.JDBC", "jdbc:sqlite:" + connection); //NON-NLS
220 temprs = tempdbconnect.executeQry(query);
221 while (temprs.next()) {
222 if (temprs.getString("name") == null ? column == null : temprs.getString("name").equals(column)) { //NON-NLS
223 found = true;
224 }
225 }
226 } catch (Exception ex) {
227 logger.log(Level.WARNING, "Error while trying to get columns from sqlite db." + connection, ex); //NON-NLS
228 }
229 return found;
230 }
231
232 public static ResultSet runQuery(String query, String connection) {
233 ResultSet results = null;
234 try {
235 SQLiteDBConnect tempdbconnect = new SQLiteDBConnect("org.sqlite.JDBC", "jdbc:sqlite:" + connection); //NON-NLS
236 results = tempdbconnect.executeQry(query);
237 tempdbconnect.closeConnection();
238 } catch (Exception ex) {
239 logger.log(Level.WARNING, "Error while trying to run sql query: " + query + " : " + connection, ex); //NON-NLS
240 }
241 return results;
242 }
243 }