Can you confirm syslog-ng has sql destinations enabled? `syslog-ng -V | grep Enable-SQL` If not, you'll need to recompile it with sql on. -Patrick Sent: Tue Jan 18 2011 05:19:08 GMT-0700 (Mountain Standard Time) From: vijay <bhaskarpeddi@gmail.com> To: syslog-ng@lists.balabit.hu Subject: [syslog-ng] oracle db + syslog-ng integration
hi,
Iam Using syslog-ng 3.0.4.when i used below configuration
destination d_sql { sql(type(oracle) username("myusername") password("mypassword") database("LOGS") table("msgs_${R_YEAR}${R_MONTH}${R_DAY}") columns("datetime varchar(16)", "host varchar(32)", "program varchar(32)", "pid varchar(8)", "message varchar2") values("$R_DATE", "$HOST", "$PROGRAM", "$PID", "$MSGONLY") indexes("datetime", "host", "program", "pid", "message")); };
iam facing error while starting service
syntax error in /usr/local/etc/syslog-ng.conf at line 322. syslog-ng documentation: http://www.balabit.com/support/documentation/?product=syslog-ng mailing list: https://lists.balabit.hu/mailman/listinfo/syslog-ng
the line 322 is---------- sql(type(oracle) username("myusername") password("mypassword")
vijay.p ______________________________________________________________________________ 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