[Pdns-users] zone2sql problem with _domainkey-records

[Arsen STASIC]

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:

zone-file-record:
rev1._domainkey             IN     TXT       "v=DKIM1\; k=rsa\; g=*\; s=email\; t=y\; p=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDupN2jUjsd5Tg2HpSHJlpkpvaqSww++4qmrxPyPllUc89YQJ71tvZFy38bFizE7kZlSjmu3RF2U8K8i6jVF1dXbwE6XvRf0hPBpKKWPH1FGxVYfzbMBfkvDmOmMFEOJjhOe5XzhoYjUVaEz4ponBU5amNu3d35okQ2/shQgariXQIDAQAB"

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';


dig-query:
dig @10.0.0.1 rev2._domainkey.test.ac.at TXT

; <<>> DiG 9.8.0 <<>> @10.0.0.1 rev2._domainkey.test.ac.at TXT
; (1 server found)
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: SERVFAIL, id: 32866
;; flags: qr aa rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 0
;; WARNING: recursion requested but not available

;; QUESTION SECTION:
;rev2._domainkey.test.ac.at.	IN	TXT

;; Query time: 2 msec
;; SERVER: 10.0.0.1#53(10.0.0.1)
;; WHEN: Mon May 30 14:00:10 2011
;; MSG SIZE  rcvd: 46


postges-record:
select * from records where name like '%domainkey%';
  id  | domain_id |             name             | type |                                                                                                                           content                                                                                                                            | ttl | prio | change_date | ordername | auth 
------+-----------+------------------------------+------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----+------+-------------+-----------+------
 2234 |         1 | rev2._domainkey.test.ac.at | TXT  | v=DKIM1\; k=rsa\; g=*\; s=email\; p=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCy3Mo0L1ZYekyD3lAAprA2dLz414BmJV2LUtfYiR9OcFcNxzf5XS+nsBTTdftECORHgv6azD9PueNPPcXpLTeOLQ/JDPNJ1eU7uDI3IpoejvcVRWyrwD4+ElEsJ/LVE2zDh4CXzZwvLHaFS1g/FRl/Op9HCMtrQNov10+Rf3Iw4wIDAQAB | 600 |    0 |  1305553141 |           |




If I populate the postgres-backend via axfr powerdns is able to serve this
record:


postgres-record:
select * from records where name like '%domainkey%';
  id  | domain_id |             name             | type |                                                                                                                             content                                                                                                                             | ttl | prio | change_date | ordername | auth 
------+-----------+------------------------------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----+------+-------------+-----------+------
 4477 |         1 | rev2._domainkey.test.ac.at | TXT  | "v=DKIM1; k=rsa; g=*; s=email; p=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCy3Mo0L1ZYekyD3lAAprA2dLz414BmJV2LUtfYiR9OcFcNxzf5XS+nsBTTdftECORHgv6azD9PueNPPcXpLTeOLQ/JDPNJ1eU7uDI3IpoejvcVRWyrwD4+ElEsJ/LVE2zDh4CXzZwvLHaFS1g/FRl/Op9HCMtrQNov10+Rf3Iw4wIDAQAB"      | 600 |   10 |             |           |


dig-query:
dig @10.0.0.1 rev2._domainkey.test.ac.at TXT

; <<>> DiG 9.8.0 <<>> @10.0.0.1 rev2._domainkey.test.ac.at TXT
; (1 server found)
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 17581
;; flags: qr aa rd; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0
;; WARNING: recursion requested but not available

;; QUESTION SECTION:
;rev2._domainkey.test.ac.at.	IN	TXT

;; ANSWER SECTION:
rev2._domainkey.test.ac.at. 600 IN	TXT	"v=DKIM1\; k=rsa\; g=*\; s=email\; p=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCy3Mo0L1ZYekyD3lAAprA2dLz414BmJV2LUtfYiR9OcFcNxzf5XS+nsBTTdftECORHgv6azD9PueNPPcXpLTeOLQ/JDPNJ1eU7uDI3IpoejvcVRWyrwD4+ElEsJ/LVE2zDh4CXzZwvLHaFS1g/FRl/Op9HCMtrQNov10+Rf3Iw4wIDAQAB"

;; Query time: 7 msec
;; SERVER: 10.0.0.1#53(10.0.0.1)
;; WHEN: Mon May 30 14:01:19 2011
;; MSG SIZE  rcvd: 307


regards,
Arsen STASIC