mysql-iptables

mysql-iptables

[George Vieira]

For those of you who were/are interested in the script I'm working called mysql-iptables. I have released a GPL version on Source Forge http://sourceforge.net/projects/mysql-iptables/.

This script gathers any chain you specify and stores the rules into a MySQL database of the same chain name. It increments the byte count so you can generate graphs in MRTG/RRDtool or whatever you like using retrieval commands like you do with iptables itself.. eg.

mysql-iptables -t MRTG -s 192.168.0.1 -p tcp --sport 80

this will return the total byte value for this rule.

a crontab updates the database like so:

*/5 * * * * root mysql-iptables --updatedb
*/5 * * * * root mysql-iptables -t HOSTS --updatedb

Any more questions please forward them to the forums... (once I get the rest up and running ;))


Thanks,
____________________________________________
George Vieira