Changeset 487
- Timestamp:
- 03/15/13 12:45:23 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/DNSDB.pm
r485 r487 63 63 ); 64 64 65 @EXPORT = (); # Export nothing by default.65 @EXPORT = qw(%typemap %reverse_typemap %permissions @permtypes $permlist %permchains); 66 66 %EXPORT_TAGS = ( ALL => [qw( 67 67 &initGlobals &login &initActionLog … … 1697 1697 $resultmsg = "Updated default permissions for group $name"; 1698 1698 } 1699 _log($dbh, (group_id => ($type eq 'user' ? $parid : $id), entry => $resultmsg));1699 $self->_log(group_id => ($type eq 'user' ? $parid : $id), entry => $resultmsg); 1700 1700 $dbh->commit; 1701 1701 }; # end eval … … 1787 1787 $dbh->do("UPDATE $par_tbl{$type} SET group_id=? WHERE $id_col{$type}=?", undef, ($newgrp, $id)); 1788 1788 # Log the change in both the old and new groups 1789 _log($dbh, (group_id => $oldgid, entry => "Moved $type $entname from $oldgname to $newgname"));1790 _log($dbh, (group_id => $newgrp, entry => "Moved $type $entname from $oldgname to $newgname"));1789 $self->_log(group_id => $oldgid, entry => "Moved $type $entname from $oldgname to $newgname"); 1790 $self->_log(group_id => $newgrp, entry => "Moved $type $entname from $oldgname to $newgname"); 1791 1791 $dbh->commit; 1792 1792 }; … … 1795 1795 eval { $dbh->rollback; }; 1796 1796 if ($config{log_failures}) { 1797 _log($dbh, (group_id => $oldgid, entry => "Error moving $type $entname to $newgname: $msg"));1797 $self->_log(group_id => $oldgid, entry => "Error moving $type $entname to $newgname: $msg"); 1798 1798 $dbh->commit; # since we enabled transactions earlier 1799 1799 } … … 1858 1858 undef, ($domain)); 1859 1859 1860 _log($dbh,(domain_id => $dom_id, group_id => $group,1861 entry => "Added ".($state ? 'active' : 'inactive')." domain $domain") );1860 $self->_log(domain_id => $dom_id, group_id => $group, 1861 entry => "Added ".($state ? 'active' : 'inactive')." domain $domain"); 1862 1862 1863 1863 # ... and now we construct the standard records from the default set. NB: group should be variable. … … 1873 1873 my @tmp1 = split /:/, $host; 1874 1874 my @tmp2 = split /:/, $val; 1875 _log($dbh,(domain_id => $dom_id, group_id => $group,1875 $self->_log(domain_id => $dom_id, group_id => $group, 1876 1876 entry => "[new $domain] Added SOA record [contact $tmp1[0]] [master $tmp1[1]] ". 1877 "[refresh $tmp2[0]] [retry $tmp2[1]] [expire $tmp2[2]] [minttl $tmp2[3]], TTL $ttl") );1877 "[refresh $tmp2[0]] [retry $tmp2[1]] [expire $tmp2[2]] [minttl $tmp2[3]], TTL $ttl"); 1878 1878 } else { 1879 1879 my $logentry = "[new $domain] Added record '$host $typemap{$type}"; 1880 1880 $logentry .= " [distance $dist]" if $typemap{$type} eq 'MX'; 1881 1881 $logentry .= " [priority $dist] [weight $weight] [port $port]" if $typemap{$type} eq 'SRV'; 1882 _log($dbh,(domain_id => $dom_id, group_id => $group,1883 entry => $logentry." $val', TTL $ttl") );1882 $self->_log(domain_id => $dom_id, group_id => $group, 1883 entry => $logentry." $val', TTL $ttl"); 1884 1884 } 1885 1885 } … … 1892 1892 my $msg = $@; 1893 1893 eval { $dbh->rollback; }; 1894 _log($dbh, (group_id => $group, entry => "Failed adding domain $domain ($msg)"))1894 $self->_log(group_id => $group, entry => "Failed adding domain $domain ($msg)") 1895 1895 if $config{log_failures}; 1896 1896 $dbh->commit; # since we enabled transactions earlier … … 1962 1962 $msg = "Deleted ".($revrec eq 'n' ? 'domain' : 'reverse zone')." $zone"; 1963 1963 $loghash{entry} = $msg; 1964 _log($dbh,%loghash);1964 $self->_log(%loghash); 1965 1965 1966 1966 # once we get here, we should have suceeded. … … 1973 1973 $loghash{entry} = "Error deleting $zone: $msg ($failmsg)"; 1974 1974 if ($config{log_failures}) { 1975 _log($dbh,%loghash);1975 $self->_log(%loghash); 1976 1976 $dbh->commit; # since we enabled transactions earlier 1977 1977 } … … 2089 2089 ($rdns_id) = $dbh->selectrow_array("SELECT currval('revzones_rdns_id_seq')"); 2090 2090 2091 _log($dbh,(rdns_id => $rdns_id, group_id => $group,2092 entry => "Added ".($state ? 'active' : 'inactive')." reverse zone $zone") );2091 $self->_log(rdns_id => $rdns_id, group_id => $group, 2092 entry => "Added ".($state ? 'active' : 'inactive')." reverse zone $zone"); 2093 2093 2094 2094 # ... and now we construct the standard records from the default set. NB: group should be variable. … … 2154 2154 my @tmp1 = split /:/, $host; 2155 2155 my @tmp2 = split /:/, $val; 2156 _log($dbh,(rdns_id => $rdns_id, group_id => $group,2156 $self->_log(rdns_id => $rdns_id, group_id => $group, 2157 2157 entry => "[new $zone] Added SOA record [contact $tmp1[0]] [master $tmp1[1]] ". 2158 "[refresh $tmp2[0]] [retry $tmp2[1]] [expire $tmp2[2]] [minttl $tmp2[3]], TTL $ttl") );2158 "[refresh $tmp2[0]] [retry $tmp2[1]] [expire $tmp2[2]] [minttl $tmp2[3]], TTL $ttl"); 2159 2159 $defttl = $tmp2[3]; 2160 2160 } else { 2161 2161 my $logentry = "[new $zone] Added record '$host $typemap{$type} $val', TTL $ttl"; 2162 2162 $logentry .= ", default location ".$self->getLoc($defloc)->{description} if $defloc; 2163 _log($dbh, (rdns_id => $rdns_id, domain_id => $domid, group_id => $group, entry => $logentry));2163 $self->_log(rdns_id => $rdns_id, domain_id => $domid, group_id => $group, entry => $logentry); 2164 2164 } 2165 2165 } … … 2183 2183 $sth_in->execute($domid,$host,$type,$val,$defttl,$defloc); 2184 2184 my $logentry = "[new $zone] Added record '$host $typemap{$type}"; 2185 _log($dbh,(rdns_id => $rdns_id, domain_id => $domid, group_id => $group,2186 entry => $logentry." $val', TTL $defttl from pattern") );2185 $self->_log(rdns_id => $rdns_id, domain_id => $domid, group_id => $group, 2186 entry => $logentry." $val', TTL $defttl from pattern"); 2187 2187 } 2188 2188 2189 2189 # If there are warnings (presumably about default records skipped for cause) log them 2190 _log($dbh, (rdns_id => $rdns_id, group_id => $group, entry => "Warning(s) adding $zone:$warnstr"))2190 $self->_log(rdns_id => $rdns_id, group_id => $group, entry => "Warning(s) adding $zone:$warnstr") 2191 2191 if $warnstr; 2192 2192 … … 2198 2198 my $msg = $@; 2199 2199 eval { $dbh->rollback; }; 2200 _log($dbh, (group_id => $group, entry => "Failed adding reverse zone $zone ($msg)"))2200 $self->_log(group_id => $group, entry => "Failed adding reverse zone $zone ($msg)") 2201 2201 if $config{log_failures}; 2202 2202 $dbh->commit; # since we enabled transactions earlier … … 2411 2411 } 2412 2412 2413 _log($dbh, (group_id => $pargroup, entry => "Added group $groupname"));2413 $self->_log(group_id => $pargroup, entry => "Added group $groupname"); 2414 2414 2415 2415 # once we get here, we should have suceeded. … … 2421 2421 eval { $dbh->rollback; }; 2422 2422 if ($config{log_failures}) { 2423 _log($dbh, (group_id => $pargroup, entry => "Failed to add group $groupname: $msg"));2423 $self->_log(group_id => $pargroup, entry => "Failed to add group $groupname: $msg"); 2424 2424 $dbh->commit; 2425 2425 } … … 2474 2474 $dbh->do("DELETE from groups WHERE group_id=?", undef, ($groupid)); 2475 2475 2476 _log($dbh, (group_id => $parid, entry => "Deleted group $groupname"));2476 $self->_log(group_id => $parid, entry => "Deleted group $groupname"); 2477 2477 $resultmsg = "Deleted group $groupname"; 2478 2478 … … 2485 2485 eval { $dbh->rollback; }; 2486 2486 if ($config{log_failures}) { 2487 _log($dbh, (group_id => $parid, entry => "$failmsg: $msg"));2487 $self->_log(group_id => $parid, entry => "$failmsg: $msg"); 2488 2488 $dbh->commit; # since we enabled transactions earlier 2489 2489 } … … 2757 2757 ##fixme: add another table to hold name/email for log table? 2758 2758 2759 _log($dbh, (group_id => $group, entry => "Added user $username ($fname $lname)"));2759 $self->_log(group_id => $group, entry => "Added user $username ($fname $lname)"); 2760 2760 # once we get here, we should have suceeded. 2761 2761 $dbh->commit; … … 2766 2766 eval { $dbh->rollback; }; 2767 2767 if ($config{log_failures}) { 2768 _log($dbh, (group_id => $group, entry => "Error adding user $username: $msg"));2768 $self->_log(group_id => $group, entry => "Error adding user $username: $msg"); 2769 2769 $dbh->commit; # since we enabled transactions earlier 2770 2770 } … … 2918 2918 " WHERE user_id=?", undef, ($username, $pass, $fname, $lname, $phone, $type, $state, $uid)); 2919 2919 $resultmsg = "Updated user info for $username ($fname $lname)"; 2920 _log($dbh,group_id => $group, entry => $resultmsg);2920 $self->_log(group_id => $group, entry => $resultmsg); 2921 2921 $dbh->commit; 2922 2922 }; … … 2925 2925 eval { $dbh->rollback; }; 2926 2926 if ($config{log_failures}) { 2927 _log($dbh, (group_id => $group, entry => "Error updating user $username: $msg"));2927 $self->_log(group_id => $group, entry => "Error updating user $username: $msg"); 2928 2928 $dbh->commit; # since we enabled transactions earlier 2929 2929 } … … 2955 2955 eval { 2956 2956 $dbh->do("DELETE FROM users WHERE user_id=?", undef, ($userid)); 2957 _log($dbh,(group_id => $userdata->{group_id},2957 $self->_log(group_id => $userdata->{group_id}, 2958 2958 entry => "Deleted user ID $userid/".$userdata->{username}. 2959 " (".$userdata->{firstname}." ".$userdata->{lastname}.")") );2959 " (".$userdata->{firstname}." ".$userdata->{lastname}.")"); 2960 2960 $dbh->commit; 2961 2961 }; … … 2964 2964 eval { $dbh->rollback; }; 2965 2965 if ($config{log_failures}) { 2966 _log($dbh,(group_id => $userdata->{group_id}, entry => "Error deleting user ID ".2967 "$userid/".$userdata->{username}.": $msg") );2966 $self->_log(group_id => $userdata->{group_id}, entry => "Error deleting user ID ". 2967 "$userid/".$userdata->{username}.": $msg"); 2968 2968 $dbh->commit; 2969 2969 } … … 3034 3034 $loghash{group_id} = $self->parentID(id => $id, type => 'user'); 3035 3035 $loghash{entry} = $resultstr; 3036 _log($dbh,%loghash);3036 $self->_log(%loghash); 3037 3037 3038 3038 $dbh->commit; … … 3130 3130 $dbh->do("INSERT INTO locations (location, group_id, iplist, description, comments) VALUES (?,?,?,?,?)", 3131 3131 undef, ($loc, $grp, $iplist, $shdesc, $comments) ); 3132 _log($dbh,entry => "Added location ($shdesc, '$iplist')");3132 $self->_log(entry => "Added location ($shdesc, '$iplist')"); 3133 3133 $dbh->commit; 3134 3134 }; … … 3138 3138 if ($config{log_failures}) { 3139 3139 $shdesc = $loc if !$shdesc; 3140 _log($dbh, (entry => "Failed adding location ($shdesc, '$iplist'): $msg"));3140 $self->_log(entry => "Failed adding location ($shdesc, '$iplist'): $msg"); 3141 3141 $dbh->commit; 3142 3142 } … … 3177 3177 $dbh->do("UPDATE locations SET group_id=?,iplist=?,description=?,comments=? WHERE location=?", 3178 3178 undef, ($grp, $iplist, $shdesc, $comments, $loc) ); 3179 _log($dbh,entry => $okmsg);3179 $self->_log(entry => $okmsg); 3180 3180 $dbh->commit; 3181 3181 }; … … 3185 3185 if ($config{log_failures}) { 3186 3186 $shdesc = $loc if !$shdesc; 3187 _log($dbh, (entry => "Failed updating location ($shdesc, '$iplist'): $msg"));3187 $self->_log(entry => "Failed updating location ($shdesc, '$iplist'): $msg"); 3188 3188 $dbh->commit; 3189 3189 } … … 3216 3216 die "Records still exist in location $olddesc\n" if $r; 3217 3217 $dbh->do("DELETE FROM locations WHERE location=?", undef, ($loc) ); 3218 _log($dbh,entry => $okmsg);3218 $self->_log(entry => $okmsg); 3219 3219 $dbh->commit; 3220 3220 }; … … 3223 3223 eval { $dbh->rollback; }; 3224 3224 if ($config{log_failures}) { 3225 _log($dbh, (entry => "Failed to delete location ($olddesc, '$oldloc->{iplist}'): $msg"));3225 $self->_log(entry => "Failed to delete location ($olddesc, '$oldloc->{iplist}'): $msg"); 3226 3226 $dbh->commit; 3227 3227 } … … 3418 3418 3419 3419 $logdata{entry} = $msg; 3420 _log($dbh,%logdata);3420 $self->_log(%logdata); 3421 3421 3422 3422 $dbh->commit; … … 3428 3428 "SOA record for $parname: $msg"; 3429 3429 if ($config{log_failures}) { 3430 _log($dbh,%logdata);3430 $self->_log(%logdata); 3431 3431 $dbh->commit; 3432 3432 } … … 3683 3683 $dbh->do("INSERT INTO "._rectable($defrec, $revrec)." ($fields) VALUES ($vallen)", 3684 3684 undef, @vallist); 3685 _log($dbh,%logdata);3685 $self->_log(%logdata); 3686 3686 $dbh->commit; 3687 3687 }; … … 3692 3692 $logdata{entry} = "Failed adding ".($defrec eq 'y' ? 'default ' : ''). 3693 3693 "record '$$host $typemap{$$rectype} $$val', TTL $ttl ($msg)"; 3694 _log($dbh,%logdata);3694 $self->_log(%logdata); 3695 3695 $dbh->commit; 3696 3696 } … … 3863 3863 eval { 3864 3864 $dbh->do("UPDATE "._rectable($defrec,$revrec)." SET $fields WHERE record_id=?", undef, (@vallist, $id) ); 3865 _log($dbh,%logdata);3865 $self->_log(%logdata); 3866 3866 $dbh->commit; 3867 3867 }; … … 3872 3872 $logdata{entry} = "Failed updating ".($defrec eq 'y' ? 'default ' : ''). 3873 3873 "record '$oldrec->{host} $typemap{$oldrec->{type}} $oldrec->{val}', TTL $oldrec->{ttl} ($msg)"; 3874 _log($dbh,%logdata);3874 $self->_log(%logdata); 3875 3875 $dbh->commit; 3876 3876 } … … 3974 3974 eval { 3975 3975 my $sth = $dbh->do("DELETE FROM "._rectable($defrec,$revrec)." WHERE record_id=?", undef, ($id)); 3976 _log($dbh,%logdata);3976 $self->_log(%logdata); 3977 3977 $dbh->commit; 3978 3978 }; … … 3983 3983 $logdata{entry} = "Error deleting ".($defrec eq 'y' ? 'default record' : 'record'). 3984 3984 " '$oldrec->{host} $typemap{$oldrec->{type}} $oldrec->{val}', TTL $oldrec->{ttl} ($msg)"; 3985 _log($dbh,%logdata);3985 $self->_log(%logdata); 3986 3986 $dbh->commit; 3987 3987 } … … 4304 4304 $loghash{group_id} = $self->parentID(id => $id, type => ($revrec eq 'n' ? 'domain' : 'revzone'), revrec => $revrec); 4305 4305 $loghash{entry} = $resultstr; 4306 _log($dbh,%loghash);4306 $self->_log(%loghash); 4307 4307 4308 4308 $dbh->commit; … … 4471 4471 ($zone_id) = $dbh->selectrow_array("SELECT currval('domains_domain_id_seq')"); 4472 4472 $domain_id = $zone_id; 4473 _log($dbh,(group_id => $group, domain_id => $domain_id,4474 entry => "[Added ".($ status ? 'active' : 'inactive')." domain $zone via AXFR]"));4473 $self->_log(group_id => $group, domain_id => $domain_id, 4474 entry => "[Added ".($args{status} ? 'active' : 'inactive')." domain $zone via AXFR]"); 4475 4475 } else { 4476 4476 ##fixme: serial … … 4480 4480 ($zone_id) = $dbh->selectrow_array("SELECT currval('revzones_rdns_id_seq')"); 4481 4481 $rdns_id = $zone_id; 4482 _log($dbh,(group_id => $group, rdns_id => $rdns_id,4483 entry => "[Added ".($ status ? 'active' : 'inactive')." reverse zone $cidr via AXFR]"));4482 $self->_log(group_id => $group, rdns_id => $rdns_id, 4483 entry => "[Added ".($args{status} ? 'active' : 'inactive')." reverse zone $cidr via AXFR]"); 4484 4484 } 4485 4485 … … 4649 4649 ($domain_id, $ettl, $etype, $erid)); 4650 4650 $nrecs++; 4651 _log($dbh, (group_id => $group, domain_id => $domain_id, rdns_id => $erdns, entry => $logentry));4651 $self->_log(group_id => $group, domain_id => $domain_id, rdns_id => $erdns, entry => $logentry); 4652 4652 next; # while axfr_next 4653 4653 } … … 4671 4671 ($rdns_id, $ettl, $etype, $erid)); 4672 4672 $nrecs++; 4673 _log($dbh, (group_id => $group, domain_id => $domid, rdns_id => $rdns_id, entry => $logentry));4673 $self->_log(group_id => $group, domain_id => $domid, rdns_id => $rdns_id, entry => $logentry); 4674 4674 next; # while axfr_next 4675 4675 } … … 4698 4698 $logentry .= " $val', TTL $ttl"; 4699 4699 } 4700 _log($dbh, (group_id => $group, domain_id => $domain_id, rdns_id => $rdns_id, entry => $logentry));4700 $self->_log(group_id => $group, domain_id => $domain_id, rdns_id => $rdns_id, entry => $logentry); 4701 4701 4702 4702 } # while axfr_next
Note:
See TracChangeset
for help on using the changeset viewer.