| 1 | #!/usr/bin/perl
 | 
|---|
| 2 | # ipdb/cgi-bin/admin.cgi
 | 
|---|
| 3 | # Hack interface to make specific changes to IPDB that (for one reason
 | 
|---|
| 4 | # or another) can't be made through the main interface.
 | 
|---|
| 5 | #
 | 
|---|
| 6 | ###
 | 
|---|
| 7 | # SVN revision info
 | 
|---|
| 8 | # $Date: 2012-11-08 22:57:54 +0000 (Thu, 08 Nov 2012) $
 | 
|---|
| 9 | # SVN revision $Rev: 548 $
 | 
|---|
| 10 | # Last update by $Author: kdeugau $
 | 
|---|
| 11 | ###
 | 
|---|
| 12 | # Copyright (C) 2004-2010 - Kris Deugau
 | 
|---|
| 13 | 
 | 
|---|
| 14 | use strict;
 | 
|---|
| 15 | use warnings;
 | 
|---|
| 16 | use CGI::Carp qw(fatalsToBrowser);
 | 
|---|
| 17 | use CGI::Simple;
 | 
|---|
| 18 | use HTML::Template;
 | 
|---|
| 19 | use DBI;
 | 
|---|
| 20 | #use POSIX qw(ceil);
 | 
|---|
| 21 | use NetAddr::IP;
 | 
|---|
| 22 | 
 | 
|---|
| 23 | use Sys::Syslog;
 | 
|---|
| 24 | 
 | 
|---|
| 25 | # don't remove!  required for GNU/FHS-ish install from tarball
 | 
|---|
| 26 | ##uselib##
 | 
|---|
| 27 | 
 | 
|---|
| 28 | use CustIDCK;
 | 
|---|
| 29 | use MyIPDB;
 | 
|---|
| 30 | 
 | 
|---|
| 31 | openlog "IPDB-admin","pid","$IPDB::syslog_facility";
 | 
|---|
| 32 | 
 | 
|---|
| 33 | # Collect the username from HTTP auth.  If undefined, we're in a test environment.
 | 
|---|
| 34 | my $authuser;
 | 
|---|
| 35 | if (!defined($ENV{'REMOTE_USER'})) {
 | 
|---|
| 36 |   $authuser = '__temptest';
 | 
|---|
| 37 | } else {
 | 
|---|
| 38 |   $authuser = $ENV{'REMOTE_USER'};
 | 
|---|
| 39 | }
 | 
|---|
| 40 | 
 | 
|---|
| 41 | syslog "debug", "$authuser active";
 | 
|---|
| 42 | 
 | 
|---|
| 43 | # Set up the CGI object...
 | 
|---|
| 44 | my $q = new CGI::Simple;
 | 
|---|
| 45 | # ... and get query-string params as well as POST params if necessary
 | 
|---|
| 46 | $q->parse_query_string;
 | 
|---|
| 47 | 
 | 
|---|
| 48 | # Convenience;  saves changing all references to %webvar
 | 
|---|
| 49 | ##fixme:  tweak for handling <select multiple='y' size=3> (list with multiple selection)
 | 
|---|
| 50 | my %webvar = $q->Vars;
 | 
|---|
| 51 | 
 | 
|---|
| 52 | # anyone got a better name?  :P
 | 
|---|
| 53 | my $thingroot = $ENV{SCRIPT_FILENAME};
 | 
|---|
| 54 | $thingroot =~ s|cgi-bin/admin.cgi||;
 | 
|---|
| 55 | 
 | 
|---|
| 56 | # Set up some globals
 | 
|---|
| 57 | $ENV{HTML_TEMPLATE_ROOT} = $thingroot."templates";
 | 
|---|
| 58 | 
 | 
|---|
| 59 | # Why not a global DB handle?  (And a global statement handle, as well...)
 | 
|---|
| 60 | # Use the connectDB function, otherwise we end up confusing ourselves
 | 
|---|
| 61 | my $ip_dbh;
 | 
|---|
| 62 | my $sth;
 | 
|---|
| 63 | my $errstr;
 | 
|---|
| 64 | ($ip_dbh,$errstr) = connectDB_My;
 | 
|---|
| 65 | if (!$ip_dbh) {
 | 
|---|
| 66 |   $webvar{action} = "dberr";
 | 
|---|
| 67 | } else {
 | 
|---|
| 68 |   initIPDBGlobals($ip_dbh);
 | 
|---|
| 69 | }
 | 
|---|
| 70 | 
 | 
|---|
| 71 | if(!defined($webvar{action})) {
 | 
|---|
| 72 |   $webvar{action} = "main";   #shuts up the warnings.
 | 
|---|
| 73 | }
 | 
|---|
| 74 | 
 | 
|---|
| 75 | # handle DB error output
 | 
|---|
| 76 | if ($webvar{action} eq 'dberr') {
 | 
|---|
| 77 |   my $page = HTML::Template->new(filename => "admin/dberr.tmpl");
 | 
|---|
| 78 |   $page->param(errmsg => $errstr);
 | 
|---|
| 79 |   print "Content-Type: text/html\n\n".$page->output;
 | 
|---|
| 80 |   exit;
 | 
|---|
| 81 | }
 | 
|---|
| 82 | 
 | 
|---|
| 83 | if ($IPDBacl{$authuser} !~ /A/) {
 | 
|---|
| 84 |   my $page = HTML::Template->new(filename => "admin/aclerr.tmpl");
 | 
|---|
| 85 | ##fixme:  need params for IPDB admin email and name
 | 
|---|
| 86 |   $page->param(ipdbadmin_email => 'ipdbadmin@example.com');
 | 
|---|
| 87 |   $page->param(ipdbadmin_name => 'the IPDB administrator');
 | 
|---|
| 88 |   print "Content-Type: text/html\n\n".$page->output;
 | 
|---|
| 89 |   exit;
 | 
|---|
| 90 | }
 | 
|---|
| 91 | 
 | 
|---|
| 92 | my $header = HTML::Template->new(filename => "admin/header.tmpl");
 | 
|---|
| 93 | 
 | 
|---|
| 94 | my $page;
 | 
|---|
| 95 | if (-e "$ENV{HTML_TEMPLATE_ROOT}/admin/$webvar{action}.tmpl") {
 | 
|---|
| 96 |   $page = HTML::Template->new(filename => "admin/$webvar{action}.tmpl");
 | 
|---|
| 97 | } else {
 | 
|---|
| 98 |   $page = HTML::Template->new(filename => "admin/dunno.tmpl");
 | 
|---|
| 99 | }
 | 
|---|
| 100 | 
 | 
|---|
| 101 | # handle index page
 | 
|---|
| 102 | if ($webvar{action} eq 'main') {
 | 
|---|
| 103 |   $header->param(mainpage => 1);
 | 
|---|
| 104 | 
 | 
|---|
| 105 |   my $tlist = getTypeList($ip_dbh, 'a');
 | 
|---|
| 106 |   $tlist->[0]->{sel} = 1;
 | 
|---|
| 107 |   $page->param(typelist => $tlist);
 | 
|---|
| 108 | 
 | 
|---|
| 109 |   my $mlist = getMasterList($ip_dbh, 'm');
 | 
|---|
| 110 |   $page->param(masterlist => $mlist);
 | 
|---|
| 111 | }
 | 
|---|
| 112 | 
 | 
|---|
| 113 | ## Non-default actions.
 | 
|---|
| 114 | 
 | 
|---|
| 115 | elsif ($webvar{action} eq 'alloc') {
 | 
|---|
| 116 | 
 | 
|---|
| 117 |   my $cidr = new NetAddr::IP $webvar{cidr};
 | 
|---|
| 118 |   if (!$cidr || "$cidr" =~ /^0/) {
 | 
|---|
| 119 |     $page->param(errmsg => "Can't allocate something that's not a netblock/ip");
 | 
|---|
| 120 |     goto ERRJUMP;
 | 
|---|
| 121 |   }
 | 
|---|
| 122 | 
 | 
|---|
| 123 |   my $custid = $def_custids{$webvar{alloctype}};
 | 
|---|
| 124 |   if ($custid eq '') {
 | 
|---|
| 125 |     # Crosscheck with billing.
 | 
|---|
| 126 |     my $status = CustIDCK->custid_exist($webvar{custid});
 | 
|---|
| 127 |     if ($CustIDCK::Error) {
 | 
|---|
| 128 |       $page->param(errmsg => "Error verifying customer ID: ".$CustIDCK::ErrMsg);
 | 
|---|
| 129 |       goto ERRJUMP;
 | 
|---|
| 130 |     }
 | 
|---|
| 131 |     if (!$status) {
 | 
|---|
| 132 |       $page->param(errmsg => "Customer ID not valid.  Make sure the Customer ID ".
 | 
|---|
| 133 |         "is correct.<br>\nUse STAFF for staff static IPs, and $IPDB::defcustid for any other ".
 | 
|---|
| 134 |         "non-customer assignments.");
 | 
|---|
| 135 |       goto ERRJUMP;
 | 
|---|
| 136 |     }
 | 
|---|
| 137 |     # Type that doesn't have a default custid
 | 
|---|
| 138 |     $custid = $webvar{custid};
 | 
|---|
| 139 |   }
 | 
|---|
| 140 | 
 | 
|---|
| 141 |   my $maskbits = $cidr->masklen;
 | 
|---|
| 142 |   my $fbtmp = findAllocateFrom($ip_dbh, $maskbits, $webvar{alloctype}, '','',
 | 
|---|
| 143 |         (gimme => "$cidr", allowpriv => 1));
 | 
|---|
| 144 | 
 | 
|---|
| 145 |   if ($webvar{alloctype} eq 'rm') {
 | 
|---|
| 146 |     if (!$fbtmp) {
 | 
|---|
| 147 |       $page->param(errmsg => "Can't allocate from outside a free block!!");
 | 
|---|
| 148 |       goto ERRJUMP;
 | 
|---|
| 149 |     }
 | 
|---|
| 150 |   } elsif ($webvar{alloctype} =~ /^(.)i$/) {
 | 
|---|
| 151 |     my $iptype = $1;
 | 
|---|
| 152 |     my $ptmp = ipParent($ip_dbh, "$cidr");
 | 
|---|
| 153 |     if ($ptmp->{type} =~ /^(.)[dp]$/) {
 | 
|---|
| 154 |       my $newiptype = "$1i";
 | 
|---|
| 155 |       $fbtmp = $ptmp->{cidr};
 | 
|---|
| 156 |       if ($ptmp->{type} !~ /^$iptype./) {
 | 
|---|
| 157 |         $page->param(warnmsg => "Warning:  Allocating IP as '".$disp_alloctypes{$newiptype}."' instead of '".
 | 
|---|
| 158 |                 $disp_alloctypes{$webvar{alloctype}}."' to match pool $fbtmp\n");
 | 
|---|
| 159 |         $webvar{alloctype} = $newiptype;
 | 
|---|
| 160 |       }
 | 
|---|
| 161 |     }
 | 
|---|
| 162 |     if (!$fbtmp) {
 | 
|---|
| 163 |       $page->param(errmsg => "Can't allocate static IP from outside a pool!!");
 | 
|---|
| 164 |       goto ERRJUMP;
 | 
|---|
| 165 |     }
 | 
|---|
| 166 |   } else {
 | 
|---|
| 167 |     if (!$fbtmp) {
 | 
|---|
| 168 |       $page->param(errmsg => "Can't allocate from outside a routed block!!");
 | 
|---|
| 169 |       goto ERRJUMP;
 | 
|---|
| 170 |     }
 | 
|---|
| 171 |   }
 | 
|---|
| 172 | 
 | 
|---|
| 173 |   my $alloc_from = new NetAddr::IP $fbtmp;
 | 
|---|
| 174 | 
 | 
|---|
| 175 |   my @cities;
 | 
|---|
| 176 |   foreach my $city (@citylist) {
 | 
|---|
| 177 |      my %row = (city => $city);
 | 
|---|
| 178 |      push @cities, \%row;
 | 
|---|
| 179 |   }
 | 
|---|
| 180 |   $page->param(
 | 
|---|
| 181 |         cidr => $cidr,
 | 
|---|
| 182 |         disptype => $disp_alloctypes{$webvar{alloctype}},
 | 
|---|
| 183 |         type => $webvar{alloctype},
 | 
|---|
| 184 |         alloc_from => $alloc_from,
 | 
|---|
| 185 |         custid => $custid,
 | 
|---|
| 186 |         citylist => \@cities
 | 
|---|
| 187 |         );
 | 
|---|
| 188 | 
 | 
|---|
| 189 | } elsif ($webvar{action} eq 'confirm') {
 | 
|---|
| 190 | 
 | 
|---|
| 191 |   $page->param(
 | 
|---|
| 192 |         cidr => $webvar{cidr},
 | 
|---|
| 193 |         custid => $webvar{custid},
 | 
|---|
| 194 |         desc => $webvar{desc},
 | 
|---|
| 195 |         disptype => $disp_alloctypes{$webvar{alloctype}}
 | 
|---|
| 196 |         );
 | 
|---|
| 197 |   # Only need to check city here.
 | 
|---|
| 198 |   if ($webvar{city} eq '-') {
 | 
|---|
| 199 |     $page->param(locerr => "Invalid customer location!  Go back and select customer's location.");
 | 
|---|
| 200 |     goto ERRJUMP;
 | 
|---|
| 201 |   }
 | 
|---|
| 202 | 
 | 
|---|
| 203 |   my ($retcode,$msg) = allocateBlock($ip_dbh, $webvar{cidr}, $webvar{alloc_from},
 | 
|---|
| 204 |         $webvar{custid}, $webvar{alloctype}, $webvar{city}, $webvar{desc}, $webvar{notes},
 | 
|---|
| 205 |         $webvar{circid});
 | 
|---|
| 206 |   if ($retcode eq 'OK') {
 | 
|---|
| 207 |     syslog "notice", "$authuser allocated '$webvar{cidr}' to '$webvar{custid}' as ".
 | 
|---|
| 208 |         "'$webvar{alloctype}'";
 | 
|---|
| 209 |     if ($webvar{alloctype} =~ /^.i$/) {
 | 
|---|
| 210 |       mailNotify($ip_dbh, "a$webvar{alloctype}", "ADDED: $disp_alloctypes{$webvar{alloctype}} allocation",
 | 
|---|
| 211 |         "$disp_alloctypes{$webvar{alloctype}} $webvar{cidr} allocated to customer $webvar{custid}\n".
 | 
|---|
| 212 |         "Description: $webvar{desc}\n\nAllocated by: $authuser\n");
 | 
|---|
| 213 |     }
 | 
|---|
| 214 |   } else {
 | 
|---|
| 215 |     $page->param(errmsg => $msg);
 | 
|---|
| 216 |     syslog "err", "($authuser) Allocation of '$webvar{cidr}' to '$webvar{custid}' as ".
 | 
|---|
| 217 |         "'$webvar{alloctype}' failed: '$msg'";
 | 
|---|
| 218 |   }
 | 
|---|
| 219 | 
 | 
|---|
| 220 | } elsif ($webvar{action} eq 'alloctweak') {
 | 
|---|
| 221 | 
 | 
|---|
| 222 |   fix_allocfrom();
 | 
|---|
| 223 |   showAllocs($webvar{allocfrom});
 | 
|---|
| 224 | 
 | 
|---|
| 225 | } elsif ($webvar{action} eq 'update') {
 | 
|---|
| 226 | 
 | 
|---|
| 227 |   update();
 | 
|---|
| 228 | 
 | 
|---|
| 229 | } elsif ($webvar{action} eq 'touch') {
 | 
|---|
| 230 | 
 | 
|---|
| 231 |   my ($code,$msg) = touchMaster($ip_dbh, $webvar{whichmaster});
 | 
|---|
| 232 |   $page->param(errmsg => $msg) if $code eq 'FAIL';
 | 
|---|
| 233 | 
 | 
|---|
| 234 | } elsif ($webvar{action} eq 'listcust') {
 | 
|---|
| 235 | 
 | 
|---|
| 236 |   $sth = $ip_dbh->prepare("select custid,name,tech_handle from customers order by custid");
 | 
|---|
| 237 |   $sth->execute;
 | 
|---|
| 238 |   my @custlist;
 | 
|---|
| 239 |   while (my @data = $sth->fetchrow_array) {
 | 
|---|
| 240 |     my %row = (
 | 
|---|
| 241 |         custid => $data[0],
 | 
|---|
| 242 |         custname => $data[1],
 | 
|---|
| 243 |         tech => $data[2]
 | 
|---|
| 244 |         );
 | 
|---|
| 245 |     push @custlist, \%row;
 | 
|---|
| 246 |   }
 | 
|---|
| 247 |   $page->param(custlist => \@custlist);
 | 
|---|
| 248 | 
 | 
|---|
| 249 | } elsif ($webvar{action} eq 'edcust') {
 | 
|---|
| 250 | 
 | 
|---|
| 251 |   if ($webvar{newcust}) {
 | 
|---|
| 252 |     $sth = $ip_dbh->prepare("INSERT INTO customers (custid) VALUES (?)");
 | 
|---|
| 253 |     $sth->execute($webvar{custid});
 | 
|---|
| 254 |   }
 | 
|---|
| 255 |   $sth = $ip_dbh->prepare("select custid,name,street,city,province,".
 | 
|---|
| 256 |         "country,pocode,phone,tech_handle,abuse_handle,admin_handle,special ".
 | 
|---|
| 257 |         "from customers where custid='$webvar{custid}'");
 | 
|---|
| 258 |   $sth->execute;
 | 
|---|
| 259 |   my ($custid, $name, $street, $city, $prov, $country, $pocode, $phone, $tech, $abuse, $admin, $special) =
 | 
|---|
| 260 |         $sth->fetchrow_array;
 | 
|---|
| 261 | 
 | 
|---|
| 262 |   $page->param(
 | 
|---|
| 263 |         custid => $custid,
 | 
|---|
| 264 |         name => $name,
 | 
|---|
| 265 |         street => $street,
 | 
|---|
| 266 |         city => $city,
 | 
|---|
| 267 |         prov => $prov,
 | 
|---|
| 268 |         country => $country,
 | 
|---|
| 269 |         pocode => $pocode,
 | 
|---|
| 270 |         phone => $phone,
 | 
|---|
| 271 |         tech => $tech,
 | 
|---|
| 272 |         abuse => $abuse,
 | 
|---|
| 273 |         admin => $admin,
 | 
|---|
| 274 |         special => $special
 | 
|---|
| 275 |         );
 | 
|---|
| 276 | 
 | 
|---|
| 277 | } elsif ($webvar{action} eq 'updcust') {
 | 
|---|
| 278 | 
 | 
|---|
| 279 |   $sth = $ip_dbh->prepare("UPDATE customers SET".
 | 
|---|
| 280 |         " name=?, street=?, city=?, province=?, country=?, pocode=?,".
 | 
|---|
| 281 |         " phone=?, tech_handle=?, abuse_handle=?, admin_handle=?, special=?".
 | 
|---|
| 282 |         " WHERE custid=?");
 | 
|---|
| 283 |   $sth->execute($webvar{name}, $webvar{street}, $webvar{city}, $webvar{province}, 
 | 
|---|
| 284 |         $webvar{country}, $webvar{pocode}, $webvar{phone}, $webvar{tech_handle}, 
 | 
|---|
| 285 |         $webvar{abuse_handle}, $webvar{admin_handle}, $webvar{special}, $webvar{custid});
 | 
|---|
| 286 |   $page->param(
 | 
|---|
| 287 |         custid => $webvar{custid},
 | 
|---|
| 288 |         name => $webvar{name},
 | 
|---|
| 289 |         street => $webvar{street},
 | 
|---|
| 290 |         city => $webvar{city},
 | 
|---|
| 291 |         prov => $webvar{province},
 | 
|---|
| 292 |         country => $webvar{country},
 | 
|---|
| 293 |         pocode => $webvar{pocode},
 | 
|---|
| 294 |         phone => $webvar{phone},
 | 
|---|
| 295 |         tech => $webvar{tech_handle},
 | 
|---|
| 296 |         abuse => $webvar{abuse_handle},
 | 
|---|
| 297 |         admin => $webvar{admin_handle},
 | 
|---|
| 298 |         special => $webvar{special}
 | 
|---|
| 299 |         );
 | 
|---|
| 300 | 
 | 
|---|
| 301 | } elsif ($webvar{action} eq 'showpools') {
 | 
|---|
| 302 | 
 | 
|---|
| 303 |   $sth = $ip_dbh->prepare("select pool, count(*) from poolips where available='y' group by pool order by pool");
 | 
|---|
| 304 |   $sth->execute;
 | 
|---|
| 305 |   my @poollist;
 | 
|---|
| 306 |   while (my ($pool,$free) = $sth->fetchrow_array) {
 | 
|---|
| 307 |     my %row = (
 | 
|---|
| 308 |         pool => $pool,
 | 
|---|
| 309 |         free => $free
 | 
|---|
| 310 |         );
 | 
|---|
| 311 |     push @poollist, \%row;
 | 
|---|
| 312 |   }
 | 
|---|
| 313 |   $page->param(poollist => \@poollist);
 | 
|---|
| 314 | 
 | 
|---|
| 315 | } elsif ($webvar{action} eq 'tweakpool') {
 | 
|---|
| 316 | 
 | 
|---|
| 317 |   showPool($webvar{pool});
 | 
|---|
| 318 | 
 | 
|---|
| 319 | } elsif ($webvar{action} eq 'updatepool') {
 | 
|---|
| 320 | 
 | 
|---|
| 321 |   $sth = $ip_dbh->prepare("update poolips set custid='$webvar{custid}', ".
 | 
|---|
| 322 |         "city=?, type='$webvar{type}', available='".
 | 
|---|
| 323 |         (($webvar{available} eq 'y') ? 'y' : 'n').
 | 
|---|
| 324 |         "', notes=?, description=? ".
 | 
|---|
| 325 |         "where ip='$webvar{ip}'");
 | 
|---|
| 326 |   $sth->execute($webvar{city},$webvar{notes},$webvar{desc});
 | 
|---|
| 327 |   $page->param(ip => $webvar{ip});
 | 
|---|
| 328 |   if ($sth->err) {
 | 
|---|
| 329 |     $page->param(errmsg => $sth->errstr);
 | 
|---|
| 330 |     syslog "err", "$authuser could not update pool IP $webvar{ip}: ".$sth->errstr;
 | 
|---|
| 331 |   } else {
 | 
|---|
| 332 |     syslog "notice", "$authuser updated pool IP $webvar{ip}";
 | 
|---|
| 333 |   }
 | 
|---|
| 334 |   $sth = $ip_dbh->prepare("select pool from poolips where ip='$webvar{ip}'");
 | 
|---|
| 335 |   $sth->execute;
 | 
|---|
| 336 |   my @data = $sth->fetchrow_array;
 | 
|---|
| 337 |   $page->param(pool => $data[0]);
 | 
|---|
| 338 | 
 | 
|---|
| 339 | } elsif ($webvar{action} eq 'showusers') {
 | 
|---|
| 340 | 
 | 
|---|
| 341 |   $sth = $ip_dbh->prepare("select username,acl from users order by username");
 | 
|---|
| 342 |   $sth->execute;
 | 
|---|
| 343 |   my @userlist;
 | 
|---|
| 344 |   while (my ($username,$acl) = $sth->fetchrow_array) {
 | 
|---|
| 345 | ##fixme: funky things happening with HTML::Template here;  shouldn't need the "logic ? iftrue : iffalse" structure
 | 
|---|
| 346 |     my %row = (
 | 
|---|
| 347 |         username => $username,
 | 
|---|
| 348 |         can_add => ($acl =~ /a/ ? 1 : 0),
 | 
|---|
| 349 |         can_change => ($acl =~ /c/ ? 1 : 0),
 | 
|---|
| 350 |         can_del => ($acl =~ /d/ ? 1 : 0),
 | 
|---|
| 351 |         sysnet => ($acl =~ /s/ ? 1 : 0),
 | 
|---|
| 352 |         is_admin => ($acl =~ /A/ ? 1 : 0),
 | 
|---|
| 353 |         acl => $acl
 | 
|---|
| 354 |         );
 | 
|---|
| 355 |     push @userlist, \%row;
 | 
|---|
| 356 |   }
 | 
|---|
| 357 |   $page->param(userlist => \@userlist);
 | 
|---|
| 358 | 
 | 
|---|
| 359 | } elsif ($webvar{action} eq 'updacl') {
 | 
|---|
| 360 | 
 | 
|---|
| 361 |   $page->param(username => $webvar{username});
 | 
|---|
| 362 |   my $acl = 'b';
 | 
|---|
| 363 |   if ($webvar{admin} eq 'on') {
 | 
|---|
| 364 |     $acl .= "acdsA";
 | 
|---|
| 365 |   } else {
 | 
|---|
| 366 |     $acl .= ($webvar{add} eq 'on' ? 'a' : '').
 | 
|---|
| 367 |         ($webvar{change} eq 'on' ? 'c' : '').
 | 
|---|
| 368 |         ($webvar{del} eq 'on' ? 'd' : '').
 | 
|---|
| 369 |         ($webvar{sysnet} eq 'on' ? 's' : '');
 | 
|---|
| 370 |   }
 | 
|---|
| 371 |   $page->param(acl => $acl);
 | 
|---|
| 372 | 
 | 
|---|
| 373 |   $sth = $ip_dbh->prepare("update users set acl='$acl' where username='$webvar{username}'");
 | 
|---|
| 374 |   $sth->execute;
 | 
|---|
| 375 |   $page->param(errmsg => $sth->errstr) if $sth->err;
 | 
|---|
| 376 | 
 | 
|---|
| 377 | } elsif ($webvar{action} eq 'newuser') {
 | 
|---|
| 378 | 
 | 
|---|
| 379 |   $page->param(username => $webvar{username});
 | 
|---|
| 380 |   my $cr_pass = ($webvar{preenc} ? $webvar{password} :
 | 
|---|
| 381 |         crypt $webvar{password}, join('',('.','/',0..9,'A'..'Z','a'..'z')[rand 64, rand 64]));
 | 
|---|
| 382 |   $sth = $ip_dbh->prepare("insert into users (username,password,acl) values ".
 | 
|---|
| 383 |         "('$webvar{username}','$cr_pass','b')");
 | 
|---|
| 384 |   $sth->execute;
 | 
|---|
| 385 |   $page->param(errmsg => $sth->errstr) if $sth->err;
 | 
|---|
| 386 | 
 | 
|---|
| 387 | } elsif ($webvar{action} eq 'deluser') {
 | 
|---|
| 388 | 
 | 
|---|
| 389 |   $page->param(username => $webvar{username});
 | 
|---|
| 390 |   $sth = $ip_dbh->prepare("delete from users where username='$webvar{username}'");
 | 
|---|
| 391 |   $sth->execute;
 | 
|---|
| 392 |   $page->param(errmsg => $sth->errstr) if $sth->err;
 | 
|---|
| 393 | 
 | 
|---|
| 394 | } elsif ($webvar{action} eq 'emailnotice') {
 | 
|---|
| 395 | 
 | 
|---|
| 396 |   $sth = $ip_dbh->prepare("SELECT action,reciplist FROM notify");
 | 
|---|
| 397 |   $sth->execute;
 | 
|---|
| 398 |   my @spamlist;
 | 
|---|
| 399 |   while (my ($notice_code,$reciplist) = $sth->fetchrow_array() ) {
 | 
|---|
| 400 | ##fixme: hairy mess, only a few things call mailNotify() anyway, so many possible notices won't work.
 | 
|---|
| 401 |     my $action_out = dispNoticeCode($notice_code);
 | 
|---|
| 402 |     my %row = (
 | 
|---|
| 403 |         action => $action_out,
 | 
|---|
| 404 |         code => $notice_code,
 | 
|---|
| 405 |         recips => $reciplist
 | 
|---|
| 406 |         );
 | 
|---|
| 407 |     push @spamlist, \%row;
 | 
|---|
| 408 |   }
 | 
|---|
| 409 |   $page->param(spamlist => \@spamlist);
 | 
|---|
| 410 | 
 | 
|---|
| 411 |   $sth = $ip_dbh->prepare("SELECT type,dispname FROM alloctypes WHERE listorder < 500 ".
 | 
|---|
| 412 |         "ORDER BY listorder");
 | 
|---|
| 413 |   $sth->execute;
 | 
|---|
| 414 |   my $i=0;
 | 
|---|
| 415 |   my @typelist;
 | 
|---|
| 416 |   while (my ($type,$disp) = $sth->fetchrow_array) {
 | 
|---|
| 417 |     my %row = (
 | 
|---|
| 418 |         type => $type,
 | 
|---|
| 419 |         disptype => $disp,
 | 
|---|
| 420 | # ahh, off-by-one counts, how we do love thee...  NOT!
 | 
|---|
| 421 |         newrow => ($i+2 > $sth->rows ? 1 : (++$i % 4)),
 | 
|---|
| 422 |         );
 | 
|---|
| 423 |     push @typelist, \%row;
 | 
|---|
| 424 |   }
 | 
|---|
| 425 |   $page->param(typelist => \@typelist);
 | 
|---|
| 426 | 
 | 
|---|
| 427 | } elsif ($webvar{action} eq 'addnotice') {
 | 
|---|
| 428 | 
 | 
|---|
| 429 |   $webvar{alloctype} = $webvar{special} if $webvar{msgaction} eq 's:';
 | 
|---|
| 430 |   if ($webvar{msgaction} && $webvar{alloctype} && $webvar{reciplist}) {
 | 
|---|
| 431 |     $page->param(cantry => 1);
 | 
|---|
| 432 |     $webvar{reciplist} =~ s/[\r\n]+/,/g;
 | 
|---|
| 433 |     $webvar{msgaction} = "f:$webvar{msgaction}" if $webvar{onfail};
 | 
|---|
| 434 |     $page->param(reciplist => $webvar{reciplist});
 | 
|---|
| 435 |     $page->param(dispnotice => dispNoticeCode($webvar{msgaction}.$webvar{alloctype}));
 | 
|---|
| 436 |     $sth = $ip_dbh->prepare("INSERT INTO notify (action, reciplist) VALUES (?,?)");
 | 
|---|
| 437 | ##fixme:  automagically merge reciplists iff action already exists
 | 
|---|
| 438 |     $sth->execute($webvar{msgaction}.$webvar{alloctype}, $webvar{reciplist});
 | 
|---|
| 439 |     $page->param(addfailed => $sth->errstr) if $sth->err;
 | 
|---|
| 440 |   }
 | 
|---|
| 441 | 
 | 
|---|
| 442 | } elsif ($webvar{action} eq 'delnotice') {
 | 
|---|
| 443 | 
 | 
|---|
| 444 |   $page->param(dispnotice => dispNoticeCode($webvar{code}.$webvar{alloctype}));
 | 
|---|
| 445 |   $sth = $ip_dbh->prepare("DELETE FROM notify WHERE action=?");
 | 
|---|
| 446 |   $sth->execute($webvar{code});
 | 
|---|
| 447 |   $page->param(delfailed => $sth->errstr) if $sth->err;
 | 
|---|
| 448 | 
 | 
|---|
| 449 | } elsif ($webvar{action} eq 'ednotice') {
 | 
|---|
| 450 | 
 | 
|---|
| 451 |   $page->param(dispnotice => dispNoticeCode($webvar{code}));
 | 
|---|
| 452 |   $page->param(code => $webvar{code});
 | 
|---|
| 453 |   $sth = $ip_dbh->prepare("SELECT reciplist FROM notify WHERE action=?");
 | 
|---|
| 454 |   $sth->execute($webvar{code});
 | 
|---|
| 455 |   my ($reciplist) = $sth->fetchrow_array;
 | 
|---|
| 456 |   $reciplist =~ s/,/\n/g;
 | 
|---|
| 457 |   $page->param(reciplist => $reciplist);
 | 
|---|
| 458 | 
 | 
|---|
| 459 | } elsif ($webvar{action} eq 'updnotice') {
 | 
|---|
| 460 | 
 | 
|---|
| 461 |   $page->param(dispnotice => dispNoticeCode($webvar{code}));
 | 
|---|
| 462 |   $sth = $ip_dbh->prepare("UPDATE notify SET reciplist=? WHERE action=?");
 | 
|---|
| 463 |   $webvar{reciplist} =~ s/[\r\n]+/,/g;
 | 
|---|
| 464 |   $sth->execute($webvar{reciplist}, $webvar{code});
 | 
|---|
| 465 |   $page->param(updfailed => $sth->errstr) if $sth->err;
 | 
|---|
| 466 | 
 | 
|---|
| 467 | } elsif ($webvar{action} ne '<NULL>') {
 | 
|---|
| 468 |   $page->param(dunno => $webvar{action});
 | 
|---|
| 469 | }
 | 
|---|
| 470 | 
 | 
|---|
| 471 | ERRJUMP: print "Content-type: text/html\n\n".$header->output;
 | 
|---|
| 472 | print $page->output;
 | 
|---|
| 473 | 
 | 
|---|
| 474 | ##fixme:  make me a footer param!
 | 
|---|
| 475 | print qq(<hr><div><a href="$IPDB::webpath/">Back</a> to main interface</div>\n);
 | 
|---|
| 476 | 
 | 
|---|
| 477 | # We print the footer here, so we don't have to do it elsewhere.
 | 
|---|
| 478 | my $footer = HTML::Template->new(filename => "footer.tmpl");
 | 
|---|
| 479 | # we're already in the admin tools, no need to provide a bottom link.  maybe.
 | 
|---|
| 480 | #$footer->param(adminlink => ($IPDBacl{$authuser} =~ /A/));
 | 
|---|
| 481 | 
 | 
|---|
| 482 | print $footer->output;
 | 
|---|
| 483 | 
 | 
|---|
| 484 | $ip_dbh->disconnect;
 | 
|---|
| 485 | 
 | 
|---|
| 486 | exit;
 | 
|---|
| 487 | 
 | 
|---|
| 488 | 
 | 
|---|
| 489 | # Hokay.  This is a little different.  We have a few specific functions here:
 | 
|---|
| 490 | #  -> Assign arbitrary subnet from arbitrary free space
 | 
|---|
| 491 | #  -> Tweak individual DB fields
 | 
|---|
| 492 | #
 | 
|---|
| 493 | 
 | 
|---|
| 494 | 
 | 
|---|
| 495 | # Tweak allocfrom into shape.
 | 
|---|
| 496 | sub fix_allocfrom {
 | 
|---|
| 497 |   if ($webvar{allocfrom} =~ /^(\d+\.){2}\d+$/) {
 | 
|---|
| 498 |     # 3-octet class C specified
 | 
|---|
| 499 |     $webvar{allocfrom} .= ".0/24";
 | 
|---|
| 500 |   } elsif ($webvar{allocfrom} =~ /^(\d+\.){3}\d+$/) {
 | 
|---|
| 501 |     # 4-octet IP specified;  
 | 
|---|
| 502 |     $webvar{allocfrom} .= "/24";
 | 
|---|
| 503 |   }
 | 
|---|
| 504 | }
 | 
|---|
| 505 | 
 | 
|---|
| 506 | 
 | 
|---|
| 507 | # Show allocations to allow editing.
 | 
|---|
| 508 | sub showAllocs {
 | 
|---|
| 509 | 
 | 
|---|
| 510 |   my $within = new NetAddr::IP $_[0];
 | 
|---|
| 511 |   $page->param(within => $within);
 | 
|---|
| 512 | 
 | 
|---|
| 513 |   $sth = $ip_dbh->prepare("select cidr,custid,type,city,description from allocations where cidr <<= '$within' order by cidr");
 | 
|---|
| 514 |   $sth->execute;
 | 
|---|
| 515 |   my @blocklist;
 | 
|---|
| 516 |   while (my ($cidr,$custid,$type,$city,$desc) = $sth->fetchrow_array) {
 | 
|---|
| 517 |     my %row = (
 | 
|---|
| 518 |         cidr => $cidr,
 | 
|---|
| 519 |         custid => $custid,
 | 
|---|
| 520 |         city => $city,
 | 
|---|
| 521 |         desc => $desc,
 | 
|---|
| 522 |         );
 | 
|---|
| 523 | 
 | 
|---|
| 524 | ##fixme:  don't wanna retrieve the whole type list *every time around the outer loop*
 | 
|---|
| 525 |     my $sth2 = $ip_dbh->prepare("select type,listname from alloctypes".
 | 
|---|
| 526 |         " where listorder < 500 and not (type like '_i') order by listorder");
 | 
|---|
| 527 |     $sth2->execute;
 | 
|---|
| 528 |     my @typelist;
 | 
|---|
| 529 |     while (my ($listtype,$dispname) = $sth2->fetchrow_array) {
 | 
|---|
| 530 |       my %subrow = (
 | 
|---|
| 531 |         type => $listtype,
 | 
|---|
| 532 |         dispname => $dispname,
 | 
|---|
| 533 |         selected => ($listtype eq $type)
 | 
|---|
| 534 |         );
 | 
|---|
| 535 |       push @typelist, \%subrow;
 | 
|---|
| 536 |     }
 | 
|---|
| 537 |     $row{typelist} = \@typelist;
 | 
|---|
| 538 |     push @blocklist, \%row;
 | 
|---|
| 539 |   }
 | 
|---|
| 540 |   $page->param(blocklist => \@blocklist);
 | 
|---|
| 541 | } # end showAllocs()
 | 
|---|
| 542 | 
 | 
|---|
| 543 | 
 | 
|---|
| 544 | # Stuff updates into DB
 | 
|---|
| 545 | sub update {
 | 
|---|
| 546 |   # Relatively simple SQL transaction here.  Note that we're deliberately NOT
 | 
|---|
| 547 |   # updating notes/desc here as it's available through the main interface.
 | 
|---|
| 548 |   $sth = $ip_dbh->prepare("update allocations set custid='$webvar{custid}',".
 | 
|---|
| 549 |         "city=?,type='$webvar{alloctype}' where cidr='$webvar{block}'");
 | 
|---|
| 550 |   $sth->execute($webvar{city});
 | 
|---|
| 551 | 
 | 
|---|
| 552 |   $page->param(block => $webvar{block});
 | 
|---|
| 553 |   if ($sth->err) {
 | 
|---|
| 554 |     $page->param(updfailed => $sth->errstr);
 | 
|---|
| 555 |     syslog "err", "$authuser could not update block '$webvar{block}': '".$sth->errstr."'";
 | 
|---|
| 556 |   } else {
 | 
|---|
| 557 |     syslog "notice", "$authuser updated $webvar{block}";
 | 
|---|
| 558 |   }
 | 
|---|
| 559 |   # need to get /24 that block is part of
 | 
|---|
| 560 |   my @bits = split /\./, $webvar{block};
 | 
|---|
| 561 |   $bits[3] = "0/24";
 | 
|---|
| 562 |   showAllocs((join ".", @bits));
 | 
|---|
| 563 | } # end update()
 | 
|---|
| 564 | 
 | 
|---|
| 565 | 
 | 
|---|
| 566 | # showPool()
 | 
|---|
| 567 | # List all IPs in a pool, and allow arbitrary admin changes to each
 | 
|---|
| 568 | # Allow changes to ALL fields
 | 
|---|
| 569 | sub showPool {
 | 
|---|
| 570 |   my $pool = new NetAddr::IP $_[0];
 | 
|---|
| 571 | 
 | 
|---|
| 572 |   $sth = $ip_dbh->prepare("select type,listname from alloctypes where type like '_i' order by listorder");
 | 
|---|
| 573 |   $sth->execute;
 | 
|---|
| 574 |   my @typelist;
 | 
|---|
| 575 |   while (my ($type,$dispname) = $sth->fetchrow_array) {
 | 
|---|
| 576 |     my %row = (
 | 
|---|
| 577 |         type => $type,
 | 
|---|
| 578 |         dispname => $dispname
 | 
|---|
| 579 |         );
 | 
|---|
| 580 |     push @typelist, \%row;
 | 
|---|
| 581 |   }
 | 
|---|
| 582 |   $page->param(typelist => \@typelist);
 | 
|---|
| 583 | 
 | 
|---|
| 584 |   $sth = $ip_dbh->prepare("SELECT ip,custid,city,type,available,description,notes from poolips".
 | 
|---|
| 585 |         " WHERE pool=? ORDER BY ip");
 | 
|---|
| 586 |   $sth->execute($pool);
 | 
|---|
| 587 |   my @iplist;
 | 
|---|
| 588 |   while (my ($ip,$custid,$city,$type,$avail,$desc,$notes) = $sth->fetchrow_array) {
 | 
|---|
| 589 |     my %row = (
 | 
|---|
| 590 |         ip => $ip,
 | 
|---|
| 591 |         custid => $custid,
 | 
|---|
| 592 |         city => $city,
 | 
|---|
| 593 |         type => $type,
 | 
|---|
| 594 |         avail => $avail,
 | 
|---|
| 595 |         desc => $desc,
 | 
|---|
| 596 |         notes => $notes
 | 
|---|
| 597 |         );
 | 
|---|
| 598 |     push @iplist, \%row;
 | 
|---|
| 599 |   }
 | 
|---|
| 600 |   $page->param(iplist => \@iplist);
 | 
|---|
| 601 | } # end showPool()
 | 
|---|
| 602 | 
 | 
|---|
| 603 | 
 | 
|---|
| 604 | # interpret the notify codes
 | 
|---|
| 605 | sub dispNoticeCode {
 | 
|---|
| 606 |   my $code = shift;
 | 
|---|
| 607 |   my $action_out = '';
 | 
|---|
| 608 | 
 | 
|---|
| 609 |   if ($code =~ /^s:/) {
 | 
|---|
| 610 |     $code =~ s/^s:/Special: /;
 | 
|---|
| 611 |     return $code;
 | 
|---|
| 612 |   }
 | 
|---|
| 613 |   if ($code =~ /^f:(.+)$/) {
 | 
|---|
| 614 |     $code =~ s/^f://;
 | 
|---|
| 615 |     $action_out = "Failure on ";
 | 
|---|
| 616 |   }
 | 
|---|
| 617 |   if (my $target = $code =~ /^n(.+)/) {
 | 
|---|
| 618 |     $action_out .= "New ";
 | 
|---|
| 619 |     if ($1 eq 'ci') { $action_out .= "city"; }
 | 
|---|
| 620 |     elsif ($1 eq 'no') { $action_out .= "node"; }
 | 
|---|
| 621 |     else { $action_out .= '<unknown>'; }
 | 
|---|
| 622 |   } else {
 | 
|---|
| 623 |     my ($action,$target) = ($code =~ /^(.)(.+)$/);
 | 
|---|
| 624 |     if ($action eq 'a')      { $action_out .= 'Add '; }
 | 
|---|
| 625 |     elsif ($action eq 'u')   { $action_out .= 'Update '; }
 | 
|---|
| 626 |     elsif ($action eq 'd')   { $action_out .= 'Delete '; }
 | 
|---|
| 627 | ##fixme:  what if we get something funky?
 | 
|---|
| 628 | # What about the eleventy-billion odd combinations possible?
 | 
|---|
| 629 | # this should give an idea of the structure tho
 | 
|---|
| 630 |     if ($target eq 'a') { $action_out .= "all"; }
 | 
|---|
| 631 |     elsif ($target eq '.i') {
 | 
|---|
| 632 |       $action_out .= "all static IPs";
 | 
|---|
| 633 |     }
 | 
|---|
| 634 |     else { $action_out .= $disp_alloctypes{$target}; }
 | 
|---|
| 635 |   }
 | 
|---|
| 636 |   return $action_out;
 | 
|---|
| 637 | }
 | 
|---|