Monitor mysql-error.log / added iptables to block ip

iptables_mysql.py

#!/usr/bin/env python
# -*- coding: utf8 -*-
import re
from subprocess import call

path = "/var/log/mysql/"
log = "error.log"

logContents = ""
excludeText = "localhost ....."

with open("{}{}".format(path,log)) as f:
    logContents = f.read()

extractedIP = {}
for ip in re.findall( r'\'?\'@\'[0-9]+(?:\.[0-9]+){3}\'', logContents):
    ip = ip.replace('@','').replace('\'','')
    try:
        if type(extractedIP[ip]):
            extractedIP[ip] = extractedIP[ip] + 1
    except:
        extractedIP[ip] = 1

for index in extractedIP:
    if extractedIP[index] > 2 and index not in excludeText:
        call("iptables -A INPUT -s {} -j DROP".format(index), shell=True)

call("iptables-save > /opt/iptables.backup", shell=True)
print "Done"