Got it.  I needed to rectify the zone.  For whatever reason, the zone wasn't rectified after making the change.  I need to look at ispconfig and find out why it didn't do that.

Thanks for all of your help,
--Curtis

On 11/8/24 10:37, Frank @ Kiwazo via Pdns-users wrote:


On 8 Nov 2024, at 16:23, Brian Candler via Pdns-users <pdns-users@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. INTXT

;; 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. INTXT

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

_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users

Reply via email to