PowerDNS with PowerAdmin on Fedora

Installing and Configuring PowerDNS with PowerAdmin from Source

Pre-requisites

# yum group install ‘Development Tools’

# yum install libxml2-devel gd gd-devel libmcrypt-devel libmcrypt libmhash curl curl-devel libtool-ltdl-devel libtool-ltdl libpng-devel imagemagick ncurses ncurses-devel pce-devel zlib-devel bzip2-devel

Apache 2.2.15

# cd /usr/local/src

# wget http://mirror.its.uidaho.edu/pub/apache/httpd/httpd-2.2.15.tar.gz

# tar zxvf httpd-2.2.15.tar.gz

# cd httpd-2.2.15

# ./configure –prefix=/usr/local/apache2 –enable-so –enable-deflate –enable-proxy –enable-proxy-connect –enable-proxy-http –enable-proxy-ajp –enable-proxy-balancer –enable-ssl –enable-unique-id –enable-usertrack –enable-vhost-alias –with-mpm=prefork –enable-static-ab –enable-rewrite

# make

# make install

# vi /usr/local/apache2/conf/httpd.conf

# /usr/local/apache2/bin/apachectl start

MySQL 5.1.45

#wget http://www.mirrorservice.org/sites/ftp.mysql.com/Downloads/MySQL-5.1/mysql-5.1.45.tar.gz

# tar zxvf mysql-5.1.45.tar.gz

# cd mysql-5.1.45

# ./configure –prefix=/usr/local/mysql –with-low-memory –enable-assembler –with-mysqld-ldflags=-all-static –with-plugins=partition,archive,innobase,myisam

# make

# make install

# /usr/sbin/groupadd mysql

# /usr/sbin/useradd -g mysql mysql

# cd /usr/local/mysql/

# chown -R mysql .

# chgrp -R mysql .

# bin/mysql_install_db

# chown -R root .

# chown -R mysql var

# bin/mysqld_safe -user=mysql &

# /usr/local/mysql/bin/mysqladmin -u root password the_password

PHP 5.3.2

# wget http://my2.php.net/get/php-5.3.2.tar.gz/from/us.php.net/mirror

# tar zxvf php-5.3.2.tar.gz

# cd php-5.3.2

# ./configure \

–prefix=/usr/local/php5 \

–with-apxs2=/usr/local/apache2/bin/apxs \

–with-mysql=/usr/local/mysql \

–with-mysqli=/usr/local/mysql/bin/mysql_config \

–enable-force-cgi-redirect \

–enable-fastcgi \

–with-gd \

–enable-soap \

–with-pear \

–enable-mbstring \

–with-mcrypt \

–with-curl \

–with-zlib \

–with-bz2 \

–enable-zip \

–enable-shared

# make

# make install

# libtool –finish /usr/src/php/php-5.3.2/libs

# vi /usr/local/apache2/conf/httpd.conf

Add this line:

AddType application/x-httpd-php .php

# /usr/local/apache2/bin/apachectl stop

# /usr/local/apache2/bin/apachectl start

# vi /usr/local/apache2/htdocs/info.php

<?php

phpinfo();

phpMyAdmin 3.3.1

# cd /usr/local/src

# wget http://space.dl.sourceforge.net/project/phpmyadmin/phpMyAdmin/3.3.1/phpMyAdmin-3.3.1-english.tar.gz

# cp phpMyAdmin-3.3.1-english.tar.gz /usr/local/apache2/htdocs

# cd /usr/local/apache2/htdocs

# tar zxvf phpMyAdmin-3.3.1-english.tar.gz

# mv phpMyAdmin-3.3.1-english phpMyAadmin

# cd phpMyAdmin

# cp config.sample.inc.php config.inc.php

# mkdir config

# chmod o+rw config

# cp config.inc.php config/

# chmod o+w config/config.inc.php

Now, open setup/ in browser

# mv config/config.inc.php .

# chmod o-w config.inc.php

# rm -rf config

PowerDNS 2.9.22

# cd /usr/local/src

# wget http://downloads.powerdns.com/releases/pdns-2.9.22.tar.gz

# tar zxvf pdns-2.9.22.tar.gz

# cd mydns-2.9.22

# ./configure \

–with-mysql=/usr/local/mysql \

–with-mysql-lib=/usr/local/mysql/lib/mysql \

–with-mysql-include=/usr/local/mysql/include/lib/mysql \

–with-mysqli=/usr/local/mysql/bin/mysql_config \

–with-included-gettext \

–enable-shared

# make

# make install

# cd /usr/local/etc/

# cp pdns.conf-dist pdns.conf

# vi pdns.conf

launch=gmysql

gmysql-host=127.0.0.1

gmysql-user=root

gmysql-password=dbpassword

gmysql-dbname=pdns

mysql> create database pdns;

mysql> use pdns;

mysql>create table domains (

id INT auto_increment,

name VARCHAR(255) NOT NULL,

master VARCHAR(128) DEFAULT NULL,

last_check INT DEFAULT NULL,

type VARCHAR(6) NOT NULL,

notified_serial INT DEFAULT NULL,

account VARCHAR(40) DEFAULT NULL,

primary key (id)

)type=InnoDB;

CREATE UNIQUE INDEX name_index ON domains(name);

CREATE TABLE records (

id INT auto_increment,

domain_id INT DEFAULT NULL,

name VARCHAR(255) DEFAULT NULL,

type VARCHAR(6) DEFAULT NULL,

content VARCHAR(255) DEFAULT NULL,

ttl INT DEFAULT NULL,

prio INT DEFAULT NULL,

change_date INT DEFAULT NULL,

primary key(id)

)type=InnoDB;

CREATE INDEX rec_name_index ON records(name);

CREATE INDEX nametype_index ON records(name,type);

CREATE INDEX domain_id ON records(domain_id);

create table supermasters (

ip VARCHAR(25) NOT NULL,

nameserver VARCHAR(255) NOT NULL,

account VARCHAR(40) DEFAULT NULL

);

GRANT SELECT ON supermasters TO pdns;

GRANT ALL ON domains TO pdns;

GRANT ALL ON records TO pdns;

# /usr/local/sbin/pdns_server &

# host www.test.com 127.0.0.1

mysql> use pdns;

mysql> INSERT INTO domains (name, type) values (‘test.com’, ‘NATIVE’);