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 <[email protected]> wrote: > Control: severity -1 normal > Control: tags -1 + confirmed > > Dominique, > > Thank you for your report. > > * Dominique Jaeggi <[email protected]> [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 <[email protected]> > : :' : Debian Developer > `. `' 7D1A CFFA D9E0 806C 9C4C D392 5C13 D6DB 9305 2E03 > `- > -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
