[Pdns-users] zone2sql problem with _domainkey-records

[Arsen STASIC]

* bert hubert <bert.hubert at netherlabs.nl> [2011-05-31 12:55 (+0200)]:
> On Mon, May 30, 2011 at 02:14:58PM +0200, Arsen STASIC wrote:
> > hi,
> > 
> > If I convert a valid zone-file to postgres-backend via zone2sql a valid
> > sql-loader-file is generated but unfortunately powerdns is unable to
> > serve this record:
> 
> Hi Arsen,
> 
> Can you re-test against a recent snapshot from
> http://powerdnssec.org/downloads ? 

Unfortunately it does not work.

I have used pdns-3.0-rc2.20110529.2203 but the sql-loader-file is the
same one as the original (2.9.22).

NEW hosts-gpgsql-record:
insert into records (domain_id, name,type,content,ttl,prio) select id ,'rev1._domainkey.test.ac.at', 'TXT', '"v=DKIM1\\; k=rsa\\; g=*\\; s=email\\; t=y\\; p=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDupN2jUjsd5Tg2HpSHJlpkpvaqSww++4qmrxPyPllUc89YQJ71tvZFy38bFizE7kZlSjmu3RF2U8K8i6jVF1dXbwE6XvRf0hPBpKKWPH1FGxVYfzbMBfkvDmOmMFEOJjhOe5XzhoYjUVaEz4ponBU5amNu3d35okQ2/shQgariXQIDAQAB"', 600, 0 from domains where name='test.ac.at';

OLD hosts-gpgsql-record:
insert into records (domain_id, name,type,content,ttl,prio) select id ,'rev1._domainkey.test.ac.at', 'TXT', '"v=DKIM1\\; k=rsa\\; g=*\\; s=email\\; t=y\\; p=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDupN2jUjsd5Tg2HpSHJlpkpvaqSww++4qmrxPyPllUc89YQJ71tvZFy38bFizE7kZlSjmu3RF2U8K8i6jVF1dXbwE6XvRf0hPBpKKWPH1FGxVYfzbMBfkvDmOmMFEOJjhOe5XzhoYjUVaEz4ponBU5amNu3d35okQ2/shQgariXQIDAQAB"', 600, 0 from domains where name='test.ac.at';


regards,
Arsen STASIC