====== FreeBSD 11 PowerDNS and MySQL ======

===== Install PowerDNS Package =====
<file bash>
portsnap fetch
portsnap extract
cd /usr/ports/dns/powerdns
make config # select mysql
export BATCH=yes # otherwise you get prompted for a lot of options
make install # this takes a while
</file>
===== Setup MySQL Server =====
==== Find installed MySQL client ====
<file>
pkg info | grep mysql | grep client
</file>
  * In My case I was using client version 5.6
==== Install from Port ====
<file>
cd /usr/ports/databases/mysql56-server/
make install
</file>
==== Enable MySQL Server ====
<file>
echo "mysql_enable=\"YES\"" > /etc/rc.conf
service mysql-server start
</file>
==== Set Password ====
<file>
mysql_secure_installation # set root password to MYSQLPASSWORD
</file>

===== Setup PowerDNS Database =====
==== Create PowerDNS Database ====
<file bash>
mysql -p # enter password you changed from MYSQLPASSWORD
</file>
<file mysql>
create database powerdns; 
quit;
</file>
<file bash>
mysql -p powerdns < /usr/local/share/doc/powerdns/schema.mysql.sql # enter password you changed from CHANGEME
</file>

===== Set PowerDNS Options =====
  * edit /usr/local/etc/pdns/pdns.conf
  * The following are the important directives for DNS transfers, MySQL, and the Web Frontend
<file>
allow-axfr-ips=127.0.0.0/8   #add your domain ranges to this list, this is a "," separated list
disable-axfr=no

launch=gmysql
gmysql-host=127.0.0.1
gmysql-user=root
gmysql-password=MYSQLPASSWORD
gmysql-dbname=powerdns

api=yes
api-key=APIPASSWORD
webserver=yes
webserver-address=127.0.0.1
webserver-port=8081
</file>

===== Enable PowerDNS Startup =====
  * add mysql to the REQUIRE line in /usr/local/etc/rc.d/pdns
<file>
...
# REQUIRE: DAEMON SERVERS mysql
...
</file>
  * Enable and start
<file>
echo "pdns_enable=\"YES\"" > /etc/rc.conf
service pdns start
</file>

===== Install Apache and PHP =====
<file>
pkg install mod_php56 php56 php56-curl php56-json php56-openssl php56-session php56-sqlite3 apache24
</file>
  * Add/create the following to **/usr/local/etc/apache24/php5.conf**
<file>
<FilesMatch "\.php$">
    SetHandler application/x-httpd-php
</FilesMatch>
<FilesMatch "\.phps$">
    SetHandler application/x-httpd-php-source
</FilesMatch>

DirectoryIndex index.html index.php
</file>

  * Enable and start apache
<file>
echo "apache24_enable=\"YES\"" > /etc/rc.conf
service apache24 start
</file>

===== Install and Configure NSedit =====
  * download a copy of NSEDIT from [[https://github.com/tuxis-ie/nsedit]]
  * Extract to **/usr/local/www/apache24/data**
  * make a directory and give www:www full access to it
<file>
mkdir -p /usr/local/etc/pdns/web-db
chown -R www:www /usr/local/etc/pdns/web-db
</file>
  * Edit ./nsedit/includes/config.inc.php and set the following values
<file>
$apipass = 'APIPASSWORD';  
$apiip   = '127.0.0.1';  
$apiport = '8081';   
$apiproto = 'http'; 
$authdb  = "/usr/local/etc/pdns/web-db/pdns.users.sqlite3";
</file>

==== Login to NSEdit ====
  * go to http://localhost/nsedit/index.php
  * Login with Username: **admin**, password: **admin**

====== Project PKGs ======
{{:freebsd:pkg_pdns_nsedit.tar.bz2|}}

====== Tips ======
===== Refresh Save Zone =====
<file>
pdns_control retrieve <Zone Name>
</file>