<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><br id="lineBreakAtBeginningOfMessage"><div><br><blockquote type="cite"><div>On 8 Nov 2024, at 16:23, Brian Candler via Pdns-users <pdns-users@mailman.powerdns.com> wrote:</div><br class="Apple-interchange-newline"><div>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<div>
<div class="moz-cite-prefix">On 08/11/2024 15:18, Curtis Maurand via
Pdns-users wrote:<br>
</div>
<blockquote type="cite" cite="mid:75779F9C-23AF-4F17-9F45-211CCECF0591@maurand.com">
<div>From the sql query “select * from records where
domain_id=’47’ and type=’txt’” I get</div>
<div><br>
</div>
<div><div style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 17px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures">| 638 |
47 | circadianinfo.com._report._dmarc.xyonet.com |
TXT | v=DMARC1 </span></div><div style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 17px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><br>
</div><div style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 17px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;">Dig
returns nothing.</div><div style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 17px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><br>
</div><div style="margin: 0px; font-style: normal; font-variant-caps: normal; font-stretch: normal; font-size: 17px; line-height: normal; font-family: Menlo; font-size-adjust: none; font-kerning: auto; font-variant-alternates: normal; font-variant-ligatures: normal; font-variant-numeric: normal; font-variant-east-asian: normal; font-variant-position: normal; font-feature-settings: normal; font-optical-sizing: auto; font-variation-settings: normal;"><span style="font-variant-ligatures: no-common-ligatures">;
<<>> DiG 9.18.28-1~deb12u2-Debian
<<>> txt @localhost circadininfo.com.</span></div>
</div>
</blockquote><p><span style="font-variant-ligatures: no-common-ligatures">circadininfo
!= </span><span style="font-variant-ligatures: no-common-ligatures">circadianinfo</span></p>
</div>
</div></blockquote><div><br></div><div>Besides that, your ns1 and ns2 seem to disagree:</div><div><br></div><div>ns1 doesn't have the info:</div><div><br></div><div><div>❯ dig txt circadianinfo.com._report._dmarc.xyonet.com @ns1.xyonet.com.</div><div><br></div><div>; <<>> DiG 9.10.6 <<>> txt circadianinfo.com._report._dmarc.xyonet.com @ns1.xyonet.com.</div><div>;; global options: +cmd</div><div>;; Got answer:</div><div>;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 32216</div><div>;; flags: qr aa rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 1</div><div>;; WARNING: recursion requested but not available</div><div><br></div><div>;; OPT PSEUDOSECTION:</div><div>; EDNS: version: 0, flags:; udp: 1232</div><div>;; QUESTION SECTION:</div><div>;circadianinfo.com._report._dmarc.xyonet.com. IN<span class="Apple-tab-span" style="white-space:pre"> </span>TXT</div><div><br></div><div>;; Query time: 116 msec</div><div>;; SERVER: 208.105.217.26#53(208.105.217.26)</div><div>;; WHEN: Fri Nov 08 16:33:34 CET 2024</div><div>;; MSG SIZE rcvd: 72</div><div><br></div><div>While ns2 does have the record:</div><div><br></div><div><div>❯ dig txt circadianinfo.com._report._dmarc.xyonet.com @ns2.xyonet.com.</div><div><br></div><div>; <<>> DiG 9.10.6 <<>> txt circadianinfo.com._report._dmarc.xyonet.com @ns2.xyonet.com.</div><div>;; global options: +cmd</div><div>;; Got answer:</div><div>;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 14455</div><div>;; flags: qr aa rd; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1</div><div>;; WARNING: recursion requested but not available</div><div><br></div><div>;; OPT PSEUDOSECTION:</div><div>; EDNS: version: 0, flags:; udp: 1232</div><div>;; QUESTION SECTION:</div><div>;circadianinfo.com._report._dmarc.xyonet.com. IN<span class="Apple-tab-span" style="white-space:pre"> </span>TXT</div><div><br></div><div>;; ANSWER SECTION:</div><div>circadianinfo.com._report._dmarc.xyonet.com. 3600 IN TXT "v=DMARC1"</div><div><br></div><div>;; Query time: 106 msec</div><div>;; SERVER: 173.198.227.84#53(173.198.227.84)</div><div>;; WHEN: Fri Nov 08 16:34:05 CET 2024</div><div>;; MSG SIZE rcvd: 93</div><div><br></div><div><br></div><div>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...</div><div><br></div><div><br></div><div><br></div><div>Frank</div></div></div></div></body></html>