Howto Power DNS block porn


Power DNS
Power DNS

 Howto Power DNS block porn
#############DEBIAN##############
apt-get install mysql-client mysql-server pdns-server pdns recursor pdns-backend-mysql pdns-server

#cat /etc/powerdns/pdns.conf
allow-recursion=127.0.0.1, 172.17.17.0/30, 172.16.0.0/12,192.168.0.0/16,10.0.0.0/8
config-dir=/etc/powerdns
daemon=yes
disable-axfr=yes
distributor-threads=4
guardian=yes
launch=gmysql
gmysql-host=127.0.0.1
gmysql-user=pdns
gmysql-password=rahasia
gmysql-dbname=pdns
gmysql-socket=/var/run/mysqld/mysqld.sock
max-cache-entries=10000000
lazy-recursion=yes
local-address=0.0.0.0
local-port=53
master=yes
module-dir=/usr/lib/powerdns
recursor=127.0.0.1:5300
setgid=pdns
setuid=pdns
socket-dir=/var/run
webserver=yes
webserver-address=192.168.111.2
webserver-port=8081
wildcards=on
version-string=powerdns

############CENTOS#############
yum install pdns pdns-backend-mysql pdns-server  pdns-recursor
chkconfig --levels 235 pdns on
chkconfig --levels 235 pdns-recursor on

#############
cat /etc/pdns/pdns.conf
setgid=pdns
setuid=pdns
launch=gmysql
gmysql-host=127.0.0.1
gmysql-user=pdns
gmysql-password=rahasia
gmysql-dbname=pdns
allow-recursion=127.0.0.1,172.16.0.0/12,192.168.0.0/16,10.0.0.0/8
config-dir=/etc/pdns
daemon=yes
disable-axfr=yes
distributor-threads=4
guardian=yes
gmysql-socket=/var/lib/mysql/mysql.sock
lazy-recursion=yes
local-address=0.0.0.0
local-port=53
master=yes
module-dir=/usr/lib64/pdns
recursor=127.0.0.1:5300
socket-dir=/var/run
webserver=yes
webserver-address=192.168.0.99
webserver-port=8081
wildcard-url=on
version-string=powerdns


#############
#cat /etc/pdns-recursor/recursor.conf
setuid=pdns-recursor
setgid=pdns-recursor
config-dir=/etc/pdns-recursor/
allow-from=127.0.0.0/8, 10.0.0.0/8, 192.168.0.0/16, 172.16.0.0/12
local-address=127.0.0.1
local-port=5300
quiet=yes
#############


wget "http://urlblacklist.com/cgi-bin/commercialdownload.pl?type=download&file=bigblacklist" -O /tmp/bigblacklist.tar.bz2
tar xvf bigblacklist.tar.bz2 -C /tmp/
cd /tmp
cp blacklists/porn/domains /tmp/
mv blackdomains /var/lib/mysql/powerdns/
mysql -uroot -pvertrigo -Dpdns -e "LOAD DATA INFILE 'blackdomains' INTO TABLE domains"
mysql -uroot -pvertrigo -Dpdns -e "select id,name from domains" > forrecord
awk '{print "NULL" "\t" $1 "\t" $2 "\t" "A" "\t" "118.98.97.100" "\t" "86400" "\t" "0" "\t" "1286888925" }' forrecord > sqlrecords
awk '{print "NULL" "\t" $1 "\t" "*."$2 "\t" "A" "\t" "118.98.97.100" "\t" "86400" "\t" "0" "\t" "1301888925" }' forrecord > wildcard
awk '{print "NULL" "\t" $1 "\t" $2 "\t" "SOA" "\t" "nms fahmi@idmail.or.id 1" "\t" "86400" "\t" "1301888925" "\t" "NULL" }' forrecord > soarecords
cp soarecords  /var/lib/mysql/pdns
cp wildcard /var/lib/mysql/pdns
cp sqlrecords  /var/lib/mysql/pdns
mysql -uroot -pvertrigo -Dpdns -e "LOAD DATA INFILE 'sqlrecords' INTO TABLE records"
mysql -uroot -pvertrigo -Dpdns -e "LOAD DATA INFILE 'wildcard' INTO TABLE records"
mysql -uroot -pvertrigo -Dpdns -e "LOAD DATA INFILE 'soarecords' INTO TABLE records"