Attached is syslog-ng.conf and the script I run. I don't know if anyone else has ever faced the same prob.. Any suggestion .. should I use another db? -----Original Message----- From: syslog-ng-bounces@lists.balabit.hu [mailto:syslog-ng-bounces@lists.balabit.hu] On Behalf Of Balazs Scheidler Sent: Tuesday, July 13, 2010 7:00 PM To: Syslog-ng users' and developers' mailing list Subject: 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 ____________________________________________________________________________ __ Member info: https://lists.balabit.hu/mailman/listinfo/syslog-ng Documentation: http://www.balabit.com/support/documentation/?product=syslog-ng FAQ: http://www.campin.net/syslog-ng/faq.html