[Pdns-users] Mysql connect erros

Mark Moseley moseleymark at gmail.com
Fri Sep 16 22:14:07 UTC 2005

You're probably running into the pre-4.1 vs 4.1 password lengths issue (
http://dev.mysql.com/doc/mysql/en/old-client.html).The easiest thing to do 
is to set the password for the pdns mysql user to pre-4.1 length, like: (in 
mysql db) update user set password = OLD_PASSWORD( "password" ) where user = 
"pdns user" (and possibly host = "host used for that user if multiple 
instances of that user"). Don't forget to "flush privileges" after.

The other option is that if you're not depending on mysqld to continue 
working with other mysql-4.1-aware apps, you can also start mysqld with the 
option --old-passwords 

This will use the old pre-4.1 authentication, which your mysql client lib is 
probably using. Mind you, if you've got other apps using mysql too, it 
*might* break them, so be ready to switch back in a hurry :)

On 9/16/05, bert hubert <bert.hubert at netherlabs.nl> wrote:
> On Fri, Sep 16, 2005 at 03:04:19PM -0500, Matt Kollross wrote:
> > i'm using powerdns with mysql 4.1.14. i've tried both launch=gmysql
> > and myql and i'm getting a "Sep 16 15:40:30 gmysql Connection failed:
> > Unable to connect to database: Client does not support authentication
> > protocol requested by server; consider upgrading MySQL client". Is
> > there any known issues with the newest mysql and powerdns. If so
> > what version of mysql is compatable?
> If you recompile powerdns yourself this problem goes away.
> I'll see if I can compile the next version of PowerDNS against the latest
> MySQL.
> --
> http://www.PowerDNS.com Open source, database driven DNS Software
> http://netherlabs.nl Open and Closed source services
> _______________________________________________
> Pdns-users mailing list
> Pdns-users at mailman.powerdns.com
> http://mailman.powerdns.com/mailman/listinfo/pdns-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20050916/9d6b11f5/attachment-0001.html>

More information about the Pdns-users mailing list