source: branches/secondaryzones/dns.cgi@ 921

Last change on this file since 921 was 921, checked in by Kris Deugau, 18 hours ago

/branches/secondaryzones

Add "new secondary zone" data entry page

  • Property svn:executable set to *
  • Property svn:keywords set to Date Rev Author Id
File size: 106.6 KB
Line 
1#!/usr/bin/perl -w -T
2# Main web UI script for DeepNet DNS Administrator
3##
4# $Id: dns.cgi 921 2025-08-14 19:51:22Z kdeugau $
5# Copyright 2008-2022 Kris Deugau <kdeugau@deepnet.cx>
6#
7# This program is free software: you can redistribute it and/or modify
8# it under the terms of the GNU General Public License as published by
9# the Free Software Foundation, either version 3 of the License, or
10# (at your option) any later version.
11#
12# This program is distributed in the hope that it will be useful,
13# but WITHOUT ANY WARRANTY; without even the implied warranty of
14# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15# GNU General Public License for more details.
16#
17# You should have received a copy of the GNU General Public License
18# along with this program. If not, see <http://www.gnu.org/licenses/>.
19##
20
21use strict;
22use warnings;
23
24use CGI::Carp qw (fatalsToBrowser);
25use CGI::Simple;
26use HTML::Template;
27use CGI::Session '-ip_match';
28use Net::DNS;
29use DBI;
30
31use Data::Dumper;
32
33#sub is_tainted {
34# # from perldoc perlsec
35# return ! eval { eval("#" . substr(join("", @_), 0, 0)); 1 };
36#}
37
38# Taint-safe (ish) voodoo to push "the directory the script is in" into @INC.
39# See https://secure.deepnet.cx/trac/dnsadmin/ticket/80 for more gory details on how we got here.
40use File::Spec ();
41use File::Basename ();
42my $path;
43BEGIN {
44 $path = File::Basename::dirname(File::Spec->rel2abs($0));
45 if ($path =~ /(.*)/) {
46 $path = $1;
47 }
48}
49use lib $path;
50
51use DNSDB;
52
53my @debugbits; # temp, to be spit out near the end of processing
54my $debugenv = 0;
55
56# Let's do these templates right...
57my $templatedir = "templates";
58
59# Set up the CGI object...
60my $q = new CGI::Simple;
61# ... and get query-string params as well as POST params if necessary
62$q->parse_query_string;
63
64# This is probably excessive fiddling, but it puts the parameters somewhere my fingers know about...
65my %webvar = $q->Vars;
66
67# shut up some warnings, in case we arrive somewhere we forgot to set this
68$webvar{defrec} = 'n' if !$webvar{defrec}; # non-default records
69$webvar{revrec} = 'n' if !$webvar{revrec}; # non-reverse (domain) records
70
71# create a DNSDB object. this loads some local system defaults and connects to the DB
72# with the credentials configured
73##fixme: pass params for loadConfig, and use them there, to allow one codebase to support multiple sites
74my $dnsdb = new DNSDB;
75
76my $header = HTML::Template->new(filename => "$templatedir/header.tmpl");
77my $footer = HTML::Template->new(filename => "$templatedir/footer.tmpl");
78$footer->param(version => $DNSDB::VERSION);
79
80##fixme: slim chance this could be triggered on errors other than DB failure?
81if (!$dnsdb) {
82 print "Content-type: text/html\n\n";
83 print $header->output;
84 my $errpage = HTML::Template->new(filename => "$templatedir/dberr.tmpl");
85 $errpage->param(errmsg => $DNSDB::errstr);
86 print $errpage->output;
87 print $footer->output;
88 exit;
89}
90
91$header->param(orgname => $dnsdb->{orgname}) if $dnsdb->{orgname} ne 'Example Corp';
92
93my $logingroup;
94my $curgroup;
95my @viewablegroups;
96
97# retrieve the session ID from our cookie, if possible
98my $sid = $q->cookie('dnsadmin_session');
99
100# see if the session loads
101my $session = CGI::Session->load("driver:File", $sid, {Directory => $dnsdb->{sessiondir}})
102 or die CGI::Session->errstr();
103
104if (!$sid || $session->is_expired || !$session->param('uid') || !$dnsdb->userStatus($session->param('uid')) ) {
105 $webvar{page} = 'login';
106} else {
107 # we have a session to load from, maybe
108 $logingroup = ($session->param('logingroup') ? $session->param('logingroup') : 1);
109 $curgroup = ($session->param('curgroup') ? $session->param('curgroup') : $logingroup);
110 # security check - does the user have permission to view this entity?
111 # this is a prep step used "many" places
112 $dnsdb->getChildren($logingroup, \@viewablegroups, 'all');
113 push @viewablegroups, $logingroup;
114##fixme: make sessions persist through closing the site?
115# this even bridges browser close too. hmm...
116 $webvar{page} = 'domlist' if !$webvar{page};
117}
118
119# set $webvar{page} before we try to use it.
120$webvar{page} = 'login' if !$webvar{page};
121
122## per-page startwith, filter, searchsubs
123
124##fixme: complain-munge-and-continue with non-"[a-z0-9-.]" filter and startwith
125$webvar{startwith} =~ s/^(0-9|[a-z]).*/$1/ if $webvar{startwith};
126# not much call for chars not allowed in domain names
127# allow <>= so searches can use the Postgres CIDR operators
128# allow , for things like DMARC records
129$webvar{filter} =~ s{[^a-zA-Z0-9_.,:\@%<>=/-]}{}g if $webvar{filter};
130## only set 'y' if box is checked, no other values legal
131## however, see https://secure.deepnet.cx/trac/dnsadmin/ticket/31
132# first, drop obvious fakes
133delete $webvar{searchsubs} if $webvar{searchsubs} && $webvar{searchsubs} !~ /^[ny]/;
134# strip the known "turn me off!" bit.
135$webvar{searchsubs} =~ s/^n\s?// if $webvar{searchsubs};
136# strip non-y/n - note this legitimately allows {searchsubs} to go empty
137$webvar{searchsubs} =~ s/[^yn]//g if $webvar{searchsubs};
138
139# pagination
140my $perpage = 15; # Just In Case
141$perpage = $dnsdb->{perpage} if $dnsdb->{perpage};
142my $offset = ($webvar{offset} ? $webvar{offset} : 0);
143
144## set up "URL to self" (whereami edition)
145# @#$%@%@#% XHTML - & in a URL must be escaped. >:(
146my $uri_self = $ENV{REQUEST_URI};
147$uri_self = "/dns.cgi" if !$uri_self || $uri_self eq '/';
148$uri_self =~ s/\&([a-z])/\&amp\;$1/g;
149
150# le sigh. and we need to strip any previous action
151$uri_self =~ s/\&amp;action=[^&]+//g;
152
153# much magic happens. if startwith or a search string change (to, from, or
154# across, in the request vs whatever's in the session) then the offset should
155# be reset to 0 so that the first/prev/next/last widget populates correctly,
156# and so that the list of whatever we're looking at actually shows things
157# (since we may have started on page 42 of 300 with a LOOOOONG list, but we
158# now only need 3 pages for the filtered list).
159# while we're at it, plonk these into the session for safekeeping.
160if (defined($webvar{startwith})) {
161 if ($webvar{startwith} ne $session->param($webvar{page}.'startwith')) {
162 $uri_self =~ s/\&amp;offset=[^&]//;
163 $offset = 0;
164 }
165 $session->param($webvar{page}.'startwith', $webvar{startwith});
166}
167if (defined($webvar{filter})) {
168 $session->param($webvar{page}.'filter', '') if !$session->param($webvar{page}.'filter');
169 if ($webvar{filter} ne $session->param($webvar{page}.'filter')) {
170 $uri_self =~ s/\&amp;offset=[^&]//;
171 $offset = 0;
172 }
173 $session->param($webvar{page}.'filter', $webvar{filter})
174}
175$session->param($webvar{page}.'searchsubs', $webvar{searchsubs}) if defined($webvar{searchsubs});
176
177# and now that the search/filter criteria for this page are set, put them in some globals for actual use.
178my $startwith = $session->param($webvar{page}.'startwith');
179my $filter = $session->param($webvar{page}.'filter');
180my $searchsubs = $session->param($webvar{page}.'searchsubs');
181
182# ... and assemble the args
183my @filterargs;
184push @filterargs, "^[$startwith]" if $startwith;
185push @filterargs, $filter if $filter;
186
187# and search filter options. these get stored in the session, but discarded
188# as soon as you switch to a different page.
189##fixme: think about retaining these on a per-page basis, as well as offset; same as the sort-order bits
190no warnings qw(uninitialized);
191$uri_self =~ s/\&amp;startwith=[a-z09-]*(\&)?/$1/g;
192$uri_self =~ s/\&amp;searchsubs=[a-z09-]*(\&)?/$1/g;
193$uri_self =~ s/\&amp;filter=[a-z09-]*(\&)?/$1/g;
194use warnings qw(uninitialized);
195
196# Fix up $uri_self so we don't lose the session/page
197$uri_self .= "?page=$webvar{page}" if $uri_self =~ m{/dns.cgi$};
198$uri_self = "$ENV{SCRIPT_NAME}?page=$webvar{page}$1" if $uri_self =~ m{/dns.cgi\&(.+)$};
199
200## end uri_self monkeying
201
202# NB: these must match the field name and SQL ascend/descend syntax respectively
203# sortby is reset to a suitable "default", then re-reset to whatever the user has
204# clicked on last in the record=listing subs, but best to put a default here.
205my $sortby = "domain";
206my $sortorder = "ASC";
207
208# Create the page template object. Display a reasonable error page and whine if the template doesn't exist.
209my $page;
210eval {
211 # sigh. can't set loop_context_vars or global_vars once instantiated.
212 $page = HTML::Template->new(filename => "$templatedir/$webvar{page}.tmpl",
213 loop_context_vars => 1, global_vars => 1);
214};
215if ($@) {
216 my $msg = $@;
217 $page = HTML::Template->new(filename => "$templatedir/badpage.tmpl");
218 if (-e "$templatedir/$webvar{page}.tmpl") {
219 $page->param(badtemplate => $q->escapeHTML($msg));
220 } else {
221 warn "Bad page $webvar{page} requested";
222 $page->param(badpage => $q->escapeHTML($webvar{page}));
223 }
224 $webvar{page} = 'badpage';
225}
226
227$session->expire($dnsdb->{timeout});
228my $sesscookie = $q->cookie( -name => 'dnsadmin_session',
229 -value => $sid,
230 -expires => "+".$dnsdb->{timeout},
231 -secure => 0,
232## fixme: need to extract root path for cookie, so as to limit cookie to dnsadmin instance
233# -path => $url
234 );
235
236# handle can-happen-on-(almost)-any-page actions
237if ($webvar{action}) {
238
239 if ($webvar{action} eq 'login') {
240 # Snag ACL/permissions here too
241
242 my $userdata = $dnsdb->login($webvar{username}, $webvar{password});
243
244 if ($userdata) {
245
246 # (re)create the session
247 $session = new CGI::Session("driver:File", $sid, {Directory => $dnsdb->{sessiondir}})
248 or die CGI::Session->errstr();
249 $sid = $session->id();
250
251 $sesscookie = $q->cookie( -name => 'dnsadmin_session',
252 -value => $sid,
253 -expires => "+".$dnsdb->{timeout},
254 -secure => 0,
255## fixme: need to extract root path for cookie, so as to limit cookie to dnsadmin instance
256# -path => $url
257 );
258
259 # set session bits
260 $session->expire($dnsdb->{timeout});
261 $session->param('logingroup',$userdata->{group_id});
262 $session->param('curgroup',$userdata->{group_id});
263 $session->param('uid',$userdata->{user_id});
264 $session->param('username',$webvar{username});
265 $curgroup = $userdata->{group_id};
266
267# for reference. seems we don't need to set these on login any more.
268# $session->param('domlistsortby','domain');
269# $session->param('domlistorder','ASC');
270# $session->param('revzonessortby','revnet');
271# $session->param('revzonesorder','ASC');
272# $session->param('useradminsortby','user');
273# $session->param('useradminorder','ASC');
274# $session->param('grpmansortby','group');
275# $session->param('grpmanorder','ASC');
276# $session->param('reclistsortby','host');
277# $session->param('reclistorder','ASC');
278# $session->param('loclistsortby','description');
279# $session->param('loclistorder','ASC');
280# $session->param('logsortby','stamp');
281# $session->param('logorder','DESC');
282
283 ## "recover my link" - tack on request bits and use requested page instead of hardcoding domlist
284 # this could possibly be compacted by munging changepage a little so we don't have to deconstruct
285 # and reconstruct the URI argument list.
286 my %target = (page => "domlist");
287 if ($webvar{target} && $webvar{target} =~ /\?/ && $webvar{target} !~ /page=login/) {
288 my $tmp = (split /\?/, $webvar{target})[1];
289 $tmp =~ s/^\&//;
290 my @targs = split /\&/, $tmp;
291 foreach (@targs) {
292 my ($k,$v) = split /=/;
293 $target{$k} = $v if $k;
294 # if we're going through a "session expired" login, we may have a different
295 # "current group" than the login group.
296 $session->param('curgroup', $v) if $k eq 'curgroup';
297##fixme: page=record goes "FOOM", sometimes - cause/fix?
298 }
299 }
300 changepage(%target);
301
302 } else {
303 $webvar{loginfailed} = 1;
304 } # user data fetch check
305
306 } elsif ($webvar{action} eq 'logout') {
307 # delete the session
308 $session->delete();
309 $session->flush();
310
311 my $sesscookie = $q->cookie( -name => 'dnsadmin_session',
312 -value => $sid,
313 -expires => "-1",
314 -secure => 0,
315## fixme: need to extract root path for cookie, so as to limit cookie to dnsadmin instance
316# -path => $url
317 );
318
319 my $newurl = "http://$ENV{HTTP_HOST}$ENV{SCRIPT_NAME}";
320 $newurl =~ s|/[^/]+$|/|;
321 print $q->redirect( -uri => $newurl, -cookie => $sesscookie);
322 exit;
323
324 } elsif ($webvar{action} eq 'chgroup' && $webvar{page} ne 'login') {
325 # fiddle session-stored group data
326 # magic incantation to... uhhh...
327
328 # ... and the "change group" bits...
329 $uri_self =~ s/\&amp;group=[^&]*//g;
330
331 # security check - does the user have permission to view this entity?
332 my $errmsg;
333 if (!(grep /^$webvar{group}$/, @viewablegroups)) {
334 # hmm. Reset the current group to the login group? Yes. Prevents confusing behaviour elsewhere.
335 $session->param('curgroup',$logingroup);
336 $webvar{group} = $logingroup;
337 $curgroup = $logingroup;
338 $errmsg = "You are not permitted to view or make changes in the requested group";
339 $page->param(errmsg => $errmsg);
340 }
341
342 $session->param('curgroup', $webvar{group});
343 $curgroup = ($webvar{group} ? $webvar{group} : $session->param('curgroup'));
344
345 # I hate special cases.
346##fixme: probably need to handle webvar{revrec}=='y' too
347 if ($webvar{page} eq 'reclist' && $webvar{defrec} eq 'y') {
348 my %args = (page => $webvar{page}, id => $curgroup, defrec => $webvar{defrec}, revrec => $webvar{revrec});
349 $args{errmsg} = $errmsg if $errmsg;
350 changepage(%args);
351 }
352 # add offset back *into* $uri_self if we're also currently looking at a live record list.
353 if ($webvar{page} eq 'reclist' && $webvar{defrec} eq 'n') {
354 $uri_self .= "\&amp;offset=$offset";
355 }
356 } # done action=chgroup
357} # handle global webvar{action}s
358
359
360# finally check if the user was disabled. we could just leave this for logout/session expiry,
361# but if they keep the session active they'll continue to have access long after being disabled. :/
362# Treat it as a session expiry.
363if ($session->param('uid') && !$dnsdb->userStatus($session->param('uid')) ) {
364 $sid = '';
365 $session->delete; # force expiry of the session Right Away
366 $session->flush; # make sure it hits storage
367 changepage(page=> "login", sessexpired => 1);
368}
369
370# Misc Things To Do on most pages
371my %permissions;
372$dnsdb->getPermissions('user', $session->param('uid'), \%permissions);
373$dnsdb->initActionLog($session->param('uid'));
374
375##
376## Per-page processing
377##
378
379if ($webvar{page} eq 'login') {
380
381 my $target = $ENV{REQUEST_URI};
382 $target =~ s/\&/\&amp;/g;
383 $page->param(target => $target); # needs to be trimmed a little, maybe?
384
385 $page->param(sessexpired => 1) if (!$sid && $target !~ m|/$|);
386
387 if ($webvar{loginfailed}) {
388 $page->param(loginfailed => 1);
389 $webvar{target} =~ s/\&/\&amp;/g; # XHTML we do (not) love you so
390 $page->param(target => $webvar{target}) if $webvar{target};
391 }
392# if $webvar{sessexpired}; # or this with below?
393 if ($session->is_expired) {
394 $page->param(sessexpired => 1);
395 $session->delete(); # Just to make sure
396 $session->flush();
397 }
398 $page->param(version => $DNSDB::VERSION);
399 $page->param(script_self => ($ENV{SCRIPT_NAME} =~ m|/([^/]+)$|)[0]);
400
401} elsif ($webvar{page} eq 'domlist' or $webvar{page} eq 'index') {
402
403 $page->param(domlist => 1);
404
405# hmm. seeing problems in some possibly-not-so-corner cases.
406# this currently only handles "domain on", "domain off"
407 if (defined($webvar{zonestatus})) {
408 # security check - does the user have permission to access this entity?
409 my $flag = 0;
410 foreach (@viewablegroups) {
411 $flag = 1 if $dnsdb->isParent($_, 'group', $webvar{id}, 'domain');
412 }
413 if ($flag && ($permissions{admin} || $permissions{domain_edit})) {
414 my $stat = $dnsdb->zoneStatus($webvar{id}, 'n', $webvar{zonestatus});
415 $page->param(resultmsg => $DNSDB::resultstr);
416 } else {
417 $page->param(errmsg => "You are not permitted to view or change the requested domain");
418 }
419 $uri_self =~ s/\&amp;zonestatus=[^&]*//g; # clean up URL for stuffing into templates
420 }
421
422 show_msgs();
423
424 $page->param(curpage => $webvar{page});
425
426 listdomains();
427
428} elsif ($webvar{page} eq 'newdomain') {
429
430 changepage(page => "domlist", errmsg => "You are not permitted to add domains")
431 unless ($permissions{admin} || $permissions{domain_create});
432
433 $webvar{group} = $curgroup if !$webvar{group};
434 fill_grouplist("grouplist", $webvar{group});
435 fill_loclist($curgroup, $webvar{defloc} ? $webvar{defloc} : '');
436
437 if ($session->param('add_failed')) {
438 $session->clear('add_failed');
439 $page->param(add_failed => 1);
440 $page->param(errmsg => $session->param('errmsg'));
441 $session->clear('errmsg');
442 $page->param(domain => $webvar{domain});
443 $page->param(addinactive => $webvar{makeactive} eq 'n');
444 }
445
446} elsif ($webvar{page} eq 'adddomain') {
447
448 changepage(page => "domlist", errmsg => "You are not permitted to add domains")
449 unless ($permissions{admin} || $permissions{domain_create});
450
451 # security check - does the user have permission to access this entity?
452 if (!check_scope(id => $webvar{group}, type => 'group')) {
453 $session->param('add_failed', 1);
454##fixme: domain a security risk for XSS?
455 changepage(page => "newdomain", domain => $webvar{domain},
456 errmsg => "You do not have permission to add a domain to the requested group");
457 }
458
459 $webvar{makeactive} = 0 if !defined($webvar{makeactive});
460
461 my ($code,$msg) = $dnsdb->addDomain($webvar{domain}, $webvar{group}, ($webvar{makeactive} eq 'on' ? 1 : 0),
462 $webvar{defloc});
463
464 if ($code eq 'OK') {
465 $webvar{domain} = lc($webvar{domain}) if $dnsdb->{lowercase};
466 $dnsdb->mailNotify("New ".($webvar{makeactive} eq 'on' ? 'Active' : 'Inactive')." Domain Created",
467 ($webvar{makeactive} eq 'on' ? 'Active' : 'Inactive').qq( domain "$webvar{domain}" added by ).
468 $session->param("username"));
469 changepage(page => "reclist", id => $msg);
470 } else {
471 $session->param('add_failed', 1);
472##fixme: domain a security risk for XSS?
473 changepage(page => "newdomain", errmsg => $msg, domain => $webvar{domain},
474 group => $webvar{group}, makeactive => ($webvar{makeactive} ? 'y' : 'n'), defloc => $webvar{defloc});
475 }
476
477} elsif ($webvar{page} eq 'deldom') {
478
479 changepage(page => "domlist", errmsg => "You are not permitted to delete domains")
480 unless ($permissions{admin} || $permissions{domain_delete});
481
482 # security check - does the user have permission to access this entity?
483 if (!check_scope(id => $webvar{id}, type => 'domain')) {
484 changepage(page => "domlist", errmsg => "You do not have permission to delete the requested domain");
485 }
486
487 $page->param(id => $webvar{id});
488
489 # first pass = confirm y/n (sorta)
490 if (!defined($webvar{del})) {
491
492 $page->param(del_getconf => 1);
493 $page->param(domain => $dnsdb->domainName($webvar{id}));
494
495 } elsif ($webvar{del} eq 'ok') {
496 my $pargroup = $dnsdb->parentID(id => $webvar{id}, type => 'domain', revrec => $webvar{revrec});
497 my ($code,$msg) = $dnsdb->delZone($webvar{id}, $webvar{revrec});
498 if ($code eq 'OK') {
499 changepage(page => "domlist", resultmsg => $msg);
500 } else {
501 changepage(page => "domlist", errmsg => $msg);
502 }
503
504 } else {
505 # cancelled. whee!
506 changepage(page => "domlist");
507 }
508
509} elsif ($webvar{page} eq 'revzones') {
510
511 $webvar{revrec} = 'y';
512
513 if (defined($webvar{zonestatus})) {
514 # security check - does the user have permission to access this entity?
515 my $flag = 0;
516 foreach (@viewablegroups) {
517 $flag = 1 if $dnsdb->isParent($_, 'group', $webvar{id}, 'revzone');
518 }
519 if ($flag && ($permissions{admin} || $permissions{domain_edit})) {
520 my $stat = $dnsdb->zoneStatus($webvar{id}, 'y', $webvar{zonestatus});
521 $page->param(resultmsg => $DNSDB::resultstr);
522 } else {
523 $page->param(errmsg => "You are not permitted to view or change the requested reverse zone");
524 }
525 $uri_self =~ s/\&amp;zonestatus=[^&]*//g; # clean up URL for stuffing into templates
526 }
527
528 show_msgs();
529
530 $page->param(curpage => $webvar{page});
531 listzones();
532
533} elsif ($webvar{page} eq 'newrevzone') {
534
535## scope/access check - use domain settings? invent new (bleh)
536 changepage(page => "revzones", errmsg => "You are not permitted to add reverse zones")
537 unless ($permissions{admin} || $permissions{domain_create});
538
539 fill_grouplist("grouplist");
540 fill_loclist($curgroup, $webvar{defloc} ? $webvar{defloc} : '');
541
542 # prepopulate revpatt with the matching default record
543# $dnsdb->getRecByName(revrec => $webvar{revrec}, defrec => $webvar{defrec}, host => 'string');
544
545 if ($session->param('add_failed')) {
546 $session->clear('add_failed');
547 $page->param(errmsg => $session->param('errmsg'));
548 $session->clear('errmsg');
549 $page->param(revzone => $webvar{revzone});
550 $page->param(revpatt => $webvar{revpatt});
551 }
552
553} elsif ($webvar{page} eq 'addrevzone') {
554
555 changepage(page => "revzones", errmsg => "You are not permitted to add reverse zones")
556 unless ($permissions{admin} || $permissions{domain_create});
557
558 # security check - does the user have permission to access this entity?
559 if (!check_scope(id => $webvar{group}, type => 'group')) {
560 changepage(page => "newrevzone", add_failed => 1, revzone => $webvar{revzone}, revpatt => $webvar{revpatt},
561 errmsg => "You do not have permission to add a reverse zone to the requested group");
562 }
563
564 my ($code,$msg) = $dnsdb->addRDNS($webvar{revzone}, $webvar{revpatt}, $webvar{group},
565 ($webvar{makeactive} eq 'on' ? 1 : 0), $webvar{location});
566
567 if ($code eq 'OK') {
568 changepage(page => "reclist", id => $msg, revrec => 'y');
569 } elsif ($code eq 'WARN') {
570 changepage(page => "reclist", id => $msg, revrec => 'y', warnmsg => $DNSDB::resultstr);
571 } else {
572 $session->param('add_failed', 1);
573 changepage(page => "newrevzone", revzone => $webvar{revzone}, revpatt => $webvar{revpatt}, errmsg => $msg);
574 }
575
576} elsif ($webvar{page} eq 'delrevzone') {
577
578 changepage(page => "revzones", errmsg => "You are not permitted to delete reverse zones")
579 unless ($permissions{admin} || $permissions{domain_delete});
580
581 # security check - does the user have permission to access this entity?
582 if (!check_scope(id => $webvar{id}, type => 'revzone')) {
583 changepage(page => "revzones", errmsg => "You do not have permission to delete the requested reverse zone");
584 }
585
586 $page->param(id => $webvar{id});
587
588 # first pass = confirm y/n (sorta)
589 if (!defined($webvar{del})) {
590
591 $page->param(del_getconf => 1);
592 $page->param(revzone => $dnsdb->revName($webvar{id}));
593
594 } elsif ($webvar{del} eq 'ok') {
595 my $pargroup = $dnsdb->parentID(id => $webvar{id}, type => 'revzone', revrec => $webvar{revrec});
596 my $zone = $dnsdb->revName($webvar{id});
597 my ($code,$msg) = $dnsdb->delZone($webvar{id}, 'y');
598 if ($code eq 'OK') {
599 changepage(page => "revzones", resultmsg => $msg);
600 } else {
601 changepage(page => "revzones", errmsg => $msg);
602 }
603
604 } else {
605 # cancelled. whee!
606 changepage(page => "revzones");
607 }
608
609} elsif ($webvar{page} eq 'secondaryzones') {
610
611# $page->param(domlist => 1);
612
613# hmm. seeing problems in some possibly-not-so-corner cases.
614# this currently only handles "domain on", "domain off"
615 if (defined($webvar{zonestatus})) {
616 # security check - does the user have permission to access this entity?
617 my $flag = 0;
618 foreach (@viewablegroups) {
619 $flag = 1 if $dnsdb->isParent($_, 'group', $webvar{id}, 'secondary');
620 }
621 if ($flag && ($permissions{admin} || $permissions{domain_edit})) {
622 my $stat = $dnsdb->secondaryzoneStatus($webvar{id}, 'n', $webvar{zonestatus});
623 $page->param(resultmsg => $DNSDB::resultstr);
624 } else {
625 $page->param(errmsg => "You are not permitted to view or change the requested domain");
626 }
627 $uri_self =~ s/\&amp;zonestatus=[^&]*//g; # clean up URL for stuffing into templates
628 }
629
630 show_msgs();
631
632 $page->param(curpage => $webvar{page});
633
634 listsecondaryzones();
635
636} elsif ($webvar{page} eq 'newsecondary') {
637
638 changepage(page => "secondaryzones", errmsg => "You are not permitted to add secondary zones")
639 unless ($permissions{admin} || $permissions{domain_create});
640
641 $webvar{group} = $curgroup if !$webvar{group};
642 fill_grouplist("grouplist", $webvar{group});
643 fill_loclist($curgroup, $webvar{defloc} ? $webvar{defloc} : '');
644
645 if ($session->param('add_failed')) {
646 $session->clear('add_failed');
647 $page->param(add_failed => 1);
648 $page->param(errmsg => $session->param('errmsg'));
649 $session->clear('errmsg');
650 $page->param(zone => $webvar{zone});
651 $page->param(addinactive => $webvar{makeactive} eq 'n');
652 }
653
654} elsif ($webvar{page} eq 'editsecondary') {
655
656 # security check - does the user have permission to view this entity?
657 # id is zone id
658 if (!check_scope(id => $webvar{id}, type => 'secondaryzone')) {
659 changepage(page => 'secondaryzones',
660 errmsg => "You do not have permission to edit the requested secondary zone");
661 }
662
663 changepage(page => "secondaryzones", errmsg => "You are not permitted to edit secondary zones", id => $webvar{id})
664 unless ($permissions{admin} || $permissions{domain_edit});
665
666 $page->param(id => $webvar{id});
667 $page->param(parent => $dnsdb->secondaryName($webvar{id}));
668 my $zoneinfo = $dnsdb->getSecondaryDetails($webvar{id});
669 $page->param(prins => $zoneinfo->{primaryserver});
670 fill_loclist($curgroup, $zoneinfo->{default_location});
671
672} elsif ($webvar{page} eq 'updatesecondary') {
673
674 # security check - does the user have permission to view this entity?
675 # pass 1, record ID
676 # id is zone id
677 if (!check_scope(id => $webvar{id}, type => 'secondaryzone')) {
678 changepage(page => 'secondaryzones',
679 errmsg => "You do not have permission to edit the requested secondary zone");
680 }
681
682 changepage(page => "secondaryzones", errmsg => "You are not permitted to edit secondary zones", id => $webvar{id})
683 unless ($permissions{admin} || $permissions{domain_edit});
684
685 my ($code, $msg) = $dnsdb->updateSecondaryDetails(
686 id => $webvar{id}, primary => $webvar{prins}, location => $webvar{defloc});
687 if ($code eq 'OK') {
688 my $zone = $dnsdb->secondaryName($webvar{id});
689 changepage(page => "secondaryzones", resultmsg => "Secondary zone $zone updated");
690 } else {
691 $page->param(update_failed => 1);
692 $page->param(msg => $msg);
693
694 $page->param(id => $webvar{id});
695 $page->param(prins => $webvar{prins});
696 fill_loclist($curgroup, $webvar{defloc});
697 }
698
699} elsif ($webvar{page} eq 'reclist') {
700
701 # security check - does the user have permission to view this entity?
702 if (!check_scope(id => $webvar{id}, type =>
703 ($webvar{defrec} eq 'y' ? 'group' : ($webvar{revrec} eq 'y' ? 'revzone' : 'domain')))) {
704 $page->param(errmsg => "You are not permitted to view or change the requested ".
705 ($webvar{defrec} eq 'y' ? "group's default records" :
706 ($webvar{revrec} eq 'y' ? "reverse zone's records" : "domain's records")));
707 $page->param(perm_err => 1); # this causes the template to skip the record listing output.
708 goto DONERECLIST; # and now we skip filling in the content which is not printed due to perm_err above
709 }
710
711# hmm. where do we send them?
712 if ($webvar{defrec} eq 'y' && !$permissions{admin}) {
713 $page->param(errmsg => "You are not permitted to edit default records");
714 $page->param(perm_err => 1);
715 } else {
716
717 $page->param(mayeditsoa => $permissions{admin} || $permissions{domain_edit});
718##fixme: ACL needs pondering. Does "edit domain" interact with record add/remove/etc?
719# Note this seems to be answered "no" in Vega.
720# ACLs
721 $page->param(record_create => ($permissions{admin} || $permissions{record_create}) );
722# we don't have any general edit links on the page; they're all embedded in the TMPL_LOOP
723# $page->param(record_edit => ($permissions{admin} || $permissions{record_edit}) );
724 $page->param(record_delete => ($permissions{admin} || $permissions{record_delete}) );
725
726 # Handle record list for both default records (per-group) and live domain records
727
728 $page->param(defrec => $webvar{defrec});
729 $page->param(revrec => $webvar{revrec});
730 $page->param(id => $webvar{id});
731 $page->param(curpage => $webvar{page});
732
733 my $count = $dnsdb->getRecCount(defrec => $webvar{defrec}, revrec => $webvar{revrec},
734 id => $webvar{id}, filter => $filter);
735
736 $sortby = 'host';
737# sort/order
738 $session->param($webvar{page}.'sortby', $webvar{sortby}) if $webvar{sortby};
739 $session->param($webvar{page}.'order', $webvar{order}) if $webvar{order};
740
741 $sortby = $session->param($webvar{page}.'sortby') if $session->param($webvar{page}.'sortby');
742 $sortorder = $session->param($webvar{page}.'order') if $session->param($webvar{page}.'order');
743
744# set up the headers
745 my @cols;
746 my %colheads;
747 if ($webvar{revrec} eq 'n') {
748 @cols = ('host', 'type', 'val', 'distance', 'weight', 'port', 'ttl');
749 %colheads = (host => 'Name', type => 'Type', val => 'Address',
750 distance => 'Distance', weight => 'Weight', port => 'Port', ttl => 'TTL');
751 } else {
752 @cols = ('val', 'type', 'host', 'ttl');
753 %colheads = (val => 'IP Address', type => 'Type', host => 'Hostname', ttl => 'TTL');
754 }
755 my %custom = (id => $webvar{id}, defrec => $webvar{defrec}, revrec => $webvar{revrec});
756 fill_colheads($sortby, $sortorder, \@cols, \%colheads, \%custom);
757
758# fill the page-count and first-previous-next-last-all details
759 fill_pgcount($count,"records",
760 ($webvar{defrec} eq 'y' ? "group ".$dnsdb->groupName($webvar{id}) :
761 ($webvar{revrec} eq 'y' ? $dnsdb->revName($webvar{id}) : $dnsdb->domainName($webvar{id}))
762 ));
763 fill_fpnla($count); # should put some params on this sub...
764
765 $page->param(defrec => $webvar{defrec});
766 showzone($webvar{defrec}, $webvar{revrec}, $webvar{id});
767 if ($webvar{defrec} eq 'n') {
768 if ($webvar{revrec} eq 'n') {
769 $page->param(logdom => 1);
770 } else {
771 $page->param(logrdns => 1);
772 }
773 }
774
775 show_msgs();
776
777 } # close "you can't edit default records" check
778
779 # Yes, this is a GOTO target. PTBHTTT.
780 DONERECLIST: ;
781
782} elsif ($webvar{page} eq 'record') {
783
784 # security check - does the user have permission to access this entity?
785 if (!check_scope(id => $webvar{id}, type =>
786 ($webvar{defrec} eq 'y' ? ($webvar{revrec} eq 'y' ? 'defrevrec' : 'defrec') : 'record'))) {
787 $page->param(perm_err => "You are not permitted to edit the requested record");
788 goto DONEREC;
789 }
790 # round 2, check the parent.
791 if (!check_scope(id => $webvar{parentid}, type =>
792 ($webvar{defrec} eq 'y' ? 'group' : ($webvar{revrec} eq 'y' ? 'revzone' : 'domain')))) {
793 my $msg = ($webvar{defrec} eq 'y' ?
794 "You are not permitted to add or edit default records in the requested group" :
795 "You are not permitted to add or edit records in the requested domain/zone");
796 $page->param(perm_err => $msg);
797 goto DONEREC;
798 }
799
800 $page->param(defrec => $webvar{defrec});
801 $page->param(revrec => $webvar{revrec});
802 $page->param(fwdzone => $webvar{revrec} eq 'n');
803
804 if ($webvar{recact} eq 'new') {
805
806 changepage(page => "reclist", errmsg => "You are not permitted to add records", id => $webvar{parentid})
807 unless ($permissions{admin} || $permissions{record_create});
808
809 $page->param(todo => "Add record");
810 $page->param(recact => "add");
811 $page->param(parentid => $webvar{parentid});
812
813 fill_recdata();
814
815 if ($webvar{defrec} eq 'n') {
816 my $defloc = $dnsdb->getZoneLocation($webvar{revrec}, $webvar{parentid});
817 fill_loclist($curgroup, $defloc);
818 }
819
820 } elsif ($webvar{recact} eq 'add') {
821
822 changepage(page => "reclist", errmsg => "You are not permitted to add records", id => $webvar{parentid})
823 unless ($permissions{admin} || $permissions{record_create});
824
825 # location check - if user does not have record_locchg, set $webvar{location} to default location for zone
826 my $parloc = $dnsdb->getZoneLocation($webvar{revrec}, $webvar{parentid});
827 $webvar{location} = $parloc unless ($permissions{admin} || $permissions{record_locchg});
828
829 my @recargs = ($webvar{defrec}, $webvar{revrec}, $webvar{parentid},
830 \$webvar{name}, \$webvar{type}, \$webvar{address}, $webvar{ttl}, $webvar{location},
831 $webvar{expires}, $webvar{stamp});
832 if ($webvar{type} == $reverse_typemap{MX} or $webvar{type} == $reverse_typemap{SRV}) {
833 push @recargs, $webvar{distance};
834 if ($webvar{type} == $reverse_typemap{SRV}) {
835 push @recargs, $webvar{weight};
836 push @recargs, $webvar{port};
837 }
838 }
839
840 my ($code,$msg) = $dnsdb->addRec(@recargs);
841
842 if ($code eq 'OK' || $code eq 'WARN') {
843 my %pageparams = (page => "reclist", id => $webvar{parentid},
844 defrec => $webvar{defrec}, revrec => $webvar{revrec});
845 $pageparams{warnmsg} = $msg."<br />\n".$DNSDB::resultstr if $code eq 'WARN';
846 $pageparams{resultmsg} = $DNSDB::resultstr if $code eq 'OK';
847 changepage(%pageparams);
848 } else {
849 $page->param(failed => 1);
850 $page->param(errmsg => $msg);
851 $page->param(wastrying => "adding");
852 $page->param(todo => "Add record");
853 $page->param(recact => "add");
854 $page->param(parentid => $webvar{parentid});
855 $page->param(id => $webvar{id});
856 fill_recdata(); # populate the form... er, mostly.
857 if ($webvar{defrec} eq 'n') {
858 fill_loclist($curgroup, $webvar{location});
859 }
860 }
861
862 } elsif ($webvar{recact} eq 'edit') {
863
864 changepage(page => "reclist", errmsg => "You are not permitted to edit records", id => $webvar{parentid})
865 unless ($permissions{admin} || $permissions{record_edit});
866
867 $page->param(todo => "Update record");
868 $page->param(recact => "update");
869 $page->param(parentid => $webvar{parentid});
870 $page->param(id => $webvar{id});
871 my $recdata = $dnsdb->getRecLine($webvar{defrec}, $webvar{revrec}, $webvar{id});
872 $page->param(name => $recdata->{host});
873 $page->param(address => $recdata->{val});
874 $page->param(distance => $recdata->{distance});
875 $page->param(weight => $recdata->{weight});
876 $page->param(port => $recdata->{port});
877 $page->param(ttl => $recdata->{ttl});
878 $page->param(typelist => $dnsdb->getTypelist($webvar{revrec}, $recdata->{type}));
879 if ($recdata->{stampactive}) {
880 $page->param(stamp => $recdata->{stamp});
881 $page->param(stamp_until => $recdata->{expires});
882 }
883 if ($webvar{defrec} eq 'n') {
884 fill_loclist($curgroup, $recdata->{location});
885 }
886
887 } elsif ($webvar{recact} eq 'update') {
888
889 changepage(page => "reclist", errmsg => "You are not permitted to edit records", id => $webvar{parentid})
890 unless ($permissions{admin} || $permissions{record_edit});
891
892 # retain old location if user doesn't have permission to fiddle locations
893 my $oldrec = $dnsdb->getRecLine($webvar{defrec}, $webvar{revrec}, $webvar{id});
894 $webvar{location} = $oldrec->{location} unless ($permissions{admin} || $permissions{record_locchg});
895
896 my ($code,$msg) = $dnsdb->updateRec($webvar{defrec}, $webvar{revrec}, $webvar{id}, $webvar{parentid},
897 \$webvar{name}, \$webvar{type}, \$webvar{address}, $webvar{ttl}, $webvar{location},
898 $webvar{expires}, $webvar{stamp},
899 $webvar{distance}, $webvar{weight}, $webvar{port});
900
901 if ($code eq 'OK' || $code eq 'WARN') {
902 my %pageparams = (page => "reclist", id => $webvar{parentid},
903 defrec => $webvar{defrec}, revrec => $webvar{revrec});
904 $pageparams{warnmsg} = $msg."<br />\n".$DNSDB::resultstr if $code eq 'WARN';
905 $pageparams{resultmsg} = $DNSDB::resultstr if $code eq 'OK';
906 changepage(%pageparams);
907 } else {
908 $page->param(failed => 1);
909 $page->param(errmsg => $msg);
910 $page->param(wastrying => "updating");
911 $page->param(todo => "Update record");
912 $page->param(recact => "update");
913 $page->param(parentid => $webvar{parentid});
914 $page->param(id => $webvar{id});
915 fill_recdata();
916 }
917 }
918
919 if ($webvar{defrec} eq 'y') {
920 $page->param(dohere => "default records in group ".$dnsdb->groupName($webvar{parentid}));
921 } else {
922 $page->param(dohere => $dnsdb->domainName($webvar{parentid})) if $webvar{revrec} eq 'n';
923 $page->param(dohere => $dnsdb->revName($webvar{parentid})) if $webvar{revrec} eq 'y';
924 }
925
926 # Yes, this is a GOTO target. PTBHTTT.
927 DONEREC: ;
928
929} elsif ($webvar{page} eq 'delrec') {
930
931 # This is a complete separate segment since it uses a different template from add/edit records above
932
933 changepage(page => "reclist", errmsg => "You are not permitted to delete records", id => $webvar{parentid},
934 defrec => $webvar{defrec}, revrec => $webvar{revrec})
935 unless ($permissions{admin} || $permissions{record_delete});
936
937 if (!check_scope(id => $webvar{id}, type =>
938 ($webvar{defrec} eq 'y' ? ($webvar{revrec} eq 'y' ? 'defrevrec' : 'defrec') : 'record'))) {
939 # redirect to domlist because we don't have permission for the entity requested
940 changepage(page => 'domlist', revrec => $webvar{revrec},
941 errmsg => "You do not have permission to delete records in the requested ".
942 ($webvar{defrec} eq 'y' ? 'group' : 'domain'));
943 }
944
945 $page->param(id => $webvar{id});
946 $page->param(defrec => $webvar{defrec});
947 $page->param(revrec => $webvar{revrec});
948 $page->param(parentid => $webvar{parentid});
949 # first pass = confirm y/n (sorta)
950 if (!defined($webvar{del})) {
951 $page->param(del_getconf => 1);
952 my $rec = $dnsdb->getRecLine($webvar{defrec}, $webvar{revrec}, $webvar{id});
953 $page->param(host => $rec->{host});
954 $page->param(ftype => $typemap{$rec->{type}});
955 $page->param(recval => $rec->{val});
956 } elsif ($webvar{del} eq 'ok') {
957 my ($code,$msg) = $dnsdb->delRec($webvar{defrec}, $webvar{revrec}, $webvar{id});
958 if ($code eq 'OK') {
959 changepage(page => "reclist", id => $webvar{parentid}, defrec => $webvar{defrec},
960 revrec => $webvar{revrec}, resultmsg => $msg);
961 } else {
962## need to find failure mode
963 changepage(page => "reclist", id => $webvar{parentid}, defrec => $webvar{defrec},
964 revrec => $webvar{revrec}, errmsg => $msg);
965 }
966 } else {
967 changepage(page => "reclist", id => $webvar{parentid}, defrec => $webvar{defrec}, revrec => $webvar{revrec});
968 }
969
970} elsif ($webvar{page} eq 'editsoa') {
971
972 # security check - does the user have permission to view this entity?
973 # id is domain/revzone/group id
974 if (!check_scope(id => $webvar{id}, type =>
975 ($webvar{defrec} eq 'y' ? 'group' : ($webvar{revrec} eq 'y' ? 'revzone' : 'domain')))) {
976 changepage(page => 'domlist', errmsg => "You do not have permission to edit the ".
977 ($webvar{defrec} eq 'y' ? 'default ' : '')."SOA record for the requested ".
978 ($webvar{defrec} eq 'y' ? 'group' : 'domain'));
979 }
980
981 if ($webvar{defrec} eq 'y') {
982 changepage(page => "domlist", errmsg => "You are not permitted to edit default records")
983 unless $permissions{admin};
984 } else {
985 changepage(page => "reclist", errmsg => "You are not permitted to edit domain SOA records", id => $webvar{id})
986 unless ($permissions{admin} || $permissions{domain_edit});
987 }
988
989 fillsoa($webvar{defrec},$webvar{revrec},$webvar{id});
990
991} elsif ($webvar{page} eq 'updatesoa') {
992
993 # security check - does the user have permission to view this entity?
994 # pass 1, record ID
995 if (!check_scope(id => $webvar{recid}, type =>
996 ($webvar{defrec} eq 'y' ? ($webvar{revrec} eq 'y' ? 'defrevrec' : 'defrec') : 'record'))) {
997##fixme: should we redirect to the requested record list page instead of the domain list?
998 changepage(page => 'domlist', errmsg => "You do not have permission to edit the requested SOA record");
999 }
1000 # pass 2, parent (group or domain) ID
1001 if (!check_scope(id => $webvar{id}, type =>
1002 ($webvar{defrec} eq 'y' ? 'group' : ($webvar{revrec} eq 'y' ? 'revzone' : 'domain')))) {
1003 changepage(page => ($webvar{revrec} eq 'y' ? 'revzones' : 'domlist'),
1004 errmsg => "You do not have permission to edit the ".
1005 ($webvar{defrec} eq 'y' ? 'default ' : '')."SOA record for the requested ".
1006 ($webvar{defrec} eq 'y' ? 'group' : ($webvar{revrec} eq 'y' ? 'reverse zone' : 'domain')) );
1007 }
1008
1009 changepage(page => "reclist", errmsg => "You are not permitted to edit domain SOA records", id => $webvar{id})
1010 unless ($permissions{admin} || $permissions{domain_edit});
1011
1012 my ($code, $msg) = $dnsdb->updateSOA($webvar{defrec}, $webvar{revrec},
1013 (contact => $webvar{contact}, prins => $webvar{prins}, refresh => $webvar{refresh},
1014 retry => $webvar{retry}, expire => $webvar{expire}, minttl => $webvar{minttl},
1015 ttl => $webvar{ttl}, id => $webvar{id}) );
1016 if ($code eq 'OK') {
1017 changepage(page => "reclist", id => $webvar{id}, defrec => $webvar{defrec}, revrec => $webvar{revrec},
1018 resultmsg => "SOA record updated");
1019 } else {
1020 $page->param(update_failed => 1);
1021 $page->param(msg => $msg);
1022 fillsoa($webvar{defrec}, $webvar{revrec}, $webvar{id}, 'w');
1023 }
1024
1025} elsif ($webvar{page} eq 'grpman') {
1026
1027 listgroups();
1028
1029# Permissions!
1030 $page->param(addgrp => $permissions{admin} || $permissions{group_create});
1031 $page->param(edgrp => $permissions{admin} || $permissions{group_edit});
1032 $page->param(delgrp => $permissions{admin} || $permissions{group_delete});
1033
1034 show_msgs();
1035 $page->param(curpage => $webvar{page});
1036
1037} elsif ($webvar{page} eq 'newgrp') {
1038
1039 changepage(page => "grpman", errmsg => "You are not permitted to add groups")
1040 unless ($permissions{admin} || $permissions{group_create});
1041
1042 # do.. uhh.. stuff.. if we have no webvar{grpaction}
1043 if ($webvar{grpaction} && $webvar{grpaction} eq 'add') {
1044
1045 # security check - does the user have permission to access this entity?
1046 if (!check_scope(id => $webvar{pargroup}, type => 'group')) {
1047 changepage(page => "grpman", errmsg => "You are not permitted to add a group to the requested parent group");
1048 }
1049
1050 my %newperms;
1051 my $alterperms = 0;
1052 foreach (@permtypes) {
1053 $newperms{$_} = 0;
1054 if ($permissions{admin} || $permissions{$_}) {
1055 $newperms{$_} = (defined($webvar{$_}) && $webvar{$_} eq 'on' ? 1 : 0);
1056 } else {
1057 $alterperms = 1;
1058 }
1059 }
1060 # "Chained" permissions. Some permissions imply others; make sure they get set.
1061 foreach (keys %permchains) {
1062 if ($newperms{$_} && !$newperms{$permchains{$_}}) {
1063 $newperms{$permchains{$_}} = 1;
1064 }
1065 }
1066 # force inheritance of parent group's default records with inherit flag,
1067 # otherwise we end up with the hardcoded defaults from DNSDB.pm. See
1068 # https://secure.deepnet.cx/trac/dnsadmin/ticket/8 for the UI enhancement
1069 # that will make this variable.
1070 my ($code,$msg) = $dnsdb->addGroup($webvar{newgroup}, $webvar{pargroup}, \%newperms, 1);
1071 if ($code eq 'OK') {
1072 if ($alterperms) {
1073 changepage(page => "grpman", warnmsg =>
1074 "You can only grant permissions you hold. New group $webvar{newgroup} added with reduced access.");
1075 } else {
1076 changepage(page => "grpman", resultmsg => "Added group $webvar{newgroup}");
1077 }
1078 } # fallthrough else
1079 # no point in doing extra work
1080 fill_permissions($page, \%newperms);
1081 $page->param(add_failed => 1);
1082 $page->param(errmsg => $msg);
1083 $page->param(newgroup => $webvar{newgroup});
1084 fill_grouplist('pargroup',$webvar{pargroup});
1085 } else {
1086 fill_grouplist('pargroup',$curgroup);
1087 # fill default permissions with immediate parent's current ones
1088 my %parperms;
1089 $dnsdb->getPermissions('group', $curgroup, \%parperms);
1090 fill_permissions($page, \%parperms);
1091 }
1092
1093} elsif ($webvar{page} eq 'delgrp') {
1094
1095 changepage(page => "grpman", errmsg => "You are not permitted to delete groups", id => $webvar{parentid})
1096 unless ($permissions{admin} || $permissions{group_delete});
1097
1098 # security check - does the user have permission to access this entity?
1099 if (!check_scope(id => $webvar{id}, type => 'group')) {
1100 changepage(page => "grpman", errmsg => "You are not permitted to delete the requested group");
1101 }
1102
1103 $page->param(id => $webvar{id});
1104 # first pass = confirm y/n (sorta)
1105 if (!defined($webvar{del})) {
1106 $page->param(del_getconf => 1);
1107
1108##fixme
1109# do a check for "group has stuff in it", and splatter a big warning
1110# up along with an unchecked-by-default check box to YES DAMMIT DELETE THE WHOLE THING
1111
1112 } elsif ($webvar{del} eq 'ok') {
1113 my ($code,$msg) = $dnsdb->delGroup($webvar{id});
1114 if ($code eq 'OK') {
1115##fixme: need to clean up log when deleting a major container
1116 changepage(page => "grpman", resultmsg => $msg);
1117 } else {
1118# need to find failure mode
1119 changepage(page => "grpman", errmsg => $msg);
1120 }
1121 } else {
1122 # cancelled. whee!
1123 changepage(page => "grpman");
1124 }
1125 $page->param(delgroupname => $dnsdb->groupName($webvar{id}));
1126
1127} elsif ($webvar{page} eq 'edgroup') {
1128
1129 changepage(page => "grpman", errmsg => "You are not permitted to edit groups")
1130 unless ($permissions{admin} || $permissions{group_edit});
1131
1132 # security check - does the user have permission to access this entity?
1133 if (!check_scope(id => $webvar{gid}, type => 'group')) {
1134 changepage(page => "grpman", errmsg => "You are not permitted to edit the requested group");
1135 }
1136
1137 if ($webvar{grpaction} && $webvar{grpaction} eq 'updperms') {
1138 # extra safety check; make sure user can't construct a URL to bypass ACLs
1139 my %curperms;
1140 $dnsdb->getPermissions('group', $webvar{gid}, \%curperms);
1141 my %chperms;
1142 my $alterperms = 0;
1143 foreach (@permtypes) {
1144 $webvar{$_} = 0 if !defined($webvar{$_});
1145 $webvar{$_} = 1 if $webvar{$_} eq 'on';
1146 if ($permissions{admin} || $permissions{$_}) {
1147 $chperms{$_} = $webvar{$_} if $curperms{$_} ne $webvar{$_};
1148 } else {
1149 $alterperms = 1;
1150 $chperms{$_} = 0;
1151 }
1152 }
1153 # "Chained" permissions. Some permissions imply others; make sure they get set.
1154 foreach (keys %permchains) {
1155 if ($chperms{$_} && !$chperms{$permchains{$_}}) {
1156 $chperms{$permchains{$_}} = 1;
1157 }
1158 }
1159 my ($code,$msg) = $dnsdb->changePermissions('group', $webvar{gid}, \%chperms);
1160 if ($code eq 'OK') {
1161 if ($alterperms) {
1162 changepage(page => "grpman", warnmsg =>
1163 "You can only grant permissions you hold. Default permissions in group ".
1164 $dnsdb->groupName($webvar{gid})." updated with reduced access");
1165 } else {
1166 changepage(page => "grpman", resultmsg => $msg);
1167 }
1168 } # fallthrough else
1169 # no point in doing extra work
1170 fill_permissions($page, \%chperms);
1171 $page->param(errmsg => $msg);
1172 }
1173 $page->param(gid => $webvar{gid});
1174 $page->param(grpmeddle => $dnsdb->groupName($webvar{gid}));
1175 my %grpperms;
1176 $dnsdb->getPermissions('group', $webvar{gid}, \%grpperms);
1177 fill_permissions($page, \%grpperms);
1178
1179} elsif ($webvar{page} eq 'bulkdomain' || $webvar{page} eq 'bulkrev') {
1180 # Bulk operations on domains. Note all but group move are available on the domain list.
1181
1182 changepage(page => "domlist", errmsg => "You are not permitted to make bulk zone changes")
1183 unless ($permissions{admin} || $permissions{domain_edit} || $permissions{domain_create} || $permissions{domain_delete});
1184
1185 fill_grouplist("grouplist");
1186
1187 $page->param(fwdzone => $webvar{page} eq 'bulkdomain');
1188
1189 my $count = $dnsdb->getZoneCount(revrec => ($webvar{page} eq 'bulkdomain' ? 'n' : 'y'),
1190 curgroup => $curgroup);
1191
1192 $page->param(curpage => $webvar{page});
1193 fill_pgcount($count, 'domains', $dnsdb->groupName($curgroup));
1194 fill_fpnla($count);
1195 $page->param(perpage => $perpage);
1196
1197 my $domlist = $dnsdb->getZoneList(revrec => ($webvar{page} eq 'bulkdomain' ? 'n' : 'y'),
1198 curgroup => $curgroup, offset => $offset);
1199 my $rownum = 0;
1200 foreach my $dom (@{$domlist}) {
1201 delete $dom->{status};
1202 delete $dom->{group};
1203 $dom->{newrow} = (++$rownum) % 5 == 0 && $rownum != $perpage;
1204 }
1205
1206 $page->param(domtable => $domlist);
1207 # ACLs
1208 $page->param(maymove => ($permissions{admin} || ($permissions{domain_edit} && $permissions{domain_create} && $permissions{domain_delete})));
1209 $page->param(maystatus => $permissions{admin} || $permissions{domain_edit});
1210 $page->param(maydelete => $permissions{admin} || $permissions{domain_delete});
1211
1212#} elsif ($webvar{page} eq 'confirmbulkdom' || $webvar{page} eq 'confirmbulkrev') {
1213} elsif ($webvar{page} eq 'confirmbulk') {
1214
1215 changepage(page => "domlist", errmsg => "You are not permitted to make bulk zone changes")
1216 unless ($permissions{admin} || $permissions{domain_edit} || $permissions{domain_create} || $permissions{domain_delete});
1217
1218 $page->param(bulkaction => $webvar{bulkaction});
1219 $page->param(destgroup => $webvar{destgroup});
1220 my @zlist;
1221 my $rownum = 0;
1222
1223##fixme: this could probably be made more efficient, since this looks up 2 zone names for
1224# each comparison during sort rather than slurping them in bulk once before doing the sort
1225 # sort zones by zone name, not ID
1226 sub zsort {
1227 my $tmpa = ($a =~ /^dom/ ? $dnsdb->domainName($webvar{$a}) : $dnsdb->revName($webvar{$a}) );
1228 my $tmpb = ($b =~ /^dom/ ? $dnsdb->domainName($webvar{$b}) : $dnsdb->revName($webvar{$b}) );
1229 return $tmpa cmp $tmpb;
1230 }
1231 # eugh. can't see a handy way to sort this mess by zone name the way it is on the submitting page. :(
1232 foreach my $input (sort zsort grep(/^(?:dom|rev)_/, keys %webvar) ) {
1233 next unless $input =~ /^(dom|rev)_\d+$/;
1234 my $fr = $1;
1235 my %row = (zoneid => $webvar{$input},
1236 zone => ($fr eq 'dom' ? $dnsdb->domainName($webvar{$input}) : $dnsdb->revName($webvar{$input}) ),
1237 zvarname => $input,
1238 newrow => ( (++$rownum) % 5 == 0 && $rownum != $perpage),
1239 );
1240 push @zlist, \%row;
1241 }
1242 $page->param(domtable => \@zlist);
1243
1244} elsif ($webvar{page} eq 'bulkchange') {
1245
1246 # security check - does the user have permission to access this entity?
1247 if (!check_scope(id => $webvar{destgroup}, type => 'group')) {
1248 $page->param(errmsg => "You are not permitted to make bulk changes in the requested group");
1249 goto DONEBULK;
1250 }
1251
1252 # skip the changes if user did not confirm
1253 my $wasrev = grep /^rev_/, keys %webvar;
1254 changepage(page => ($wasrev ? "bulkrev" : "bulkdomain")) unless $webvar{okdel} eq 'y';
1255
1256 changepage(page => "domlist", errmsg => "You are not permitted to make bulk zone changes")
1257 unless ($permissions{admin} || $permissions{domain_edit} || $permissions{domain_create} || $permissions{domain_delete});
1258
1259 # per-action scope checks
1260 if ($webvar{bulkaction} eq 'move') {
1261 changepage(page => "domlist", errmsg => "You are not permitted to bulk-move zones")
1262 unless ($permissions{admin} || ($permissions{domain_edit} && $permissions{domain_create} && $permissions{domain_delete}));
1263 my $newgname = $dnsdb->groupName($webvar{destgroup});
1264 $page->param(action => "Move to group $newgname");
1265 } elsif ($webvar{bulkaction} eq 'deactivate' || $webvar{bulkaction} eq 'activate') {
1266 changepage(page => "domlist", errmsg => "You are not permitted to bulk-$webvar{bulkaction} zones")
1267 unless ($permissions{admin} || $permissions{domain_edit});
1268 $page->param(action => "$webvar{bulkaction} zones");
1269 } elsif ($webvar{bulkaction} eq 'delete') {
1270 changepage(page => "domlist", errmsg => "You are not permitted to bulk-delete zones")
1271 unless ($permissions{admin} || $permissions{domain_delete});
1272 $page->param(action => "$webvar{bulkaction} zones");
1273 } else {
1274 # unknown action, bypass actually doing anything. it should not be possible in
1275 # normal operations, and anyone who meddles with the URL gets what they deserve.
1276 goto DONEBULK;
1277 } # move/(de)activate/delete if()
1278
1279 my @bulkresults;
1280 # nngh. due to alpha-sorting on the previous page, we can't use domid-numeric
1281 # order here, and since we don't have the domain names until we go around this
1282 # loop, we can't alpha-sort them here. :(
1283 foreach my $input (keys %webvar) {
1284 my %row;
1285 next unless $input =~ /^(dom|rev)_\d+$/;
1286 my $fr = $1;
1287 # second security check - does the user have permission to meddle with this domain?
1288 if (!check_scope(id => $webvar{$input}, type => ($fr eq 'dom' ? 'domain' : 'revzone'))) {
1289 $row{domerr} = "You are not permitted to make changes to the requested zone";
1290 $row{domain} = $webvar{$input};
1291 push @bulkresults, \%row;
1292 next;
1293 }
1294 $row{domain} = ($fr eq 'dom' ? $dnsdb->domainName($webvar{$input}) : $dnsdb->revName($webvar{$input}));
1295
1296 # Do the $webvar{bulkaction}
1297 my ($code, $msg);
1298 ($code, $msg) = $dnsdb->changeGroup(($fr eq 'dom' ? 'domain' : 'revzone'), $webvar{$input}, $webvar{destgroup})
1299 if $webvar{bulkaction} eq 'move';
1300 if ($webvar{bulkaction} eq 'deactivate' || $webvar{bulkaction} eq 'activate') {
1301 my $stat = $dnsdb->zoneStatus($webvar{$input}, ($fr eq 'dom' ? 'n' : 'y'),
1302 ($webvar{bulkaction} eq 'activate' ? 'domon' : 'domoff'));
1303 $code = (defined($stat) ? 'OK' : 'FAIL');
1304 $msg = (defined($stat) ? $DNSDB::resultstr : $DNSDB::errstr);
1305 }
1306 ($code, $msg) = $dnsdb->delZone($webvar{$input}, ($fr eq 'dom' ? 'n' : 'y'))
1307 if $webvar{bulkaction} eq 'delete';
1308
1309 # Set the result output from the action
1310 if ($code eq 'OK') {
1311 $row{domok} = $msg;
1312 } elsif ($code eq 'WARN') {
1313 $row{domwarn} = $msg;
1314 } else {
1315 $row{domerr} = $msg;
1316 }
1317 push @bulkresults, \%row;
1318
1319 } # foreach (keys %webvar)
1320 $page->param(bulkresults => \@bulkresults);
1321
1322 # Yes, this is a GOTO target. PTHBTTT.
1323 DONEBULK: ;
1324
1325} elsif ($webvar{page} eq 'useradmin') {
1326
1327 if (defined($webvar{userstatus})) {
1328 # security check - does the user have permission to access this entity?
1329 my $flag = 0;
1330 foreach (@viewablegroups) {
1331 $flag = 1 if $dnsdb->isParent($_, 'group', $webvar{id}, 'user');
1332 }
1333 if ($flag && ($permissions{admin} || $permissions{user_edit} ||
1334 ($permissions{self_edit} && $webvar{id} == $session->param('uid')) )) {
1335 my $stat = $dnsdb->userStatus($webvar{id}, $webvar{userstatus});
1336 # kick user out if user disabled self
1337 # arguably there should be a more specific error message for this case
1338 changepage(page=> 'login', sessexpired => 1) if $webvar{id} == $session->param('uid');
1339 $page->param(resultmsg => $DNSDB::resultstr);
1340 } else {
1341 $page->param(errmsg => "You are not permitted to view or change the requested user");
1342 }
1343 $uri_self =~ s/\&amp;userstatus=[^&]*//g; # clean up URL for stuffing into templates
1344 }
1345
1346 list_users();
1347
1348# Permissions!
1349 $page->param(adduser => $permissions{admin} || $permissions{user_create});
1350# should we block viewing other users? Vega blocks "editing"...
1351# NB: no "edit self" link as with groups here. maybe there should be?
1352# $page->param(eduser => $permissions{admin} || $permissions{user_edit});
1353 $page->param(deluser => $permissions{admin} || $permissions{user_delete});
1354
1355 show_msgs();
1356 $page->param(curpage => $webvar{page});
1357
1358} elsif ($webvar{page} eq 'user') {
1359
1360 # All user add/edit actions fall through the same page, since there aren't
1361 # really any hard differences between the templates
1362
1363 #fill_actypelist($webvar{accttype});
1364 fill_clonemelist();
1365 my %grpperms;
1366 $dnsdb->getPermissions('group', $curgroup, \%grpperms);
1367
1368 my $grppermlist = new HTML::Template(filename => "$templatedir/permlist.tmpl");
1369 my %noaccess;
1370 fill_permissions($grppermlist, \%grpperms, \%noaccess);
1371 $grppermlist->param(info => 1);
1372 $page->param(grpperms => $grppermlist->output);
1373
1374 $page->param(is_admin => $permissions{admin});
1375
1376 $webvar{useraction} = '' if !$webvar{useraction};
1377
1378 if ($webvar{useraction} eq 'add' or $webvar{useraction} eq 'update') {
1379
1380 $page->param(add => 1) if $webvar{useraction} eq 'add';
1381
1382 # can't re-use $code and $msg for update if we want to be able to identify separate failure states
1383 my ($code,$code2,$msg,$msg2) = ('OK','OK','OK','OK');
1384
1385 my $alterperms = 0; # flag iff we need to force custom permissions due to user's current access limits
1386
1387 my %newperms; # we're going to prefill the existing permissions, so we can change them.
1388 $dnsdb->getPermissions('user', $webvar{uid}, \%newperms);
1389
1390 if ($webvar{pass1} ne $webvar{pass2}) {
1391 $code = 'FAIL';
1392 $msg = "Passwords don't match";
1393 } else {
1394
1395 my $permstring = 'i'; # start with "inherit"
1396
1397 # Remap passed checkbox states from webvar to integer/boolean values in %newperms
1398 foreach (@permtypes) {
1399 $newperms{$_} = (defined($webvar{$_}) && $webvar{$_} eq 'on' ? 1 : 0);
1400 }
1401
1402 # Check for chained permissions. Some permissions imply others; make sure they get set.
1403 foreach (keys %permchains) {
1404 if ($newperms{$_} && !$newperms{$permchains{$_}}) {
1405 $newperms{$permchains{$_}} = 1;
1406 }
1407 }
1408
1409 # check for possible priviledge escalations
1410 if (!$permissions{admin}) {
1411 if ($webvar{perms_type} eq 'inherit') {
1412 # Group permissions are only relevant if inheriting
1413 my %grpperms;
1414 $dnsdb->getPermissions('group', $curgroup, \%grpperms);
1415 my $ret = $dnsdb->comparePermissions(\%permissions, \%grpperms);
1416 if ($ret eq '<' || $ret eq '!') {
1417 # User's permissions are not a superset or equivalent to group. Can't inherit
1418 # (and include access user doesn't currently have), so we force custom.
1419 $webvar{perms_type} = 'custom';
1420 $alterperms = 1;
1421 }
1422 }
1423 my $ret = $dnsdb->comparePermissions(\%newperms, \%permissions);
1424 if ($ret eq '>' || $ret eq '!') {
1425 # User's new permissions are not a subset or equivalent to previous. Can't add
1426 # permissions user doesn't currently have, so we force custom.
1427 $webvar{perms_type} = 'custom';
1428 $alterperms = 1;
1429 }
1430 }
1431
1432##fixme:
1433# could possibly factor building the meat of the permstring out of this if/elsif set, so
1434# as to avoid running around @permtypes quite so many times
1435 if ($webvar{perms_type} eq 'custom') {
1436 $permstring = 'C:';
1437 foreach (@permtypes) {
1438 if ($permissions{admin} || $permissions{$_}) {
1439 $permstring .= ",$_" if defined($webvar{$_}) && $webvar{$_} eq 'on';
1440 } else {
1441 $newperms{$_} = 0; # remove permissions user doesn't currently have
1442 }
1443 }
1444 $page->param(perm_custom => 1);
1445 } elsif ($permissions{admin} && $webvar{perms_type} eq 'clone') {
1446 $permstring = "c:$webvar{clonesrc}";
1447 $dnsdb->getPermissions('user', $webvar{clonesrc}, \%newperms);
1448 $page->param(perm_clone => 1);
1449 }
1450 # Recheck chained permissions, in the supposedly impossible case that the removals
1451 # above mangled one of them. This *should* be impossible via normal web UI operations.
1452 foreach (keys %permchains) {
1453 if ($newperms{$_} && !$newperms{$permchains{$_}}) {
1454 $newperms{$permchains{$_}} = 1;
1455 $permstring .= ",$permchains{$_}";
1456 }
1457 }
1458 if ($webvar{useraction} eq 'add') {
1459 changepage(page => "useradmin", errmsg => "You do not have permission to add new users")
1460 unless $permissions{admin} || $permissions{user_create};
1461 # no scope check; user is created in the current group
1462 ($code,$msg) = $dnsdb->addUser($webvar{uname}, $curgroup, $webvar{pass1},
1463 ($webvar{makeactive} eq 'on' ? 1 : 0), $webvar{accttype}, $permstring,
1464 $webvar{fname}, $webvar{lname}, $webvar{phone});
1465 } else {
1466 changepage(page => "useradmin", errmsg => "You do not have permission to edit users")
1467 unless $permissions{admin} || $permissions{user_edit} ||
1468 ($permissions{self_edit} && $session->param('uid') == $webvar{uid});
1469 # security check - does the user have permission to access this entity?
1470 if (!check_scope(id => $webvar{user}, type => 'user')) {
1471 changepage(page => "useradmin", errmsg => "You do not have permission to edit the requested user");
1472 }
1473# User update is icky. I'd really like to do this in one atomic operation,
1474# but that gets hairy by either duplicating a **lot** of code in DNSDB.pm
1475# or self-torture trying to not commit the transaction until we're really done.
1476 # Allowing for changing group, but not coding web support just yet.
1477 ($code,$msg) = $dnsdb->updateUser($webvar{uid}, $webvar{uname}, $webvar{gid}, $webvar{pass1},
1478 ($webvar{makeactive} eq 'on' ? 1 : 0), $webvar{accttype},
1479 $webvar{fname}, $webvar{lname}, $webvar{phone});
1480 if ($code eq 'OK') {
1481 $newperms{admin} = 1 if $permissions{admin} && $webvar{accttype} eq 'S';
1482 ($code2,$msg2) = $dnsdb->changePermissions('user', $webvar{uid}, \%newperms, ($permstring eq 'i'));
1483 }
1484 }
1485 }
1486
1487 if ($code eq 'OK' && $code2 eq 'OK') {
1488 my %pageparams = (page => "useradmin");
1489 if ($alterperms) {
1490 $pageparams{warnmsg} = "You can only grant permissions you hold.\nUser ".
1491 ($webvar{useraction} eq 'add' ? "$webvar{uname} added" : "info updated for $webvar{uname}").
1492 ".\nPermissions ".($webvar{useraction} eq 'add' ? 'added' : 'updated')." with reduced access.";
1493 } else {
1494 $pageparams{resultmsg} = "$msg".($webvar{useraction} eq 'add' ? '' : "\n$msg2");
1495 }
1496 changepage(%pageparams);
1497
1498 # add/update failed:
1499 } else {
1500 $page->param(add_failed => 1);
1501 $page->param(action => $webvar{useraction});
1502 $page->param(set_permgroup => 1);
1503 if ($webvar{perms_type} eq 'inherit') { # set permission class radio
1504 $page->param(perm_inherit => 1);
1505 } elsif ($webvar{perms_type} eq 'clone') {
1506 $page->param(perm_clone => 1);
1507 } else {
1508 $page->param(perm_custom => 1);
1509 }
1510 $page->param(uname => $webvar{uname});
1511 $page->param(fname => $webvar{fname});
1512 $page->param(lname => $webvar{lname});
1513 $page->param(pass1 => $webvar{pass1});
1514 $page->param(pass2 => $webvar{pass2});
1515 $page->param(errmsg => "User info updated but permissions update failed: $msg2") if $code eq 'OK';
1516 $page->param(errmsg => $msg) if $code ne 'OK';
1517 fill_permissions($page, \%newperms);
1518 fill_actypelist($webvar{accttype});
1519 fill_clonemelist();
1520 }
1521
1522 } elsif ($webvar{useraction} eq 'edit') {
1523
1524 changepage(page => "useradmin", errmsg => "You do not have permission to edit users")
1525 unless $permissions{admin} || $permissions{user_edit} ||
1526 ($permissions{self_edit} && $session->param('uid') == $webvar{user});
1527
1528 # security check - does the user have permission to access this entity?
1529 if (!check_scope(id => $webvar{user}, type => 'user')) {
1530 changepage(page => "useradmin", errmsg => "You do not have permission to edit the requested user");
1531 }
1532
1533 $page->param(set_permgroup => 1);
1534 $page->param(action => 'update');
1535 $page->param(uid => $webvar{user});
1536 fill_clonemelist();
1537
1538 my $userinfo = $dnsdb->getUserData($webvar{user});
1539 fill_actypelist($userinfo->{type});
1540 # not using this yet, but adding it now means we can *much* more easily do so later.
1541 $page->param(gid => $userinfo->{group_id});
1542
1543 my %curperms;
1544 $dnsdb->getPermissions('user', $webvar{user}, \%curperms);
1545 fill_permissions($page, \%curperms);
1546
1547 $page->param(uname => $userinfo->{username});
1548 $page->param(fname => $userinfo->{firstname});
1549 $page->param(lname => $userinfo->{lastname});
1550 $page->param(set_permgroup => 1);
1551 if ($userinfo->{inherit_perm}) {
1552 $page->param(perm_inherit => 1);
1553 } else {
1554 $page->param(perm_custom => 1);
1555 }
1556 } else {
1557 changepage(page => "useradmin", errmsg => "You are not allowed to add new users")
1558 unless $permissions{admin} || $permissions{user_create};
1559 # default is "new"
1560 $page->param(add => 1);
1561 $page->param(action => 'add');
1562 fill_permissions($page, \%grpperms);
1563 fill_actypelist();
1564 }
1565
1566} elsif ($webvar{page} eq 'deluser') {
1567
1568 changepage(page=> "useradmin", errmsg => "You are not allowed to delete users")
1569 unless $permissions{admin} || $permissions{user_delete};
1570
1571 # security check - does the user have permission to access this entity?
1572 if (!check_scope(id => $webvar{id}, type => 'user')) {
1573 changepage(page => "useradmin", errmsg => "You are not permitted to delete the requested user");
1574 }
1575
1576 $page->param(id => $webvar{id});
1577 # first pass = confirm y/n (sorta)
1578 if (!defined($webvar{del})) {
1579 $page->param(del_getconf => 1);
1580 $page->param(user => $dnsdb->userFullName($webvar{id}));
1581 } elsif ($webvar{del} eq 'ok') {
1582 my ($code,$msg) = $dnsdb->delUser($webvar{id});
1583 if ($code eq 'OK') {
1584 # success. go back to the user list, do not pass "GO"
1585 changepage(page => "useradmin", resultmsg => $msg);
1586 } else {
1587 changepage(page => "useradmin", errmsg => $msg);
1588 }
1589 } else {
1590 # cancelled. whee!
1591 changepage(page => "useradmin");
1592 }
1593
1594} elsif ($webvar{page} eq 'loclist') {
1595
1596 changepage(page => "domlist", errmsg => "You are not allowed access to this function")
1597 unless $permissions{admin} || $permissions{location_view};
1598
1599 # security check - does the user have permission to access this entity?
1600# if (!check_scope(id => $webvar{id}, type => 'loc')) {
1601# changepage(page => "loclist", errmsg => "You are not permitted to <foo> the requested location/view");
1602# }
1603 list_locations();
1604 show_msgs();
1605
1606# Permissions!
1607 $page->param(addloc => $permissions{admin} || $permissions{location_create});
1608 $page->param(delloc => $permissions{admin} || $permissions{location_delete});
1609
1610} elsif ($webvar{page} eq 'location') {
1611
1612 changepage(page => "domlist", errmsg => "You are not allowed access to this function")
1613 unless $permissions{admin} || $permissions{location_view};
1614
1615 # security check - does the user have permission to access this entity?
1616# if (!check_scope(id => $webvar{id}, type => 'loc')) {
1617# changepage(page => "loclist", errmsg => "You are not permitted to <foo> the requested location/view");
1618# }
1619
1620 $webvar{locact} = '' if !$webvar{locact};
1621
1622 if ($webvar{locact} eq 'add') {
1623 changepage(page => "loclist", errmsg => "You are not permitted to add locations/views", id => $webvar{parentid})
1624 unless ($permissions{admin} || $permissions{location_create});
1625
1626 my ($code,$msg) = $dnsdb->addLoc(group => $curgroup, desc => $webvar{locname},
1627 comments => $webvar{comments}, iplist => $webvar{iplist});
1628
1629 if ($code eq 'OK' || $code eq 'WARN') {
1630 my %pageparams = (page => "loclist", id => $webvar{parentid},
1631 defrec => $webvar{defrec}, revrec => $webvar{revrec});
1632 $pageparams{warnmsg} = $msg."<br />\n".$DNSDB::resultstr if $code eq 'WARN';
1633 $pageparams{resultmsg} = $DNSDB::resultstr if $code eq 'OK';
1634 changepage(%pageparams);
1635 } else {
1636 $page->param(failed => 1);
1637 $page->param(errmsg => $msg);
1638 $page->param(wastrying => "adding");
1639 $page->param(todo => "Add location/view");
1640 $page->param(locact => "add");
1641 $page->param(id => $webvar{id});
1642 $page->param(locname => $webvar{locname});
1643 $page->param(comments => $webvar{comments});
1644 $page->param(iplist => $webvar{iplist});
1645 }
1646
1647 } elsif ($webvar{locact} eq 'edit') {
1648 changepage(page => "loclist", errmsg => "You are not permitted to edit locations/views", id => $webvar{parentid})
1649 unless ($permissions{admin} || $permissions{location_edit});
1650
1651 my $loc = $dnsdb->getLoc($webvar{loc});
1652 $page->param(wastrying => "editing");
1653 $page->param(todo => "Edit location/view");
1654 $page->param(locact => "update");
1655 $page->param(id => $webvar{loc});
1656 $page->param(locname => $loc->{description});
1657 $page->param(comments => $loc->{comments});
1658 $page->param(iplist => $loc->{iplist});
1659
1660 } elsif ($webvar{locact} eq 'update') {
1661 changepage(page => "loclist", errmsg => "You are not permitted to edit locations/views", id => $webvar{parentid})
1662 unless ($permissions{admin} || $permissions{location_edit});
1663
1664 my ($code,$msg) = $dnsdb->updateLoc($webvar{id}, $curgroup, $webvar{locname}, $webvar{comments}, $webvar{iplist});
1665
1666 if ($code eq 'OK') {
1667 changepage(page => "loclist", resultmsg => $msg);
1668 } else {
1669 $page->param(failed => 1);
1670 $page->param(errmsg => $msg);
1671 $page->param(wastrying => "editing");
1672 $page->param(todo => "Edit location/view");
1673 $page->param(locact => "update");
1674 $page->param(id => $webvar{loc});
1675 $page->param(locname => $webvar{locname});
1676 $page->param(comments => $webvar{comments});
1677 $page->param(iplist => $webvar{iplist});
1678 }
1679 } else {
1680 changepage(page => "loclist", errmsg => "You are not permitted to add locations/views", id => $webvar{parentid})
1681 unless ($permissions{admin} || $permissions{location_create});
1682
1683 $page->param(todo => "Add location/view");
1684 $page->param(locact => "add");
1685 $page->param(locname => ($webvar{locname} ? $webvar{locname} : ''));
1686 $page->param(iplist => ($webvar{iplist} ? $webvar{iplist} : ''));
1687
1688 show_msgs();
1689 }
1690
1691} elsif ($webvar{page} eq 'delloc') {
1692
1693 changepage(page=> "loclist", errmsg => "You are not allowed to delete locations")
1694 unless $permissions{admin} || $permissions{location_delete};
1695
1696 # security check - does the user have permission to access this entity?
1697# if (!check_scope(id => $webvar{id}, type => 'loc')) {
1698# changepage(page => "loclist", errmsg => "You are not permitted to <foo> the requested location/view");
1699# }
1700
1701 $page->param(locid => $webvar{locid});
1702 my $locdata = $dnsdb->getLoc($webvar{locid});
1703 $locdata->{description} = $webvar{locid} if !$locdata->{description};
1704 # first pass = confirm y/n (sorta)
1705 if (!defined($webvar{del})) {
1706 $page->param(del_getconf => 1);
1707 $page->param(location => $locdata->{description});
1708 } elsif ($webvar{del} eq 'ok') {
1709 my ($code,$msg) = $dnsdb->delLoc($webvar{locid});
1710 if ($code eq 'OK') {
1711 # success. go back to the user list, do not pass "GO"
1712 changepage(page => "loclist", resultmsg => $msg);
1713 } else {
1714 changepage(page => "loclist", errmsg => $msg);
1715 }
1716 } else {
1717 # cancelled. whee!
1718 changepage(page => "loclist");
1719 }
1720
1721} elsif ($webvar{page} eq 'dnsq') {
1722
1723 if ($webvar{qfor}) {
1724 $webvar{qfor} =~ s/^\s*//;
1725 $webvar{qfor} =~ s/\s*$//;
1726 $page->param(qfor => $webvar{qfor});
1727 }
1728 if ($webvar{resolver}) {
1729 $webvar{resolver} =~ s/^\s*//;
1730 $webvar{resolver} =~ s/\s*$//;
1731 $page->param(resolver => $webvar{resolver});
1732 }
1733 $page->param(typelist => $dnsdb->getTypelist('l', ($webvar{type} ? $webvar{type} : undef)));
1734 $page->param(nrecurse => $webvar{nrecurse}) if $webvar{nrecurse};
1735
1736 if ($webvar{qfor}) {
1737 my $resolv = Net::DNS::Resolver->new;
1738 $resolv->tcp_timeout(5); # make me adjustable!
1739 $resolv->udp_timeout(5); # make me adjustable!
1740 $resolv->recurse(0) if $webvar{nrecurse};
1741 $resolv->nameservers($webvar{resolver}) if $webvar{resolver};
1742 my $query = $resolv->query($webvar{qfor}, $typemap{$webvar{type}});
1743 if ($query) {
1744
1745 $page->param(showresults => 1);
1746
1747 my @answer;
1748 foreach my $rr ($query->answer) {
1749# next unless $rr->type eq "A" or $rr->type eq 'NS';
1750 my %row;
1751 my ($host,$ttl,$class,$type,$data) =
1752 ($rr->string =~ /^([0-9a-zA-Z_.-]+)\s+(\d+)\s+([A-Za-z]+)\s+([A-Za-z]+)\s+(.+)$/s);
1753 $row{host} = $host;
1754 $row{ftype} = $type;
1755 $row{rdata} = ($type eq 'SOA' ? "<pre>$data</pre>" : $data);
1756 push @answer, \%row;
1757 }
1758 $page->param(answer => \@answer);
1759
1760 my @additional;
1761 foreach my $rr ($query->additional) {
1762# next unless $rr->type eq "A" or $rr->type eq 'NS';
1763 my %row;
1764 my ($host,$ttl,$class,$type,$data) =
1765 ($rr->string =~ /^([0-9a-zA-Z_.-]+)\s+(\d+)\s+([A-Za-z]+)\s+([A-Za-z]+)\s+(.+)$/);
1766 $row{host} = $host;
1767 $row{ftype} = $type;
1768 $row{rdata} = $data;
1769 push @additional, \%row;
1770 }
1771 $page->param(additional => \@additional);
1772
1773 my @authority;
1774 foreach my $rr ($query->authority) {
1775# next unless $rr->type eq "A" or $rr->type eq 'NS';
1776 my %row;
1777 my ($host,$ttl,$class,$type,$data) =
1778 ($rr->string =~ /^([0-9a-zA-Z_.-]+)\s+(\d+)\s+([A-Za-z]+)\s+([A-Za-z]+)\s+(.+)$/);
1779 $row{host} = $host;
1780 $row{ftype} = $type;
1781 $row{rdata} = $data;
1782 push @authority, \%row;
1783 }
1784 $page->param(authority => \@authority);
1785
1786 $page->param(usedresolver => $resolv->answerfrom);
1787 $page->param(frtype => $typemap{$webvar{type}});
1788
1789 } else {
1790 $page->param(errmsg => $resolv->errorstring);
1791 }
1792 }
1793 ## done DNS query
1794
1795} elsif ($webvar{page} eq 'axfr') {
1796
1797 changepage(page => "domlist", errmsg => "You are not permitted to import domains")
1798 unless ($permissions{admin} || $permissions{domain_create});
1799
1800 # don't need this while we've got the dropdown in the menu. hmm.
1801 fill_grouplist("grouplist");
1802
1803 $page->param(ifrom => $webvar{ifrom}) if $webvar{ifrom};
1804 $page->param(rwsoa => $webvar{rwsoa}) if $webvar{rwsoa};
1805 $page->param(rwns => $webvar{rwns}) if $webvar{rwns};
1806 $page->param(forcettl => $webvar{forcettl}) if $webvar{forcettl};
1807 $page->param(newttl => $webvar{newttl}) if $webvar{newttl};
1808 # This next one is arguably better on by default, but Breaking Things Is Bad, Mmmkay?
1809 $page->param(mergematching => $webvar{mergematching}) if $webvar{mergematching};
1810 $page->param(dominactive => 1) if (!$webvar{domactive} && $webvar{doit}); # eww.
1811 $page->param(importdoms => $webvar{importdoms}) if $webvar{importdoms};
1812
1813 # shut up warning about uninitialized variable
1814 $webvar{doit} = '' if !defined($webvar{doit});
1815
1816 if ($webvar{doit} eq 'y' && !$webvar{ifrom}) {
1817 $page->param(errmsg => "Need to set host to import from");
1818 } elsif ($webvar{doit} eq 'y' && !$webvar{importdoms}) {
1819 $page->param(errmsg => "Need domains to import");
1820 } elsif ($webvar{doit} eq 'y') {
1821
1822 # security check - does the user have permission to access this entity?
1823 if (!check_scope(id => $webvar{group}, type => 'group')) {
1824 $page->param(errmsg => "You are not permitted to import domains into the requested group");
1825 goto DONEAXFR;
1826 }
1827
1828 # Bizarre Things Happen when you AXFR a null-named zone.
1829 $webvar{importdoms} =~ s/^\s+//;
1830 my @domlist = split /\s+/, $webvar{importdoms};
1831 my @results;
1832 foreach my $domain (@domlist) {
1833##fixme: Net::DNS has made changes somewhere between 0.66something (~~ Debian wheezy) and
1834# 0.81 (~~ Debian jessie) that cause taint failures when providing a hostname as a nameserver
1835# for AXFR. A proper fix may boil down to "split AXFR into its own script". Feh.
1836# For now, we'll just convert the requested AXFR host to an IP, and pass that down the chain instead.
1837 my $nsip = gethostbyname($webvar{ifrom});
1838 use Socket;
1839 $nsip = inet_ntoa($nsip);
1840 # strangely enough we don't seem to need to detaint:
1841 #($nsip) = ($nsip =~ /^([a-fA-F0-9:.]+)$/);
1842 my %row;
1843 my ($code,$msg) = $dnsdb->importAXFR($nsip, $domain, $webvar{group},
1844 status => $webvar{domactive}, rwsoa => $webvar{rwsoa}, rwns => $webvar{rwns},
1845 newttl => ($webvar{forcettl} ? $webvar{newttl} : 0),
1846 merge => $webvar{mergematching});
1847 $row{domok} = $msg if $code eq 'OK';
1848 if ($code eq 'WARN') {
1849 $msg =~ s|\n|<br />|g;
1850 $row{domwarn} = $msg;
1851 }
1852 if ($code eq 'FAIL') {
1853 $msg =~ s|\n|<br />\n|g;
1854 $row{domerr} = $msg;
1855 }
1856 $msg = "<br />\n".$msg if $msg =~ m|<br />|;
1857 $row{domain} = $domain;
1858 push @results, \%row;
1859 }
1860 $page->param(axfrresults => \@results);
1861 }
1862
1863 # Yes, this is a GOTO target. PTBHTTT.
1864 DONEAXFR: ;
1865
1866} elsif ($webvar{page} eq 'whoisq') {
1867
1868 if ($webvar{qfor}) {
1869 use Net::Whois::Raw;
1870 use Text::Wrap;
1871
1872# caching useful?
1873#$Net::Whois::Raw::CACHE_DIR = "/var/spool/pwhois/";
1874#$Net::Whois::Raw::CACHE_TIME = 60;
1875
1876 my ($dominfo, $whois_server) = whois($webvar{qfor});
1877##fixme: if we're given an IP, try rwhois as well as whois so we get the real final data
1878
1879 # le sigh. idjits spit out data without linefeeds...
1880 $Text::Wrap::columns = 88;
1881
1882# &%$@%@# high-bit crap. We should probably find a way to properly recode these
1883# instead of one-by-one. Note CGI::Simple's escapeHTML() doesn't do more than
1884# the bare minimum. :/
1885# Mainly an XHTML validation thing.
1886 $dominfo = $q->escapeHTML($dominfo);
1887 $dominfo =~ s/\xa9/\&copy;/g;
1888 $dominfo =~ s/\xae/\&reg;/g;
1889
1890 $page->param(qfor => $webvar{qfor});
1891 $page->param(dominfo => wrap('','',$dominfo));
1892 $page->param(whois_server => $whois_server);
1893 } else {
1894 $page->param(errmsg => "Missing host or domain to query in WHOIS") if $webvar{askaway};
1895 }
1896
1897} elsif ($webvar{page} eq 'log') {
1898
1899 my $id = $curgroup; # we do this because the group log may be called from (almost) any page,
1900 # but the others are much more limited. this is probably non-optimal.
1901
1902 if ($webvar{ltype} && $webvar{ltype} eq 'user') {
1903##fixme: where should we call this from?
1904 $id = $webvar{id};
1905##fixme: don't include username on out-of-scope users
1906 $page->param(logfor => 'user '.($id ? $dnsdb->userFullName($id) : $webvar{fname}));
1907 } elsif ($webvar{ltype} && $webvar{ltype} eq 'dom') {
1908 $id = $webvar{id};
1909 if (!check_scope(id => $id, type => 'domain')) {
1910 $page->param(errmsg => "You are not permitted to view log entries for the requested domain");
1911 goto DONELOG;
1912 }
1913 $page->param(logfor => 'domain '.$dnsdb->domainName($id));
1914 } elsif ($webvar{ltype} && $webvar{ltype} eq 'rdns') {
1915 $id = $webvar{id};
1916 if (!check_scope(id => $id, type => 'revzone')) {
1917 $page->param(errmsg => "You are not permitted to view log entries for the requested reverse zone");
1918 goto DONELOG;
1919 }
1920 $page->param(logfor => 'reverse zone '.$dnsdb->revName($id));
1921 } else {
1922 # Default to listing curgroup log
1923 $page->param(logfor => 'group '.$dnsdb->groupName($id));
1924 # note that scope limitations are applied via the change-group check;
1925 # group log is always for the "current" group
1926 }
1927 $webvar{ltype} = 'group' if !$webvar{ltype};
1928
1929 # Done here since we want to allow more arbitrary blobs in the log filter
1930 if (defined($webvar{logfilter})) {
1931 $session->param('logfilter', '') if !$session->param('logfilter');
1932 if ($webvar{logfilter} ne $session->param('logfilter')) {
1933 $uri_self =~ s/\&amp;offset=[^&]//;
1934 $offset = 0;
1935 }
1936 $session->param('logfilter', $webvar{logfilter})
1937 }
1938 my $logfilter = $session->param('logfilter');
1939 $filter = $logfilter;
1940 $page->param(logfilter => $logfilter);
1941
1942 my $lcount = $dnsdb->getLogCount(id => $id, group => $logingroup, fname => $webvar{fname},
1943 logtype => $webvar{ltype}, filter => $logfilter);
1944 if (!$lcount) {
1945 $page->param(errmsg => $dnsdb->errstr);
1946 $lcount = 0;
1947 }
1948
1949 $page->param(id => $id);
1950 $page->param(ltype => $webvar{ltype});
1951
1952 fill_fpnla($lcount);
1953 fill_pgcount($lcount, "log entries", '');
1954 $page->param(curpage => $webvar{page}.($webvar{ltype} ? "&amp;ltype=$webvar{ltype}" : ''));
1955
1956 $sortby = 'stamp';
1957 $sortorder = 'DESC'; # newest-first; although filtering is probably going to be more useful than sorting
1958# sort/order
1959 $session->param($webvar{page}.'sortby', $webvar{sortby}) if $webvar{sortby};
1960 $session->param($webvar{page}.'order', $webvar{order}) if $webvar{order};
1961
1962 $sortby = $session->param($webvar{page}.'sortby') if $session->param($webvar{page}.'sortby');
1963 $sortorder = $session->param($webvar{page}.'order') if $session->param($webvar{page}.'order');
1964
1965 # Set up the column headings with the sort info
1966 my @cols = ('fname','domain','revzone','entry','stamp');
1967 my %colnames = (fname => 'Name', domain => 'Forward zone', revzone => 'Reverse zone',
1968 entry => 'Log Entry', stamp => 'Date/Time');
1969 fill_colheads($sortby, $sortorder, \@cols, \%colnames);
1970
1971##fixme: increase per-page limit or use separate limit for log? some ops give *lots* of entries...
1972 my $logentries = $dnsdb->getLogEntries(id => $id, group => $logingroup, fname => $webvar{fname},
1973 logtype => $webvar{ltype},
1974 offset => $webvar{offset}, sortby => $sortby, sortorder => $sortorder, filter => $logfilter);
1975 if (!$logentries) {
1976 $page->param(errmsg => $dnsdb->errstr);
1977 } else {
1978 # undef $logentries is inexplicably puking instead of showing "no entries found",
1979 # like all the rest of the methods that return a list the same way. idunno...
1980 $page->param(logentries => $logentries);
1981 }
1982
1983##fixme:
1984# - on log record creation, bundle "parented" log actions (eg, "AXFR record blah for domain foo",
1985# or "Add record bar for new domain baz") into one entry (eg, "AXFR domain foo", "Add domain baz")?
1986# need a way to expand this into the complete list, and to exclude "child" entries
1987
1988 # scope check fail target
1989 DONELOG: ;
1990
1991} elsif ($webvar{page} eq 'recsearch') {
1992
1993 # we do this for the domain and record list filter/search - it should be extremely rare to
1994 # need to search on characters outside this set until we get into IDNs
1995 # note this is a little larger due to template records
1996 # allow <>= so searches can use the Postgres CIDR operators
1997 # allow , for things like DMARC records
1998 $webvar{searchfor} =~ s{[^a-zA-Z0-9_.,:\@%<>=/-]}{}g if $webvar{searchfor};
1999
2000 # save the search in the session, same as the "filter" in various other lists...
2001 if (defined($webvar{searchfor})) {
2002 if ($session->param('recsearch') && $webvar{searchfor} ne $session->param('recsearch')) {
2003 $uri_self =~ s/\&amp;offset=[^&]//;
2004 $offset = 0;
2005 }
2006 $session->param(recsearch => $webvar{searchfor});
2007 }
2008 my $searchfor = $session->param('recsearch');
2009
2010 $sortby = 'host';
2011 $session->param($webvar{page}.'sortby', $webvar{sortby}) if $webvar{sortby};
2012 $session->param($webvar{page}.'order', $webvar{order}) if $webvar{order};
2013 $sortby = $session->param($webvar{page}.'sortby') if $session->param($webvar{page}.'sortby');
2014 $sortorder = $session->param($webvar{page}.'order') if $session->param($webvar{page}.'order');
2015
2016 # some magic to label and linkify the column headers for sorting
2017 my @cols = ('domain','revzone','host','type','val');
2018 my %colheads = (domain => "Domain (Group)", revzone => "Reverse zone (Group)", host => "Host",
2019 type => "Type", val => "IP/value");
2020 # only users allowed to see location/view data get this column
2021 if ($permissions{admin} || $permissions{location_view}) {
2022 $colheads{location} = "Location";
2023 push @cols, 'location';
2024 }
2025 fill_colheads($sortby, $sortorder, \@cols, \%colheads);
2026
2027 # pgcount.tmpl
2028 my $count = $dnsdb->recSearchCount(searchfor => $searchfor, group => $logingroup);
2029 fill_pgcount($count, "records");
2030 fill_fpnla($count);
2031
2032 # and a bit for fpnla.tmpl
2033 $page->param(curpage => $webvar{page});
2034
2035 $page->param(searchfor => $searchfor);
2036 my $recset = $dnsdb->recSearch(searchfor => $searchfor, group => $logingroup, offset => $webvar{offset},
2037 sortby => $sortby, sortorder => $sortorder);
2038 $page->param(searchresults => $recset);
2039
2040} # end $webvar{page} dance
2041
2042
2043# start output here so we can redirect pages.
2044print $q->header( -cookie => $sesscookie);
2045print $header->output;
2046
2047##common bits
2048# mostly things in the menu
2049if ($webvar{page} ne 'login' && $webvar{page} ne 'badpage') {
2050 $page->param(username => $session->param("username"));
2051
2052 $page->param(group => $curgroup);
2053 $page->param(groupname => $dnsdb->groupName($curgroup));
2054 $page->param(logingrp => $dnsdb->groupName($logingroup));
2055 $page->param(logingrp_num => $logingroup);
2056
2057##fixme
2058 $page->param(mayrdns => 1);
2059 $page->param(maysecondary => 1);
2060
2061 $page->param(mayloc => ($permissions{admin} || $permissions{location_view}));
2062
2063 $page->param(maydefrec => $permissions{admin});
2064 $page->param(mayimport => $permissions{admin} || $permissions{domain_create});
2065 $page->param(maybulk => $permissions{admin} || $permissions{domain_edit} || $permissions{domain_create} || $permissions{domain_delete});
2066
2067 $page->param(chggrps => ($permissions{admin} || $permissions{group_create} || $permissions{group_edit} || $permissions{group_delete}));
2068
2069 # group tree. should go elsewhere, probably
2070 my $tmpgrplist = fill_grptree($logingroup,$curgroup);
2071 $page->param(grptree => $tmpgrplist);
2072 $page->param(subs => ($tmpgrplist ? 1 : 0)); # probably not useful to pass gobs of data in for a boolean
2073 $page->param(inlogingrp => $curgroup == $logingroup);
2074
2075# fill in the URL-to-self for the group tree and search-by-letter
2076 $page->param(whereami => $uri_self);
2077# fill in general URL-to-self
2078 $page->param(script_self => "$ENV{SCRIPT_NAME}?");
2079# fill in the generalized path-to-instance
2080 $page->param(webpath => ($ENV{SCRIPT_NAME} =~ m|(/.+)/[^/]+$|)[0]);
2081}
2082
2083if (@debugbits) {
2084 print "<pre>\n";
2085 foreach (@debugbits) { print; }
2086 print "</pre>\n";
2087}
2088
2089# spit it out
2090print $page->output;
2091
2092if ($debugenv) {
2093 print "<div id=\"debug\">webvar keys: <pre>\n";
2094 foreach my $key (keys %webvar) {
2095 print "key: $key\tval: $webvar{$key}\n";
2096 }
2097 print "</pre>\nsession:\n<pre>\n";
2098 my $sesdata = $session->dataref();
2099 foreach my $key (keys %$sesdata) {
2100 print "key: $key\tval: ".$sesdata->{$key}."\n";
2101 }
2102 print "</pre>\nENV:\n<pre>\n";
2103 foreach my $key (keys %ENV) {
2104 print "key: $key\tval: $ENV{$key}\n";
2105 }
2106 print "</pre></div>\n";
2107}
2108
2109print $footer->output;
2110
2111# as per the docs, Just In Case
2112$session->flush();
2113
2114exit 0;
2115
2116
2117sub fill_grptree {
2118 my $root = shift;
2119 my $cur = shift;
2120 my $indent = shift || ' ';
2121
2122 my @childlist;
2123
2124 # some magic to control bad offsets on group change
2125 my $grp_uri_self = $uri_self;
2126 $grp_uri_self =~ s/\&amp;offset=[^&]+// unless ($webvar{page} eq 'reclist' && $webvar{defrec} eq 'n');
2127
2128 my $grptree = HTML::Template->new(filename => 'templates/grptree.tmpl');
2129 $dnsdb->getChildren($root, \@childlist, 'immediate');
2130 return if $#childlist == -1;
2131 my @grouplist;
2132 foreach (@childlist) {
2133 my %row;
2134 $row{grpname} = $dnsdb->groupName($_);
2135 $row{grpnum} = $_;
2136 $row{whereami} = $grp_uri_self;
2137 $row{curgrp} = ($_ == $cur);
2138 $row{expanded} = $dnsdb->isParent($_, 'group', $cur, 'group');
2139 $row{expanded} = 1 if $_ == $cur;
2140 $row{subs} = fill_grptree($_,$cur,$indent.' ');
2141 $row{indent} = $indent;
2142 push @grouplist, \%row;
2143 }
2144 $grptree->param(indent => $indent);
2145 $grptree->param(treelvl => \@grouplist);
2146 return $grptree->output;
2147}
2148
2149sub changepage {
2150 my %params = @_; # think this works the way I want...
2151
2152 # cross-site scripting fixup. instead of passing error messages by URL/form
2153 # variable, put them in the session where the nasty user can't meddle.
2154 # these are done here since it's far simpler to pass them in from wherever
2155 # than set them locally everywhere.
2156 foreach my $sessme ('resultmsg','warnmsg','errmsg') {
2157 if (my $tmp = $params{$sessme}) {
2158 $tmp =~ s/^\n//;
2159 $tmp =~ s|\n|<br />\n|g;
2160 $session->param($sessme, $tmp);
2161 delete $params{$sessme};
2162 }
2163 }
2164
2165 # handle user check
2166 my $newurl = "http://$ENV{HTTP_HOST}$ENV{SCRIPT_NAME}?";
2167 foreach (sort keys %params) {
2168## fixme: something is undefined here on add location
2169 $newurl .= "&$_=".$q->url_encode($params{$_});
2170 }
2171
2172 # Just In Case
2173 $session->flush();
2174
2175 print $q->redirect ( -url => $newurl, -cookie => $sesscookie);
2176 exit;
2177} # end changepage
2178
2179# wrap up the usual suspects for result, warning, or error messages to be displayed
2180sub show_msgs {
2181 if ($session->param('resultmsg')) {
2182 $page->param(resultmsg => $session->param('resultmsg'));
2183 $session->clear('resultmsg');
2184 }
2185 if ($session->param('warnmsg')) {
2186 $page->param(warnmsg => $session->param('warnmsg'));
2187 $session->clear('warnmsg');
2188 }
2189 if ($session->param('errmsg')) {
2190 $page->param(errmsg => $session->param('errmsg'));
2191 $session->clear('errmsg');
2192 }
2193} # end show_msgs
2194
2195sub fillsoa {
2196 my $defrec = shift;
2197 my $revrec = shift;
2198 my $id = shift;
2199 my $preserve = shift || 'd'; # Flag to use webvar fields or retrieve from database
2200
2201 my $domname = ($defrec eq 'y' ? '' : "DOMAIN");
2202
2203 $page->param(defrec => $defrec);
2204 $page->param(revrec => $revrec);
2205
2206# i had a good reason to do this when I wrote it...
2207# $page->param(domain => $domname);
2208# $page->param(group => $DNSDB::group);
2209 $page->param(isgrp => 1) if $defrec eq 'y';
2210 $page->param(parent => ($defrec eq 'y' ? $dnsdb->groupName($id) :
2211 ($revrec eq 'n' ? $dnsdb->domainName($id) : $dnsdb->revName($id)) ) );
2212
2213# defaults
2214 $page->param(defcontact => $DNSDB::def{contact});
2215 $page->param(defns => $DNSDB::def{prins});
2216 $page->param(defsoattl => $DNSDB::def{soattl});
2217 $page->param(defrefresh => $DNSDB::def{refresh});
2218 $page->param(defretry => $DNSDB::def{retry});
2219 $page->param(defexpire => $DNSDB::def{expire});
2220 $page->param(defminttl => $DNSDB::def{minttl});
2221
2222 $page->param(id => $id);
2223
2224 if ($preserve eq 'd') {
2225 # there are probably better ways to do this. TMTOWTDI.
2226 my $soa = $dnsdb->getSOA($defrec, $revrec, $id);
2227
2228 $page->param(prins => ($soa->{prins} ? $soa->{prins} : $DNSDB::def{prins}));
2229 $page->param(contact => ($soa->{contact} ? $soa->{contact} : $DNSDB::def{contact}));
2230 $page->param(refresh => ($soa->{refresh} ? $soa->{refresh} : $DNSDB::def{refresh}));
2231 $page->param(retry => ($soa->{retry} ? $soa->{retry} : $DNSDB::def{retry}));
2232 $page->param(expire => ($soa->{expire} ? $soa->{expire} : $DNSDB::def{expire}));
2233 $page->param(minttl => ($soa->{minttl} ? $soa->{minttl} : $DNSDB::def{minttl}));
2234 $page->param(ttl => ($soa->{ttl} ? $soa->{ttl} : $DNSDB::def{soattl}));
2235 } else {
2236 $page->param(prins => ($webvar{prins} ? $webvar{prins} : $DNSDB::def{prins}));
2237 $page->param(contact => ($webvar{contact} ? $webvar{contact} : $DNSDB::def{contact}));
2238 $page->param(refresh => ($webvar{refresh} ? $webvar{refresh} : $DNSDB::def{refresh}));
2239 $page->param(retry => ($webvar{retry} ? $webvar{retry} : $DNSDB::def{retry}));
2240 $page->param(expire => ($webvar{expire} ? $webvar{expire} : $DNSDB::def{expire}));
2241 $page->param(minttl => ($webvar{minttl} ? $webvar{minttl} : $DNSDB::def{minttl}));
2242 $page->param(ttl => ($webvar{ttl} ? $webvar{ttl} : $DNSDB::def{soattl}));
2243 }
2244}
2245
2246sub showzone {
2247 my $def = shift;
2248 my $rev = shift;
2249 my $id = shift;
2250
2251 # get the SOA first
2252 my $soa = $dnsdb->getSOA($def, $rev, $id);
2253
2254 $page->param(contact => $soa->{contact});
2255 $page->param(prins => $soa->{prins});
2256 $page->param(serial => $soa->{serial});
2257 $page->param(refresh => $soa->{refresh});
2258 $page->param(retry => $soa->{retry});
2259 $page->param(expire => $soa->{expire});
2260 $page->param(minttl => $soa->{minttl});
2261 $page->param(ttl => $soa->{ttl});
2262
2263 my $foo2 = $dnsdb->getRecList(defrec => $def, revrec => $rev, id => $id, offset => $webvar{offset},
2264 sortby => $sortby, sortorder => $sortorder, filter => $filter);
2265
2266 foreach my $rec (@$foo2) {
2267 if ($typemap{$rec->{type}}) {
2268 $rec->{type} = $typemap{$rec->{type}};
2269 } else {
2270 $rec->{type} = "TYPE$rec->{type}";
2271 }
2272 $rec->{fwdzone} = $rev eq 'n';
2273 $rec->{ttl} = '(auto)' if $rec->{ttl} == -1;
2274 $rec->{distance} = 'n/a' unless ($rec->{type} eq 'MX' || $rec->{type} eq 'SRV');
2275 $rec->{weight} = 'n/a' unless ($rec->{type} eq 'SRV');
2276 $rec->{port} = 'n/a' unless ($rec->{type} eq 'SRV');
2277# ACLs
2278 $rec->{record_edit} = ($permissions{admin} || $permissions{record_edit});
2279 $rec->{record_delete} = ($permissions{admin} || $permissions{record_delete});
2280 $rec->{locname} = '' unless ($permissions{admin} || $permissions{location_view});
2281# Timestamps
2282 if ($rec->{expires}) {
2283 $rec->{stamptype} = $rec->{ispast} ? 'expired at' : 'expires at';
2284 } else {
2285 $rec->{stamptype} = 'valid after';
2286 }
2287 # strip seconds and timezone? no, not yet. could probably offer a config knob on this display at some point.
2288# $rec->{stamp} =~ s/:\d\d-\d+$//;
2289 delete $rec->{expires};
2290 delete $rec->{ispast};
2291 }
2292 $page->param(reclist => $foo2);
2293}
2294
2295sub fill_recdata {
2296 # le sigh. we may get called with many empty %webvar keys
2297 no warnings qw( uninitialized );
2298
2299##todo: allow BIND-style bare names, ASS-U-ME that the name is within the domain?
2300# prefill <domain> or DOMAIN in "Host" space for new records
2301 if ($webvar{revrec} eq 'n') {
2302 $page->param(typelist => $dnsdb->getTypelist($webvar{revrec}, $webvar{type}));
2303 my $domroot = ($webvar{defrec} eq 'y' ? 'DOMAIN' : $dnsdb->domainName($webvar{parentid}));
2304 $page->param(name => ($webvar{name} ? $webvar{name} : $domroot));
2305 $page->param(address => $webvar{address});
2306 $page->param(distance => $webvar{distance})
2307 if ($webvar{type} == $reverse_typemap{MX} or $webvar{type} == $reverse_typemap{SRV});
2308 $page->param(weight => $webvar{weight}) if $webvar{type} == $reverse_typemap{SRV};
2309 $page->param(port => $webvar{port}) if $webvar{type} == $reverse_typemap{SRV};
2310 } else {
2311 my $domroot = ($webvar{defrec} eq 'y' ? 'ADMINDOMAIN' : ".$dnsdb->{domain}");
2312 $page->param(name => ($webvar{name} ? $webvar{name} : $domroot));
2313 my $zname = ($webvar{defrec} eq 'y' ? 'ZONE' : $dnsdb->revName($webvar{parentid}, 'y'));
2314 $zname =~ s|\d*/\d+$||;
2315 $page->param(address => ($webvar{address} ? $webvar{address} : $zname));
2316 $page->param(typelist => $dnsdb->getTypelist($webvar{revrec},
2317 $webvar{type} || ($zname =~ /:/ ? $reverse_typemap{'AAAA+PTR'} : $reverse_typemap{'A+PTR'})));
2318 }
2319# retrieve the right ttl instead of falling (way) back to the hardcoded system default
2320 my $soa = $dnsdb->getSOA($webvar{defrec}, $webvar{revrec}, $webvar{parentid});
2321 $page->param(ttl => ($webvar{ttl} ? $webvar{ttl} : $soa->{minttl}));
2322 $page->param(stamp_until => ($webvar{expires} eq 'until'));
2323 $page->param(stamp => $webvar{stamp});
2324}
2325
2326sub fill_actypelist {
2327 my $curtype = shift || 'u';
2328
2329 my @actypes;
2330
2331 my %row1 = (actypeval => 'u', actypename => 'user');
2332 $row1{typesel} = 1 if $curtype eq 'u';
2333 push @actypes, \%row1;
2334
2335 my %row2 = (actypeval => 'S', actypename => 'superuser');
2336 $row2{typesel} = 1 if $curtype eq 'S';
2337 push @actypes, \%row2;
2338
2339 $page->param(actypelist => \@actypes);
2340}
2341
2342sub fill_clonemelist {
2343 # shut up some warnings, but don't stomp on caller's state
2344 local $webvar{clonesrc} = 0 if !defined($webvar{clonesrc});
2345
2346 my $clones = $dnsdb->getUserDropdown($curgroup, $webvar{clonesrc});
2347 $page->param(clonesrc => $clones);
2348}
2349
2350sub fill_fpnla {
2351 my $count = shift;
2352 if ($offset eq 'all') {
2353 $page->param(perpage => $perpage);
2354# uhm....
2355 } else {
2356 # all these bits only have sensible behaviour if offset is numeric. err, probably.
2357 if ($count > $perpage) {
2358 # if there are more results than the default, always show the "all" link
2359 $page->param(navall => 1);
2360
2361 if ($offset > 0) {
2362 $page->param(navfirst => 1);
2363 $page->param(navprev => 1);
2364 $page->param(prevoffs => $offset-1);
2365 }
2366
2367 # show "next" and "last" links if we're not on the last page of results
2368 if ( (($offset+1) * $perpage - $count) < 0 ) {
2369 $page->param(navnext => 1);
2370 $page->param(nextoffs => $offset+1);
2371 $page->param(navlast => 1);
2372 $page->param(lastoffs => int (($count-1)/$perpage));
2373 }
2374 } else {
2375 $page->param(onepage => 1);
2376 }
2377 }
2378} # end fill_fpnla()
2379
2380sub fill_pgcount {
2381 my $pgcount = shift;
2382 my $pgtype = shift;
2383 my $parent = shift;
2384
2385 $page->param(ntot => $pgcount);
2386 $page->param(nfirst => (($offset eq 'all' ? 0 : $offset)*$perpage+1));
2387 $page->param(npglast => ($offset eq 'all' ? $pgcount :
2388 ( (($offset+1)*$perpage) > $pgcount ? $pgcount : (($offset+1)*$perpage) )
2389 ));
2390 $page->param(pgtype => $pgtype);
2391 $page->param(parent => $parent);
2392 $page->param(filter => $filter);
2393} # end fill_pgcount()
2394
2395
2396sub listdomains { listzones(); } # temp
2397
2398sub listzones {
2399# ACLs
2400 $page->param(domain_create => ($permissions{admin} || $permissions{domain_create}) );
2401 $page->param(domain_edit => ($permissions{admin} || $permissions{domain_edit}) );
2402 $page->param(domain_delete => ($permissions{admin} || $permissions{domain_delete}) );
2403
2404 my @childgroups;
2405 $dnsdb->getChildren($curgroup, \@childgroups, 'all') if $searchsubs;
2406 my $childlist = join(',',@childgroups);
2407
2408 my $count = $dnsdb->getZoneCount(childlist => $childlist, curgroup => $curgroup, revrec => $webvar{revrec},
2409 filter => ($filter ? $filter : undef), startwith => ($startwith ? $startwith : undef) );
2410
2411# fill page count and first-previous-next-last-all bits
2412 fill_pgcount($count,($webvar{revrec} eq 'n' ? 'domains' : 'revzones'),$dnsdb->groupName($curgroup));
2413 fill_fpnla($count);
2414
2415 $sortby = ($webvar{revrec} eq 'n' ? 'domain' : 'revnet');
2416# sort/order
2417 $session->param($webvar{page}.'sortby', $webvar{sortby}) if $webvar{sortby};
2418 $session->param($webvar{page}.'order', $webvar{order}) if $webvar{order};
2419
2420 $sortby = $session->param($webvar{page}.'sortby') if $session->param($webvar{page}.'sortby');
2421 $sortorder = $session->param($webvar{page}.'order') if $session->param($webvar{page}.'order');
2422
2423# set up the headers
2424 my @cols = (($webvar{revrec} eq 'n' ? 'domain' : 'revnet'), 'status', 'group');
2425 my %colheads = (domain => 'Domain', revnet => 'Reverse Zone', status => 'Status', group => 'Group');
2426 fill_colheads($sortby, $sortorder, \@cols, \%colheads);
2427
2428 # hack! hack! pthbttt. have to rethink the status column storage,
2429 # or inactive comes "before" active. *sigh*
2430 $sortorder = ($sortorder eq 'ASC' ? 'DESC' : 'ASC') if $sortby eq 'status';
2431
2432# waffle, waffle - keep state on these as well as sortby, sortorder?
2433##fixme: put this higher so the count doesn't get munched?
2434 $page->param("start$startwith" => 1) if $startwith && $startwith =~ /^(?:[a-z]|0-9)$/;
2435
2436 $page->param(filter => $filter) if $filter;
2437 $page->param(searchsubs => $searchsubs) if $searchsubs;
2438
2439 $page->param(group => $curgroup);
2440
2441 my $zonelist = $dnsdb->getZoneList(childlist => $childlist, curgroup => $curgroup, revrec => $webvar{revrec},
2442 filter => ($filter ? $filter : undef), startwith => ($startwith ? $startwith : undef),
2443 offset => $offset, sortby => $sortby, sortorder => $sortorder
2444 );
2445# probably don't need this, keeping for reference for now
2446# foreach my $rec (@$zonelist) {
2447# }
2448 $page->param(domtable => $zonelist);
2449} # end listzones()
2450
2451
2452sub listsecondaryzones {
2453# ACLs
2454 $page->param(secondary_create => ($permissions{admin} || $permissions{domain_create}) );
2455 $page->param(secondary_edit => ($permissions{admin} || $permissions{domain_edit}) );
2456 $page->param(secondary_delete => ($permissions{admin} || $permissions{domain_delete}) );
2457
2458 my @childgroups;
2459 $dnsdb->getChildren($curgroup, \@childgroups, 'all') if $searchsubs;
2460 my $childlist = join(',',@childgroups);
2461
2462# my $count = $dnsdb->getSecondaryZoneCount(childlist => $childlist, curgroup => $curgroup,
2463 my $count = $dnsdb->getZoneCount(childlist => $childlist, curgroup => $curgroup, secondary => 'y',
2464 filter => ($filter ? $filter : undef), startwith => ($startwith ? $startwith : undef) );
2465
2466# fill page count and first-previous-next-last-all bits
2467 fill_pgcount($count, 'secondary zone(s)', $dnsdb->groupName($curgroup));
2468 fill_fpnla($count);
2469
2470 $sortby = 'zone';
2471# sort/order
2472 $session->param($webvar{page}.'sortby', $webvar{sortby}) if $webvar{sortby};
2473 $session->param($webvar{page}.'order', $webvar{order}) if $webvar{order};
2474
2475 $sortby = $session->param($webvar{page}.'sortby') if $session->param($webvar{page}.'sortby');
2476 $sortorder = $session->param($webvar{page}.'order') if $session->param($webvar{page}.'order');
2477
2478# set up the headers
2479 my @cols = ('secondary', 'primaryserver', 'status', 'group');
2480 my %colheads = (secondary => 'Secondary zone', primaryserver => 'Primary server(s)', status => 'Status', group => 'Group');
2481 fill_colheads($sortby, $sortorder, \@cols, \%colheads);
2482
2483 # hack! hack! pthbttt. have to rethink the status column storage,
2484 # or inactive comes "before" active. *sigh*
2485 $sortorder = ($sortorder eq 'ASC' ? 'DESC' : 'ASC') if $sortby eq 'status';
2486
2487# waffle, waffle - keep state on these as well as sortby, sortorder?
2488##fixme: put this higher so the count doesn't get munched?
2489 $page->param("start$startwith" => 1) if $startwith && $startwith =~ /^(?:[a-z]|0-9)$/;
2490
2491 $page->param(filter => $filter) if $filter;
2492 $page->param(searchsubs => $searchsubs) if $searchsubs;
2493
2494 $page->param(group => $curgroup);
2495
2496# my $zonelist = $dnsdb->getSecondaryZoneList(childlist => $childlist, curgroup => $curgroup,
2497 my $zonelist = $dnsdb->getZoneList(childlist => $childlist, curgroup => $curgroup, secondary => 'y',
2498 filter => ($filter ? $filter : undef), startwith => ($startwith ? $startwith : undef),
2499 offset => $offset, sortby => $sortby, sortorder => $sortorder
2500 );
2501# probably don't need this, keeping for reference for now
2502# foreach my $rec (@$zonelist) {
2503# }
2504 $page->param(zonetable => $zonelist);
2505} # end listsecondaryzones()
2506
2507
2508sub listgroups {
2509
2510# security check - does the user have permission to view this entity?
2511 if (!(grep /^$curgroup$/, @viewablegroups)) {
2512 # hmm. Reset the current group to the login group? Yes. Prevents confusing behaviour elsewhere.
2513 $session->param('curgroup',$logingroup);
2514 $page->param(errmsg => "You are not permitted to view the requested group");
2515 $curgroup = $logingroup;
2516 }
2517
2518 my @childgroups;
2519 $dnsdb->getChildren($curgroup, \@childgroups, 'all') if $searchsubs;
2520 my $childlist = join(',',@childgroups);
2521
2522 my ($count) = $dnsdb->getGroupCount(childlist => $childlist, curgroup => $curgroup,
2523 filter => ($filter ? $filter : undef), startwith => ($startwith ? $startwith : undef) );
2524
2525# fill page count and first-previous-next-last-all bits
2526 fill_pgcount($count,"groups",'');
2527 fill_fpnla($count);
2528
2529 $page->param(gid => $curgroup);
2530
2531 $sortby = 'group';
2532# sort/order
2533 $session->param($webvar{page}.'sortby', $webvar{sortby}) if $webvar{sortby};
2534 $session->param($webvar{page}.'order', $webvar{order}) if $webvar{order};
2535
2536 $sortby = $session->param($webvar{page}.'sortby') if $session->param($webvar{page}.'sortby');
2537 $sortorder = $session->param($webvar{page}.'order') if $session->param($webvar{page}.'order');
2538
2539# set up the headers
2540 my @cols = ('group','parent','nusers','ndomains','nrevzones');
2541 my %colnames = (group => 'Group', parent => 'Parent Group', nusers => 'Users', ndomains => 'Domains', nrevzones => 'Reverse Zones');
2542 fill_colheads($sortby, $sortorder, \@cols, \%colnames);
2543
2544# waffle, waffle - keep state on these as well as sortby, sortorder?
2545 $page->param("start$startwith" => 1) if $startwith && $startwith =~ /^(?:[a-z]|0-9)$/;
2546
2547 $page->param(filter => $filter) if $filter;
2548 $page->param(searchsubs => $searchsubs) if $searchsubs;
2549
2550# munge sortby for columns in database
2551 $sortby = 'g.group_name' if $sortby eq 'group';
2552 $sortby = 'g2.group_name' if $sortby eq 'parent';
2553
2554 my $glist = $dnsdb->getGroupList(childlist => $childlist, curgroup => $curgroup,
2555 filter => ($filter ? $filter : undef), startwith => ($startwith ? $startwith : undef),
2556 offset => $webvar{offset}, sortby => $sortby, sortorder => $sortorder);
2557
2558 $page->param(grouptable => $glist);
2559} # end listgroups()
2560
2561
2562sub fill_grouplist {
2563 my $template_var = shift;
2564 my $cur = shift || $curgroup;
2565
2566 # little recursive utility sub-sub
2567 sub getgroupdrop {
2568 my $root = shift;
2569 my $cur = shift; # to tag the selected group
2570 my $grplist = shift;
2571 my $indent = shift || '&nbsp;&nbsp;&nbsp;&nbsp;';
2572
2573 my @childlist;
2574 $dnsdb->getChildren($root, \@childlist, 'immediate');
2575 return if $#childlist == -1;
2576 foreach (@childlist) {
2577 my %row;
2578 $row{groupval} = $_;
2579 $row{groupactive} = ($_ == $cur);
2580 $row{groupname} = $indent.$dnsdb->groupName($_);
2581 push @{$grplist}, \%row;
2582 getgroupdrop($_, $cur, $grplist, $indent.'&nbsp;&nbsp;&nbsp;&nbsp;');
2583 }
2584 }
2585
2586 my @grouplist;
2587 push @grouplist, { groupval => $logingroup, groupactive => $logingroup == $curgroup,
2588 groupname => $dnsdb->groupName($logingroup) };
2589 getgroupdrop($logingroup, $curgroup, \@grouplist);
2590
2591 $page->param("$template_var" => \@grouplist);
2592} # end fill_grouplist()
2593
2594
2595sub fill_loclist {
2596 my $cur = shift || $curgroup;
2597 my $defloc = shift || '';
2598
2599 return unless ($permissions{admin} || $permissions{location_view});
2600
2601 $page->param(location_view => ($permissions{admin} || $permissions{location_view}));
2602
2603 if ($permissions{admin} || $permissions{record_locchg}) {
2604 my $loclist = $dnsdb->getLocDropdown($cur, $defloc);
2605 $page->param(record_locchg => 1);
2606 $page->param(loclist => $loclist);
2607 } else {
2608 my $loc = $dnsdb->getLoc($defloc);
2609 $page->param(loc_name => $loc->{description});
2610 }
2611} # end fill_loclist()
2612
2613
2614sub list_users {
2615
2616 my @childgroups;
2617 $dnsdb->getChildren($curgroup, \@childgroups, 'all') if $searchsubs;
2618 my $childlist = join(',',@childgroups);
2619
2620 my $count = $dnsdb->getUserCount(childlist => $childlist, curgroup => $curgroup,
2621 filter => ($filter ? $filter : undef), startwith => ($startwith ? $startwith : undef) );
2622
2623# fill page count and first-previous-next-last-all bits
2624 fill_pgcount($count,"users",'');
2625 fill_fpnla($count);
2626
2627 $sortby = 'user';
2628# sort/order
2629 $session->param($webvar{page}.'sortby', $webvar{sortby}) if $webvar{sortby};
2630 $session->param($webvar{page}.'order', $webvar{order}) if $webvar{order};
2631
2632 $sortby = $session->param($webvar{page}.'sortby') if $session->param($webvar{page}.'sortby');
2633 $sortorder = $session->param($webvar{page}.'order') if $session->param($webvar{page}.'order');
2634
2635# set up the headers
2636 my @cols = ('user','fname','type','group','status');
2637 my %colnames = (user => 'Username', fname => 'Full Name', type => 'Type', group => 'Group', status => 'Status');
2638 fill_colheads($sortby, $sortorder, \@cols, \%colnames);
2639
2640# waffle, waffle - keep state on these as well as sortby, sortorder?
2641 $page->param("start$startwith" => 1) if $startwith && $startwith =~ /^(?:[a-z]|0-9)$/;
2642
2643 $page->param(filter => $filter) if $filter;
2644 $page->param(searchsubs => $searchsubs) if $searchsubs;
2645
2646 my $ulist = $dnsdb->getUserList(childlist => $childlist, curgroup => $curgroup,
2647 filter => ($filter ? $filter : undef), startwith => ($startwith ? $startwith : undef),
2648 offset => $webvar{offset}, sortby => $sortby, sortorder => $sortorder);
2649 # Some UI things need to be done to the list (unlike other lists)
2650 foreach my $u (@{$ulist}) {
2651 $u->{eduser} = ($permissions{admin} ||
2652 ($permissions{user_edit} && $u->{type} ne 'S') ||
2653 ($permissions{self_edit} && $u->{user_id} == $session->param('uid')) );
2654 $u->{deluser} = ($permissions{admin} || ($permissions{user_delete} && $u->{type} ne 'S'));
2655 $u->{type} = ($u->{type} eq 'S' ? 'superuser' : 'user');
2656 }
2657 $page->param(usertable => $ulist);
2658} # end list_users()
2659
2660
2661sub list_locations {
2662
2663 my @childgroups;
2664 $dnsdb->getChildren($curgroup, \@childgroups, 'all') if $searchsubs;
2665 my $childlist = join(',',@childgroups);
2666
2667 my $count = $dnsdb->getLocCount(childlist => $childlist, curgroup => $curgroup,
2668 filter => ($filter ? $filter : undef), startwith => ($startwith ? $startwith : undef) );
2669
2670# fill page count and first-previous-next-last-all bits
2671 fill_pgcount($count,"locations/views",'');
2672 fill_fpnla($count);
2673
2674 $sortby = 'user';
2675# sort/order
2676 $session->param($webvar{page}.'sortby', $webvar{sortby}) if $webvar{sortby};
2677 $session->param($webvar{page}.'order', $webvar{order}) if $webvar{order};
2678
2679 $sortby = $session->param($webvar{page}.'sortby') if $session->param($webvar{page}.'sortby');
2680 $sortorder = $session->param($webvar{page}.'order') if $session->param($webvar{page}.'order');
2681
2682# set up the headers
2683 my @cols = ('description', 'iplist', 'group');
2684 my %colnames = (description => 'Location/View Name', iplist => 'Permitted IPs/Ranges', group => 'Group');
2685 fill_colheads($sortby, $sortorder, \@cols, \%colnames);
2686
2687# waffle, waffle - keep state on these as well as sortby, sortorder?
2688 $page->param("start$startwith" => 1) if $startwith && $startwith =~ /^(?:[a-z]|0-9)$/;
2689
2690 $page->param(filter => $filter) if $filter;
2691 $page->param(searchsubs => $searchsubs) if $searchsubs;
2692
2693 my $loclist = $dnsdb->getLocList(childlist => $childlist, curgroup => $curgroup,
2694 filter => ($filter ? $filter : undef), startwith => ($startwith ? $startwith : undef),
2695 offset => $webvar{offset}, sortby => $sortby, sortorder => $sortorder);
2696 # Some UI things need to be done to the list
2697 foreach my $l (@{$loclist}) {
2698 $l->{iplist} = "(All IPs)" if !$l->{iplist};
2699 $l->{edloc} = ($permissions{admin} || $permissions{loc_edit});
2700 $l->{delloc} = ($permissions{admin} || $permissions{loc_delete});
2701 }
2702 $page->param(loctable => $loclist);
2703} # end list_locations()
2704
2705
2706# Generate all of the glop necessary to add or not the appropriate marker/flag for
2707# the sort order and column in domain, user, group, and record lists
2708# Takes an array ref and hash ref
2709sub fill_colheads {
2710 my $sortby = shift;
2711 my $sortorder = shift;
2712 my $cols = shift;
2713 my $colnames = shift;
2714 my $custom = shift;
2715
2716 my @headings;
2717
2718 foreach my $col (@$cols) {
2719 my %coldata;
2720 $coldata{page} = $webvar{page};
2721 $coldata{offset} = $webvar{offset} if $webvar{offset};
2722 $coldata{sortby} = $col;
2723 $coldata{colname} = $colnames->{$col};
2724 if ($col eq $sortby) {
2725 $coldata{order} = ($sortorder eq 'ASC' ? 'DESC' : 'ASC');
2726 $coldata{sortorder} = $sortorder;
2727 } else {
2728 $coldata{order} = 'ASC';
2729 }
2730 if ($custom) {
2731 foreach my $ckey (keys %$custom) {
2732 $coldata{$ckey} = $custom->{$ckey};
2733 }
2734 }
2735 push @headings, \%coldata;
2736 }
2737
2738 $page->param(colheads => \@headings);
2739
2740} # end fill_colheads()
2741
2742
2743# we have to do this in a variety of places; let's make it consistent
2744sub fill_permissions {
2745 my $template = shift; # may need to do several sets on a single page
2746 my $permset = shift; # hashref to permissions on object
2747 my $usercan = shift || \%permissions; # allow alternate user-is-allowed permission block
2748
2749 foreach (@permtypes) {
2750 $template->param("may_$_" => ($usercan->{admin} || $usercan->{$_}));
2751 $template->param($_ => $permset->{$_});
2752 }
2753}
2754
2755# so simple when defined as a sub instead of inline. O_o
2756sub check_scope {
2757 my %args = @_;
2758 my $entity = $args{id} || 0; # prevent the shooting of feet with SQL "... intcolumn = '' ..."
2759 my $entype = $args{type} || '';
2760
2761 if ($entype eq 'group') {
2762 return 1 if grep /^$entity$/, @viewablegroups;
2763 } else {
2764 foreach (@viewablegroups) {
2765 return 1 if $dnsdb->isParent($_, 'group', $entity, $entype);
2766 }
2767 }
2768}
Note: See TracBrowser for help on using the repository browser.