Control: severity -1 normal Control: tags -1 + confirmed Dominique,
Thank you for your report.
* Dominique Jaeggi <djae...@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 <z...@debian.org>
: :' : Debian Developer
`. `' 7D1A CFFA D9E0 806C 9C4C D392 5C13 D6DB 9305 2E03
`-
signature.asc
Description: Digital signature
