PowerDNS with PowerAdmin

[Noodle2732]

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]

Fixed!

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

[falko]

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

[normy]

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]

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

Can you log in with that password using

mysql -u power_admin -p

?

Does the password contain special characters?

[normy]

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]

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]

Originally Posted by normy

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

netstat -tap

?

[normy]

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 [::]op3s [::]:* LISTEN 4591/couriertcpd
tcp6 0 0 [::]op3 [::]:* LISTEN 4569/couriertcpd
tcp6 0 0 [::]:imap2 [::]:* LISTEN 4528/couriertcpd
tcp6 0 0 [::]:ssh [::]:* LISTEN 3879/sshd

[normy]

you are right the special character caused the problem...

thank you for helping me!!!