| [119] | 1 | #!/usr/bin/perl
 | 
|---|
 | 2 | # XMLRPC interface to manipulate most DNS DB entities
 | 
|---|
 | 3 | 
 | 
|---|
 | 4 | use strict;
 | 
|---|
 | 5 | use warnings;
 | 
|---|
 | 6 | use DNSDB;      # note we're not importing subs;  this lets us (ab)use the same sub names here for convenience
 | 
|---|
| [121] | 7 | use Data::Dumper;
 | 
|---|
| [119] | 8 | 
 | 
|---|
 | 9 | #use Frontier::RPC2;
 | 
|---|
 | 10 | use Frontier::Responder;
 | 
|---|
 | 11 | 
 | 
|---|
 | 12 | ## We need to handle a couple of things globally, rather than pasting the same bit into *every* sub.
 | 
|---|
 | 13 | ## So, let's subclass Frontier::RPC2 + Frontier::Responder, so we can override the single sub in each
 | 
|---|
 | 14 | ## that needs kicking
 | 
|---|
 | 15 | #### hmm.  put this in a separate file?
 | 
|---|
 | 16 | #package DNSDB::RPC;
 | 
|---|
 | 17 | #our @ISA = ("Frontier::RPC2", "Frontier::Responder");
 | 
|---|
 | 18 | #package main;
 | 
|---|
 | 19 | 
 | 
|---|
 | 20 | # need to create a DNSDB object too
 | 
|---|
 | 21 | my ($dbh,$msg) = DNSDB::connectDB("dnsdb","dnsdb","secret","dnsdbhost");
 | 
|---|
| [121] | 22 | DNSDB::initGlobals($dbh);
 | 
|---|
| [119] | 23 | 
 | 
|---|
 | 24 | my $methods = {
 | 
|---|
 | 25 |         'dnsdb.addDomain'       => \&addDomain,
 | 
|---|
 | 26 |         'dnsdb.delDomain'       => \&delDomain,
 | 
|---|
| [121] | 27 |         'dnsdb.addGroup'        => \&addGroup,
 | 
|---|
 | 28 |         'dnsdb.delGroup'        => \&delGroup,
 | 
|---|
 | 29 |         'dnsdb.addUser'         => \&addUser,
 | 
|---|
 | 30 |         'dnsdb.updateUser'      => \&updateUser,
 | 
|---|
 | 31 |         'dnsdb.delUser'         => \&delUser,
 | 
|---|
 | 32 |         'dnsdb.getSOA'          => \&getSOA,
 | 
|---|
| [123] | 33 |         'dnsdb.getRecLine'      => \&getRecLine,
 | 
|---|
 | 34 |         'dnsdb.getDomRecs'      => \&getDomRecs,
 | 
|---|
 | 35 |         'dnsdb.getRecCount'     => \&getRecCount,
 | 
|---|
 | 36 |         'dnsdb.addRec'          => \&addRec,
 | 
|---|
 | 37 |         'dnsdb.delRec'          => \&delRec,
 | 
|---|
 | 38 |         'dnsdb.domStatus'       => \&domStatus,
 | 
|---|
| [121] | 39 | 
 | 
|---|
| [119] | 40 |         'dnsdb.getMethods'      => \&get_method_list
 | 
|---|
 | 41 | };
 | 
|---|
 | 42 | 
 | 
|---|
 | 43 | my $res = Frontier::Responder->new(
 | 
|---|
 | 44 |         methods => $methods
 | 
|---|
 | 45 |         );
 | 
|---|
 | 46 | 
 | 
|---|
 | 47 | # "Can't do that" errors
 | 
|---|
 | 48 | ##fixme:  this MUST be loaded from a config file!  Also must support multiple IPs
 | 
|---|
 | 49 | if ($ENV{REMOTE_ADDR} ne '192.168.2.116') {
 | 
|---|
 | 50 |   print "Content-type: text/xml\n\n".$res->{_decode}->encode_fault(5, "Access denied");
 | 
|---|
 | 51 |   exit;
 | 
|---|
 | 52 | }
 | 
|---|
 | 53 | if (!$dbh) {
 | 
|---|
 | 54 |   print "Content-type: text/xml\n\n".$res->{_decode}->encode_fault(5, $msg);
 | 
|---|
 | 55 |   exit;
 | 
|---|
 | 56 | }
 | 
|---|
 | 57 | ##fixme:  fail on missing rpcuser/rpcsystem args
 | 
|---|
 | 58 | 
 | 
|---|
 | 59 | print $res->answer;
 | 
|---|
 | 60 | 
 | 
|---|
 | 61 | exit;
 | 
|---|
 | 62 | 
 | 
|---|
 | 63 | ##
 | 
|---|
 | 64 | ## Subs below here
 | 
|---|
 | 65 | ##
 | 
|---|
 | 66 | 
 | 
|---|
 | 67 | #sub connectDB {
 | 
|---|
 | 68 | #sub finish {
 | 
|---|
 | 69 | #sub initGlobals {
 | 
|---|
 | 70 | #sub initPermissions {
 | 
|---|
 | 71 | #sub getPermissions {
 | 
|---|
 | 72 | #sub changePermissions {
 | 
|---|
 | 73 | #sub comparePermissions {
 | 
|---|
 | 74 | #sub changeGroup {
 | 
|---|
 | 75 | #sub _log {
 | 
|---|
 | 76 | 
 | 
|---|
 | 77 | sub addDomain {
 | 
|---|
 | 78 |   my %args = @_;
 | 
|---|
 | 79 | 
 | 
|---|
 | 80 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 81 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 82 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
 | 83 | 
 | 
|---|
 | 84 |   my ($code, $msg) = DNSDB::addDomain($dbh, $args{domain}, $args{group}, $args{state});
 | 
|---|
 | 85 |   die $msg if $code eq 'FAIL';
 | 
|---|
 | 86 |   return $msg;  # domain ID
 | 
|---|
 | 87 | }
 | 
|---|
 | 88 | 
 | 
|---|
 | 89 | sub delDomain {
 | 
|---|
 | 90 |   my %args = @_;
 | 
|---|
 | 91 | 
 | 
|---|
 | 92 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 93 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 94 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
 | 95 | 
 | 
|---|
| [121] | 96 |   my ($code,$msg);
 | 
|---|
| [119] | 97 |   # Let's be nice;  delete based on domid OR domain name.  Saves an RPC call round-trip, maybe.
 | 
|---|
 | 98 |   if ($args{domain} =~ /^\d+$/) {
 | 
|---|
| [121] | 99 |     ($code,$msg) = DNSDB::delDomain($dbh, $args{domain});
 | 
|---|
| [119] | 100 |   } else {
 | 
|---|
 | 101 |     my $domid = DNSDB::domainID($dbh, $args{domain});
 | 
|---|
 | 102 |     die "Can't find domain" if !$domid;
 | 
|---|
| [121] | 103 |     ($code,$msg) = DNSDB::delDomain($dbh, $domid);
 | 
|---|
| [119] | 104 |   }
 | 
|---|
 | 105 |   die $msg if $code eq 'FAIL';
 | 
|---|
 | 106 | }
 | 
|---|
 | 107 | 
 | 
|---|
 | 108 | #sub domainName {
 | 
|---|
 | 109 | #sub domainID {
 | 
|---|
 | 110 | 
 | 
|---|
 | 111 | sub addGroup {
 | 
|---|
 | 112 |   my %args = @_;
 | 
|---|
 | 113 | 
 | 
|---|
 | 114 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 115 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 116 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
 | 117 | 
 | 
|---|
 | 118 | # not sure how to usefully represent permissions from any further out from DNSDB.pm :/
 | 
|---|
| [121] | 119 | # not to mention, permissions are checked at the UI layer, not the DB layer.
 | 
|---|
| [119] | 120 |   my $perms = {domain_edit => 1, domain_create => 1, domain_delete => 1,
 | 
|---|
 | 121 |         record_edit => 1, record_create => 1, record_delete => 1
 | 
|---|
 | 122 |         };
 | 
|---|
 | 123 | ## optional $inhert arg?
 | 
|---|
 | 124 |   my ($code,$msg) = DNSDB::addGroup($dbh, $args{groupname}, $args{parent_id}, $perms);
 | 
|---|
 | 125 |   die $msg if $code eq 'FAIL';
 | 
|---|
 | 126 |   return $msg;
 | 
|---|
 | 127 | }
 | 
|---|
 | 128 | 
 | 
|---|
 | 129 | sub delGroup {
 | 
|---|
 | 130 |   my %args = @_;
 | 
|---|
 | 131 | 
 | 
|---|
 | 132 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 133 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 134 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
 | 135 | 
 | 
|---|
| [121] | 136 |   my ($code,$msg);
 | 
|---|
| [119] | 137 |   # Let's be nice;  delete based on groupid OR group name.  Saves an RPC call round-trip, maybe.
 | 
|---|
 | 138 |   if ($args{group} =~ /^\d+$/) {
 | 
|---|
| [121] | 139 |     ($code,$msg) = DNSDB::delGroup($dbh, $args{group});
 | 
|---|
| [119] | 140 |   } else {
 | 
|---|
 | 141 |     my $grpid = DNSDB::groupID($dbh, $args{group});
 | 
|---|
 | 142 |     die "Can't find group" if !$grpid;
 | 
|---|
| [121] | 143 |     ($code,$msg) = DNSDB::delGroup($dbh, $grpid);
 | 
|---|
| [119] | 144 |   }
 | 
|---|
 | 145 |   die $msg if $code eq 'FAIL';
 | 
|---|
 | 146 | }
 | 
|---|
 | 147 | 
 | 
|---|
 | 148 | #sub getChildren {
 | 
|---|
 | 149 | #sub groupName {
 | 
|---|
 | 150 | #sub groupID {
 | 
|---|
 | 151 | 
 | 
|---|
 | 152 | sub addUser {
 | 
|---|
 | 153 |   my %args = @_;
 | 
|---|
 | 154 | 
 | 
|---|
 | 155 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 156 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 157 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
 | 158 | 
 | 
|---|
| [121] | 159 | # not sure how to usefully represent permissions from any further out from DNSDB.pm :/
 | 
|---|
 | 160 | # not to mention, permissions are checked at the UI layer, not the DB layer.
 | 
|---|
 | 161 |   my $perms = {domain_edit => 1, domain_create => 1, domain_delete => 1,
 | 
|---|
 | 162 |         record_edit => 1, record_create => 1, record_delete => 1
 | 
|---|
 | 163 |         };
 | 
|---|
| [119] | 164 |   # bend and twist;  get those arguments in in the right order!
 | 
|---|
 | 165 |   $args{type} = 'u' if !$args{type};
 | 
|---|
 | 166 |   $args{permstring} = 'i' if !defined($args{permstring});
 | 
|---|
 | 167 |   my @userargs = ($args{username}, $args{group}, $args{pass}, $args{state}, $args{type}, $args{permstring});
 | 
|---|
 | 168 |   for my $argname ('fname','lname','phone') {
 | 
|---|
 | 169 |     last if !$args{$argname};
 | 
|---|
 | 170 |     push @userargs, $args{$argname};
 | 
|---|
 | 171 |   }
 | 
|---|
 | 172 |   my ($code,$msg) = DNSDB::addUser($dbh, @userargs);
 | 
|---|
 | 173 |   die $msg if $code eq 'FAIL';
 | 
|---|
 | 174 |   return $msg;
 | 
|---|
 | 175 | }
 | 
|---|
 | 176 | 
 | 
|---|
 | 177 | #sub checkUser {
 | 
|---|
 | 178 | 
 | 
|---|
 | 179 | sub updateUser {
 | 
|---|
 | 180 |   my %args = @_;
 | 
|---|
 | 181 | 
 | 
|---|
 | 182 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 183 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 184 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
 | 185 | 
 | 
|---|
 | 186 |   die "Missing UID" if !$args{uid};
 | 
|---|
| [121] | 187 | 
 | 
|---|
 | 188 | # not sure how to usefully represent permissions from any further out from DNSDB.pm :/
 | 
|---|
 | 189 | # not to mention, permissions are checked at the UI layer, not the DB layer.
 | 
|---|
 | 190 |   my $perms = {domain_edit => 1, domain_create => 1, domain_delete => 1,
 | 
|---|
 | 191 |         record_edit => 1, record_create => 1, record_delete => 1
 | 
|---|
 | 192 |         };
 | 
|---|
| [119] | 193 |   # bend and twist;  get those arguments in in the right order!
 | 
|---|
 | 194 |   my @userargs = ($args{uid}, $args{username}, $args{group}, $args{pass}, $args{state}, $args{type});
 | 
|---|
 | 195 |   for my $argname ('fname','lname','phone') {
 | 
|---|
 | 196 |     last if !$args{$argname};
 | 
|---|
 | 197 |     push @userargs, $args{$argname};
 | 
|---|
 | 198 |   }
 | 
|---|
 | 199 | ##fixme:  also underlying in DNSDB::updateUser():  no way to just update this or that attribute;
 | 
|---|
 | 200 | #         have to pass them all in to be overwritten
 | 
|---|
 | 201 |   my ($code,$msg) = DNSDB::addUser($dbh, @userargs);
 | 
|---|
 | 202 |   die $msg if $code eq 'FAIL';
 | 
|---|
 | 203 | }
 | 
|---|
 | 204 | 
 | 
|---|
 | 205 | sub delUser {
 | 
|---|
 | 206 |   my %args = @_;
 | 
|---|
 | 207 | 
 | 
|---|
 | 208 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 209 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 210 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
 | 211 | 
 | 
|---|
 | 212 |   die "Missing UID" if !$args{uid};
 | 
|---|
 | 213 |   my ($code,$msg) = DNSDB::delUser($dbh, $args{uid});
 | 
|---|
 | 214 |   die $msg if $code eq 'FAIL';
 | 
|---|
 | 215 | }
 | 
|---|
 | 216 | 
 | 
|---|
 | 217 | #sub userFullName {
 | 
|---|
 | 218 | #sub userStatus {
 | 
|---|
 | 219 | #sub getUserData {
 | 
|---|
 | 220 | 
 | 
|---|
 | 221 | sub getSOA {
 | 
|---|
 | 222 |   my %args = @_;
 | 
|---|
 | 223 | 
 | 
|---|
 | 224 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 225 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 226 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
| [121] | 227 | 
 | 
|---|
 | 228 |   my %ret = DNSDB::getSOA($dbh, $args{def}, $args{id});
 | 
|---|
 | 229 |   if (!$ret{recid}) {
 | 
|---|
 | 230 |     if ($args{def} eq 'y') {
 | 
|---|
 | 231 |       die "No default SOA record in group";
 | 
|---|
 | 232 |     } else {
 | 
|---|
 | 233 |       die "No SOA record in domain";
 | 
|---|
 | 234 |     }
 | 
|---|
 | 235 |   }
 | 
|---|
 | 236 |   return \%ret;
 | 
|---|
| [119] | 237 | }
 | 
|---|
 | 238 | 
 | 
|---|
 | 239 | sub getRecLine {
 | 
|---|
 | 240 |   my %args = @_;
 | 
|---|
 | 241 | 
 | 
|---|
 | 242 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 243 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 244 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
| [123] | 245 | 
 | 
|---|
 | 246 |   my $ret = DNSDB::getRecLine($dbh, $args{def}, $args{id});
 | 
|---|
 | 247 | 
 | 
|---|
 | 248 |   die $DNSDB::errstr if !$ret;
 | 
|---|
 | 249 | 
 | 
|---|
 | 250 |   return $ret;
 | 
|---|
| [119] | 251 | }
 | 
|---|
 | 252 | 
 | 
|---|
 | 253 | sub getDomRecs {
 | 
|---|
 | 254 |   my %args = @_;
 | 
|---|
 | 255 | 
 | 
|---|
 | 256 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 257 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 258 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
| [123] | 259 | 
 | 
|---|
 | 260 | #bleh
 | 
|---|
 | 261 |   $args{nrecs} = 'all' if !$args{nrecs};
 | 
|---|
 | 262 |   $args{nstart} = 0 if !$args{nstart};
 | 
|---|
 | 263 | ## for order, need to map input to column names
 | 
|---|
 | 264 |   $args{order} = 'host' if !$args{order};
 | 
|---|
 | 265 |   $args{direction} = 'ASC' if !$args{direction};
 | 
|---|
 | 266 | 
 | 
|---|
 | 267 |   my $ret = DNSDB::getDomRecs($dbh, $args{def}, $args{id}, $args{nrecs}, $args{nstart}, $args{order}, $args{direction});
 | 
|---|
 | 268 | 
 | 
|---|
 | 269 |   die $DNSDB::errstr if !$ret;
 | 
|---|
 | 270 | 
 | 
|---|
 | 271 |   return $ret;
 | 
|---|
| [119] | 272 | }
 | 
|---|
 | 273 | 
 | 
|---|
| [123] | 274 | sub getRecCount {
 | 
|---|
 | 275 |   my %args = @_;
 | 
|---|
| [119] | 276 | 
 | 
|---|
| [123] | 277 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 278 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 279 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
 | 280 | 
 | 
|---|
 | 281 |   return DNSDB::getRecCount($dbh, $id);
 | 
|---|
 | 282 | }
 | 
|---|
 | 283 | 
 | 
|---|
| [119] | 284 | sub addRec {
 | 
|---|
 | 285 |   my %args = @_;
 | 
|---|
 | 286 | 
 | 
|---|
 | 287 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 288 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 289 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
| [123] | 290 | 
 | 
|---|
 | 291 |   # note dist, weight, port are not reequired on all types;  will be ignored if not needed.
 | 
|---|
 | 292 |   my ($code, $msg) = DNSDB::addRec($dbh, $args{def}, $args{domid}, $args{host}, $typemap{$args{type}},
 | 
|---|
 | 293 |         $args{val}, $args{ttl}, $args{dist}, $args{weight}, $args{port});
 | 
|---|
 | 294 | 
 | 
|---|
 | 295 |   die $msg if $code eq 'FAIL';
 | 
|---|
| [119] | 296 | }
 | 
|---|
 | 297 | 
 | 
|---|
 | 298 | sub updateRec {
 | 
|---|
 | 299 |   my %args = @_;
 | 
|---|
 | 300 | 
 | 
|---|
 | 301 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 302 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 303 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
| [123] | 304 | 
 | 
|---|
 | 305 |   # note dist, weight, port are not reequired on all types;  will be ignored if not needed.
 | 
|---|
 | 306 |   my ($code, $msg) = DNSDB::updateRec($dbh, $args{def}, $args{recid}, $args{host}, $typemap{$args{type}},
 | 
|---|
 | 307 |         $args{val}, $args{ttl}, $args{dist}, $args{weight}, $args{port});
 | 
|---|
 | 308 | 
 | 
|---|
 | 309 |   die $msg if $code eq 'FAIL';
 | 
|---|
| [119] | 310 | }
 | 
|---|
 | 311 | 
 | 
|---|
 | 312 | sub delRec {
 | 
|---|
 | 313 |   my %args = @_;
 | 
|---|
 | 314 | 
 | 
|---|
 | 315 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 316 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 317 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
| [123] | 318 | 
 | 
|---|
 | 319 |   # note dist, weight, port are not reequired on all types;  will be ignored if not needed.
 | 
|---|
 | 320 |   my ($code, $msg) = DNSDB::delRec($dbh, $args{def}, $args{recid});
 | 
|---|
 | 321 | 
 | 
|---|
 | 322 |   die $msg if $code eq 'FAIL';
 | 
|---|
| [119] | 323 | }
 | 
|---|
 | 324 | 
 | 
|---|
 | 325 | #sub getParents {
 | 
|---|
| [123] | 326 | 
 | 
|---|
 | 327 | sub domStatus {
 | 
|---|
 | 328 |   my %args = @_;
 | 
|---|
 | 329 | 
 | 
|---|
 | 330 |   # Make sure we've got all the local bits we need
 | 
|---|
 | 331 |   die "Missing remote username" if !$args{rpcuser};             # for logging
 | 
|---|
 | 332 |   die "Missing remote system name" if !$args{rpcsystem};        # for logging
 | 
|---|
 | 333 | 
 | 
|---|
 | 334 |   my @arglist = ($dbh, $args{domid});
 | 
|---|
 | 335 |   push @arglist, $args{status} if defined($args{status});
 | 
|---|
 | 336 | 
 | 
|---|
 | 337 |   my $status = DNSDB::domStatus(@arglist);
 | 
|---|
 | 338 | }
 | 
|---|
 | 339 | 
 | 
|---|
| [119] | 340 | #sub importAXFR {
 | 
|---|
 | 341 | #sub export {
 | 
|---|
 | 342 | #sub __export_tiny {
 | 
|---|
 | 343 | 
 | 
|---|
 | 344 | sub get_method_list {
 | 
|---|
 | 345 |   my @methods = keys %{$methods};
 | 
|---|
 | 346 |   return \@methods;
 | 
|---|
 | 347 | }
 | 
|---|