Hi Yves,
Just remove the \; at the end of that line.
Why are you logging to a file?
You could log to a FIFO pipe and insert it into the db, look at the
docs/unix/syslog-ng.conf file.
Javier
MOYA Yves wrote:
> Hello,
>
> My syslog-ng create log with ";" char. Did somebody know how to modify
> the template to de-specialize this char?
>
> destination d_postgres {
> file("/spooldir/syslog2pgsql/fulllog.$YEAR.$MONTH.$DAY.$HOUR.$MIN.$SEC"
> template("INSERT INTO syslog \(date, date_logged, host, message\) VALUES
> \('$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC', NOW\(\), $FULLHOST',
> '$MSG'\)\;\n")
> }
>
> I have ";" char in $MSG
>
> Thanks for the help :)
>
> Yves
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by Yahoo.
> Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
> Search APIs Find out how you can build Yahoo! directly into your own
> Applications - visit http://developer.yahoo.net/?fr=fad-ysdn-ostg-q22005
> _______________________________________________
> jffnms-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/jffnms-users
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Javier Szyszlican, Project Leader, JFFNMS
[EMAIL PROTECTED]
I hope JFFNMS or I were helpful to you, if you
can, please donate at http://jffnms.org/donate
-------------------------------------------------------
This SF.Net email is sponsored by Yahoo.
Introducing Yahoo! Search Developer Network - Create apps using Yahoo!
Search APIs Find out how you can build Yahoo! directly into your own
Applications - visit http://developer.yahoo.net/?fr=offad-ysdn-ostg-q22005
_______________________________________________
jffnms-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jffnms-users