Clean fail2ban database from older entry - use script with cronjob!

fail2ban-cleanup.sh

#!/usr/bin/env bash
# Tobias Schifftner, @tschiffnter
#
# Usage:
#    bash fail2ban-cleanup.php <fail2ban.sqlite3>

FILE=${1:-"/var/lib/fail2ban/fail2ban.sqlite3"}

[ -f "$FILE" ] || { echo "$FILE not found"; exit 1; }

function sql() {
    $(which sqlite3) "$FILE" "$@"
}

sql "DELETE FROM bans WHERE timeofban < strftime('%s', 'now', '-7 days');"
sql "VACUUM;"