[syslog-ng] oracle db + syslog-ng integration
Patrick H.
syslogng at feystorm.net
Wed Jan 19 16:58:20 CET 2011
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.
-Patrick
Sent: Tue Jan 18 2011 23:05:04 GMT-0700 (Mountain Standard Time)
From: vijay <bhaskarpeddi at gmail.com>
To: Syslog-ng users' and developers' mailing list
<syslog-ng at lists.balabit.hu>
Subject: Re: [syslog-ng] oracle db + syslog-ng integration
> 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. <syslogng at feystorm.net> wrote:
>
>> 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 at gmail.com>
>> To: syslog-ng at 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
>>
>>
>>
>> ______________________________________________________________________________
>> 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
>>
>>
>>
>>
> ______________________________________________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20110119/c92eead6/attachment.htm
More information about the syslog-ng
mailing list