source net {udp();};
destination d_mysql {
    pipe("/tmp/mysql.pipe"
    template("INSERT INTO logs (host, facility, priority, level, tag, date,
    time, program, msg) VALUES ( '$HOST', '$FACILITY', '$PRIORITY', '$LEVEL','$TAG',
    '$YEAR-$MONTH-$DAY', '$HOUR:$MIN:$SEC', '$PROGRAM', '$MSG' );\n")
    template-escape(yes));
};

log { source(net); destination(d_mysql);};
!