would the normalize process allow me to break the message apart to insert fields from the message into a table?
________________________________ From: rsyslog <rsyslog-boun...@lists.adiscon.com> on behalf of David Lang <da...@lang.hm> Sent: Wednesday, August 29, 2018 6:16:07 PM To: rsyslog-users Subject: Re: [rsyslog] template to parse file and save to database On Wed, 29 Aug 2018, Jason Prouty wrote: > I am trying to use the msg contains: > > directive to log a specific firewall policy message to a database > > would this be best to do in a template no, all a template does is format the message. > currently I have it going to a flat file but I cannot seem to get it to log > to a mysql database > > :msg, contains, "policy_id=xxxx" /var/log/policyidxxx.log so what you need to do is to look up the output module to put logs into your database and replace the file output with the database insertion. David Lang _______________________________________________ rsyslog mailing list http://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. _______________________________________________ rsyslog mailing list http://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.