dumperrorlog.proxy.in 1.47 KB
Newer Older
1 2 3
#!/usr/bin/perl -wT
#
# EMULAB-COPYRIGHT
4
# Copyright (c) 2005-2011 University of Utah and the Flux Group.
5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45
# All rights reserved.
#
use English;

#
# usage: dumperrorlog.proxy
#
sub usage() {
    print STDOUT "Usage: dumperrorlog.proxy tablename\n";
    exit(-1);
}
my $tablename;

#
# Configure variables
#
my $PWDFILE   = "/usr/testbed/etc/errorlog.pwd";
my $tempfile  = "testbed_dumperrorlog_tempfile";
my $DBNAME    = "errorlog";
my $DBUSER    = "errorlog";

#
# We don't want to run this script unless its the real version.
#
if ($UID != 0) {
    die("*** $0:\n".
	"    Must be root!\n");
}

# un-taint path
$ENV{'PATH'} = '/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin';
delete @ENV{'IFS', 'CDPATH', 'ENV', 'BASH_ENV'};

#
# Turn off line buffering on output
#
$| = 1;

# Load the Testbed support stuff.
use lib "@prefix@/lib";
use libtestbed;
46
use libtbdb;
47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80

sub fatal($) {
    my ($msg) = @_;

    die("*** $0:\n".
	"    $msg\n");
}

if (@ARGV != 1) {
    usage();
}
$tablename = $ARGV[0];

#
# Untaint the arguments.
#
if ($tablename =~ /^([-\w]+)$/) {
    $tablename = $1;
}
else {
    die("Tainted argument $tablename!\n");
}

#
# Grab the password we need.
#
my $pwd = `cat $PWDFILE`;
if ($pwd =~ /^([\w]*)$/) {
    $pwd = $1;
}
else {
    fatal("Bad characters in password!");
}

81 82
if (TBDBConnect($DBNAME, $DBUSER, $pwd) < 0) {
    fatal("Could not connect to errorlog database!");
83
}
84 85
DBQueryFatal("load data infile '${tempfile}.${tablename}' ".
	     "replace into table $tablename");
86 87
exit(0);