LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 12-31-2010, 12:52 AM   #1
vikas027
Senior Member
 
Registered: May 2007
Location: Sydney
Distribution: RHEL, CentOS, Ubuntu, Debian, OS X
Posts: 1,305

Rep: Reputation: 107Reputation: 107
Question PowerDNS (With MySQL Backend) And Poweradmin on CentOS 5.5


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
 
Old 12-31-2010, 07:23 AM   #2
vikas027
Senior Member
 
Registered: May 2007
Location: Sydney
Distribution: RHEL, CentOS, Ubuntu, Debian, OS X
Posts: 1,305

Original Poster
Rep: Reputation: 107Reputation: 107
Unhappy

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.

Last edited by vikas027; 12-31-2010 at 07:24 AM. Reason: Added something
 
Old 12-31-2010, 08:41 AM   #3
vikas027
Senior Member
 
Registered: May 2007
Location: Sydney
Distribution: RHEL, CentOS, Ubuntu, Debian, OS X
Posts: 1,305

Original Poster
Rep: Reputation: 107Reputation: 107
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.
 
Old 12-31-2010, 09:34 AM   #4
vikas027
Senior Member
 
Registered: May 2007
Location: Sydney
Distribution: RHEL, CentOS, Ubuntu, Debian, OS X
Posts: 1,305

Original Poster
Rep: Reputation: 107Reputation: 107
Talking

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.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Installing PowerDNS (With MySQL Backend) And Poweradmin On Fedora 12 LXer Syndicated Linux News 0 06-21-2010 01:50 PM
LXer: Installing PowerDNS (With MySQL Backend) And Poweradmin On Ubuntu 9.10 LXer Syndicated Linux News 0 04-16-2010 10:10 AM
LXer: Installing PowerDNS (With MySQL Backend) And Poweradmin On Fedora 10 LXer Syndicated Linux News 0 02-14-2009 12:02 AM
LXer: Installing PowerDNS (With MySQL Backend) And Poweradmin On Ubuntu 8.10 LXer Syndicated Linux News 0 01-30-2009 09:50 AM
LXer: Installing PowerDNS (With MySQL Backend) And Poweradmin On Debian Etch LXer Syndicated Linux News 0 01-20-2009 05:00 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:37 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration