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

   1 #!/usr/bin/perl
   2 # SmoothWall CGIs
   3 #
   4 # This code is distributed under the terms of the GPL
   5 #
   6 # JC HERITIER
   7 # page inspired from the initial firewalllog.dat
   8 #
   9 # Modified for IPFire by Christian Schmidt (www.ipfire.org)
  10
  11 # enable only the following on debugging purpose
  12 #use warnings;
  13 #use CGI::Carp 'fatalsToBrowser';
  14
  15 #use strict;
  16
  17 require '/var/ipfire/general-functions.pl';
  18 require "${General::swroot}/geoip-functions.pl";
  19 require "${General::swroot}/lang.pl";
  20 require "${General::swroot}/header.pl";
  21
  22 use POSIX();
  23
  24 #workaround to suppress a warning when a variable is used only once
  25 my @dummy = ( ${Header::table2colour} );
  26 undef (@dummy);
  27
  28 my %cgiparams=();
  29 my %logsettings=();
  30 my $errormessage = '';
  31
  32 my @shortmonths = ( 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug',
  33         'Sep', 'Oct', 'Nov', 'Dec' );
  34 my @longmonths = ( $Lang::tr{'january'}, $Lang::tr{'february'}, $Lang::tr{'march'},
  35         $Lang::tr{'april'}, $Lang::tr{'may'}, $Lang::tr{'june'}, $Lang::tr{'july'}, $Lang::tr{'august'},
  36         $Lang::tr{'september'}, $Lang::tr{'october'}, $Lang::tr{'november'},
  37         $Lang::tr{'december'} );
  38
  39 my @now = localtime();
  40 my $dow = $now[6];
  41 my $doy = $now[7];
  42 my $tdoy = $now[7];
  43 my $year = $now[5]+1900;
  44
  45 $cgiparams{'DAY'} = $now[3];
  46 $cgiparams{'MONTH'} = $now[4];
  47 $cgiparams{'ACTION'} = '';
  48
  49 &Header::getcgihash(\%cgiparams);
  50
  51 $logsettings{'LOGVIEW_REVERSE'} = 'off';
  52 &General::readhash("${General::swroot}/logging/settings", \%logsettings);
  53
  54 my $start = -1;
  55 if ($ENV{'QUERY_STRING'} && $cgiparams{'ACTION'} ne $Lang::tr{'update'})
  56 {
  57         my @temp = split(',',$ENV{'QUERY_STRING'});
  58         $start = $temp[0];
  59         $cgiparams{'MONTH'} = $temp[1];
  60         $cgiparams{'DAY'} = $temp[2];
  61         $cgiparams{country} = $temp[3];
  62 }
  63
  64 if (!($cgiparams{'MONTH'} =~ /^(0|1|2|3|4|5|6|7|8|9|10|11)$/) ||
  65         !($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)$/))
  66 {
  67         $cgiparams{'DAY'} = $now[3];
  68         $cgiparams{'MONTH'} = $now[4];
  69 }
  70 elsif($cgiparams{'ACTION'} eq '>>')
  71 {
  72         my @temp_then=();
  73         my @temp_now = localtime(time);
  74         $temp_now[4] = $cgiparams{'MONTH'};
  75         $temp_now[3] = $cgiparams{'DAY'};
  76         @temp_then = localtime(POSIX::mktime(@temp_now) + 86400);
  77            ## Retrieve the same time on the next day -
  78            ## 86400 seconds in a day
  79         $cgiparams{'MONTH'} = $temp_then[4];
  80         $cgiparams{'DAY'} = $temp_then[3];
  81 }
  82 elsif($cgiparams{'ACTION'} eq '<<')
  83 {
  84         my @temp_then=();
  85         my @temp_now = localtime(time);
  86         $temp_now[4] = $cgiparams{'MONTH'};
  87         $temp_now[3] = $cgiparams{'DAY'};
  88         @temp_then = localtime(POSIX::mktime(@temp_now) - 86400);
  89            ## Retrieve the same time on the previous day -
  90            ## 86400 seconds in a day
  91         $cgiparams{'MONTH'} = $temp_then[4];
  92         $cgiparams{'DAY'} = $temp_then[3];
  93 }
  94
  95 if (($cgiparams{'DAY'} ne $now[3]) || ($cgiparams{'MONTH'} ne $now[4]))
  96 {
  97         my @then = ();
  98         if ( (  $cgiparams{'MONTH'} eq $now[4]) && ($cgiparams{'DAY'} > $now[3]) ||
  99                         ( $cgiparams{'MONTH'} > $now[4] ) ) {
 100                 @then = localtime(POSIX::mktime( 0, 0, 0, $cgiparams{'DAY'}, $cgiparams{'MONTH'}, $year - 1901 ));
 101         } else {
 102                 @then = localtime(POSIX::mktime( 0, 0, 0, $cgiparams{'DAY'}, $cgiparams{'MONTH'}, $year - 1900 ));
 103         }
 104         $tdoy = $then[7];
 105         my $lastleap=($year-1)%4;
 106         if ($tdoy>$doy) {
 107                 if ($lastleap == 0 && $tdoy < 60) {
 108                         $doy=$tdoy+366;
 109                 } else {
 110                         $doy=$doy+365;
 111                 }
 112         }
 113 }
 114 my $datediff=0;
 115 my $dowd=0;
 116 my $multifile=0;
 117 if ($tdoy ne $doy) {
 118         $datediff=int(($doy-$tdoy)/7);
 119         $dowd=($doy-$tdoy)%7;
 120         if (($dow-$dowd)<1) {
 121                 $datediff=$datediff+1;
 122         }
 123         if (($dow-$dowd)==0) {
 124                 $multifile=1;
 125         }
 126 }
 127
 128 my $monthstr = $shortmonths[$cgiparams{'MONTH'}];
 129 my $longmonthstr = $longmonths[$cgiparams{'MONTH'}];
 130 my $day = $cgiparams{'DAY'};
 131 my $daystr='';
 132 if ($day <= 9) {
 133         $daystr = " $day"; }
 134 else {
 135         $daystr = $day;
 136 }
 137
 138 my $skip=0;
 139 my $filestr='';
 140 if ($datediff==0) {
 141         $filestr="/var/log/messages";
 142 } else {
 143         $filestr="/var/log/messages.$datediff";
 144         $filestr = "$filestr.gz" if -f "$filestr.gz";
 145 }
 146
 147 if (!(open (FILE,($filestr =~ /.gz$/ ? "gzip -dc $filestr |" : $filestr)))) {
 148         $errormessage = "$Lang::tr{'date not in logs'}: $filestr $Lang::tr{'could not be opened'}";
 149         $skip=1;
 150         # Note: This is in case the log does not exist for that date
 151 }
 152 my $lines = 0;
 153 my @log=();
 154 my $country = $cgiparams{country};
 155
 156 if (!$skip)
 157 {
 158         while (<FILE>) {
 159                 # First check whether valid log line (date, day)
 160                 if (/(^${monthstr} ${daystr} ..:..:..) [\w\-]+ kernel:.*(IN=.*)$/) {
 161                         # If ipv6 uses bridge, then use PHYSIN otherwise use IN
 162                         if    (/(^${monthstr} ${daystr} ..:..:..) [\w\-]+ kernel:.*(PHYSIN=.*)$/) {}
 163                         elsif (/(^${monthstr} ${daystr} ..:..:..) [\w\-]+ kernel:.*(IN=.*)$/) {}
 164                         my $packet      = $2;
 165                         my $iface = '';
 166                         my $srcaddr = '';
 167                         # If ipv6 uses bridge, use PHYSIN otherwise IN
 168                         if ($packet =~ /PHYSIN=(\w+)/) { $iface = $1; } elsif ($packet =~ /IN=(\w+)/) { $iface = $1; }
 169                         # Extract ipv4 and ipv6 addresses
 170                         if (($packet =~ /SRC\=(([\d]{1,3})(\.([\d]{1,3})){3})/) or ($packet =~ /SRC\=(([0-9a-fA-F]{0,4})(\:([0-9a-fA-F]{0,4})){2,7})/)) {
 171                                 $srcaddr = $1;
 172                         }
 173
 174                         if($iface eq $country) {
 175                                 # iface matches country code
 176                                 $log[$lines] = $_;
 177                                 $lines++;
 178                         }
 179                         elsif($srcaddr ne '') {
 180                                 # or srcaddr matches country code
 181                                 my $ccode = &GeoIP::lookup($srcaddr);
 182                                 if($ccode eq uc($country)){
 183                                         $log[$lines] = $_;
 184                                         $lines++;
 185                                 }
 186                         }
 187                 }
 188         }
 189         close (FILE);
 190 }
 191
 192 $skip=0;
 193 if ($multifile) {
 194         $datediff=$datediff-1;
 195         if ($datediff==0) {
 196                 $filestr="/var/log/messages";
 197         } else {
 198                 $filestr="/var/log/messages.$datediff";
 199                 $filestr = "$filestr.gz" if -f "$filestr.gz";
 200         }
 201         if (!(open (FILE,($filestr =~ /.gz$/ ? "gzip -dc $filestr |" : $filestr)))) {
 202                 $errormessage="$Lang::tr{'date not in logs'}: $filestr $Lang::tr{'could not be opened'}";
 203                 $skip=1;
 204         }
 205         if (!$skip) {
 206                 while (<FILE>) {
 207                         # Check if valid log line (date, day)
 208                         if (/(^${monthstr} ${daystr} ..:..:..) [\w\-]+ kernel:.*(IN=.*)$/) {
 209                                 my $iface = '';
 210                                 # If ipv6 uses bridge, then use PHYSIN otherwise IN
 211                                 if ($_ =~ /PHYSIN=(\w+)/) { $iface = $1; } elsif ($_ =~ /IN=(\w+)/) { $iface = $1; }
 212
 213                                 if($iface eq $country) {
 214                                         # iface matches country code
 215                                         $log[$lines] = $_;
 216                                         $lines++;
 217                                 }
 218                                 # extract ipv4 and ipv6 address
 219                                 elsif (($_ =~ /SRC\=(([\d]{1,3})(\.([\d]{1,3})){3})/) or ($_ =~ /SRC\=(([0-9a-fA-F]{0,4})(\:([0-9a-fA-F]{0,4})){2,7})/)) {
 220                                         my $srcaddr=$1;
 221                                         my $ccode = $gi->country_code_by_name($srcaddr);
 222                                         if($ccode eq uc($country)){
 223                                                 # or srcaddr matches country code
 224                                                 $log[$lines] = $_;
 225                                                 $lines++;
 226                                         }
 227                                 }
 228                         }
 229                 }
 230                 close (FILE);
 231         }
 232 }
 233
 234 &Header::showhttpheaders();
 235 &Header::openpage($Lang::tr{'firewall log country'}, 1, '');
 236 &Header::openbigbox('100%', 'left', '', $errormessage);
 237
 238 if ($errormessage) {
 239         &Header::openbox('100%', 'left', $Lang::tr{'error messages'});
 240         print "<font class='base'>$errormessage&nbsp;</font>\n";
 241         &Header::closebox();
 242 }
 243
 244 &Header::openbox('100%', 'left', "$Lang::tr{'settings'}:");
 245
 246 print <<END
 247 <form method='post' action='$ENV{'SCRIPT_NAME'}'>
 248 <table width='100%'>
 249 <tr>
 250         <td width='10%' class='base'>$Lang::tr{'month'}:&nbsp;</td>
 251         <td width='10%'>
 252         <select name='MONTH'>
 253 END
 254 ;
 255 my $month;
 256 for ($month = 0; $month < 12; $month++)
 257 {
 258         print "\t<option ";
 259         if ($month == $cgiparams{'MONTH'}) {
 260                 print "selected='selected' ";
 261         }
 262         print "value='$month'>$longmonths[$month]</option>\n";
 263 }
 264 print <<END
 265         </select>
 266         </td>
 267         <td width='10%' class='base' align='right'>&nbsp;$Lang::tr{'day'}:&nbsp;</td>
 268         <td width='40%'>
 269         <select name='DAY'>
 270 END
 271 ;
 272 for ($day = 1; $day <= 31; $day++)
 273 {
 274         print "\t<option ";
 275         if ($day == $cgiparams{'DAY'}) {
 276                 print "selected='selected' "; }
 277         print "value='$day'>$day</option>\n";
 278 }
 279 print <<END
 280 </select>
 281 </td>
 282 <td width='5%'  align='center'><input type='submit' name='ACTION' title='$Lang::tr{'day before'}' value='&lt;&lt;' /></td>
 283 <td width='5%'  align='center'><input type='submit' name='ACTION' title='$Lang::tr{'day after'}' value='&gt;&gt;' /></td>
 284 <td width='10%' align='center'><input type='submit' name='ACTION' value='$Lang::tr{'update'}' /></td>
 285 <tr><td width='15%'>$Lang::tr{'source ip country'}</td><td><input type='text' name='country' value='$cgiparams{country}'size='15'></td></tr>
 286 </tr>
 287 </table>
 288 </form>
 289 END
 290 ;
 291
 292 &Header::closebox();
 293
 294 &Header::openbox('100%', 'left', $Lang::tr{'firewall log country'});
 295 print "<p><b>$Lang::tr{'firewall hits'} $longmonthstr $daystr: $lines</b></p>";
 296
 297 if ($start == -1) {
 298         $start = $lines - ${Header::viewsize};
 299 }
 300 if ($start >= $lines - ${Header::viewsize}) { $start = $lines - ${Header::viewsize}; };
 301 if ($start < 0) { $start = 0; }
 302
 303 my $prev = $start - ${Header::viewsize};
 304 my $next = $start + ${Header::viewsize};
 305
 306 if ($prev < 0) { $prev = 0; }
 307 if ($next >= $lines) { $next = -1 }
 308 if ($start == 0) { $prev = -1; }
 309
 310 if ($lines != 0) { &oldernewer(); }
 311
 312 print <<END
 313 <table width='100%'>
 314 <tr>
 315 <td width='10%' align='center' class='boldbase'><b>$Lang::tr{'time'}</b></td>
 316 <td width='13%' align='center' class='boldbase'><b>$Lang::tr{'chain'}</b></td>
 317 <td width='5%' align='center' class='boldbase'><b>$Lang::tr{'iface'}</b></td>
 318 <td width='5%' align='center' class='boldbase'><b>$Lang::tr{'proto'}</b></td>
 319 <td width='16%' align='center' class='boldbase'><b>$Lang::tr{'source'}</b></td>
 320 <td width='10%' align='center' class='boldbase'><b>$Lang::tr{'src port'}</b></td>
 321 <td width='16%' align='center' class='boldbase'><b>$Lang::tr{'destination'}</b></td>
 322 <td width='16%' align='center' class='boldbase'><b>$Lang::tr{'dst port'}</b></td>
 323 </tr>
 324 END
 325 ;
 326
 327 my @slice = splice(@log, $start, ${Header::viewsize});
 328
 329 if ($logsettings{'LOGVIEW_REVERSE'} eq 'on') { @slice = reverse @slice; }
 330
 331 $lines = 0;
 332 foreach $_ (@slice)
 333 {
 334         $a = $_;
 335         # If ipv6 uses bridge, use PHYSIN otherwise use IN
 336         if    (/^... (..) (..:..:..) [\w\-]+ kernel:(.*)(PHYSIN=.*)$/) {}
 337         elsif (/^... (..) (..:..:..) [\w\-]+ kernel:(.*)(IN=.*)$/) {};
 338         my $packet = $4;
 339         my $iface = '';
 340         # If ipv6 uses bridge, use PHYSIN otherwise use IN
 341         if ($packet =~ /PHYSIN=(\w+)/) { $iface = $1; } elsif ($packet =~ /IN=(\w+)/) { $iface = $1; }
 342         if ( $1 =~ /2./ ){ $iface=""; }
 343         my $srcaddr = '';
 344         # Extract ipv4 and ipv6 addresses
 345         if (($packet =~ /SRC\=(([\d]{1,3})(\.([\d]{1,3})){3})/) or ($packet =~ /SRC\=(([0-9a-fA-F]{0,4})(\:([0-9a-fA-F]{0,4})){2,7})/)) {
 346                 $srcaddr = $1;
 347         };
 348
 349         if($iface eq $country || $srcaddr ne '') {
 350                 my $ccode='';
 351                 if($iface ne $country) {
 352                         $ccode = &GeoIP::lookup($srcaddr);
 353                 }
 354                 if($iface eq $country || $ccode eq uc($country)) {
 355                         my $chain = '';
 356                         my $in = '-'; my $out = '-';
 357                         my $srcaddr = ''; my $dstaddr = '';
 358                         my $protostr = '';
 359                         my $srcport = ''; my $dstport = '';
 360
 361                         # If ipv6 uses bridge, the use PHYSIN otherwise use IN
 362                         if    ($_ =~ /(^.* ..:..:..) [\w\-]+ kernel:(.*)(IN=.*)(PHYSIN=.*)$/) {}
 363                         elsif ($_ =~ /(^.* ..:..:..) [\w\-]+ kernel:(.*)(IN=.*)$/) {}
 364                         my $timestamp = $1; my $chain = $2; my $packet = $3;
 365                         $timestamp =~ /(...) (..) (..:..:..)/;
 366                         my $month = $1; my $day = $2; my $time = $3;
 367
 368                         # If ipv6 uses bridge, use PHYSIN and PHYSOUT, otherwise use IN and OUT
 369                         if ($a =~ /PHYSIN=(\w+)/)  { $iface = $1; } elsif ($a =~ /IN=(\w+)/)  { $iface = $1; }
 370                         if ($a =~ /PHYSOUT=(\w+)/) { $out = $1; }   elsif ($a =~ /OUT=(\w+)/) { $out = $1; }
 371                         # Extract ipv4 and ipv6 addresses
 372                         if (($a =~ /SRC\=(([\d]{1,3})(\.([\d]{1,3})){3})/) or ($a =~ /SRC\=(([0-9a-fA-F]{0,4})(\:([0-9a-fA-F]{0,4})){2,7})/)) { $srcaddr = $1; }
 373                         if (($a =~ /DST\=(([\d]{1,3})(\.([\d]{1,3})){3})/) or ($a =~ /DST\=(([0-9a-fA-F]{0,4})(\:([0-9a-fA-F]{0,4})){2,7})/)) { $dstaddr = $1; }
 374                         if ($a =~ /PROTO\=(\w+)/) { $protostr = $1; }
 375                         my $protostrlc = lc($protostr);
 376                         if ($a =~ /SPT\=([\d\.]+)/){ $srcport = $1; }
 377                         if ($a =~ /DPT\=([\d\.]+)/){ $dstport = $1; }
 378
 379                         if ($lines % 2) {
 380                                 print "<tr bgcolor='${Header::table1colour}'>\n";
 381                         }
 382                         else {
 383                                 print "<tr bgcolor='${Header::table2colour}'>\n";
 384                         }
 385                         print <<END
 386                         <td align='center'>$time</td>
 387                         <td align='center'>$chain</td>
 388                         <td align='center'>$iface</td>
 389                         <td align='center'>$protostr</td>
 390                         <td align='center'>
 391                         <table width='100%' cellpadding='0' cellspacing='0'><tr>
 392                         <td align='center'><a href='/cgi-bin/ipinfo.cgi?ip=$srcaddr'>$srcaddr</a></td>
 393                         </tr></table>
 394                         </td>
 395                         <td align='center'>$srcport</td>
 396                         <td align='center'>
 397                         <table width='100%' cellpadding='0' cellspacing='0'><tr>
 398                         <td align='center'><a href='/cgi-bin/ipinfo.cgi?ip=$dstaddr'>$dstaddr</a></td>
 399                         </tr></table>
 400                         </td>
 401                         <td align='center'>$dstport</td>
 402                         </tr>
 403 END
 404                         ;
 405                         $lines++;
 406                 }
 407         }
 408 }
 409
 410 print <<END
 411 </table>
 412 END
 413 ;
 414
 415 &oldernewer();
 416
 417         print"<table width='100%'><tr><td align='center'><a href='/cgi-bin/logs.cgi/firewalllogcountry.dat'><img src='/images/back.png' alt='$Lang::tr{'back'}' title='$Lang::tr{'back'}' /></a></td></tr></table>";
 418
 419 &Header::closebox();
 420
 421 &Header::closebigbox();
 422
 423 &Header::closepage();
 424
 425 sub oldernewer
 426 {
 427         print <<END
 428         <table width='100%'>
 429         <tr>
 430 END
 431         ;
 432
 433         print "<td align='center' width='50%'>";
 434         if ($prev != -1) {
 435                 print "<a href='/cgi-bin/logs.cgi/showrequestfromcountry.dat?$prev,$cgiparams{'MONTH'},$cgiparams{'DAY'},$cgiparams{country}'>$Lang::tr{'older'}</a>";
 436         }
 437         else {
 438                 print "$Lang::tr{'older'}";
 439         }
 440         print "</td>\n";
 441
 442         print "<td align='center' width='50%'>";
 443         if ($next != -1) {
 444                 print "<a href='/cgi-bin/logs.cgi/showrequestfromcountry.dat?$next,$cgiparams{'MONTH'},$cgiparams{'DAY'},$cgiparams{country}'>$Lang::tr{'newer'}</a>";
 445         }
 446         else {
 447                 print "$Lang::tr{'newer'}";
 448         }
 449
 450         print "</td>\n";
 451         print <<END
 452         </tr>
 453         </table>
 454 END
 455         ;
 456 }
 457