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