lazy script for blocking against ssh attack

deny.sh

#!/bin/sh
tbl=deny.sqlite3
log=/var/log/auth.log

sqlite3 $tbl 'create table if not exists hosts (ipaddr varchar(255) primary key);'

for addr in $(grep Invalid $log | awk '{print $10}' | sort | uniq)
do
    sqlite3 deny.sqlite3 "insert or ignore into hosts values ('$addr')"
done

sqlite3 deny.sqlite3 "select 'sshd: ' || ipaddr from hosts"