Powerdns slave zone cleanup script for sqlite3 backend

pdns-slave-zone-cleanup-sqlite3.sh

#!/bin/bash
#### Config ################################

DATABASE="/var/lib/powerdns/pdns.sqlite3"

DEBUG="no"

#### End of Config #########################

REQUIRED_COMMANDS="
sqlite3
host
grep
awk
tail
"

# print debug messages to STDERR
function debug {
        if [ "${DEBUG}" == "yes" ] ; then
                echo "DEBUG: $@" >&2
        fi
}

for CMD in ${REQUIRED_COMMANDS} ; do
        CMDNAME=`echo ${CMD} | awk '{print toupper($1) }' | sed -e s@"-"@""@g`
        export $(eval "echo ${CMDNAME}")=`which ${CMD} 2>/dev/null`
        if [ -z "${!CMDNAME}" ] ; then
                debug "Command: ${CMD} not found!"
                exit 1
        else
                debug "Found command $(echo $CMDNAME) in ${!CMDNAME}"
        fi
done

SQLCMD="${SQLITE3} ${DATABASE}"
debug "Sql command: ${SQLCMD}"

check() {
	debug "Check: ${1} ${2}"
	AUTH=`${HOST} -t SOA ${2} ${1} | ${TAIL} -n1 | ${GREP} "has no SOA record"`
	if [ "${AUTH}" == "${2} has no SOA record" ]; then
		debug "Server ${1} has no SOA for ${2}"
		DOMAIN_ID=`${SQLCMD} "SELECT id FROM domains WHERE name = '${2}' AND type = 'SLAVE' AND master LIKE '%${1}%' LIMIT 1;"`
		if [ "${DOMAIN_ID}" != "" ]; then
			debug "Removing zone ${2}"
			${SQLCMD} "DELETE FROM records WHERE domain_id = '${DOMAIN_ID}';"
			${SQLCMD} "DELETE FROM domains WHERE id = '${DOMAIN_ID}';"
		fi
	fi
}

MASTERS=(`${SQLCMD} "SELECT DISTINCT ip FROM supermasters;"`)
for m in "${MASTERS[@]}"; do
	debug "Master: ${m}"
	NAMES=(`${SQLCMD} "SELECT name FROM domains WHERE type = 'SLAVE' AND master LIKE '%${m}%';"`)
	for d in "${NAMES[@]}"; do
		check ${m} ${d}
	done
done