severity #698911 normal
tags #598911 confirmed
thanks

On Fri, Jan 25, 2013 at 07:56:13AM +0000, James Cloos wrote:
> Debian’s default schema for pdns-backend-pgsql specifies that the 
> records.content
> column be varchar(255).
> 
> That is insufficient for some records, such as RRSIG RRs used with dnssec.
> 
> Upstream has updated to varchar(65535), although text also would be find.
> 
> When using deb’s version of pdns as an axfr slave nameserver, pdns will be
> unable to save the zones which have been dnssec-signed by the master server
> into the records table, blocking operation for such zones completely.

This can easily be fixed locally, does not lead to data loss, and only
applies to two (albeit popular) database backends.

I confirm this issue, but am downgrading severity appropriately.

> The fix for new installs is a simple one-line change to the default schema as
> described above.

Will do, and hope to be able to get this approved for wheezy.

>   Existing installs which choose automatic maintainance of the pdns
>   db, though, should be updated by way of an:
> 
>    ALTER TABLE records ALTER COLUMN content TYPE VARCHAR(65535);

I would appreciate a patch for that.

Greetings
Marc

-- 
-----------------------------------------------------------------------------
Marc Haber         | "I don't trust Computers. They | Mailadresse im Header
Mannheim, Germany  |  lose things."    Winona Ryder | Fon: *49 621 31958061
Nordisch by Nature |  How to make an American Quilt | Fax: *49 621 31958062


-- 
To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to