up vote 0 down vote favorite
share [g+] share [fb]

I have a problem with my gmysql and Powerdns on Debian Squeeze , I keep getting this error : 

Sep 21 16:30:35 lucas pdns[24429]: gmysql Connection failed: Unable to connect to database: Access denied for user 'power_admin'@'localhost' (using password: YES)
Sep 21 16:30:35 lucas pdns[24429]: Caught an exception instantiating a backend, cleaning up

However I tried logging in with to mysql cli with the user and password provided in the config file and it logs in normally.

What am I not seeing ?

link|improve this question
91% accept rate
feedback

3 Answers

up vote 1 down vote accepted

Check your settings in powerdns, one of the config files has a separate entry for user and password to log into your mysql backend.

I think your mistake might lie there!

link|improve this answer
feedback
up vote 1 down vote

Well if PowerDNS says it is unable to connect that's usually just it. Did you grant it permission in mysql and issue "flush privileges;"?

Do you have this for all backend instances (default with debian is 3 i think) or does the error just occur occasionally?

link|improve this answer
feedback
up vote 0 down vote

Is your password complex? I have found reference to passwords containing the # character causing this bug.

Try an alphanumeric, but strong, password.

link|improve this answer
nope it does not contain special characters anymore, I tried that :) – Lucas Kauffman Sep 21 '11 at 16:18
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.