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

[Justin Clift]

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