{"id":1017,"date":"2010-10-13T20:10:41","date_gmt":"2010-10-13T17:10:41","guid":{"rendered":"http:\/\/www.void.gr\/kargig\/blog\/?p=1017"},"modified":"2010-10-13T23:51:26","modified_gmt":"2010-10-13T20:51:26","slug":"aaaa-records-with-plesk","status":"publish","type":"post","link":"https:\/\/www.void.gr\/kargig\/blog\/2010\/10\/13\/aaaa-records-with-plesk\/","title":{"rendered":"AAAA records with Plesk"},"content":{"rendered":"

Plesk<\/a> is surely not ready for IPv6<\/a>. Despite that fact, many people – me included, have the DNS records of their favorite domains managed by Plesk and still want to be able to add some IPv6 records to those.<\/p>\n

Some time ago I had posted on my twitter account<\/a> a link to another blog that had a “hackish way” to add AAAA records to Plesk<\/a>. I have written a slightly more elegant shell script (to be run by root only) than the one provided by experimentalworks.<\/p>\n

First of all you _need_ to alter dns_recs table of the psa database to allow AAAA records:
\n

# mysql -u admin -p psa \nmysql> alter table dns_recs modify column type enum('NS','A','AAAA','CNAME','MX','PTR','TXT','SRV','master','none') NOT NULL default 'A'; <\/code2><\/pre><\/p>\n
Then download my plesk-AAAA.sh<\/a> script and use it like the following example.<\/p>\n
To add www.foobar.gr to point to 2001:db8:1001::1<\/p>\n
Usage: .\/plesk-AAAA.sh    [zone serial]
\n#.\/plesk-AAAA.sh foobar.gr www 2001:db8:1001::1
\n#.\/plesk-AAAA.sh foobar.gr ipv6 2001:db8:1001::1 12<\/v6><\/hostname><\/domain><\/p><\/blockquote>\n
Known bug\/feature:
\nIf you add a record without adding a serial, for the soa record, at the end, it will add the serial of the domain in the form:<\/p>\n
YYYYMMDD10<\/p><\/blockquote>\n
So if you add two ipv6 hosts in the same day for the same domain you _have_ to manually add a serial >10 for the second host (and so forth).<\/p>\n
For the ones who don’t like downloading but would like to see the script source, here it is:
\n
  1 #!\/bin\/sh\n  2 \n  3 usage () {\n  4         echo "Usage: $0 <domain> <hostname> <v6 IP> [zone serial]"\n  5         echo "Usage: $0 foobar.gr www 2001:db8:1001::1"\n  6         exit 1\n  7 }\n  8 \n  9 if [ $# -lt 3 ]; then\n 10         usage\n 11 fi\n 12 DOMAIN=$1\n 13 HOSTNAME=$2\n 14 v6IP=$3\n 15 INPUT_SERIAL=${4:-10}\n 16 FULLHOST="$2.$1."\n 17 \n 18 ADMIN_PASS=`cat \/etc\/psa\/.psa.shadow`\n 19 MYSQL_BIN_D=`grep MYSQL_BIN_D \/etc\/psa\/psa.conf | awk '{print $2}'`\n 20 PRODUCT_ROOT_D=`grep PRODUCT_ROOT_D \/etc\/psa\/psa.conf | awk '{print $2}'`\n 21 SERIAL=`date +%Y%m%d${INPUT_SERIAL}`\n 22 mysql="${MYSQL_BIN_D}\/mysql -N -uadmin -p${ADMIN_PASS} psa"\n 23 \n 24 query1="SELECT dns_zone_id FROM dns_recs where host like \\"$DOMAIN%\\" LIMIT 0,1"\n 25 ZONE_ID=`echo "$query1" | $mysql`\n 26 echo "ZONE_ID=$ZONE_ID"\n 27 query2="INSERT INTO dns_recs (displayHost, host, displayVal, val, type, dns_zone_id) VALUES ('$FULLHOST', '$FULLHOST', '$v6IP', '$v6IP', 'AAAA',$ZONE_ID)"\n 28 echo "$query2" | $mysql\n 29 \n 30 query3="UPDATE dns_zone SET serial=\\"$SERIAL\\" WHERE id=$ZONE_ID LIMIT 1;"\n 31 echo "$query3" | $mysql\n 32 \n 33 echo "REBUILDING zone file for $DOMAIN"\n 34 $PRODUCT_ROOT_D\/admin\/sbin\/dnsmng update $DOMAIN<\/code2><\/pre><\/p>\n
The script has been tested with bash<\/a> and zsh<\/a>. I have no idea whether it works under any other shells.
\nThe script probably won’t delete your databases, but…use it at your own risk \ud83d\ude42 I hope someone finds it useful.<\/p>\n","protected":false},"excerpt":{"rendered":"
Plesk is surely not ready for IPv6. Despite that fact, many people – me included, have the DNS records of their favorite domains managed by Plesk and still want to be able to add some IPv6 records to those. Some time ago I had posted on my twitter account a link to another blog that […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"footnotes":""},"categories":[5,3,8],"tags":[302,303,25,199,301,595,599,209,49,304,60],"class_list":["post-1017","post","type-post","status-publish","format-standard","hentry","category-internet","category-linux","category-networking","tag-aaaa","tag-aaaa-record","tag-bash","tag-dns","tag-ipv6","tag-linux","tag-networking","tag-plesk","tag-script","tag-shell","tag-zsh"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t