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.
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
Hi, Did you already check the debug output of syslog-ng? I think if you are starting syslog-ng with "-Fevd" options, you will see the problem. yavuz wrote:
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
-- pzolee
Thanks, there were no installed dbi-drivers in my system, I understand the problem when started syslog-ng with -Fevd, On 18 March 2010 16:59, Zoltán Pallagi <pzolee@balabit.hu> wrote:
Hi,
Did you already check the debug output of syslog-ng? I think if you are starting syslog-ng with "-Fevd" options, you will see the problem.
yavuz wrote:
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
-- pzolee
participants (3)
-
Patrick H.
-
yavuz
-
Zoltán Pallagi