#!/bin/bash die() { printf '%s\n' "$*" >&2; exit 1; } sql_string() { printf '%s' "'${1//\'/\'\'}'" } powerdns_sqlite_add_replace_record() { local fqdn="$1.$3" fqdn=${fqdn: -64 : 64} local sql_new_domain="$(sql_string "$fqdn")" local sql_ip_address="$(sql_string "$2")" local sql_domain="$(sql_string "$3")" local record_type="$(sql_string "$4")" DBDIR=/etc/powerdns DBNAME=powerdns.sqlite3 DB=$DBDIR/$DBNAME test -r $DB && test -w $DB || die "Wrong permissions on $DB" test -r $DBDIR && test -w $DBDIR || die "Wrong permissions on $DBDIR" sqlite3 $DB <