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

[Christian Hofstaedtler]

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
  `-

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: Digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-pdns-maintainers/attachments/20140123/7a68151f/attachment.sig>