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.