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

[Khaleelah Peerbocus]

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 at lists.balabit.hu
[mailto:syslog-ng-bounces at 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

-------------- next part --------------
A non-text attachment was scrubbed...
Name: syslog-ng.conf
Type: application/octet-stream
Size: 6097 bytes
Desc: not available
Url : http://lists.balabit.hu/pipermail/syslog-ng/attachments/20100714/ab3376ca/attachment-0002.obj 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: syslog-ng-mssql-pipe.sh
Type: application/octet-stream
Size: 564 bytes
Desc: not available
Url : http://lists.balabit.hu/pipermail/syslog-ng/attachments/20100714/ab3376ca/attachment-0003.obj