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"