GeoIP: Add lookup function for convenience
[ipfire-2.x.git] / 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 = $gi->country_code_by_name($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