--- sysplogd 2009/04/11 12:17:53 13 +++ sysplogd 2009/04/11 12:59:28 14 @@ -47,7 +47,7 @@ id serial, timestamp timestamp default now(), ip inet not null, - hostname text not null, + hostname text, message text, level int, facility int, @@ -93,7 +93,7 @@ }); my $sth_log_unparsed = $dbh->prepare(qq{ - insert into log (ip,hostname,messsage) values (?,?,?) + insert into log (ip,hostname,message) values (?,?,?) });