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
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
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?
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?!
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...
Please change the password so that it doesn't contain any special characters. What's the output of Code: netstat -tap ?
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