dumperrorlog.proxy.in 1.59 KB
Newer Older
1 2 3 4 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 46 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 81 82 83 84 85 86 87 88 89 90 91 92 93 94
#!/usr/bin/perl -wT
#
# EMULAB-COPYRIGHT
# Copyright (c) 2005 University of Utah and the Flux Group.
# All rights reserved.
#
use English;
use Mysql;

#
# 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;

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!");
}

my $DB = Mysql->connect('localhost', $DBNAME, $DBUSER, $pwd);

fatal("Could not connect to errorlog DB!")
    if (!defined($DB));

my $query_result =
    $DB->query("load data infile '${tempfile}.${tablename}' ".
	       "replace into table $tablename");

if (! defined($query_result)) {
    fatal("DB Error: " . $DB->errstr . "\n");
}
exit(0);