I have iptables firewall in Linux bridge (RHEL5). I want to extract information like IP address, port number, port type, data and time etc from log message using Bash script and want to upload in mysql database to generate the reports.

How can I do this?? Is there any way to do??

Kind Regards, Jack

I have an iptables firewall in Linux bridge (RHEL5). I want to extract information like IP address, port number, port type, date and time, etc. from log messages using a Bash script, and then want to upload it to a MySQL database to generate the reports.

How can I do this? Is there any way to accomplish the same thing?