[Pkg-pdns-maintainers] Bug#736449: pdns-backend-mysql: mysqld sql_mode NO_AUTO_CREATE_USER causes abort of dbconfig install/mysql script

[Dominique Jaeggi]

hi christian

thank you for your comments. i fully agree. sorry for the high prio,
first time i ever reported a bug in debian :)

take care,
dom.

On Thu, Jan 23, 2014 at 7:59 PM, Christian Hofstaedtler <zeha at debian.org> wrote:
> Control: severity -1 normal
> Control: tags -1 + confirmed
>
> Dominique,
>
> Thank you for your report.
>
> * Dominique Jaeggi <djaeggi at adobe.com> [140123 19:33]:
>> When installing this package using a mysql server that has the sql_mode NO_AUTO_CREATE_USER
>> set, the postinst script fails as the /usr/share/dbconfig-common/data/pdns-backend-mysql/install/mysql
>> script is incompatible with said sql_mode.
>
>> said mode causes the following line in the mysql script:
>>    GRANT SELECT ON supermasters TO pdns;
>> to throw a mysql error:
>>    "can't find any matching row in the user table"
> [..]
>
>> Probably the host should be dynamically templated into the script, based on the debconf mysql host setting.
>
> I believe the proper fix here is to just drop the GRANT statements,
> as dbconfig-common already makes the created user have all required
> rights.
> Actually the mysql host setting is the wrong thing to use -- if
> MySQL runs remote, the host setting will be the name of the MySQL
> server, but we'd need the name of the PowerDNS server.
>
> I'm downgrading the severity as this issue only occurs when using
> mysqld in a non-default configuration and there's an easy
> workaround. (i.e. comment the GRANT lines or run mysqld in it's
> default config)
>
>
>     Christian
> --
>  ,''`.  Christian Hofstaedtler <zeha at debian.org>
> : :' :  Debian Developer
> `. `'   7D1A CFFA D9E0 806C 9C4C  D392 5C13 D6DB 9305 2E03
>   `-
>