28 lines
689 B
Tcsh
28 lines
689 B
Tcsh
#!/bin/tcsh
|
|
#$Id$
|
|
set loop=0
|
|
set host=$2
|
|
if ( ! -e $1 ) then
|
|
exit
|
|
endif
|
|
set count=`wc -l $1 | tr -s " " "\t" | cut -f2`
|
|
while ( $loop != $count )
|
|
set loop=`expr $loop + 1`
|
|
set results=`getline $1 $loop | tr -s " " "\t" | cut -f3,5-`
|
|
set msgtime=`echo $results | tr -s " " "\t" | cut -f1`
|
|
set message=`echo $results | tr -s " " "\t" | cut -f2- | tr "\t" " "`
|
|
echo "insert into TSyslog (facility,severity,date,time,host,message) values (4,21,'8/31/2002','$msgtime','$host','$message');"
|
|
end
|
|
exit
|
|
|
|
|
|
CREATE TABLE TSyslog (
|
|
TSyslog_ID bigserial UNIQUE NOT NULL PRIMARY KEY,
|
|
facility integer,
|
|
severity integer,
|
|
date date,
|
|
time time,
|
|
host varchar(128),
|
|
message text
|
|
)\g
|
|
|