Fail2Ban - Log to mysql

Question

Hi! We have a few servers with SSH public (using sFTP). Obviously, the attacks ar too many.

We want put the banned logs into a MySQL DB for make stats and etc.

Have anyone tryied this?

Thanks

Answer 1

There seems to be no direct way to do this. You will have to write a script to parse the fail2ban logfiles and insert IP's and bantimes into a mysql table. I found one here: http://blog.dp.cx/25/postfix-fail2ban-win