Can anyone share an example config file for parsing json messages and
outputting them to a custom table (fields),
Pertinent part of config that I've tried:
$ModLoad ommysql
module(load="mmjsonparse")
template(name="StdSQLformat" type="list" option.sql="on") {
constant(value="insert into mylog (bxmsg, level)")
constant(value=" values ('")
property(name="%bxmsg%")
constant(value="', ")
property(name="%level%")
constant(value="')")
}
local0.* action(type="mmjsonparse",template="StdSQLformat")
local0.* :ommysql:127.0.0.1,mydb,myuser,mypass
_______________________________________________
rsyslog mailing list
https://lists.adiscon.net/mailman/listinfo/rsyslog
http://www.rsyslog.com/professional-services/
What's up with rsyslog? Follow https://twitter.com/rgerhards
NOTE WELL: This is a PUBLIC mailing list, posts are ARCHIVED by a myriad of
sites beyond our control. PLEASE UNSUBSCRIBE and DO NOT POST if you DON'T LIKE
THAT.
