MonitorWare Knowledge Base

Hello!
I wondering how to split syslog mesage into fields defined in MySQL Table b y regex.
For exapmle:

* regex for pix log is -
/from \(([\w\-\.]+)\) to ([\w\-\.]+) on interface ([\w\-]+)/
as we can see args $1,$2 is IP and $3 is name of interface.

* additional fields in SQL Table schema :
IPsrc, IPdst, interace.

How to insert regex args $1, $2,$3..$n into Mysql Database?

• Custom written rsyslog.conf?
• Maintenance Contract?
• Installation support?