Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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 ?

share|improve this question

3 Answers 3

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!

share|improve this answer

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?

share|improve this answer

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

Try an alphanumeric, but strong, password.

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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