[Pkg-pdns-maintainers] Bug#707761: pdns-backend-pgsql: IP fields too short for master/slave operation over IPv6

[marcos at marcosdumay.com]

Package: pdns-backend-pgsql
Version: 3.1-4
Severity: normal

Dear Maintainer,

The PowerDNS master/slave synchronization does not work over IPv6 because the database schema can not hold the addresses.

A supermaster can not be configured, because the column supermaster.ip holds a maxumim of 25 characters, and the domain replication fails because the column domain.master holds a maximum of 20 characters. Increasing those limits to 39 characters, the maximum length of an IPv6 address, solves the problem.


-- System Information:
Debian Release: 7.0
  APT prefers oldstable-updates
  APT policy: (500, 'oldstable-updates'), (500, 'stable'), (500, 'oldstable')
Architecture: i386 (i686)

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

Versions of packages pdns-backend-pgsql 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  libpolarssl0           1.1.4-2
ii  libpq5                 9.1.9-1
ii  libssl1.0.0            1.0.1e-2
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-pgsql recommends:
ii  postgresql-client                          9.1+134wheezy3
ii  postgresql-client-8.4 [postgresql-client]  8.4.17-0squeeze1
ii  postgresql-client-9.1 [postgresql-client]  9.1.9-1

Versions of packages pdns-backend-pgsql suggests:
ii  postgresql  9.1+134wheezy3

-- debconf information:
  pdns-backend-pgsql/pgsql/authmethod-admin: ident
  pdns-backend-pgsql/internal/skip-preseed: false
* pdns-backend-pgsql/dbconfig-install: true
  pdns-backend-pgsql/upgrade-error: abort
  pdns-backend-pgsql/upgrade-backup: true
  pdns-backend-pgsql/pgsql/authmethod-user: ident
  pdns-backend-pgsql/dbconfig-remove:
  pdns-backend-pgsql/db/dbname: pdns
  pdns-backend-pgsql/remote/port:
  pdns-backend-pgsql/pgsql/manualconf:
  pdns-backend-pgsql/pgsql/method: unix socket
  pdns-backend-pgsql/remote/newhost:
  pdns-backend-pgsql/remove-error: abort
  pdns-backend-pgsql/db/app-user: pdns
  pdns-backend-pgsql/missing-db-package-error: abort
  pdns-backend-pgsql/install-error: abort
  pdns-backend-pgsql/pgsql/no-empty-passwords:
  pdns-backend-pgsql/pgsql/admin-user: postgres
  pdns-backend-pgsql/remote/host:
  pdns-backend-pgsql/pgsql/changeconf: false
  pdns-backend-pgsql/database-type: pgsql
  pdns-backend-pgsql/internal/reconfiguring: false
  pdns-backend-pgsql/passwords-do-not-match:
  pdns-backend-pgsql/dbconfig-upgrade: true
  pdns-backend-pgsql/dbconfig-reinstall: false
  pdns-backend-pgsql/purge: false