GeoIP: Add lookup function for convenience
[ipfire-2.x.git] / html / cgi-bin / logs.cgi / showrequestfromcountry.dat
CommitLineData
e4aac473
AH
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;
e4aac473
AH
16
17require '/var/ipfire/general-functions.pl';
00793c27 18require "${General::swroot}/geoip-functions.pl";
e4aac473
AH
19require "${General::swroot}/lang.pl";
20require "${General::swroot}/header.pl";
21
22use POSIX();
23
24#workaround to suppress a warning when a variable is used only once
25my @dummy = ( ${Header::table2colour} );
26undef (@dummy);
27
28my %cgiparams=();
29my %logsettings=();
30my $errormessage = '';
31
32my @shortmonths = ( 'Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug',
33 'Sep', 'Oct', 'Nov', 'Dec' );
34my @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
39my @now = localtime();
40my $dow = $now[6];
41my $doy = $now[7];
42my $tdoy = $now[7];
43my $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
54my $start = -1;
55if ($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];
bde7a7d2 61 $cgiparams{country} = $temp[3];
e4aac473
AH
62}
63
64if (!($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}
70elsif($cgiparams{'ACTION'} eq '>>')
71{
43638be5
ME
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];
e4aac473
AH
81}
82elsif($cgiparams{'ACTION'} eq '<<')
83{
43638be5
ME
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];
e4aac473
AH
93}
94
95if (($cgiparams{'DAY'} ne $now[3]) || ($cgiparams{'MONTH'} ne $now[4]))
96{
43638be5
ME
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 }
e4aac473
AH
113}
114my $datediff=0;
115my $dowd=0;
116my $multifile=0;
117if ($tdoy ne $doy) {
43638be5
ME
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 }
e4aac473
AH
126}
127
128my $monthstr = $shortmonths[$cgiparams{'MONTH'}];
129my $longmonthstr = $longmonths[$cgiparams{'MONTH'}];
130my $day = $cgiparams{'DAY'};
131my $daystr='';
132if ($day <= 9) {
133 $daystr = " $day"; }
134else {
135 $daystr = $day;
136}
137
138my $skip=0;
139my $filestr='';
140if ($datediff==0) {
43638be5 141 $filestr="/var/log/messages";
e4aac473 142} else {
43638be5
ME
143 $filestr="/var/log/messages.$datediff";
144 $filestr = "$filestr.gz" if -f "$filestr.gz";
e4aac473
AH
145}
146
147if (!(open (FILE,($filestr =~ /.gz$/ ? "gzip -dc $filestr |" : $filestr)))) {
43638be5
ME
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
e4aac473
AH
151}
152my $lines = 0;
153my @log=();
154my $country = $cgiparams{country};
e4aac473
AH
155
156if (!$skip)
157{
43638be5
ME
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
00793c27 181 my $ccode = &GeoIP::lookup($srcaddr);
43638be5
ME
182 if($ccode eq uc($country)){
183 $log[$lines] = $_;
184 $lines++;
185 }
186 }
187 }
e4aac473
AH
188 }
189 close (FILE);
190}
191
192$skip=0;
193if ($multifile) {
43638be5
ME
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) {
e4aac473 206 while (<FILE>) {
43638be5
ME
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 }
e4aac473
AH
229 }
230 close (FILE);
231 }
232}
233
234&Header::showhttpheaders();
415cbcec 235&Header::openpage($Lang::tr{'firewall log country'}, 1, '');
e4aac473
AH
236&Header::openbigbox('100%', 'left', '', $errormessage);
237
238if ($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
246print <<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'>
253END
254;
255my $month;
256for ($month = 0; $month < 12; $month++)
257{
258 print "\t<option ";
259 if ($month == $cgiparams{'MONTH'}) {
43638be5
ME
260 print "selected='selected' ";
261 }
e4aac473
AH
262 print "value='$month'>$longmonths[$month]</option>\n";
263}
264print <<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'>
270END
271;
272for ($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}
279print <<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>
bde7a7d2 285<tr><td width='15%'>$Lang::tr{'source ip country'}</td><td><input type='text' name='country' value='$cgiparams{country}'size='15'></td></tr>
e4aac473
AH
286</tr>
287</table>
288</form>
289END
290;
291
292&Header::closebox();
293
415cbcec 294&Header::openbox('100%', 'left', $Lang::tr{'firewall log country'});
e4aac473
AH
295print "<p><b>$Lang::tr{'firewall hits'} $longmonthstr $daystr: $lines</b></p>";
296
297if ($start == -1) {
43638be5
ME
298 $start = $lines - ${Header::viewsize};
299}
e4aac473
AH
300if ($start >= $lines - ${Header::viewsize}) { $start = $lines - ${Header::viewsize}; };
301if ($start < 0) { $start = 0; }
302
303my $prev = $start - ${Header::viewsize};
304my $next = $start + ${Header::viewsize};
305
306if ($prev < 0) { $prev = 0; }
307if ($next >= $lines) { $next = -1 }
308if ($start == 0) { $prev = -1; }
309
310if ($lines != 0) { &oldernewer(); }
311
312print <<END
bde7a7d2
AH
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>
e4aac473
AH
324END
325;
326
327my @slice = splice(@log, $start, ${Header::viewsize});
328
329if ($logsettings{'LOGVIEW_REVERSE'} eq 'on') { @slice = reverse @slice; }
330
331$lines = 0;
332foreach $_ (@slice)
333{
43638be5
ME
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>
e4aac473 403END
43638be5
ME
404 ;
405 $lines++;
406 }
407 }
e4aac473
AH
408}
409
410print <<END
bde7a7d2 411</table>
e4aac473
AH
412END
413;
414
415&oldernewer();
416
415cbcec
MF
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
e4aac473
AH
419&Header::closebox();
420
421&Header::closebigbox();
422
423&Header::closepage();
424
425sub oldernewer
426{
43638be5
ME
427 print <<END
428 <table width='100%'>
429 <tr>
e4aac473 430END
43638be5 431 ;
e4aac473 432
43638be5
ME
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";
e4aac473 441
43638be5
ME
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 }
e4aac473 449
43638be5
ME
450 print "</td>\n";
451 print <<END
452 </tr>
453 </table>
e4aac473 454END
43638be5 455 ;
e4aac473 456}
bde7a7d2 457