Re: [syslog-ng] Pipe() in syslog-ng ---- HELP

On Tue, 2010-07-13 at 15:32 +0400, Khaleelah Peerbocus wrote:

By embedded new line character you mean "\n"?

It is at the end of the query

destination d_mssql { pipe("/tmp/mssql.syslog-ng.pipe" template("INSERT INTO logs(datetime,host,program,pid,message)VALUES('$R_DATE','$HOST','$PROGRAM',' $PID','$MSGONLY');\n") template-escape(yes));

};

log { source(src); filter(f_debug); destination(d_mssql); };

Even if I remove the \n ..it does not work.. it gives the same output..

No, I mean continuing the template string in a new line in your text editor. -- Bazsi