[syslog-ng]Re: question

[Balazs Scheidler]

On Thu, Apr 12, 2001 at 04:03:08PM -0400, Andrew Ryder wrote:
> Any planned support for injection into mysql logs?

you could use the tamplate feature in 1.5.5 and pipes:

destination d_mysql { pipe("/tmp/mysql.pipe" template("INSERT INTO log (date, host) VALUES ('$YEAR-$MONTH-$DAY', '$HOST')\n") template-escape(yes) };

and run mysql client reading sql from the pipe:

mysql -h <host> LOG < /tmp/mysql.pipe

of course the pipe should be located some protected directory with
appropriate permissions.

-- 
Bazsi
PGP info: KeyID 9AF8D0A9 Fingerprint CD27 CFB0 802C 0944 9CFD 804E C82C 8EB1