[Pdns-dev] gmysql backend rejects non-alpha pw chars

[Justin Clift]

On 05/09/2012, at 1:56 AM, Xscape wrote:
> try to remove "#"， char after "#" will be treated as comment.

Doh, of course.  Thanks, that works. :)

+ Justin


> On Tuesday, September 4, 2012, Justin Clift <justin at salasaga.org> wrote:
> > Hi all,
> >
> > Found a minor problem with the gmysql backend.
> > Wondering if anyone has ideas for a workaround.
> >
> > The password policy here is to include non-alpha
> > characters in passwords.  For example:
> >
> >   ETM$TYS#$@CF%Y%%bjka3#@DXge
> >
> > However, even though that's a valid MySQL password,
> > and the mysql command like utility has no issues
> > with it, PowerDNS's gmysql backend refuses to use it.
> >
> > Errors out with:
> >
> >   gmysql Connection failed: Unable to connect to database: Access denied for user 'pdns'@'localhost' (using password: YES)
> >
> > Removing the non-alpha chars like this allows things
> > to work:
> >
> >   ETMTYSCFYbjka3DXge
> >
> > But, that's not compliant with strong password
> > policy. :(
> >
> > Thinking the problem may be escaping related, tried
> > these too:
> >
> >   gmysql-password="ETM$TYS#$@CF%Y%%bjka3#@DXge"
> >   gmysql-password='ETM$TYS#$@CF%Y%%bjka3#@DXge'
> >   gmysql-password="ETM\$TYS\#\$\@CF\%Y\%\%bjka3\#\@DXge"
> >   gmysql-password=ETM\$TYS\#\$\@CF\%Y\%\%bjka3\#\@DXge
> >
> > Still no go.  Anyone have ideas?
> >
> > Regards and best wishes,
> >
> > Justin Clift
> > _______________________________________________
> > Pdns-dev mailing list
> > Pdns-dev at mailman.powerdns.com
> > http://mailman.powerdns.com/mailman/listinfo/pdns-dev
> >