Re: [syslog-ng] syslog-ng remote MSSQL databases

On Thu, 2011-12-08 at 11:09 -0300, Bely Silva Junior wrote:
> dear Srs
>
> I need configure syslog-ng insert data on remote MSSQL database, it's
> possible ?
>
> my conf:
>
> destination d_mssql {
> sql(type(mssql) host("ipaddres") port("1433") username("syslogng")
> password("password") database("syslogng")
> table("logs")
> columns("datetime varchar(16)","host varchar(32)" ,"program
> varchar(32)","pid varchar(8)","message varchar(4096)")
> values("$R_DATE", "$HOST", "$PROGRAM", "$PID", "$MSGONLY")
> indexes()
> );
> };
>
>
>
> I had error when restart syslog-ng say : syntax erro

Newer syslog-ng's have better error reporting, however since your
declaration seems to be ok (it did start up with my syslog-ng), it seems
likely that your syslog-ng binary lacks SQL support.

Can you check what syslog-ng --version output looks like?

-- Bazsi ______________________________________________________________________________ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.balabit.com/wiki/syslog-ng-faq

• This message: [ Message body ]
• Next message: Balazs Scheidler: "Re: [syslog-ng] Minimum Syslog Message Length"
• Previous message: Balazs Scheidler: "Re: [syslog-ng] Invalid frame header messages"
• In reply to: Bely Silva Junior: "[syslog-ng] syslog-ng remote MSSQL databases"

• Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ]