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.
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.