Hi, There was a patch just recently, which makes syslog-ng to attempt to write a single message to an SQL destination 3 times only, and drops it afterwards. Would that solve your problem? My collegue wrote the patch, I'll ask him to post it here. On Mon, 2010-02-08 at 09:29 -0700, Bob Belnap wrote:
Hello,
I am parsing some of my log messages into different database columns using the sql() function, and I have noticed that when there is an insert error into the database no further logs for that host make it to the db. In fact, syslog-ng keeps attempting the insert, and logs the insert error indefinitely. I couldn't find a way to gracefully handle these sorts of errors in the docs. I'd like to be able to specify an action on a database insert failure (log message to a different log and stop trying to insert, for example). But I do not want a single insert failure to stop all subsequent inserts for that host. What are my options here? I'm currently using OSE 3.0.4.
Thanks for your help.
--Bob ______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html
-- Bazsi