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
_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users
