<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#0050d0">
<font size="-1"><font face="Helvetica, Arial, sans-serif">Can you
confirm syslog-ng has sql destinations enabled?<br>
`syslog-ng -V | grep Enable-SQL`<br>
If not, you'll need to recompile it with sql on.<br>
<br>
-Patrick<br>
</font></font><br>
Sent: Tue Jan 18 2011 05:19:08 GMT-0700 (Mountain Standard Time)<br>
From: vijay <a class="moz-txt-link-rfc2396E" href="mailto:bhaskarpeddi@gmail.com"><bhaskarpeddi@gmail.com></a><br>
To: <a class="moz-txt-link-abbreviated" href="mailto:syslog-ng@lists.balabit.hu">syslog-ng@lists.balabit.hu</a> <br>
Subject: [syslog-ng] oracle db + syslog-ng integration
<blockquote
cite="mid:AANLkTi=nOqyeOBPeH=H-v7cPqUKvwjrK_CeZ1JXkScs-@mail.gmail.com"
type="cite">
<pre wrap="">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:
<a class="moz-txt-link-freetext" href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
mailing list: <a class="moz-txt-link-freetext" href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
the line 322 is---------- sql(type(oracle) username("myusername")
password("mypassword")
vijay.p
______________________________________________________________________________
Member info: <a class="moz-txt-link-freetext" href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
Documentation: <a class="moz-txt-link-freetext" href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a class="moz-txt-link-freetext" href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a>
</pre>
</blockquote>
</body>
</html>