HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   HOWTO-Related Questions (http://www.howtoforge.com/forums/forumdisplay.php?f=2)
-   -   PowerDNS with PowerAdmin (http://www.howtoforge.com/forums/showthread.php?t=31087)

Noodle2732 8th February 2009 16:32

PowerDNS with PowerAdmin
 
Hi there,

I've been following the HOWTO - Installing PowerDNS (With MySQL Backend) And Poweradmin On Ubuntu 8.10

and have run into a problem, when i goto the PowerAdmin install webpage it doesnt proccess the PHP instead it display the php in plain text.

I have ISP Config installed and running and that works fine so i'm assuming its something to do with the PEAR packages? any help would be a preciated


Thanks,
Nathan

Noodle2732 8th February 2009 19:37

Fixed!

Bit stupid really because i had ISPConfig installed i had disabled PHP globally

falko 9th February 2009 15:15

You could've installed the Poweradmin web interface in a web site created with ISPConfig.

normy 9th March 2009 11:21

powerdns - mysql backend problem
 
Hi!

I've just installed powerdns, as in the tutorial is on an Ubuntu 8.10, but I can't fix a problem in my deamon.log appears:

Mar 9 11:00:30 ns pdns[4671]: gmysql Connection failed: Unable to connect to database: Access denied for user 'power_admin'@'localhost' (using password: YES)
Mar 9 11:00:30 ns pdns[4671]: Caught an exception instantiating a backend, cleaning up
Mar 9 11:00:30 ns pdns[4671]: TCP server is unable to launch backends - will try again when questions come in: Unable to launch gmysql connection: Unable to connect to database: Access denied for user 'power_admin'@'localhost' (using password: YES)
Mar 9 11:00:30 ns pdns[4671]: About to create 3 backend threads for UDP
Mar 9 11:00:30 ns pdns[4671]: gmysql Connection failed: Unable to connect to database: Access denied for user 'power_admin'@'localhost' (using password: YES)
Mar 9 11:00:30 ns pdns[4671]: Caught an exception instantiating a backend, cleaning up
Mar 9 11:00:30 ns pdns[4671]: gmysql Connection failed: Unable to connect to database: Access denied for user 'power_admin'@'localhost' (using password: YES)
Mar 9 11:00:30 ns pdns[4671]: Caught an exception instantiating a backend, cleaning up
Mar 9 11:00:30 ns pdns[4671]: gmysql Connection failed: Unable to connect to database: Access denied for user 'power_admin'@'localhost' (using password: YES)
Mar 9 11:00:30 ns pdns[4671]: Caught an exception instantiating a backend, cleaning up


:( , I've tryed to fix it, I've granted all the privileges for the power_admin user but without succes...

Can somebody help me?!

thanx

falko 10th March 2009 20:23

Are you uding the correct password for power_admin in the PowerDNS configuration?

Can you log in with that password using
Code:

mysql -u power_admin -p
?

Does the password contain special characters?

normy 11th March 2009 09:24

I've tryed to loggin as you wrote with the power_admin user, and it workd.
but my password contains az '#' character, could it be the problem, powerdns doesn't like special characters?!

normy 11th March 2009 10:01

I forgot to mention that I've followed your other tutorial to, with the postfix virtual users with mysql, on the same server with the powerdns.
I didn't think that they can interfer, could they?
and my mail.log displays the same problem that tha mail_admin user can't connect:
Mar 11 09:58:37 ns postfix/cleanup[4929]: warning: problem talking to service rewrite: Connection reset by peer
Mar 11 09:58:37 ns postfix/master[4684]: warning: process /usr/lib/postfix/trivial-rewrite pid 5073 exit status 1
Mar 11 09:58:37 ns postfix/master[4684]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling
Mar 11 09:59:37 ns postfix/proxymap[4802]: warning: connect to mysql server 127.0.0.1: Access denied for user 'mail_admin'@'localhost' (using password: YES)
Mar 11 09:59:37 ns postfix/proxymap[4802]: warning: connect to mysql server 127.0.0.1: Access denied for user 'postfix'@'localhost' (using password: YES)
Mar 11 09:59:37 ns postfix/trivial-rewrite[5074]: fatal: proxy:mysql:/etc/postfix/mysql-virtual_domains.cf(0,lock|fold_fix): table lookup problem
Mar 11 09:59:38 ns postfix/smtpd[4801]: warning: problem talking to service rewrite: Success
Mar 11 09:59:38 ns postfix/cleanup[4929]: warning: problem talking to service rewrite: Connection reset by peer
Mar 11 09:59:38 ns postfix/master[4684]: warning: process /usr/lib/postfix/trivial-rewrite pid 5074 exit status 1
Mar 11 09:59:38 ns postfix/master[4684]: warning: /usr/lib/postfix/trivial-rewrite: bad command startup -- throttling


thanx again for trying to help me... :)

falko 12th March 2009 17:34

Quote:

Originally Posted by normy (Post 174651)
but my password contains az '#' character, could it be the problem, powerdns doesn't like special characters?!

Please change the password so that it doesn't contain any special characters.
What's the output of
Code:

netstat -tap
?

normy 13th March 2009 08:54

output of "netstat -tap" is:

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost:10024 *:* LISTEN 3905/amavisd (maste
tcp 0 0 localhost:10025 *:* LISTEN 4685/master
tcp 0 0 *:mysql *:* LISTEN 3980/mysqld
tcp 0 0 *:www *:* LISTEN 4782/apache2
tcp 0 0 localhost:domain *:* LISTEN 4607/pdns_server-in
tcp 0 0 *:ssh *:* LISTEN 3879/sshd
tcp 0 0 *:smtp *:* LISTEN 4685/master
tcp 1 0 localhost:10025 localhost:54888 CLOSE_WAIT 4801/smtpd
tcp 0 0 localhost:mysql localhost:60873 TIME_WAIT -
tcp 0 0 localhost:mysql localhost:60872 TIME_WAIT -
tcp 0 148 ns.ardealul.ro:ssh 192.168.5.66:3926 ESTABLISHED 4916/0
tcp6 0 0 [::]:imaps [::]:* LISTEN 4553/couriertcpd
tcp6 0 0 [::]:pop3s [::]:* LISTEN 4591/couriertcpd
tcp6 0 0 [::]:pop3 [::]:* LISTEN 4569/couriertcpd
tcp6 0 0 [::]:imap2 [::]:* LISTEN 4528/couriertcpd
tcp6 0 0 [::]:ssh [::]:* LISTEN 3879/sshd

normy 13th March 2009 09:37

it works
 
:) you are right the special character caused the problem...

thank you for helping me!!!


All times are GMT +2. The time now is 06:58.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.