Changeset 28
- Timestamp:
- 02/27/03 16:09:17 (10 years ago)
- Files:
-
- trunk/mylogger.pm (modified) (2 diffs)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
trunk/mylogger.pm
r23 r28 3 3 package mylogger; 4 4 5 use DBI;5 #use DBI; 6 6 use POSIX; 7 7 use vars qw/$dbh $sth/; … … 11 11 my $group = shift; 12 12 my $message = shift; 13 chomp($message); 13 14 14 $dbh ||= DBI->connect("DBI:mysql:database=weblogs", "logger", "", { RaiseError => 0 });15 warn "DBI->connect failed." unless($dbh);16 if($dbh) {17 $sth ||= $dbh->prepare(q{INSERT INTO logs (host, domain, timestamp, data) VALUES(?,?,?,?)});18 }15 # $dbh ||= DBI->connect("DBI:mysql:database=weblogs", "logger", "", { RaiseError => 0 }); 16 # warn "DBI->connect failed." unless($dbh); 17 # if($dbh) { 18 # $sth ||= $dbh->prepare(q{INSERT INTO logs (host, domain, timestamp, data) VALUES(?,?,?,?)}); 19 # } 19 20 20 21 my ($user, $host) = ($sender =~ /#([^#]+)#([^#]+)/); 21 22 my ($time) = ($message =~ /\[([^\]]+)\]/); 22 23 $time ||= stftime("%d/%b/%Y:%H:%M:%S %z", localtime(time)); 23 $sth && $sth->execute($host, $group, $time, $message);24 # $sth && $sth->execute($host, $group, $time, $message); 24 25 print STDERR "Insert($host, $group, $time, $message);\n"; 25 26 }
