PowerDNS with PowerAdmin

Discussion in 'HOWTO-Related Questions' started by Noodle2732, Feb 8, 2009.

  1. Noodle2732

    Noodle2732 New Member

    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
     
  2. Noodle2732

    Noodle2732 New Member

    Fixed!

    Bit stupid really because i had ISPConfig installed i had disabled PHP globally
     
  3. falko

    falko Super Moderator

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

    normy New Member

    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
     
  5. falko

    falko Super Moderator

    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?
     
  6. normy

    normy New Member

    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?!
     
  7. normy

    normy New Member

    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... :)
     
  8. falko

    falko Super Moderator

    Please change the password so that it doesn't contain any special characters.
    What's the output of
    Code:
    netstat -tap
    ?
     
  9. normy

    normy New Member

    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
     
  10. normy

    normy New Member

    it works

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

    thank you for helping me!!!
     

Share This Page