]>
Commit | Line | Data |
---|---|---|
10e4f239 MT |
1 | #!/usr/bin/perl |
2 | # | |
3 | # SmoothWall CGIs | |
4 | # | |
5 | # This code is distributed under the terms of the GPL | |
6 | # | |
7 | # (c) The SmoothWall Team | |
10e4f239 MT |
8 | # |
9 | # $Id: urlfilter.dat,v 1.4 2005/05/15 00:00:00 marco Exp $ | |
10 | # | |
11 | ||
12 | use strict; | |
13 | ||
14 | # enable only the following on debugging purpose | |
15 | #use warnings; | |
16 | #use CGI::Carp 'fatalsToBrowser'; | |
17 | ||
18 | use POSIX(); | |
19 | ||
20 | require '/var/ipfire/general-functions.pl'; | |
21 | require "${General::swroot}/lang.pl"; | |
22 | require "${General::swroot}/header.pl"; | |
23 | ||
f2fdd0c1 CS |
24 | my %color = (); |
25 | my %mainsettings = (); | |
26 | &General::readhash("${General::swroot}/main/settings", \%mainsettings); | |
27 | &General::readhash("/srv/web/ipfire/html/themes/".$mainsettings{'THEME'}."/include/colors.txt", \%color); | |
28 | ||
10e4f239 MT |
29 | my $dbdir = "${General::swroot}/urlfilter/blacklists"; |
30 | my $logdir = "/var/log/squidGuard"; | |
31 | ||
32 | my %cgiparams=(); | |
33 | my %logsettings=(); | |
34 | my %filtersettings=(); | |
35 | my %selected=(); | |
36 | ||
37 | my $errormessage=''; | |
38 | ||
39 | my @log=(); | |
40 | my $logarch=''; | |
41 | my $date=''; | |
42 | my $time=''; | |
43 | my $pid=''; | |
44 | my @loginfo=(); | |
45 | my @ip=(); | |
46 | my @category=(); | |
47 | my $dsturl=''; | |
48 | my $site=''; | |
49 | my $attr1=''; | |
50 | my $attr2=''; | |
51 | ||
52 | my $start=0; | |
53 | my $prev=0; | |
54 | my $next=0; | |
55 | my $lines=0; | |
56 | my @slice=(); | |
57 | ||
58 | my @then=(); | |
59 | my @temp=(); | |
60 | my @temp_then=(); | |
61 | my @temp_now=(); | |
62 | my $lastleap=''; | |
63 | ||
64 | my $day=''; | |
65 | my $daystr=''; | |
66 | my $month=''; | |
67 | my $monthstr=''; | |
68 | my $longmonthstr=''; | |
69 | my $year=''; | |
70 | ||
71 | my $logday=''; | |
72 | my $logmonth=''; | |
73 | my $logyear=''; | |
74 | ||
75 | my @shortmonths = ( 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', | |
76 | 'Sep', 'Oct', 'Nov', 'Dec' ); | |
77 | my @longmonths = ( $Lang::tr{'january'}, $Lang::tr{'february'}, $Lang::tr{'march'}, | |
78 | $Lang::tr{'april'}, $Lang::tr{'may'}, $Lang::tr{'june'}, $Lang::tr{'july'}, $Lang::tr{'august'}, | |
79 | $Lang::tr{'september'}, $Lang::tr{'october'}, $Lang::tr{'november'}, | |
80 | $Lang::tr{'december'} ); | |
81 | ||
82 | my @now = localtime(time); | |
83 | my $doy = $now[7]; | |
84 | my $tdoy = $now[7]; | |
85 | my $year = $now[5]+1900; | |
86 | ||
87 | $cgiparams{'DAY'} = $now[3]; | |
88 | $cgiparams{'MONTH'} = $now[4]; | |
89 | $cgiparams{'LOGTYPE'} = 'urlfilter'; | |
90 | ||
91 | &Header::getcgihash(\%cgiparams); | |
92 | $logsettings{'LOGVIEW_REVERSE'} = 'off'; | |
93 | &General::readhash("${General::swroot}/logging/settings", \%logsettings); | |
94 | if (-e "${General::swroot}/urlfilter/settings") | |
95 | { | |
96 | &General::readhash("${General::swroot}/urlfilter/settings", \%filtersettings); | |
97 | } | |
98 | ||
99 | $now[4] = $cgiparams{'MONTH'}+1; | |
100 | if($now[4] < 10) { | |
101 | $now[4] = "0$now[4]"; } | |
102 | ||
103 | $start = -1; | |
104 | ||
105 | if ($ENV{'QUERY_STRING'} && $cgiparams{'ACTION'} ne $Lang::tr{'update'}) | |
106 | { | |
107 | @temp = split(',',$ ENV{'QUERY_STRING'}); | |
108 | $start = $temp[0]; | |
109 | $cgiparams{'MONTH'} = $temp[1]; | |
110 | $cgiparams{'DAY'} = $temp[2]; | |
111 | $cgiparams{'LOGTYPE'} = $temp[3]; | |
112 | } | |
113 | ||
114 | if (!($cgiparams{'MONTH'} =~ /^(0|1|2|3|4|5|6|7|8|9|10|11)$/) || | |
115 | !($cgiparams{'DAY'} =~ /^(1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27|28|29|30|31)$/)) | |
116 | { | |
117 | $cgiparams{'DAY'} = $now[3]; | |
118 | $cgiparams{'MONTH'} = $now[4]; | |
119 | } | |
120 | elsif($cgiparams{'ACTION'} eq '>>') | |
121 | { | |
122 | @temp_now = localtime(time); | |
123 | $temp_now[4] = $cgiparams{'MONTH'}; | |
124 | $temp_now[3] = $cgiparams{'DAY'}; | |
125 | @temp_then = localtime(POSIX::mktime(@temp_now) + 86400); | |
126 | ## Retrieve the same time on the next day - | |
127 | ## 86400 seconds in a day | |
128 | $cgiparams{'MONTH'} = $temp_then[4]; | |
129 | $cgiparams{'DAY'} = $temp_then[3]; | |
130 | } | |
131 | elsif($cgiparams{'ACTION'} eq '<<') | |
132 | { | |
133 | @temp_now = localtime(time); | |
134 | $temp_now[4] = $cgiparams{'MONTH'}; | |
135 | $temp_now[3] = $cgiparams{'DAY'}; | |
136 | @temp_then = localtime(POSIX::mktime(@temp_now) - 86400); | |
137 | ## Retrieve the same time on the previous day - | |
138 | ## 86400 seconds in a day | |
139 | $cgiparams{'MONTH'} = $temp_then[4]; | |
140 | $cgiparams{'DAY'} = $temp_then[3]; | |
141 | } | |
142 | ||
143 | $monthstr = $shortmonths[$cgiparams{'MONTH'}]; | |
144 | $longmonthstr = $longmonths[$cgiparams{'MONTH'}]; | |
145 | ||
146 | if (($cgiparams{'DAY'} ne $now[3]) || ($cgiparams{'MONTH'} ne $now[4])) | |
147 | { | |
148 | @then = (); | |
149 | if ( ( $cgiparams{'MONTH'} eq $now[4]) && ($cgiparams{'DAY'} > $now[3]) || | |
150 | ( $cgiparams{'MONTH'} > $now[4] ) ) { | |
151 | @then = localtime(POSIX::mktime( 0, 0, 0, $cgiparams{'DAY'}, $cgiparams{'MONTH'}, $year - 1901 )); | |
152 | } else { | |
153 | @then = localtime(POSIX::mktime( 0, 0, 0, $cgiparams{'DAY'}, $cgiparams{'MONTH'}, $year - 1900 )); | |
154 | } | |
155 | $tdoy = $then[7]; | |
156 | $lastleap=($year-1)%4; | |
157 | if ($tdoy>$doy) { | |
158 | if ($lastleap == 0 && $tdoy < 60) { | |
159 | $doy=$tdoy+366; | |
160 | } else { | |
161 | $doy=$doy+365; | |
162 | } | |
163 | } | |
164 | } | |
165 | ||
166 | $day = $cgiparams{'DAY'}; | |
167 | if ($day <= 9) { | |
168 | $daystr = " $day"; | |
169 | } else { | |
170 | $daystr = $day; | |
171 | } | |
172 | if ($day < 10) { | |
173 | $day = "0$day"; | |
174 | } | |
175 | ||
176 | &processevent; | |
177 | ||
178 | if ($cgiparams{'ACTION'} eq $Lang::tr{'export'}) | |
179 | { | |
180 | print "Content-type: text/plain\n\n"; | |
181 | print "IPCop URL filter log\r\n"; | |
182 | print "Section: $cgiparams{'LOGTYPE'}\r\n"; | |
183 | print "Date: $daystr $longmonthstr\r\n"; | |
184 | print "\r\n"; | |
185 | ||
186 | if ($logsettings{'LOGVIEW_REVERSE'} eq 'on') { @log = reverse @log; } | |
187 | ||
188 | foreach (@log) | |
189 | { | |
190 | ($date,$time,$pid,@loginfo) = split(/ /); | |
191 | @ip = split(/\//,$loginfo[2]); | |
192 | @category = split(/\//,$loginfo[0]); | |
193 | $dsturl = $loginfo[1]; | |
194 | $loginfo[3] =~ s/\%5c/\\/; | |
195 | print "$date "; | |
196 | print "$time "; | |
197 | if ($cgiparams{'LOGTYPE'} eq 'squidGuard') | |
198 | { | |
199 | print "$pid "; | |
200 | print "@loginfo"; | |
201 | } else { | |
202 | print "$category[1] "; | |
203 | print "$ip[0] "; | |
204 | if ($filtersettings{'ENABLE_USERNAME_LOG'} eq 'on') { print "$loginfo[3] "; } | |
205 | print "$dsturl"; | |
206 | print "\n"; | |
207 | } | |
208 | } | |
209 | ||
210 | exit; | |
211 | } | |
212 | ||
213 | &Header::showhttpheaders(); | |
214 | ||
215 | &Header::openpage($Lang::tr{'urlfilter log viewer'}, 1, ''); | |
216 | ||
217 | &Header::openbigbox('100%', 'left', '', $errormessage); | |
218 | ||
219 | if ($errormessage) { | |
220 | &Header::openbox('100%', 'left', $Lang::tr{'error messages'}); | |
221 | print "<font class='base'>$errormessage </font>\n"; | |
222 | &Header::closebox(); | |
223 | } | |
224 | ||
225 | &Header::openbox('100%', 'left', "$Lang::tr{'settings'}:"); | |
226 | ||
227 | $selected{'LOGTYPE'}{$cgiparams{'LOGTYPE'}} = "selected='selected'"; | |
228 | ||
229 | print <<END | |
230 | <form method='post' action="$ENV{'SCRIPT_NAME'}"> | |
231 | <table width='100%'> | |
232 | <tr> | |
233 | <td width='8%' class='base'>$Lang::tr{'section'}</td> | |
234 | <td width='15%' class='base'> | |
235 | <select name='LOGTYPE' size='1'> | |
236 | <option value='urlfilter' $selected{'LOGTYPE'}{'urlfilter'} = "selected='selected'">$Lang::tr{'urlfilter url filter'}</option> | |
237 | <option value='squidGuard' $selected{'LOGTYPE'}{'squidGuard'} = "selected='selected'">squidGuard</option> | |
238 | </select> | |
239 | </td> | |
240 | ||
241 | <td width='8%' class='base'>$Lang::tr{'month'}:</td> | |
242 | <td width='15%'> | |
243 | <select name='MONTH'> | |
244 | END | |
245 | ; | |
246 | for ($month = 0; $month < 12; $month++) | |
247 | { | |
248 | print "\t<option "; | |
249 | if ($month == $cgiparams{'MONTH'}) { | |
250 | print 'selected="selected" '; } | |
251 | print "value='$month'>$longmonths[$month]</option>\n"; | |
252 | } | |
253 | print <<END | |
254 | </select> | |
255 | </td> | |
256 | <td width='8%' class='base'>$Lang::tr{'day'}:</td> | |
257 | <td width='15%'> | |
258 | <select name='DAY'> | |
259 | END | |
260 | ; | |
261 | for ($day = 1; $day <= 31; $day++) | |
262 | { | |
263 | print "\t<option "; | |
264 | if ($day == $cgiparams{'DAY'}) { | |
265 | print 'selected="selected" '; } | |
266 | print "value='$day'>$day</option>\n"; | |
267 | } | |
268 | print <<END | |
269 | </select> | |
270 | </td> | |
271 | <td width='5%' align='center'><input type='submit' name='ACTION' title='$Lang::tr{'day before'}' value='<<' /></td> | |
272 | <td width='5%' align='center'><input type='submit' name='ACTION' title='$Lang::tr{'day after'}' value='>>' /></td> | |
273 | <td width='10%' align='center'><input type='submit' name='ACTION' value='$Lang::tr{'update'}' /></td> | |
274 | <td width='10%' align='center'><input type='submit' name='ACTION' value='$Lang::tr{'export'}' /></td> | |
275 | </tr> | |
276 | </table> | |
277 | </form> | |
278 | END | |
279 | ; | |
280 | ||
281 | &Header::closebox(); | |
282 | ||
283 | &Header::openbox('100%', 'left', $Lang::tr{'log'}); | |
284 | ||
285 | $lines = @log; | |
286 | ||
287 | if ($start == -1) { $start = $lines - $Header::viewsize; } | |
288 | if ($start >= $lines - $Header::viewsize) { $start = $lines - $Header::viewsize; }; | |
289 | if ($start < 0) { $start = 0; } | |
290 | ||
291 | $prev = $start - $Header::viewsize; | |
292 | $next = $start + $Header::viewsize; | |
293 | ||
294 | if ($prev < 0) { $prev = 0; } | |
295 | if ($next >= $lines) { $next = -1 } | |
296 | if ($start == 0) { $prev = -1; } | |
297 | ||
298 | if ($cgiparams{'LOGTYPE'} eq 'urlfilter') | |
299 | { | |
300 | print "<b>$Lang::tr{'urlfilter log summary'} $longmonthstr $daystr: $lines</b><p>\n"; | |
301 | } | |
302 | ||
303 | @slice = splice(@log, $start, $Header::viewsize); | |
304 | ||
305 | if ($logsettings{'LOGVIEW_REVERSE'} eq 'on') { @slice = reverse @slice; } | |
306 | ||
307 | if ($lines) | |
308 | { | |
309 | ||
310 | $lines = 0; | |
311 | ||
312 | print "<table width='100%'>\n"; | |
313 | unless ($cgiparams{'LOGTYPE'} eq 'squidGuard') | |
314 | { | |
315 | print "<tr>\n"; | |
316 | print "<td align='center'><b>$Lang::tr{'urlfilter time'}</b></td>\n"; | |
317 | print "<td align='center'><b>$Lang::tr{'urlfilter category'}</b></td>\n"; | |
318 | print "<td align='center'><b>$Lang::tr{'urlfilter client'}</b></td>\n"; | |
319 | if ($filtersettings{'ENABLE_USERNAME_LOG'} eq 'on') { print "<td align='center'><b>$Lang::tr{'urlfilter username'}</b></td>\n"; } | |
320 | print "<td align='center'><b>$Lang::tr{'urlfilter dst'}</b></td>\n"; | |
321 | print "</tr>\n"; | |
322 | } | |
323 | ||
324 | foreach (@slice) | |
325 | { | |
326 | undef $attr1; undef $attr2; | |
327 | $lines++; | |
328 | ($date,$time,$pid,@loginfo) = split(/ /); | |
329 | @ip = split(/\//,$loginfo[2]); | |
330 | @category = split(/\//,$loginfo[0]); | |
331 | $dsturl = $loginfo[1]; | |
332 | $loginfo[3] =~ s/\%5c/\\/; | |
333 | if ($cgiparams{'LOGTYPE'} eq 'squidGuard') { | |
334 | if (@loginfo[0] =~ /squidGuard/) { $attr1 .= "<b>"; $attr2 .= "</b>"; } | |
335 | if (@loginfo[1] =~ /ready/) { $attr1 .= "<b><font color='$Header::colourgreen'>"; $attr2 .= "</font></b>"; } | |
336 | if (@loginfo[2] =~ /emergency/) { $attr1 .= "<b><font color='$Header::colourerr'>"; $attr2 .= "</font></b>"; } | |
337 | print "<tr>\n"; | |
338 | } else { | |
f2fdd0c1 | 339 | if ($lines % 2) { print "<tr bgcolor='$color{'color20'}'>\n"; } else { print "<tr bgcolor='$color{'color22'}'>\n"; } |
10e4f239 MT |
340 | } |
341 | if ($cgiparams{'LOGTYPE'} eq 'squidGuard') { | |
342 | print "<td nowrap>$time $pid $attr1@loginfo$attr2</td>\n"; | |
343 | } else { | |
344 | print "<td width='10%' align='center' nowrap>$time</td>\n"; | |
345 | print "<td width='11%' align='center' nowrap>$category[1]</td>\n"; | |
346 | print "<td width='15%' align='center' nowrap>$ip[0]</td>\n"; | |
347 | if ($filtersettings{'ENABLE_USERNAME_LOG'} eq 'on') | |
348 | { | |
349 | print "<td width='12%' align='center' nowrap>$loginfo[3]</td>\n"; | |
350 | $site = substr($dsturl,0,55); | |
351 | if (length($dsturl) > 55) { $site .= "..."; } | |
352 | } else { | |
353 | $site = substr($dsturl,0,69); | |
354 | if (length($dsturl) > 69) { $site .= "..."; } | |
355 | } | |
356 | #print "<td>$site</td>\n"; | |
357 | print "<td><a href='$dsturl' title='$dsturl' target='_blank'>$site</a></td>\n"; | |
358 | } | |
359 | print "</tr>\n"; | |
360 | } | |
361 | ||
362 | print "</table><br>\n"; | |
363 | ||
364 | } | |
365 | ||
366 | &oldernewer(); | |
367 | ||
368 | &Header::closebox(); | |
369 | ||
370 | &Header::closebigbox(); | |
371 | ||
372 | &Header::closepage(); | |
373 | ||
374 | # ------------------------------------------------------------------- | |
375 | ||
376 | sub processevent | |
377 | { | |
378 | my $filestr=''; | |
379 | ||
380 | undef @log; | |
381 | if ($cgiparams{'LOGTYPE'} eq 'squidGuard') | |
382 | { | |
383 | $filestr = "$logdir/squidGuard.log"; | |
384 | foreach $logarch (<$filestr.*.gz>) | |
385 | { | |
386 | open (LOG,"gzip -dc $logarch |"); | |
387 | foreach (<LOG>) { | |
388 | ($date,$time,$pid,@loginfo) = split(/ /); | |
389 | ($logyear,$logmonth,$logday) = split(/-/,$date); | |
390 | if (($logyear == $year) && ($logmonth == $cgiparams{'MONTH'}+1) && ($logday == $day)) { push(@log,$_) } | |
391 | } | |
392 | close(LOG); | |
393 | } | |
394 | open (LOG,$filestr); | |
395 | foreach (<LOG>) { | |
396 | ($date,$time,$pid,@loginfo) = split(/ /); | |
397 | ($logyear,$logmonth,$logday) = split(/-/,$date); | |
398 | if (($logyear == $year) && ($logmonth == $cgiparams{'MONTH'}+1) && ($logday == $day)) { push(@log,$_) } | |
399 | } | |
400 | close(LOG); | |
401 | } else { | |
402 | foreach $logarch (<$logdir/*.gz>) | |
403 | { | |
404 | if ($logarch !~ /squidGuard\.log/) { | |
405 | open (LOG,"gzip -dc $logarch |"); | |
406 | foreach (<LOG>) { | |
407 | ($date,$time,$pid,@loginfo) = split(/ /); | |
408 | ($logyear,$logmonth,$logday) = split(/-/,$date); | |
409 | if (($logyear == $year) && ($logmonth == $cgiparams{'MONTH'}+1) && ($logday == $day)) { push(@log,$_) } | |
410 | } | |
411 | close(LOG); | |
412 | } | |
413 | } | |
414 | foreach $filestr (<$logdir/*.log>) | |
415 | { | |
416 | if ($filestr !~ /squidGuard\.log/) { | |
417 | open (LOG,$filestr); | |
418 | foreach (<LOG>) { | |
419 | ($date,$time,$pid,@loginfo) = split(/ /); | |
420 | ($logyear,$logmonth,$logday) = split(/-/,$date); | |
421 | if (($logyear == $year) && ($logmonth == $cgiparams{'MONTH'}+1) && ($logday == $day)) { push(@log,$_) } | |
422 | } | |
423 | close(LOG); | |
424 | } | |
425 | } | |
426 | @log = sort { substr($a,11,8) cmp substr($b,11,8) } @log; | |
427 | ||
428 | } | |
429 | } | |
430 | ||
431 | # ------------------------------------------------------------------- | |
432 | ||
433 | sub oldernewer | |
434 | { | |
435 | print "<table width='100%'>"; | |
436 | print "<tr>"; | |
437 | ||
438 | print "<td align='center' width='50%'>"; | |
439 | if ($prev != -1) { | |
440 | print "<a href='$ENV{'SCRIPT_NAME'}?$prev,$cgiparams{'MONTH'},$cgiparams{'DAY'},$cgiparams{'LOGTYPE'}'>$Lang::tr{'older'}</a>"; } | |
441 | else { | |
442 | print "$Lang::tr{'older'}"; } | |
443 | print "</td>\n"; | |
444 | ||
445 | print "<td align='center' width='50%'>"; | |
446 | if ($next != -1) { | |
447 | print "<a href='$ENV{'SCRIPT_NAME'}?$next,$cgiparams{'MONTH'},$cgiparams{'DAY'},$cgiparams{'LOGTYPE'}'>$Lang::tr{'newer'}</a>"; } | |
448 | else { | |
449 | print "$Lang::tr{'newer'}"; } | |
450 | print "</td>\n"; | |
451 | ||
452 | print "</tr>"; | |
453 | print "</table>"; | |
454 | } | |
455 | ||
456 | # ------------------------------------------------------------------- |