[Pdns-users] txt record not returning a value

[Frank @ Kiwazo]

> On 8 Nov 2024, at 16:23, Brian Candler via Pdns-users <pdns-users at mailman.powerdns.com> wrote:
> 
> On 08/11/2024 15:18, Curtis Maurand via Pdns-users wrote:
>> From the sql query “select * from records where domain_id=’47’ and type=’txt’” I get
>> 
>> | 638 |        47 | circadianinfo.com._report._dmarc.xyonet.com | TXT  | v=DMARC1 
>> 
>> Dig returns nothing.
>> 
>> ; <<>> DiG 9.18.28-1~deb12u2-Debian <<>> txt @localhost circadininfo.com.
> circadininfo != circadianinfo
> 

Besides that, your ns1 and ns2 seem to disagree:

ns1 doesn't have the info:

❯ dig txt circadianinfo.com._report._dmarc.xyonet.com @ns1.xyonet.com.

; <<>> DiG 9.10.6 <<>> txt circadianinfo.com._report._dmarc.xyonet.com @ns1.xyonet.com.
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 32216
;; flags: qr aa rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 1
;; WARNING: recursion requested but not available

;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 1232
;; QUESTION SECTION:
;circadianinfo.com._report._dmarc.xyonet.com. IN	TXT

;; Query time: 116 msec
;; SERVER: 208.105.217.26#53(208.105.217.26)
;; WHEN: Fri Nov 08 16:33:34 CET 2024
;; MSG SIZE  rcvd: 72

While ns2 does have the record:

❯ dig txt circadianinfo.com._report._dmarc.xyonet.com @ns2.xyonet.com.

; <<>> DiG 9.10.6 <<>> txt circadianinfo.com._report._dmarc.xyonet.com @ns2.xyonet.com.
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 14455
;; flags: qr aa rd; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1
;; WARNING: recursion requested but not available

;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 1232
;; QUESTION SECTION:
;circadianinfo.com._report._dmarc.xyonet.com. IN	TXT

;; ANSWER SECTION:
circadianinfo.com._report._dmarc.xyonet.com. 3600 IN TXT "v=DMARC1"

;; Query time: 106 msec
;; SERVER: 173.198.227.84#53(173.198.227.84)
;; WHEN: Fri Nov 08 16:34:05 CET 2024
;; MSG SIZE  rcvd: 93


I suggest you check what's going on there... On top of that, there seem to be dnssec errors as well for that zone. Inserting things into a DB backend directly is considered bad. Doing that for a dnssec signed zone is very bad. Try to run a rectify-zone and see if that improves...



Frank
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20241108/2934c899/attachment.htm>