<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#0050d0">
<font size="-1"><font face="Helvetica, Arial, sans-serif">Yes, you will
need the source code for syslog-ng. You will also need the libdbi
package along with libdbi-dbd-oracle. If you can find the libdbi stuff
pre-compiled that will work, otherwise you'll need to compile it too.<br>
<br>
-Patrick<br>
</font></font><br>
Sent: Tue Jan 18 2011 23:05:04 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: Syslog-ng users' and developers' mailing list
<a class="moz-txt-link-rfc2396E" href="mailto:syslog-ng@lists.balabit.hu"><syslog-ng@lists.balabit.hu></a> <br>
Subject: Re: [syslog-ng] oracle db + syslog-ng integration
<blockquote
cite="mid:AANLkTikmzqPe45+xQJszAFQ+VEkLCctcvTyB6dcgg34O@mail.gmail.com"
type="cite">
<pre wrap="">Enable-SQL: off
i taken syslog-ng package from sunfreeware for solaris.
is i have to take source code from balabit and compile.
vijay
On Tue, Jan 18, 2011 at 10:15 PM, Patrick H. <a class="moz-txt-link-rfc2396E" href="mailto:syslogng@feystorm.net"><syslogng@feystorm.net></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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 <a class="moz-txt-link-rfc2396E" href="mailto:bhaskarpeddi@gmail.com"><bhaskarpeddi@gmail.com></a>
To: <a class="moz-txt-link-abbreviated" href="mailto:syslog-ng@lists.balabit.hu">syslog-ng@lists.balabit.hu</a>
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:
<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>
______________________________________________________________________________
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>
<pre wrap=""><!---->______________________________________________________________________________
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>