[syslog-ng]apache logs, again

Andreas Hasenack andreas@conectiva.com.br
Tue, 8 Oct 2002 11:01:42 -0300


Em Tue, Oct 08, 2002 at 03:53:18PM +0200, Balazs Scheidler escreveu:
> I assume you are using templates to format the time field above
> (2001-12-31), try using 

Yes, I'm using:
template("INSERT INTO logs (host, facility, priority, level, tag, date,
 time, program, msg) VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL', '$TAG',
 '$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM', '$MSG' );\n") template-escape(yes));

> message itself. I'd be curious how 2001-12-31 was generated. If no timestamp
> is included in the message, syslog-ng substitutes the current date (same as
> received stamp)

BTW, this is syslog-ng-1.5.21 with libol-0.3.3.
I'll play with logger a bit more, the first impression I got now was that
this behaviour only occurs when I pipe messages to logger, and not when
putting the message on the command line.