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

   1 #!/usr/bin/perl
   2 #
   3 # SmoothWall CGIs
   4 #
   5 # This code is distributed under the terms of the GPL
   6 #
   7 # JC HERITIER
   8 # page inspired from the initial firewalllog.dat
   9 #
  10 # Modified for IPFire by Christian Schmidt
  11 #                            and Michael Tremer (www.ipfire.org)
  12
  13 use strict;
  14 use Geo::IP::PurePerl;
  15 use Getopt::Std;
  16
  17 # enable only the following on debugging purpose
  18 #use warnings;
  19 #use CGI::Carp 'fatalsToBrowser';
  20
  21 require '/var/ipfire/general-functions.pl';
  22 require "${General::swroot}/geoip-functions.pl";
  23 require "${General::swroot}/lang.pl";
  24 require "${General::swroot}/header.pl";
  25
  26 use POSIX();
  27
  28 my %cgiparams=();
  29 my %settings=();
  30 my $pienumber;
  31 my $otherspie;
  32 my $showpie;
  33 my $sortcolumn;
  34 my $errormessage = '';
  35
  36 $cgiparams{'pienumber'} = 10;
  37 $cgiparams{'otherspie'} = 1;
  38 $cgiparams{'showpie'} = 1;
  39 $cgiparams{'sortcolumn'} = 1;
  40
  41 my @shortmonths = ( 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug',
  42         'Sep', 'Oct', 'Nov', 'Dec' );
  43 my @longmonths = ( $Lang::tr{'january'}, $Lang::tr{'february'}, $Lang::tr{'march'},
  44         $Lang::tr{'april'}, $Lang::tr{'may'}, $Lang::tr{'june'}, $Lang::tr{'july'}, $Lang::tr{'august'},
  45         $Lang::tr{'september'}, $Lang::tr{'october'}, $Lang::tr{'november'},
  46         $Lang::tr{'december'} );
  47
  48 my @now = localtime();
  49 my $dow = $now[6];
  50 my $doy = $now[7];
  51 my $tdoy = $now[7];
  52 my $year = $now[5]+1900;
  53
  54 $cgiparams{'DAY'} = $now[3];
  55 $cgiparams{'MONTH'} = $now[4];
  56 $cgiparams{'ACTION'} = '';
  57
  58 &General::readhash("${General::swroot}/fwlogs/ipsettings", \%settings);
  59 if ($settings{'pienumber'} != 0) { $cgiparams{'pienumber'} = $settings{'pienumber'} };
  60 if ($settings{'otherspie'} != 0) { $cgiparams{'otherspie'} = $settings{'otherspie'} };
  61 if ($settings{'showpie'} != 0) { $cgiparams{'showpie'} = $settings{'showpie'} };
  62 if ($settings{'sortcolumn'} != 0) { $cgiparams{'sortcolumn'} = $settings{'sortcolumn'} };
  63
  64 &Header::getcgihash(\%cgiparams);
  65 if ($cgiparams{'pienumber'} != 0) { $settings{'pienumber'} = $cgiparams{'pienumber'} };
  66 if ($cgiparams{'otherspie'} != 0) { $settings{'otherspie'} = $cgiparams{'otherspie'} };
  67 if ($cgiparams{'showpie'} != 0) { $settings{'showpie'} = $cgiparams{'showpie'} };
  68 if ($cgiparams{'sortcolumn'} != 0) { $settings{'sortcolumn'} = $cgiparams{'sortcolumn'} };
  69
  70 if ($cgiparams{'ACTION'} eq $Lang::tr{'save'})
  71 {
  72    &General::writehash("${General::swroot}/fwlogs/ipsettings", \%settings);
  73 }
  74
  75 my $start = -1;
  76 if ($ENV{'QUERY_STRING'} && $cgiparams{'ACTION'} ne $Lang::tr{'update'})
  77 {
  78         my @temp = split(',',$ENV{'QUERY_STRING'});
  79         $start = $temp[0];
  80         $cgiparams{'MONTH'} = $temp[1];
  81         $cgiparams{'DAY'} = $temp[2];
  82 }
  83
  84 if (!($cgiparams{'MONTH'} =~ /^(0|1|2|3|4|5|6|7|8|9|10|11)$/) ||
  85     !($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)$/))
  86 {
  87         $cgiparams{'DAY'} = $now[3];
  88         $cgiparams{'MONTH'} = $now[4];
  89 }
  90 elsif($cgiparams{'ACTION'} eq '>>')
  91 {
  92         my @temp_then=();
  93         my @temp_now = localtime(time);
  94         $temp_now[4] = $cgiparams{'MONTH'};
  95         $temp_now[3] = $cgiparams{'DAY'};
  96         @temp_then = localtime(POSIX::mktime(@temp_now) + 86400);
  97            ## Retrieve the same time on the next day -
  98            ## 86400 seconds in a day
  99         $cgiparams{'MONTH'} = $temp_then[4];
 100         $cgiparams{'DAY'} = $temp_then[3];
 101 }
 102 elsif($cgiparams{'ACTION'} eq '<<')
 103 {
 104         my @temp_then=();
 105         my @temp_now = localtime(time);
 106         $temp_now[4] = $cgiparams{'MONTH'};
 107         $temp_now[3] = $cgiparams{'DAY'};
 108         @temp_then = localtime(POSIX::mktime(@temp_now) - 86400);
 109            ## Retrieve the same time on the previous day -
 110            ## 86400 seconds in a day
 111         $cgiparams{'MONTH'} = $temp_then[4];
 112         $cgiparams{'DAY'} = $temp_then[3];
 113 }
 114
 115 if (($cgiparams{'DAY'} ne $now[3]) || ($cgiparams{'MONTH'} ne $now[4]))
 116 {
 117         my @then = ();
 118         if ( (  $cgiparams{'MONTH'} eq $now[4]) && ($cgiparams{'DAY'} > $now[3]) ||
 119                         ( $cgiparams{'MONTH'} > $now[4] ) ) {
 120                 @then = localtime(POSIX::mktime( 0, 0, 0, $cgiparams{'DAY'}, $cgiparams{'MONTH'}, $year - 1901 ));
 121         } else {
 122                 @then = localtime(POSIX::mktime( 0, 0, 0, $cgiparams{'DAY'}, $cgiparams{'MONTH'}, $year - 1900 ));
 123         }
 124         $tdoy = $then[7];
 125         my $lastleap=($year-1)%4;
 126         if ($tdoy>$doy) {
 127                 if ($lastleap == 0 && $tdoy < 60) {
 128                         $doy=$tdoy+366;
 129                 } else {
 130                         $doy=$doy+365;
 131                 }
 132         }
 133 }
 134
 135 my $datediff=0;
 136 my $dowd=0;
 137 my $multifile=0;
 138 if ($tdoy ne $doy) {
 139         $datediff=int(($doy-$tdoy)/7);
 140         $dowd=($doy-$tdoy)%7;
 141         if (($dow-$dowd)<1) {
 142                 $datediff=$datediff+1;
 143         }
 144         if (($dow-$dowd)==0) {
 145                 $multifile=1;
 146         }
 147 }
 148
 149 my $monthstr = $shortmonths[$cgiparams{'MONTH'}];
 150 my $longmonthstr = $longmonths[$cgiparams{'MONTH'}];
 151 my $day = $cgiparams{'DAY'};
 152 my $daystr='';
 153 if ($day <= 9) {
 154         $daystr = " $day"; }
 155 else {
 156         $daystr = $day;
 157 }
 158
 159 my $skip=0;
 160 my $filestr='';
 161 if ($datediff==0) {
 162         $filestr="/var/log/messages";
 163 } else {
 164        $filestr="/var/log/messages.$datediff";
 165        $filestr = "$filestr.gz" if -f "$filestr.gz";
 166 }
 167
 168 if (!(open (FILE,($filestr =~ /.gz$/ ? "gzip -dc $filestr |" : $filestr)))) {
 169         $errormessage = "$Lang::tr{'date not in logs'}: $filestr $Lang::tr{'could not be opened'}";
 170         $skip=1;
 171         # Note: This is in case the log does not exist for that date
 172 }
 173 my $lines = 0;
 174 my @log=();
 175
 176 if (!$skip)
 177 {
 178         while (<FILE>)
 179         {
 180                 if (/(^${monthstr} ${daystr} ..:..:..) [\w\-]+ kernel:.*(IN=.*)$/) {
 181                         $log[$lines] = $_;
 182                         $lines++;
 183                 }
 184         }
 185         close (FILE);
 186 }
 187
 188 $skip=0;
 189 if ($multifile) {
 190         $datediff=$datediff-1;
 191         if ($datediff==0) {
 192                 $filestr="/var/log/messages";
 193         } else {
 194                 $filestr="/var/log/messages.$datediff";
 195                 $filestr = "$filestr.gz" if -f "$filestr.gz";
 196         }
 197         if (!(open (FILE,($filestr =~ /.gz$/ ? "gzip -dc $filestr |" : $filestr)))) {
 198                 $errormessage="$Lang::tr{'date not in logs'}: $filestr $Lang::tr{'could not be opened'}";
 199                 $skip=1;
 200         }
 201         if (!$skip) {
 202                 while (<FILE>) {
 203                         if (/(^${monthstr} ${daystr} ..:..:..) [\w\-]+ kernel:.*(IN=.*)$/) {
 204                                 $log[$lines] = $_;
 205                                 $lines++;
 206                         }
 207                 }
 208                 close (FILE);
 209         }
 210 }
 211
 212 my $MODNAME="fwlogs";
 213
 214 &Header::showhttpheaders();
 215 &Header::openpage($Lang::tr{'firewall log'}, 1, '');
 216 &Header::openbigbox('100%', 'left', '', $errormessage);
 217
 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 print <<END
 228 <form method='post' action='$ENV{'SCRIPT_NAME'}'>
 229 <table width='100%'>
 230 <tr>
 231         <td width='10%' class='base'>$Lang::tr{'month'}:&nbsp;</td>
 232         <td width='10%'>
 233         <select name='MONTH'>
 234 END
 235 ;
 236 my $month;
 237 for ($month = 0; $month < 12; $month++)
 238 {
 239         print "\t<option ";
 240         if ($month == $cgiparams{'MONTH'}) {
 241                 print "selected='selected' "; }
 242         print "value='$month'>$longmonths[$month]</option>\n";
 243 }
 244 print <<END
 245         </select>
 246         </td>
 247         <td width='10%' class='base' align='right'>&nbsp;$Lang::tr{'day'}:&nbsp;</td>
 248         <td width='40%'>
 249         <select name='DAY'>
 250 END
 251 ;
 252 for ($day = 1; $day <= 31; $day++)
 253 {
 254         print "\t<option ";
 255         if ($day == $cgiparams{'DAY'}) {
 256                 print "selected='selected' "; }
 257         print "value='$day'>$day</option>\n";
 258 }
 259
 260 if( $cgiparams{'pienumber'} != 0){$pienumber=$cgiparams{'pienumber'};}
 261 if( $cgiparams{'otherspie'} != 0){$otherspie=$cgiparams{'otherspie'};}
 262 if( $cgiparams{'showpie'} != 0){$showpie=$cgiparams{'showpie'};}
 263 if( $cgiparams{'sortcolumn'} != 0){$sortcolumn=$cgiparams{'sortcolumn'};}
 264 print <<END
 265 </select>
 266 </td>
 267 <td width='5%'  align='center'><input type='submit' name='ACTION' title='$Lang::tr{'day before'}' value='&lt;&lt;' /></td>
 268 <td width='5%'  align='center'><input type='submit' name='ACTION' title='$Lang::tr{'day after'}' value='&gt;&gt;' /></td>
 269 <td width='20%' align='right'><input type='submit' name='ACTION' value='$Lang::tr{'update'}' /></td>
 270 </tr>
 271 <tr>
 272         <td colspan='3' align='left' valign="left">$Lang::tr{'Number of Countries for the pie chart'}:</td>
 273         <td colspan='3' align='left' valign="center"><input type='text' name='pienumber' value='$pienumber' size='4'></td>
 274         <td align='right'><input type='submit' name='ACTION' value='$Lang::tr{'save'}' /></td>
 275 </tr>
 276 </table>
 277 </form>
 278 END
 279 ;
 280
 281 &Header::closebox();
 282
 283 &Header::openbox('100%', 'left', 'Firewall Logs');
 284 print "<p><b>$Lang::tr{'firewall hits'} $longmonthstr $daystr: $lines</b></p>";
 285
 286 my $red_interface = &General::get_red_interface();
 287 my $linesjc = 0;
 288 my %tabjc;
 289 my $gi = Geo::IP::PurePerl->new();
 290
 291 if ($pienumber == -1 || $pienumber > $lines || $sortcolumn == 2) { $pienumber = $lines; };
 292 $lines = 0;
 293
 294 foreach $_ (@log)
 295 {
 296   # If ipv6 uses bridge, use PHYSIN for iface, otherwise IN
 297   if (/^... (..) (..:..:..) [\w\-]+ kernel:(.*)(PHYSIN=.*)$/) {}
 298   elsif (/^... (..) (..:..:..) [\w\-]+ kernel:(.*)(IN=.*)$/) {}
 299   my $packet = $4;
 300   my $iface  = '';
 301   if ($packet =~ /PHYSIN=(\w+)/) { $iface = $1 } elsif ($packet =~ /IN=(\w+)/) { $iface = $1 }
 302   if ( $1 =~ /2./ ) { $iface=''; }
 303   my $srcaddr = '';
 304   # Find ipv4 and ipv6 addresses
 305   if ($packet =~ /SRC\=(([\d]{1,3})(\.([\d]{1,3})){3})/) { $srcaddr = $1 }
 306   elsif ($packet =~ /SRC\=(([0-9a-fA-F]{0,4})(\:([0-9a-fA-F]{0,4})){2,7})/) { $srcaddr = $1 }
 307
 308   if($iface eq $red_interface) {
 309     # Traffic from red
 310     if($srcaddr ne '') {
 311       # srcaddr is set
 312       my $ccode = $gi->country_code_by_name($srcaddr);
 313       if ($ccode eq '') {
 314           $ccode = 'unknown';
 315       }
 316       $tabjc{$ccode} = $tabjc{$ccode} + 1 ;
 317       if(($tabjc{$ccode} == 1) && ($lines < $pienumber)) { $lines = $lines + 1; }
 318       $linesjc++;
 319     }
 320   }
 321   else {
 322     # Traffic not from red
 323     if($iface ne '') {
 324         $tabjc{$iface} = $tabjc{$iface} + 1 ;
 325         if(($tabjc{$iface} == 1) && ($lines < $pienumber)) { $lines = $lines + 1; }
 326         $linesjc++;
 327     }
 328     else {
 329       # What to do with empty iface lines?
 330       # This probably is traffic from ipfire itself (IN= OUT=XY)?
 331     }
 332   }
 333 }
 334
 335 $pienumber = $lines;
 336
 337 my @keytabjc = keys %tabjc;
 338
 339 my @slice;
 340 my $go;
 341 my $nblinejc;
 342
 343 if( $cgiparams{'linejc'} eq 'all' ){ $nblinejc = $linesjc; $go=1; }
 344 if( ($cgiparams{'linejc'} != 0) && ($cgiparams{'linejc'} ne 'all') ){ $nblinejc = $cgiparams{'linejc'}; $go=1;}
 345 if( $go != 1){ $nblinejc = 1000; }
 346
 347 my @key;
 348 my @value;
 349 my $indice=0;
 350 my @tabjc2;
 351
 352 if ($sortcolumn == 1)
 353 {
 354         @tabjc2 = sort { $b <=> $a } values (%tabjc);
 355 }
 356 else
 357 {
 358         @tabjc2 = sort { $a <=> $b } keys (%tabjc);
 359 }
 360
 361 my $colour=1;
 362
 363 ##############################################
 364 #pie chart generation
 365 use GD::Graph::pie;
 366 use GD::Graph::colour;
 367 #ips sort by hits number
 368 my $v;
 369
 370 if ($sortcolumn == 1)
 371 {
 372         for ($v=0;$v<$pienumber;$v++){
 373           findkey($tabjc2[$v]);
 374         }
 375 }
 376 else
 377 {
 378         foreach $v (@tabjc2) {
 379           $key[$indice] = $v;
 380           $value[$indice] = $tabjc{$v};
 381           $indice++;
 382         }
 383 }
 384
 385 my @ips;
 386 my @numb;
 387
 388 @ips = @key;
 389 @numb = @value;
 390
 391 my $o;
 392
 393 if($cgiparams{'otherspie'} == 2 ){}
 394 else{
 395         my $numothers;
 396         for($o=0;$o<$pienumber;$o++){
 397           $numothers = $numothers + $numb[$o];
 398         }
 399         $numothers =  $linesjc - $numothers;
 400         if ($numothers > 0) {
 401                 $ips[$pienumber]="$Lang::tr{'otherip'}";
 402                 $numb[$pienumber] =  $numothers;
 403         }
 404 }
 405
 406 my @data = (\@ips,\@numb);
 407 use GD::Graph::colour qw( :files );
 408
 409 my $color=0;
 410 my %color = ();
 411 my %mainsettings = ();
 412 &General::readhash("${General::swroot}/main/settings", \%mainsettings);
 413 &General::readhash("/srv/web/ipfire/html/themes/".$mainsettings{'THEME'}."/include/colors.txt", \%color);
 414
 415 if ($showpie != 2 && $pienumber <= 50 && $pienumber != 0) {
 416         my $mygraph = GD::Graph::pie->new(500, 350);
 417         $mygraph->set(
 418               'title' => '',
 419               'pie_height' => 50,
 420               'start_angle' => 89
 421              ) or warn $mygraph->error;
 422
 423         $mygraph->set_value_font(GD::gdMediumBoldFont);
 424         $mygraph->set( dclrs => [ "$color{'color1'}" , "$color{'color2'}" , "$color{'color3'}" , "$color{'color4'}" , "$color{'color5'}" , "$color{'color6'}" , "$color{'color7'}" , "$color{'color8'}" , "$color{'color9'}" , "$color{'color10'}" ] );
 425         my $myimage = $mygraph->plot(\@data) or die $mygraph->error;
 426
 427         my @filenames = glob("/srv/web/ipfire/html/graphs/fwlog-country*.png");
 428         unlink(@filenames);
 429         my $imagerandom = rand(1000000);
 430         my $imagename = "/srv/web/ipfire/html/graphs/fwlog-country$imagerandom.png";
 431         open(FILE,">$imagename");
 432         print FILE $myimage->png;
 433         close(FILE);
 434         #####################################################
 435         print "<div style='text-align:center;'>";
 436         print "<img src='/graphs/fwlog-country$imagerandom.png'>";
 437         print "</div>";
 438 }
 439 print <<END
 440 <table width='100%' class='tbl'>
 441 <tr>
 442 <th width='10%' align='center' class='boldbase'></th>
 443 <th width='30%' align='center' class='boldbase'><b>$Lang::tr{'country'}</b></th>
 444 <th width='30%' align='center' class='boldbase'><b>Count</b></th>
 445 <th width='30%' align='center' class='boldbase'><b>$Lang::tr{'percentage'}</b></th>
 446 </tr>
 447 END
 448 ;
 449
 450 my $total=0;
 451 my $show=0;
 452
 453 my $s;
 454 my $percent;
 455 my $col="";
 456
 457 for($s=0;$s<$lines;$s++)
 458 {
 459   $show++;
 460   $percent = $value[$s] * 100 / $linesjc;
 461   $percent = sprintf("%.f", $percent);
 462   $total = $total + $value[$s];
 463   # colors are numbered 1 to 10
 464   my $colorIndex = ($color % 10) + 1;
 465   $col="bgcolor='$color{\"color$colorIndex\"}'";
 466   $color++;
 467   print "<tr>";
 468
 469   print "<td align='center' $col>";
 470
 471   # Dont show details button for "unknown" location.
 472   if ($key[$s] ne 'unknown') {
 473         print"<form method='post' action='showrequestfromcountry.dat'>";
 474         print"<input type='hidden' name='MONTH' value='$cgiparams{'MONTH'}'>";
 475         print"<input type='hidden' name='DAY' value='$cgiparams{'DAY'}'>";
 476         print"<input type='hidden' name='country' value='$key[$s]'>";
 477         print"<input type='submit' value='details'></form>";
 478   }
 479   elsif ($key[$s] eq 'unknown') {
 480         print "unknown";
 481   }
 482   # Looks dangerous to use hardcoded interface names here. Probably needs fixing.
 483   if ($key[$s] eq 'blue0' || $key[$s] eq 'green0' || $key[$s] eq 'orange0' ) {
 484       print "<td align='center' $col>$key[$s]</td>";
 485   }
 486   else {
 487         my $fcode = lc($key[$s]);
 488
 489         # Get flag icon for of the country.
 490         my $flag_icon = &GeoIP::get_flag_icon($fcode);
 491
 492         if($flag_icon) {
 493                 print "<td align='center' $col><a href='/cgi-bin/country.cgi#$fcode'><img src='$flag_icon' border='0' align='absmiddle' alt='$key[$s]' title='$key[$s]'></a></td>";
 494         } else {
 495                 print "<td align='center' $col>$key[$s]</td>";
 496       }
 497   }
 498   print "<td align='center' $col>$value[$s]</td>";
 499   print "<td align='center' $col>$percent</td>";
 500   print "</tr>";
 501 }
 502
 503 if($cgiparams{'otherspie'} == 2 ){}
 504 else{
 505   # colors are numbered 1 to 10
 506   my $colorIndex = ($color % 10) + 1;
 507   $col="bgcolor='$color{\"color$colorIndex\"}'";
 508   print "<tr>";
 509
 510 if ( $linesjc ne "0")
 511 {
 512 my $dif;
 513 $dif = $linesjc - $total;
 514 $percent = $dif * 100 / $linesjc;
 515 $percent = sprintf("%.f", $percent);
 516 print <<END
 517 <td align='center' $col></TD>
 518 <td align='center' $col>$Lang::tr{'other countries'}</td>
 519 <td align='center' $col>$dif</TD>
 520 <td align='center' $col>$percent</TD>
 521 </tr>
 522 END
 523 ;
 524 }
 525 }
 526 print <<END
 527 </TABLE>
 528 END
 529 ;
 530
 531 &Header::closebox();
 532 &Header::closebigbox();
 533 &Header::closepage();
 534
 535 sub findkey {
 536   my $v;
 537   foreach $v (@keytabjc) {
 538     if ($tabjc{$v} eq $_[0]) {
 539       delete $tabjc{$v};
 540       $key[$indice] = "$v";
 541       $value[$indice] = $_[0];
 542       $indice++;
 543       last;
 544     }
 545   }
 546 }
 547 sub checkversion {
 548         #Automatic Updates is disabled
 549         return "0","0";
 550 }
 551