diff options
Diffstat (limited to 'web/api/read')
-rwxr-xr-x | web/api/read/networks | 26 | ||||
-rwxr-xr-x | web/api/read/oplog | 36 | ||||
-rwxr-xr-x | web/api/read/snmp | 30 | ||||
-rwxr-xr-x | web/api/read/switches-management | 52 | ||||
-rwxr-xr-x | web/api/read/template-list | 21 |
5 files changed, 0 insertions, 165 deletions
diff --git a/web/api/read/networks b/web/api/read/networks deleted file mode 100755 index 0fbdb15..0000000 --- a/web/api/read/networks +++ /dev/null @@ -1,26 +0,0 @@ -#! /usr/bin/perl -# vim:ts=8:sw=8 - -use CGI qw(fatalsToBrowser); -use DBI; -use lib '/opt/gondul/include'; -use nms; -use nms::web; -use strict; -use warnings; -use Data::Dumper; - -$nms::web::cc{'max-age'} = "5"; -$nms::web::cc{'stale-while-revalidate'} = "30"; - -my $q2 = $nms::web::dbh->prepare('select name, vlan, networks.tags, switches.sysname as router, subnet4, subnet6, gw4, gw6 from networks left join switches on switches.switch = networks.router'); - -$q2->execute(); -while (my $ref = $q2->fetchrow_hashref()) { - my $name = $ref->{'name'}; - $nms::web::json{'networks'}{$ref->{'name'}} = $ref; - my $data = JSON::XS::decode_json($ref->{'tags'}); - $nms::web::json{'networks'}{$ref->{'name'}}{'tags'} = $data; -} - -finalize_output(); diff --git a/web/api/read/oplog b/web/api/read/oplog deleted file mode 100755 index 22e21ac..0000000 --- a/web/api/read/oplog +++ /dev/null @@ -1,36 +0,0 @@ -#! /usr/bin/perl -# vim:ts=8:sw=8 - -use lib '/opt/gondul/include'; -use nms::web; -use strict; -use warnings; - -my $filter = ''; - -if (defined($get_params{'now'})) { - $filter = "where time < timestamp with time zone 'epoch' + " . db_safe_quote('now') . " * INTERVAL '1 second' "; -} -my $query = $nms::web::dbh->prepare('select id,date_trunc(\'second\',time) as timestamp,extract(hour from time) as h, extract(minute from time) as m,systems,username,log from oplog ' - . $filter . -'order by id desc;'); -$query->execute(); -while (my $ref = $query->fetchrow_hashref()) { - my %meh; - if (!defined($ref->{'log'})) { - next; - } - $meh{'time'} = $ref->{'h'} . ":" . $ref->{'m'}; - $meh{'log'} = $ref->{'log'} || "weird?"; - $meh{'username'} = $ref->{'username'} || "undefined"; - $meh{'id'} = $ref->{'id'}; - $meh{'systems'} = $ref->{'systems'}; - $meh{'timestamp'} = $ref->{'timestamp'}; - $meh{'timestamp'} =~ s/ /T/; - $meh{'timestamp'} =~ s/\+00$/Z/; - $meh{'timestamp'} =~ s/\+(\d\d)$/+$1:00/; - - push @{$nms::web::json{'oplog'}},\%meh; -} - -nms::web::finalize_output(); diff --git a/web/api/read/snmp b/web/api/read/snmp deleted file mode 100755 index 0865107..0000000 --- a/web/api/read/snmp +++ /dev/null @@ -1,30 +0,0 @@ -#! /usr/bin/perl -# vim:ts=8:sw=8 - -use CGI qw(fatalsToBrowser); -use DBI; -use lib '/opt/gondul/include'; -use nms; -use nms::web; -use strict; -use warnings; -use JSON; -use Data::Dumper; - -$nms::web::cc{'max-age'} = "10"; - -my $q = $nms::web::dbh->prepare('select sysname,data from snmp natural join switches where id in (select max(id) from snmp where ' - . $nms::web::when . 'group by switch);'); - -$q->execute(); -while (my $ref = $q->fetchrow_hashref()) { - my $sysname = $ref->{'sysname'}; - - # This is, strictly speaking, redundant. But by doing this, we can - # re-use the standard methods of finalize_output() and whatnot. - my $data = JSON::XS::decode_json($ref->{'data'}); - - $nms::web::json{'snmp'}{$ref->{'sysname'}} = $data; -} - -finalize_output(); diff --git a/web/api/read/switches-management b/web/api/read/switches-management deleted file mode 100755 index 118ea4d..0000000 --- a/web/api/read/switches-management +++ /dev/null @@ -1,52 +0,0 @@ -#! /usr/bin/perl -# vim:ts=8:sw=8 - -use CGI qw(fatalsToBrowser); -use DBI; -use lib '/opt/gondul/include'; -use nms; -use nms::web; -use strict; -use warnings; -use Data::Dumper; - -my $target = $ENV{REQUEST_URI}; -$target =~ s/$ENV{SCRIPT_NAME}//; -$target =~ s/^\///; -my $switch; -my $port; - -if ($target !~ m/now=/) { - ($switch, $port) = split(/\//,$target,2); -} - -my $q2; - -$nms::web::cc{'max-age'} = "5"; -$nms::web::cc{'stale-while-revalidate'} = "30"; - -my $limit = ''; -if (defined($switch)) { - $limit = ' and sysname = ' . $nms::web::dbh->quote($switch); -} - -$q2 = $nms::web::dbh->prepare("select - switches.sysname, - host(switches.mgmt_v4_addr) as mgmt_v4_addr, - host(switches.mgmt_v6_addr) as mgmt_v6_addr, - switches.mgmt_vlan, - switches.traffic_vlan, - switches.poll_frequency, - switches.last_updated, - switches.distro_name, - switches.distro_phy_port, - switches.community - from switches where switches.placement is not null and switches.deleted = false $limit;"); - -$q2->execute(); -while (my $ref = $q2->fetchrow_hashref()) { - my $sysname = $ref->{'sysname'}; - $nms::web::json{'switches'}{$ref->{'sysname'}} = $ref; -} - -finalize_output(); diff --git a/web/api/read/template-list b/web/api/read/template-list deleted file mode 100755 index 81b9986..0000000 --- a/web/api/read/template-list +++ /dev/null @@ -1,21 +0,0 @@ -#! /usr/bin/perl -# vim:ts=8:sw=8 - -use lib '/opt/gondul/include'; -use nms::web; -use strict; -use warnings; - -my @dirs = ("/opt/gondul/web/templates","/opt/gondul/data/templates"); - -foreach my $template_dir (@dirs) { -opendir (DIR, $template_dir) or next; -while (my $file = readdir(DIR)) { - next if ($file =~ m/^\./); - my %meh; - $meh{'file'} = $file; - - push @{$nms::web::json{'templates'}},\%meh; -} -} -nms::web::finalize_output(); |