7 my $greentimeout = 900;
8 my $maxtimeout = $greentimeout*9;
10 my $dbh = DBI->connect("dbi:Pg:dbname=snmpfetch;host=violet.tg05.gathering.org", "snmpfetch", "removed")
11 or die "Couldn't connect to database";
13 GD::Image->trueColor(1);
14 $img = GD::Image->new('snmp-bg.png');
16 my $blk = $img->colorResolve(0, 0, 0);
18 $img->string(gdMediumBoldFont,0,0,"TG05 - DHCP-lease status",$blk);
19 $img->string(gdSmallFont,0,20,"Last recieved DHCP-request",$blk);
21 # first 1/5: green (<30 min)
22 # middle 3/5: yellow -> red (30 min - 6 hours)
23 # last 1/5: blue (>6 hours)
24 my $grn = $img->colorResolve(0, 255, 0);
25 my $blu = $img->colorResolve(0, 0, 255);
27 my $l1 = 42 + (236 - 42)/5;
28 my $l2 = 236 - (236 - 42)/5;
30 $img->filledRectangle(32, 42, 53, $l1, $grn);
31 $img->string(gdSmallFont,56,$l1-8,($greentimeout/60)." min",$blk);
33 $img->filledRectangle(32, $l2, 53, 237, $blu);
34 $img->string(gdSmallFont,56,$l2-5,($maxtimeout/60)." min",$blk);
36 for my $y ($l1..$l2) {
37 my $i = 1.0 - ($y - $l1) / ($l2 - $l1);
38 my $clr = get_color($i);
40 $img->filledRectangle(32,$y,53,$y+1,$clr);
43 my $q = $dbh->prepare('select switch,sysname,placement,EXTRACT(EPOCH FROM now() - last_ack) as age from switches natural join placements natural join dhcp');
45 while (my $ref = $q->fetchrow_hashref()) {
46 my $age = $ref->{'age'};
47 if (!defined($age) || $age > $maxtimeout) {
48 $clr = $img->colorResolve(0, 0, 255);
49 } elsif ($age < $greentimeout) {
50 $clr = $img->colorResolve(0, 255, 0);
55 my $intensity = log($age / $greentimeout) / log($maxtimeout/$greentimeout);
56 $clr = get_color(1.0 - $intensity);
59 $_ = $ref->{'sysname'};
60 if (!m/d0/i) { # don't draw distro-switches
61 $ref->{'placement'} =~ /\((\d+),(\d+)\),\((\d+),(\d+)\)/;
62 $img->filledRectangle($3,$4,$1,$2,$clr);
63 $img->rectangle($3,$4,$1,$2,$blk);
65 $img->stringUp(gdSmallFont,$3,$2-3,$ref->{'sysname'},$blk);
70 if (!defined($ARGV[0])) {
71 print $cgi->header(-type=>'image/png',
72 -refresh=>'10; http://nms.tg05.gathering.org/dhcpkart.pl');
77 my $intensity = shift;
79 return $img->colorResolve(255.0, 255.0 * ($intensity ** $gamma), 0);