Hiya,
Here's what
I have, why doesn't it work?
destination d_mysql { pipe("/var/log/mysql.pipe"
template("INSERT INTO logs
(host,
facility, priority, level, datetime, msg)
VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL',
'$YEAR-$MONTH-$DAY $HOUR:$MIN:$SEC','$MSG' );\n") template-esc
destination d_host { pipe("/var/log/mysql.pipe"
template("INSERT INTO host
(host)
VALUES ( '$HOST' ) ON DUPLICATE KEY UPDATE
count=count+1;\n") template-escape(yes)); };
destination d_mysql_facility {
pipe("/var/log/mysql.pipe" template("INSERT IGNORE INTO facility
(facility)
VALUES ( '$FACILITY' );\n") template-escape(yes)); };
# This doesn't work
#log { source(net); destination(d_mysql); destination(d_host);
destination(d_mysql_facility); };
# This works
log { source(net); destination(d_mysql); };