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