html/cgi-bin/logs.cgi/urlfilter.dat

   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
   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
  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
  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&nbsp;</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='&lt;&lt;' /></td>
 272         <td width='5%' align='center'><input type='submit' name='ACTION' title='$Lang::tr{'day after'}' value='&gt;&gt;' /></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%' class='tbl'>";
 313         unless ($cgiparams{'LOGTYPE'} eq 'squidGuard')
 314         {
 315                 print "<tr>\n";
 316                 print "<th align='center'><b>$Lang::tr{'urlfilter time'}</b></th>\n";
 317                 print "<th align='center'><b>$Lang::tr{'urlfilter category'}</b></th>\n";
 318                 print "<th align='center'><b>$Lang::tr{'urlfilter client'}</b></th>\n";
 319                 if ($filtersettings{'ENABLE_USERNAME_LOG'} eq 'on') { print "<th align='center'><b>$Lang::tr{'urlfilter username'}</b></th>\n"; }
 320                 print "<th align='center'><b>$Lang::tr{'urlfilter dst'}</b></th>\n";
 321                 print "</tr>\n";
 322         }
 323
 324         my $col="";
 325         foreach (@slice)
 326         {
 327                 undef $attr1; undef $attr2;
 328                 $lines++;
 329                 ($date,$time,$pid,@loginfo) = split(/ /);
 330                 @ip = split(/\//,$loginfo[2]);
 331                 @category = split(/\//,$loginfo[0]);
 332                 $dsturl = $loginfo[1];
 333                 $loginfo[3] =~ s/\%5c/\\/;
 334                 if ($cgiparams{'LOGTYPE'} eq 'squidGuard') {
 335                         if (@loginfo[0] =~ /squidGuard/) { $attr1 .= "<b>"; $attr2 .= "</b>"; }
 336                         if (@loginfo[1] =~ /ready/) { $attr1 .= "<b><font color='$Header::colourgreen'>"; $attr2 .= "</font></b>"; }
 337                         if (@loginfo[2] =~ /emergency/) { $attr1 .= "<b><font color='$Header::colourerr'>"; $attr2 .= "</font></b>"; }
 338                         print "<tr>\n";
 339                 } else {
 340                         if ($lines % 2) {
 341                                 print "<tr>";
 342                                 $col="bgcolor='$color{'color22'}'";
 343                         }else {
 344                                 print "<tr>";
 345                                 $col="bgcolor='$color{'color20'}'";
 346                         }
 347                 }
 348                 if ($cgiparams{'LOGTYPE'} eq 'squidGuard') {
 349                         print "<td nowrap $col>$time &nbsp; $pid &nbsp; $attr1@loginfo$attr2</td>\n";
 350                 } else {
 351                         print "<td width='10%' align='center' nowrap $col>$time</td>\n";
 352                         print "<td width='11%' align='center' nowrap $col>$category[1]</td>\n";
 353                         print "<td width='15%' align='center' nowrap $col>$ip[0]</td>\n";
 354                         if ($filtersettings{'ENABLE_USERNAME_LOG'} eq 'on')
 355                         {
 356                                 print "<td width='12%' align='center' nowrap $col>$loginfo[3]</td>\n";
 357                                 $site = substr($dsturl,0,55);
 358                                 if (length($dsturl) > 55) { $site .= "..."; }
 359                         } else {
 360                                 $site = substr($dsturl,0,69);
 361                                 if (length($dsturl) > 69) { $site .= "..."; }
 362                         }
 363                         #print "<td>$site</td>\n";
 364                         print "<td $col><a href='$dsturl' title='$dsturl' target='_blank'>$site</a></td>\n";
 365                 }
 366                 print "</tr>\n";
 367         }
 368
 369         print "</table><br>\n";
 370
 371 }
 372
 373 &oldernewer();
 374
 375 &Header::closebox();
 376
 377 &Header::closebigbox();
 378
 379 &Header::closepage();
 380
 381 # -------------------------------------------------------------------
 382
 383 sub processevent
 384 {
 385         my $filestr='';
 386
 387         undef @log;
 388         if ($cgiparams{'LOGTYPE'} eq 'squidGuard')
 389         {
 390                 $filestr = "$logdir/squidGuard.log";
 391                 foreach $logarch (<$filestr.*.gz>)
 392                 {
 393                         open (LOG,"gzip -dc $logarch |");
 394                         foreach (<LOG>) {
 395                                 ($date,$time,$pid,@loginfo) = split(/ /);
 396                                 ($logyear,$logmonth,$logday) = split(/-/,$date);
 397                                 if (($logyear == $year) && ($logmonth == $cgiparams{'MONTH'}+1) && ($logday == $day)) { push(@log,$_) }
 398                         }
 399                         close(LOG);
 400                 }
 401                 open (LOG,$filestr);
 402                 foreach (<LOG>) {
 403                         ($date,$time,$pid,@loginfo) = split(/ /);
 404                         ($logyear,$logmonth,$logday) = split(/-/,$date);
 405                         if (($logyear == $year) && ($logmonth == $cgiparams{'MONTH'}+1) && ($logday == $day)) { push(@log,$_) }
 406                 }
 407                 close(LOG);
 408         } else {
 409                 foreach $logarch (<$logdir/*.gz>)
 410                 {
 411                         if ($logarch !~ /squidGuard\.log/) {
 412                                 open (LOG,"gzip -dc $logarch |");
 413                                 foreach (<LOG>) {
 414                                         ($date,$time,$pid,@loginfo) = split(/ /);
 415                                         ($logyear,$logmonth,$logday) = split(/-/,$date);
 416                                         if (($logyear == $year) && ($logmonth == $cgiparams{'MONTH'}+1) && ($logday == $day)) { push(@log,$_) }
 417                                 }
 418                                 close(LOG);
 419                         }
 420                 }
 421                 foreach $filestr (<$logdir/*.log>)
 422                 {
 423                         if ($filestr !~ /squidGuard\.log/) {
 424                                 open (LOG,$filestr);
 425                                 foreach (<LOG>) {
 426                                         ($date,$time,$pid,@loginfo) = split(/ /);
 427                                         ($logyear,$logmonth,$logday) = split(/-/,$date);
 428                                         if (($logyear == $year) && ($logmonth == $cgiparams{'MONTH'}+1) && ($logday == $day)) { push(@log,$_) }
 429                                 }
 430                                 close(LOG);
 431                         }
 432                 }
 433                 @log = sort { substr($a,11,8) cmp substr($b,11,8) } @log;
 434
 435         }
 436 }
 437
 438 # -------------------------------------------------------------------
 439
 440 sub oldernewer
 441 {
 442         print "<table width='100%'>";
 443         print "<tr>";
 444
 445         print "<td align='center' width='50%'>";
 446         if ($prev != -1) {
 447                 print "<a href='$ENV{'SCRIPT_NAME'}?$prev,$cgiparams{'MONTH'},$cgiparams{'DAY'},$cgiparams{'LOGTYPE'}'>$Lang::tr{'older'}</a>"; }
 448         else {
 449                 print "$Lang::tr{'older'}"; }
 450         print "</td>\n";
 451
 452         print "<td align='center' width='50%'>";
 453         if ($next != -1) {
 454                 print "<a href='$ENV{'SCRIPT_NAME'}?$next,$cgiparams{'MONTH'},$cgiparams{'DAY'},$cgiparams{'LOGTYPE'}'>$Lang::tr{'newer'}</a>"; }
 455         else {
 456                 print "$Lang::tr{'newer'}"; }
 457         print "</td>\n";
 458
 459         print "</tr>";
 460         print "</table>";
 461 }
 462
 463 # -------------------------------------------------------------------