[syslog-ng] handling errors with sql inserts

[Balazs Scheidler]

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