1 | #!/usr/bin/perl
|
---|
2 | # ipdb/cgi-bin/newnode.cgi
|
---|
3 | # Add new wifi tower or fibre demarc switch ("node") to database
|
---|
4 | ###
|
---|
5 | # SVN revision info
|
---|
6 | # $Date: 2010-08-04 20:49:53 +0000 (Wed, 04 Aug 2010) $
|
---|
7 | # SVN revision $Rev: 460 $
|
---|
8 | # Last update by $Author: kdeugau $
|
---|
9 | ###
|
---|
10 | # Copyright (C) 2010 - Kris Deugau
|
---|
11 |
|
---|
12 | use strict;
|
---|
13 | use warnings;
|
---|
14 | #use CGI::Carp qw(fatalsToBrowser);
|
---|
15 | use CGI::Simple;
|
---|
16 | use HTML::Template;
|
---|
17 | use DBI;
|
---|
18 | #use CommonWeb qw(:ALL);
|
---|
19 | #use POSIX qw(ceil);
|
---|
20 | use NetAddr::IP;
|
---|
21 | use Sys::Syslog;
|
---|
22 |
|
---|
23 | # don't remove! required for GNU/FHS-ish install from tarball
|
---|
24 | ##uselib##
|
---|
25 |
|
---|
26 | use MyIPDB;
|
---|
27 |
|
---|
28 | openlog "IPDB","pid","$IPDB::syslog_facility";
|
---|
29 |
|
---|
30 | # Collect the username from HTTP auth. If undefined, we're in a test environment.
|
---|
31 | my $authuser;
|
---|
32 | if (!defined($ENV{'REMOTE_USER'})) {
|
---|
33 | $authuser = '__temptest';
|
---|
34 | } else {
|
---|
35 | $authuser = $ENV{'REMOTE_USER'};
|
---|
36 | }
|
---|
37 |
|
---|
38 | # Set up the CGI object...
|
---|
39 | my $q = new CGI::Simple;
|
---|
40 | # ... and get query-string params as well as POST params if necessary
|
---|
41 | $q->parse_query_string;
|
---|
42 |
|
---|
43 | # Convenience; saves changing all references to %webvar
|
---|
44 | ##fixme: tweak for handling <select multiple='y' size=3> (list with multiple selection)
|
---|
45 | my %webvar = $q->Vars;
|
---|
46 |
|
---|
47 | my ($dbh,$errstr) = connectDB_My;
|
---|
48 | my $sth;
|
---|
49 |
|
---|
50 | $ENV{HTML_TEMPLATE_ROOT} = '../templates';
|
---|
51 |
|
---|
52 | my $page = HTML::Template->new(filename => "newnode.tmpl");
|
---|
53 |
|
---|
54 | if ($webvar{nodename}) {
|
---|
55 | $sth = $dbh->prepare("insert into nodes (node_type,node_name,node_ip) values (?,?,?)");
|
---|
56 | $sth->execute($webvar{type}, $webvar{nodename}, $webvar{nodeip});
|
---|
57 | $page->param(nodename => $webvar{nodename});
|
---|
58 | if ($sth->err) {
|
---|
59 | $page->param(err => $sth->errstr);
|
---|
60 | my $msg = "$authuser could not add node '$webvar{nodename}','$webvar{type}' to database: ".$sth->errstr;
|
---|
61 | mailNotify($dbh, 'f:nno', "IPDB node add failure", $msg);
|
---|
62 | syslog "err", $msg;
|
---|
63 | } else {
|
---|
64 | syslog "notice", "$authuser added node '$webvar{nodename}'";
|
---|
65 | }
|
---|
66 | }
|
---|
67 |
|
---|
68 | print "Content-type: text/html\n\n";
|
---|
69 |
|
---|
70 | print $page->output;
|
---|
71 |
|
---|
72 | finish($dbh);
|
---|