[syslog-ng]syslog-ng

[Michael Earls]

the ver of syslog-ng 1.5.15, does it support templates?  i can not
get this line to work in this ver,,
 
## Log syslog-ng to mysql database 
                       
            ##           
                     
                       
                destination d_mysql {
                       
                   
pipe("/tmp/mysql.pipe"
                       
                   
template("INSERT INTO logs (host, facility, priority, level, tag, date,

                       
                    time,
program, msg) VALUES ( '$HOST', '$FACILILITY', '$PRIORITY', '$LEVEL',
'$TAG', 
                       
                   
'$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM', '$MSG' );\n")
template-escape(yes));
                       
                     };
                       
                log { source(net);
destination(d_mysql);
                       
                };


 
is there a debug mode and where does that debug file go?
 
thanks
 
michael