[syslog-ng] syslog-ng remote MSSQL databases

[Bely Silva Junior]

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





-- 
Bely Silva Junior
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.balabit.hu/pipermail/syslog-ng/attachments/20111208/737c633d/attachment.htm