If you configure a destination for the 'syslog' facility, syslog-ng will use this to spit out its error messages. If something is going wrong with the sql, it'll log it there. Just add a "filter f_syslog { facility(syslog); };" and put it out to a file somewhere (oh, with a source internal() as well).

Sent: Thursday, March 18, 2010 8:42:30 AM
From: yavuz <sakncli@gmail.com>
To: syslog-ng@lists.balabit.hu
Subject: [syslog-ng] Problem with sql destination

Hi all,

I want to insert logs directly to mysql database,
I am using two destinations one is a file(for testing purposes) and the second is sql. Logs are written to file but not sql destination. I couldn't find the problem because don't know where to look.

The configuration file is attached.

thanks in advance.

// ps.
______________________________________________________________________________
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

  