Scripts/dynpowerup

This script will update the A records for zones you host on your local PowerDNS nameserver to your (external) dynamic IP.

I'm running this script after every reconnect of my VDSL link through ppp's ip-up scripts by putting it here:

/etc/ppp/ip-up.d/dynpowerup

This is the original version of the script, which requires you to add you records manually:

#!/bin/bash

RECORDS=("example.com" "ns1.example.com" "ns2.example.com" "example.org" "example.net")
SOA="ns1.example.com. hostmaster.example.com. `date +%Y%m%d%H` 10800 3600 604800 3600"

DBUSER="your-powerdns-user"
DBPASS="your-powerdns-password"
DBNAME="your-powerdns-database"

IP=`lynx -dump http://checkip.dyndns.org | awk '{print $4}'`

if [ -e "/tmp/nsup.IP" ]; then
  read OLD_IP < "/tmp/nsup.IP"
else
  OLD_IP="0.0.0.0"
fi

if [ "$IP" != "$OLD_IP" ]; then
  echo "IP address changed from $OLD_IP to $IP" | logger -t DynPowerUp
  for RECORD in ${RECORDS[@]}; do
    echo "updating record: $RECORD" | logger -t DynPowerUp
    COMMAND="$COMMAND UPDATE ${DBNAME}.records SET content = \"$IP\" WHERE name = \"$RECORD\" AND type = 'A';"
    COMMAND="$COMMAND UPDATE ${DBNAME}.records SET content = \"$SOA\" WHERE name = \"$RECORD\" AND type = 'SOA';"
  done
  mysql -u${DBUSER} -p${DBPASS} ${DBNAME} -e "$COMMAND"
  echo "$IP" > /tmp/nsup.IP
  echo "IP updates done" | logger -t DynPowerUp
fi

And this is a version which looks for a specific NS record and updates all A records with a TTL of 60:

#!/bin/bash

NS="ns1.example.com"
TTL="60"
SOA="ns1.example.com. hostmaster.example.com. `date +%Y%m%d%H` 10800 3600 604800 3600"

DBUSER="your-powerdns-user"
DBPASS="your-powerdns-password"
DBNAME="your-powerdns-database"

RECORDS="SELECT name FROM records WHERE type = 'A' AND ttl = '"${TTL}"' AND domain_id IN
        (SELECT domain_id FROM records WHERE type = 'NS' AND content = '"${NS}"');"

IP=`lynx -dump http://checkip.dyndns.org | awk '{print $4}'`

if [ -e "/tmp/nsup.IP" ]; then
  read OLD_IP < "/tmp/nsup.IP"
else
  OLD_IP="0.0.0.0"
fi

if [ "${IP}" != "${OLD_IP}" ]; then
  echo "IP address changed from ${OLD_IP} to ${IP}" | logger -t nsup
  for RECORD in `mysql -u${DBUSER} -p${DBPASS} ${DBNAME} -NB -e "${RECORDS}"`; do
    echo "updating record: ${RECORD}" | logger -t nsup
    COMMAND="${COMMAND} UPDATE ${DBNAME}.records SET content = \"$IP\" WHERE name = \"${RECORD}\" AND type = 'A';"
    COMMAND="${COMMAND} UPDATE ${DBNAME}.records SET content = \"$SOA\" WHERE name = \"${RECORD}\" AND type = 'SOA';"
  done
  mysql -u${DBUSER} -p${DBPASS} ${DBNAME} -e "$COMMAND"
  echo "${IP}" > /tmp/nsup.IP
  echo "IP updates done" | logger -t nsup
fi