[SOLVED] PowerDNS (With MySQL Backend) And Poweradmin on CentOS 5.5

vikas027 · 12-31-2010, 12:52 AM

Hi All,

I am trying to install PowerDNS (With MySQL Backend) And Poweradmin on CentOS 5.5.

I have set up a LAMP stack using the default CentOS RPMs
briefly as

Code:

yum groupinstall "Web Server" "MySQL Database"
yum install php* mysql* httpd*

These are the packages involved:

Quote:

MySQL 5.0.77-4
PHP 5.1.6-27
PowerDNS Authoritative Server 2.9.22
Power Admin 2.1.5

Now, I am trying to compile and install PowerDNS source file with MySQL support.

As per ./configure --help, the below options are required to configure it with MySQL (which I have already installed)

Code:

# ./configure --help | grep -i mysql
  --with-mysql=<path>		root directory path of MySQL installation
  --with-mysql-lib=<path>	directory path of MySQL library installation
  --with-mysql-includes=<path>	directory path of MySQL header installation

This is complete my.cnf file

Code:

# cat /etc/my.cnf  | grep -v ^#
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
old_passwords=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

I am little confused with these directory paths. In my system these are the MySQL directories.

Code:

# find / -type d -name mysql
/usr/include/mysql
/usr/share/mysql
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/DBD/mysql
/usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi/auto/DBD/mysql
/usr/lib/mysql
/var/lib/mysql
/var/lib/mysql/mysql

Now, is this the correct configuration directories with respect to my setup.

Code:

./configure --with-mysql=/var/lib/mysql --with-mysql-lib=/usr/lib/mysql --with-mysql-includes=/usr/include/mysql

vikas027 · 12-31-2010, 07:23 AM

Hi All,

I finally found RPMs of pdns and pdns-backend-mysql from here.
I have left the source file now.

Now, as per following this guide
when I am opening hxxp://192.168.1.10/poweradmin/ , it is throwing an error on the webpage itself -- Error: You have to install PHP mcrypt extension!.

I then installed php-mcrypt-5.1.6 and its dependcies libmcrypt-2.5.8 and libmcrypt-devel-2.5.8-4 but still it is throwing the same error.

Quote:

[root@box1 CentOS]# rpm -qa | grep php
php-5.1.6-27.el5
php-pgsql-5.1.6-27.el5
php-bcmath-5.1.6-27.el5
php-snmp-5.1.6-27.el5
php-soap-5.1.6-27.el5
php-pear-1.4.9-6.el5
php-pdo-5.1.6-27.el5
php-imap-5.1.6-27.el5
php-xmlrpc-5.1.6-27.el5
php-xml-5.1.6-27.el5
php-devel-5.1.6-27.el5
php-mcrypt-5.1.6-15.el5.centos.1
php-cli-5.1.6-27.el5
php-ldap-5.1.6-27.el5
php-odbc-5.1.6-27.el5
php-gd-5.1.6-27.el5
php-mbstring-5.1.6-27.el5
php-pear-MDB2-2.4.1-2.el5.centos
php-common-5.1.6-27.el5
php-dba-5.1.6-27.el5
php-pear-MDB2-Driver-mysql-1.4.1-3.el5.centos
php-mhash-5.1.6-15.el5.centos.1
php-mysql-5.1.6-27.el5
php-ncurses-5.1.6-27.el5

Any ideas what is still causing the webpage to look for php-mcrypt

Thanks in advance.

vikas027 · 12-31-2010, 08:41 AM

Hi All,

This helped me out. At last, I have configured PowerDNS with MySQL as backend and PowerAdmin Tool to administer PowerDNS over web.

Code:

service httpd restart; service mysqld restart; service pdns restart

I am having problems while configuring a reverse lookup zone, google-ing it. Will post the results here.

Anyways, if someone is finding problems in configuring it on RHEL/CENTOS, may be I could help them out.

vikas027 · 12-31-2010, 09:34 AM

Well all done. I am a happy man now.

I am closing this thread. I have saved screenshots for all web configurations, if anyone needs help to configure this get back to this thread.

Thanks all.