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

[Dominique Jaeggi]

Package: pdns-backend-mysql
Version: 3.1-4
Severity: grave
Justification: renders package unusable

Dear Maintainer,
*** Please consider answering these questions, where appropriate ***

   * What led up to the situation?
   * What exactly did you do (or not do) that was effective (or
     ineffective)?
   * What was the outcome of this action?
   * What outcome did you expect instead?

*** End of the template - remove these lines ***

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"

The problem does not arise, if the grant statement specifies a host for the user, e.g.

   GRANTE SELECT ON supermasters TO pdns at localhost;

Probably the host should be dynamically templated into the script, based on the debconf mysql host setting.

-- System Information:
Debian Release: 7.3
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 3.2.0-4-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE= (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages pdns-backend-mysql depends on:
ii  dbconfig-common        1.8.47+nmu1
ii  debconf [debconf-2.0]  1.5.49
ii  libc6                  2.13-38
ii  libgcc1                1:4.7.2-5
ii  libmysqlclient18       5.5.33+dfsg-0+wheezy1
ii  libpolarssl0           1.2.9-1~deb7u1
ii  libstdc++6             4.7.2-5
ii  pdns-server            3.1-4
ii  zlib1g                 1:1.2.7.dfsg-13

Versions of packages pdns-backend-mysql recommends:
ii  mysql-client                     5.5.33+dfsg-0+wheezy1
ii  mysql-client-5.5 [mysql-client]  5.5.33+dfsg-0+wheezy1

Versions of packages pdns-backend-mysql suggests:
ii  mysql-server  5.5.33+dfsg-0+wheezy1

-- debconf information:
  pdns-backend-mysql/app-password-confirm: (password omitted)
  pdns-backend-mysql/mysql/admin-pass: (password omitted)
  pdns-backend-mysql/mysql/app-pass: (password omitted)
  pdns-backend-mysql/password-confirm: (password omitted)
* pdns-backend-mysql/mysql/admin-user: root
* pdns-backend-mysql/upgrade-backup: true
  pdns-backend-mysql/internal/skip-preseed: false
* pdns-backend-mysql/dbconfig-install: true
* pdns-backend-mysql/dbconfig-upgrade: true
* pdns-backend-mysql/remove-error:  abort
  pdns-backend-mysql/remote/host:
* pdns-backend-mysql/dbconfig-remove:
* pdns-backend-mysql/mysql/method: unix socket
* pdns-backend-mysql/upgrade-error:  abort
* pdns-backend-mysql/install-error:  ignore
* pdns-backend-mysql/db/dbname: pdns
  pdns-backend-mysql/remote/port:
  pdns-backend-mysql/purge: false
* pdns-backend-mysql/internal/reconfiguring: false
* pdns-backend-mysql/missing-db-package-error:  abort
* pdns-backend-mysql/db/app-user: pdns
* pdns-backend-mysql/dbconfig-reinstall: false
  pdns-backend-mysql/passwords-do-not-match:
* pdns-backend-mysql/database-type: mysql
  pdns-backend-mysql/remote/newhost: