[syslog-ng] oracle db + syslog-ng integration

vijay bhaskarpeddi at gmail.com
Wed Jan 19 07:05:04 CET 2011


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
>
>
>


More information about the syslog-ng mailing list