[syslog-ng] syslog-ng remote MSSQL databases

[Balazs Scheidler]

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