![[ DNS Administrator ]](/fx/dnsadmin-logo.png){kind=logo}
- Timestamp:
- 03/06/26 11:33:19 (3 days ago)
- Location:
- trunk
- Files:
-
- 3 edited
- 2 copied
-
. (modified) (1 prop)
-
t/DNSTest.pm (modified) (5 diffs)
-
t/cname.t (copied) (copied from branches/cname-collision/t/cname.t )
-
t/dns-unitbase.sql (modified) (6 diffs)
-
t/test-cname-timestamps.sql (copied) (copied from branches/cname-collision/t/test-cname-timestamps.sql )
Legend:
- Unmodified
- Added
- Removed
-
trunk
- Property svn:mergeinfo changed
/branches/cname-collision (added) merged: 936-942,949-956,958-960,962-964,967-970,972-984,986-1001,1003-1006,1008-1031,1038-1046
- Property svn:mergeinfo changed
-
trunk/t/DNSTest.pm
r985 r1051 5 5 ## 6 6 # $Id$ 7 # Copyright 2025 Kris Deugau <kdeugau@deepnet.cx>7 # Copyright 2025,2026 Kris Deugau <kdeugau@deepnet.cx> 8 8 # 9 9 # This program is free software: you can redistribute it and/or modify … … 48 48 dbuser => 'dnstest', 49 49 dbpass => 'dnstestpwd', 50 51 # This exercises more branches of the CNAME collision check with more fine-grained results. 52 coerce_cname_timestamp => 'adjust', 50 53 ); 51 54 ok( defined $dnsdb ); … … 61 64 62 65 my ($dcount) = $dbh->selectrow_array("SELECT count(*) FROM domains WHERE NOT domain IN ". 63 "('example.com','example.net','example.org','expiry1.test','expiry2.test' )");66 "('example.com','example.net','example.org','expiry1.test','expiry2.test','expiry3.test','cname-blocks1.test')"); 64 67 BAIL_OUT("# DB looks like it may not be a test DB, found $dcount > 0 non-test domains!\n") 65 68 if $dcount > 0; … … 68 71 my ($rcount) = $dbh->selectrow_array(qq{SELECT count(*) FROM records WHERE NOT ( 69 72 host like '%example.com' or host like '%example.net' or host like '%example.org' or 70 host like '%expiry1.test' or host like '%expiry2.test' or inetlazy(val) << '192.168.2.0/27' 73 host like '%expiry_.test' or host like '%cname-blocks_.test' or 74 inetlazy(val) << '192.168.2.0/27' 71 75 )}); 72 76 my $maxrecs = 0; 73 BAIL_OUT("# DB looks like it may not be a test DB, found $rcount > $maxrecs records!\n")77 BAIL_OUT("# DB looks like it may not be a test DB, found $rcount > $maxrecs non-test records!\n") 74 78 if $rcount > $maxrecs; 75 79 cmp_ok( $rcount, '<=', $maxrecs, "non-test record ($rcount): looks like a test DB" ); … … 83 87 my $reload = qx( psql -h $dnsdb->{dbhost} -U $dnsdb->{dbuser} $dnsdb->{dbname} 2>&1 < t/dns-unitbase.sql ); 84 88 diag( $reload ) if $debug; 89 # Set timestamps to a sliding window 90 my $stampwindow = qx( psql -h $dnsdb->{dbhost} -U $dnsdb->{dbuser} $dnsdb->{dbname} 2>&1 < t/test-cname-timestamps.sql ); 91 diag( $stampwindow ) if $debug; 85 92 undef $ENV{PGPASSWORD}; 86 93 } # new() -
trunk/t/dns-unitbase.sql
r965 r1051 657 657 2 example.org 1 1 2025121800 D f ac 658 658 3 example.net 1 1 2025121800 D f ab 659 4 expiry1.test 1 1 1765992407 D f 659 4 expiry1.test 1 1 2026011400 D t 660 5 expiry2.test 1 1 2026011901 D t 661 6 expiry3.test 1 1 2026020509 D t 662 7 cname-blocks1.test 1 1 2026021811 D t 660 663 \. 661 664 … … 665 668 -- 666 669 667 SELECT pg_catalog.setval('public.domains_domain_id_seq', 4, true);670 SELECT pg_catalog.setval('public.domains_domain_id_seq', 7, true); 668 671 669 672 … … 761 764 53 0 1 1 admin Initial User Added record '192.168.2.17 TXT imma blocker!', TTL 2560 2025-12-23 13:06:20.492137-05 1 0 762 765 55 0 1 1 admin Initial User Added record '192.168.2.18 CNAME 18-2.arpa.example.com', TTL 2560 2026-01-07 16:37:03.094557-05 1 0 766 56 4 1 1 admin Initial User Added record 'expired1.expiry1.test A 192.168.2.23', TTL 5400, expires at 2025-12-24 18:30 2026-01-07 17:55:46.022401-05 0 0 767 57 4 1 1 admin Initial User Added record 'expired2.expiry1.test TXT imma expire soon', TTL 5400, expires at 2026-01-10 07:00 2026-01-07 17:57:07.015962-05 0 0 768 58 4 1 1 admin Initial User Added record 'active-after1.expiry1.test TXT not active yet', TTL 5400, valid after 2026-01-11 11:30 2026-01-07 18:12:57.491476-05 0 0 769 59 4 1 1 admin Initial User Added record 'active-after2.expiry1.test TXT I'm done waiting', TTL 5400, expires at 2025-12-31 14:00 2026-01-14 18:02:13.876839-05 0 0 770 60 5 1 1 admin Initial User Added active domain expiry2.test 2026-01-15 12:08:59.951774-05 0 0 771 61 5 1 1 admin Initial User [new expiry2.test] Added SOA record [contact ns1.example.com] [master hostmaster.expiry2.test] [refresh 10800] [retry 3600] [expire 604800] [minttl 5400], TTL 86400 2026-01-15 12:08:59.951774-05 0 60 772 62 5 1 1 admin Initial User [new expiry2.test] Added record 'expiry2.test NS ns2.example.com', TTL 7200 2026-01-15 12:08:59.951774-05 0 60 773 63 5 1 1 admin Initial User [new expiry2.test] Added record 'expiry2.test NS ns1.example.com', TTL 7200 2026-01-15 12:08:59.951774-05 0 60 774 64 5 1 1 admin Initial User [new expiry2.test] Added record 'expiry2.test A 10.0.0.4', TTL 7200 2026-01-15 12:08:59.951774-05 0 60 775 65 5 1 1 admin Initial User [new expiry2.test] Added record 'expiry2.test MX [distance 10] mx1.example.com', TTL 7200 2026-01-15 12:08:59.951774-05 0 60 776 66 5 1 1 admin Initial User [new expiry2.test] Added record 'www.expiry2.test CNAME expiry2.test', TTL 10800 2026-01-15 12:08:59.951774-05 0 60 777 67 5 1 1 admin Initial User [new expiry2.test] Added record 'expiry2.test TXT "v=spf1 a mx -all"', TTL 10800 2026-01-15 12:08:59.951774-05 0 60 778 68 5 1 1 admin Initial User Added record 'expires-at1.expiry2.test TXT Hanging around', TTL 5400 2026-01-15 12:57:28.411931-05 0 0 779 69 5 1 1 admin Initial User Added record 'expires-at2.expiry2.test TXT imma expire soon', TTL 5400, expires at 2026-01-15 18:00 2026-01-15 12:58:51.09629-05 0 0 780 70 5 1 1 admin Initial User Added record 'expires-at3.expiry2.test TXT active after pending expiry', TTL 5400, expires at 2026-01-15 18:00 2026-01-15 13:21:31.833257-05 0 0 781 71 5 1 1 admin Initial User Added record 'expires-at4.expiry2.test TXT active before pending expiry', TTL 5400, expires at 2026-01-15 18:00 2026-01-15 17:59:01.61806-05 0 0 782 72 5 1 1 admin Initial User Added record 'expires-at5.expiry2.test TXT expired before now', TTL 5400, expires at 2026-01-15 18:00 2026-01-16 11:50:43.678446-05 0 0 783 73 5 1 1 admin Initial User Added record 'valid-after1.expiry2.test TXT always here', TTL 5400 2026-01-16 13:36:36.066418-05 0 0 784 74 5 1 1 admin Initial User Added record 'valid-after2.expiry2.test TXT valid soon', TTL 5400, expires at 2026-01-15 18:00 2026-01-16 13:38:57.274666-05 0 0 785 75 5 1 1 admin Initial User Added record 'valid-after3.expiry2.test TXT valid days ago', TTL 5400, expires at 2026-01-15 18:00 2026-01-16 13:45:27.179614-05 0 0 786 76 5 1 1 admin Initial User Added record 'valid-after4.expiry2.test TXT valid quite soon', TTL 5400, expires at 2026-01-15 18:00 2026-01-19 11:40:07.438603-05 0 0 787 77 5 1 1 admin Initial User Added record 'valid-after5.expiry2.test TXT expires before pending valid', TTL 5400, expires at 2026-01-15 18:00 2026-01-19 11:40:55.325144-05 0 0 788 78 6 1 1 admin Initial User Added active domain expiry3.test 2026-01-29 18:05:53.678277-05 0 0 789 79 6 1 1 admin Initial User [new expiry3.test] Added SOA record [contact ns1.example.com] [master hostmaster.expiry3.test] [refresh 10800] [retry 3600] [expire 604800] [minttl 5400], TTL 86400 2026-01-29 18:05:53.678277-05 0 78 790 80 6 1 1 admin Initial User [new expiry3.test] Added record 'expiry3.test NS ns2.example.com', TTL 7200 2026-01-29 18:05:53.678277-05 0 78 791 81 6 1 1 admin Initial User [new expiry3.test] Added record 'expiry3.test NS ns1.example.com', TTL 7200 2026-01-29 18:05:53.678277-05 0 78 792 82 6 1 1 admin Initial User [new expiry3.test] Added record 'expiry3.test A 10.0.0.4', TTL 7200 2026-01-29 18:05:53.678277-05 0 78 793 83 6 1 1 admin Initial User [new expiry3.test] Added record 'expiry3.test MX [distance 10] mx1.example.com', TTL 7200 2026-01-29 18:05:53.678277-05 0 78 794 84 6 1 1 admin Initial User [new expiry3.test] Added record 'www.expiry3.test CNAME expiry3.test', TTL 10800 2026-01-29 18:05:53.678277-05 0 78 795 85 6 1 1 admin Initial User [new expiry3.test] Added record 'expiry3.test TXT "v=spf1 a mx -all"', TTL 10800 2026-01-29 18:05:53.678277-05 0 78 796 86 6 1 1 admin Initial User Added record 'nostamp1a.expiry3.test TXT target - expired', TTL 5400, expires at 2026-01-29 14:00 2026-01-30 15:07:08.695134-05 0 0 797 87 6 1 1 admin Initial User Added record 'nostamp2a.expiry3.test TXT target - soon to expire', TTL 5400, expires at 2026-01-31 14:00 2026-01-30 15:07:34.780671-05 0 0 798 88 6 1 1 admin Initial User Added record 'nostamp3a.expiry3.test TXT target - valid soon', TTL 5400, valid after 2026-01-31 14:00 2026-01-30 15:07:53.379107-05 0 0 799 89 6 1 1 admin Initial User Added record 'nostamp4a.expiry3.test TXT target - already valid', TTL 5400, valid after 2026-01-29 14:00 2026-01-30 15:08:15.4399-05 0 0 800 90 6 1 1 admin Initial User Added record 'nostamp1b.expiry3.test TXT to change', TTL 5400 2026-01-30 15:29:48.433198-05 0 0 801 91 6 1 1 admin Initial User Added record 'nostamp2b.expiry3.test TXT to change', TTL 5400 2026-01-30 15:29:53.902318-05 0 0 802 92 6 1 1 admin Initial User Added record 'nostamp3b.expiry3.test TXT to change', TTL 5400 2026-01-30 15:29:57.875273-05 0 0 803 93 6 1 1 admin Initial User Added record 'nostamp4b.expiry3.test TXT to change', TTL 5400 2026-01-30 15:30:01.924263-05 0 0 804 94 6 1 1 admin Initial User Added record 'expires1a.expiry3.test TXT target - no timestamp', TTL 5400 2026-02-03 12:02:32.883354-05 0 0 805 95 6 1 1 admin Initial User Added record 'expires2a.expiry3.test TXT target - expired', TTL 5400, expires at 2026-01-29 14:00 2026-02-03 12:03:09.031474-05 0 0 806 96 6 1 1 admin Initial User Added record 'expires3a.expiry3.test TXT target - expires soon', TTL 5400, expires at 2026-01-31 14:00 2026-02-03 12:04:30.954558-05 0 0 807 97 6 1 1 admin Initial User Added record 'expires4a.expiry3.test TXT target - valid soon', TTL 5400, valid after 2026-01-31 14:00 2026-02-03 12:04:52.864866-05 0 0 808 98 6 1 1 admin Initial User Added record 'expires5a.expiry3.test TXT target - already valid', TTL 5400, valid after 2026-01-29 14:00 2026-02-03 12:05:10.629373-05 0 0 809 99 6 1 1 admin Initial User Added record 'expires6a.expiry3.test TXT target - valid less soon', TTL 5400, valid after 2026-01-15 18:00 2026-02-03 12:05:31.096289-05 0 0 810 100 6 1 1 admin Initial User Added record 'expires1b.expiry3.test TXT to change', TTL 5400 2026-02-03 12:05:33.779645-05 0 0 811 101 6 1 1 admin Initial User Added record 'expires2b.expiry3.test TXT to change', TTL 5400 2026-02-03 12:05:44.12329-05 0 0 812 102 6 1 1 admin Initial User Added record 'expires3b.expiry3.test TXT to change', TTL 5400 2026-02-03 12:05:50.968888-05 0 0 813 103 6 1 1 admin Initial User Added record 'expires4b.expiry3.test TXT to change', TTL 5400 2026-02-03 12:05:56.415551-05 0 0 814 104 6 1 1 admin Initial User Added record 'expires5b.expiry3.test TXT to change', TTL 5400 2026-02-03 12:06:01.591204-05 0 0 815 105 6 1 1 admin Initial User Added record 'expires6b.expiry3.test TXT to change', TTL 5400 2026-02-03 12:06:34.192183-05 0 0 816 106 6 1 1 admin Initial User Added record 'validafter1a.expiry3.test TXT target - no timestamp', TTL 5400 2026-02-05 17:06:17.118891-05 0 0 817 107 6 1 1 admin Initial User Added record 'validafter2a.expiry3.test TXT target - expires in the future', TTL 5400, expires at 2026-02-05 17:30 2026-02-05 17:07:12.29965-05 0 0 818 108 6 1 1 admin Initial User Added record 'validafter3a.expiry3.test TXT target - expires soon', TTL 5400, expires at 2026-02-05 17:30 2026-02-05 17:07:49.064852-05 0 0 819 109 6 1 1 admin Initial User Added record 'validafter4a.expiry3.test TXT target - valid less soon', TTL 5400, valid after 2026-02-05 17:30 2026-02-05 17:14:01.474778-05 0 0 820 110 6 1 1 admin Initial User Added record 'validafter5a.expiry3.test TXT target - valid soon', TTL 5400, valid after 2026-02-05 17:30 2026-02-05 17:14:25.354496-05 0 0 821 111 6 1 1 admin Initial User Added record 'validafter1b.expiry3.test TXT to change', TTL 5400 2026-02-05 17:16:49.945082-05 0 0 822 112 6 1 1 admin Initial User Added record 'validafter2b.expiry3.test TXT to change', TTL 5400 2026-02-05 17:16:59.246035-05 0 0 823 113 6 1 1 admin Initial User Added record 'validafter3b.expiry3.test TXT to change', TTL 5400 2026-02-05 17:17:04.371248-05 0 0 824 114 6 1 1 admin Initial User Added record 'validafter4b.expiry3.test TXT to change', TTL 5400 2026-02-05 17:17:09.60198-05 0 0 825 115 6 1 1 admin Initial User Added record 'validafter5b.expiry3.test TXT to change', TTL 5400 2026-02-05 17:17:15.012334-05 0 0 826 116 7 1 1 admin Initial User Added active domain cname-blocks1.test 2026-02-18 18:00:14.727439-05 0 0 827 117 7 1 1 admin Initial User [new cname-blocks1.test] Added SOA record [contact ns1.example.com] [master hostmaster.cname-blocks1.test] [refresh 10800] [retry 3600] [expire 604800] [minttl 5400], TTL 86400 2026-02-18 18:00:14.727439-05 0 116 828 118 7 1 1 admin Initial User [new cname-blocks1.test] Added record 'cname-blocks1.test NS ns2.example.com', TTL 7200 2026-02-18 18:00:14.727439-05 0 116 829 119 7 1 1 admin Initial User [new cname-blocks1.test] Added record 'cname-blocks1.test NS ns1.example.com', TTL 7200 2026-02-18 18:00:14.727439-05 0 116 830 120 7 1 1 admin Initial User [new cname-blocks1.test] Added record 'cname-blocks1.test A 10.0.0.4', TTL 7200 2026-02-18 18:00:14.727439-05 0 116 831 121 7 1 1 admin Initial User [new cname-blocks1.test] Added record 'cname-blocks1.test MX [distance 10] mx1.example.com', TTL 7200 2026-02-18 18:00:14.727439-05 0 116 832 122 7 1 1 admin Initial User [new cname-blocks1.test] Added record 'www.cname-blocks1.test CNAME cname-blocks1.test', TTL 10800 2026-02-18 18:00:14.727439-05 0 116 833 123 7 1 1 admin Initial User [new cname-blocks1.test] Added record 'cname-blocks1.test TXT "v=spf1 a mx -all"', TTL 10800 2026-02-18 18:00:14.727439-05 0 116 834 124 7 1 1 admin Initial User Added record 'blocker01.cname-blocks1.test TXT I do not collide', TTL 5400 2026-02-18 18:00:35.918847-05 0 0 835 125 7 1 1 admin Initial User Added record 'blocker02.cname-blocks1.test CNAME target.example.com', TTL 5400 2026-02-18 18:00:54.003589-05 0 0 836 126 7 1 1 admin Initial User Added record 'blocker03.cname-blocks1.test CNAME target.example.com', TTL 5400, expires at 2026-02-20 20:20:00-05 2026-02-18 18:01:13.009519-05 0 0 837 127 7 1 1 admin Initial User Added record 'blocker04.cname-blocks1.test CNAME target.example.com', TTL 5400, valid after 2026-02-20 20:20:00-05 2026-02-18 18:01:24.142491-05 0 0 838 128 7 1 1 admin Initial User Added record 'blocker05.cname-blocks1.test CNAME target.example.com', TTL 5400 2026-02-18 18:02:22.263541-05 0 0 839 129 7 1 1 admin Initial User Added record 'blocker06.cname-blocks1.test CNAME target.example.com', TTL 5400, expires at 2026-02-20 20:20:00-05 2026-02-18 18:02:37.418389-05 0 0 840 130 7 1 1 admin Initial User Added record 'blocker07.cname-blocks1.test CNAME target.example.com', TTL 5400, valid after 2026-02-20 20:20:00-05 2026-02-18 18:02:47.023266-05 0 0 841 131 7 1 1 admin Initial User Added record 'blocker08.cname-blocks1.test CNAME target.example.com', TTL 5400, valid after 2026-02-20 20:20:00-05 2026-02-18 18:02:52.405397-05 0 0 842 132 7 1 1 admin Initial User Added record 'blocker09.cname-blocks1.test CNAME target.example.com', TTL 5400 2026-02-18 18:03:11.617403-05 0 0 843 133 7 1 1 admin Initial User Added record 'blocker10.cname-blocks1.test CNAME target.example.com', TTL 5400, expires at 2026-02-20 20:20:00-05 2026-02-18 18:03:25.888935-05 0 0 844 134 7 1 1 admin Initial User Added record 'blocker11.cname-blocks1.test CNAME target.example.com', TTL 5400, expires at 2026-02-20 20:20:00-05 2026-02-18 18:03:33.383937-05 0 0 845 135 7 1 1 admin Initial User Added record 'blocker12.cname-blocks1.test CNAME target.example.com', TTL 5400, valid after 2026-02-20 20:20:00-05 2026-02-18 18:03:41.441495-05 0 0 763 846 \. 764 847 … … 768 851 -- 769 852 770 SELECT pg_catalog.setval('public.log_log_id_seq', 55, true);853 SELECT pg_catalog.setval('public.log_log_id_seq', 135, true); 771 854 772 855 … … 855 938 0 45 imma blocker! 16 192.168.2.17 0 0 0 2560 \N 1 1969-12-31 19:00:00-05 f f \N 856 939 0 46 18-2.arpa.example.com 5 192.168.2.18 0 0 0 2560 \N 1 1969-12-31 19:00:00-05 f f \N 940 4 47 expired1.expiry1.test 1 192.168.2.23 0 0 0 5400 \N 0 2025-12-24 18:30:00-05 t t \N 941 4 48 expired2.expiry1.test 16 imma expire soon 0 0 0 5400 \N 0 2026-01-10 07:00:00-05 t t \N 942 4 49 active-after1.expiry1.test 16 not active yet 0 0 0 5400 \N 0 2026-01-11 11:30:00-05 f t \N 943 4 50 active-after2.expiry1.test 16 I'm done waiting 0 0 0 5400 \N 0 2025-12-31 14:00:00-05 f t \N 944 5 51 ns1.example.com:hostmaster.expiry2.test 6 10800:3600:604800:5400 0 0 0 86400 \N 0 1969-12-31 19:00:00-05 f f \N 945 5 52 expiry2.test 2 ns2.example.com 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 946 5 53 expiry2.test 2 ns1.example.com 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 947 5 54 expiry2.test 1 10.0.0.4 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 948 5 55 expiry2.test 15 mx1.example.com 10 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 949 5 56 www.expiry2.test 5 expiry2.test 0 0 0 10800 \N 0 1969-12-31 19:00:00-05 f f \N 950 5 57 expiry2.test 16 "v=spf1 a mx -all" 0 0 0 10800 \N 0 1969-12-31 19:00:00-05 f f \N 951 5 58 expires-at1.expiry2.test 16 Hanging around 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 952 5 59 expires-at2.expiry2.test 16 imma expire soon 0 0 0 5400 \N 0 2026-01-15 18:00:00-05 t t \N 953 5 60 expires-at3.expiry2.test 16 active after pending expiry 0 0 0 5400 \N 0 2026-01-15 18:00:00-05 f t \N 954 5 61 expires-at4.expiry2.test 16 active before pending expiry 0 0 0 5400 \N 0 2026-01-15 18:00:00-05 f t \N 955 5 62 expires-at5.expiry2.test 16 expired before now 0 0 0 5400 \N 0 2026-01-15 18:00:00-05 t t \N 956 5 63 valid-after1.expiry2.test 16 always here 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 957 5 64 valid-after2.expiry2.test 16 expires soon 0 0 0 5400 \N 0 2026-01-15 18:00:00-05 t t \N 958 5 65 valid-after3.expiry2.test 16 valid days ago 0 0 0 5400 \N 0 2026-01-15 18:00:00-05 f t \N 959 5 66 valid-after4.expiry2.test 16 valid quite soon 0 0 0 5400 \N 0 2026-01-15 18:00:00-05 f t \N 960 5 67 valid-after5.expiry2.test 16 expires before pending valid 0 0 0 5400 \N 0 2026-01-15 18:00:00-05 t t \N 961 6 68 ns1.example.com:hostmaster.expiry3.test 6 10800:3600:604800:5400 0 0 0 86400 \N 0 1969-12-31 19:00:00-05 f f \N 962 6 69 expiry3.test 2 ns2.example.com 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 963 6 70 expiry3.test 2 ns1.example.com 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 964 6 71 expiry3.test 1 10.0.0.4 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 965 6 72 expiry3.test 15 mx1.example.com 10 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 966 6 73 www.expiry3.test 5 expiry3.test 0 0 0 10800 \N 0 1969-12-31 19:00:00-05 f f \N 967 6 74 expiry3.test 16 "v=spf1 a mx -all" 0 0 0 10800 \N 0 1969-12-31 19:00:00-05 f f \N 968 6 75 nostamp1a.expiry3.test 16 target - expired 0 0 0 5400 \N 0 2026-01-29 14:00:00-05 t t \N 969 6 76 nostamp2a.expiry3.test 16 target - soon to expire 0 0 0 5400 \N 0 2026-01-31 14:00:00-05 t t \N 970 6 77 nostamp3a.expiry3.test 16 target - valid soon 0 0 0 5400 \N 0 2026-01-31 14:00:00-05 f t \N 971 6 78 nostamp4a.expiry3.test 16 target - already valid 0 0 0 5400 \N 0 2026-01-29 14:00:00-05 f t \N 972 6 79 nostamp1b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 973 6 80 nostamp2b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 974 6 81 nostamp3b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 975 6 82 nostamp4b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 976 6 83 expires1a.expiry3.test 16 target - no timestamp 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 977 6 84 expires2a.expiry3.test 16 target - expired 0 0 0 5400 \N 0 2026-01-29 14:00:00-05 t t \N 978 6 85 expires3a.expiry3.test 16 target - expires soon 0 0 0 5400 \N 0 2026-01-31 14:00:00-05 t t \N 979 6 86 expires4a.expiry3.test 16 target - valid soon 0 0 0 5400 \N 0 2026-01-31 14:00:00-05 f t \N 980 6 87 expires5a.expiry3.test 16 target - already valid 0 0 0 5400 \N 0 2026-01-29 14:00:00-05 f t \N 981 6 88 expires6a.expiry3.test 16 target - valid less soon 0 0 0 5400 \N 0 2026-01-29 14:00:00-05 f t \N 982 6 89 expires1b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 983 6 90 expires2b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 984 6 91 expires3b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 985 6 92 expires4b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 986 6 93 expires5b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 987 6 94 expires6b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 988 6 95 validafter1a.expiry3.test 16 target - no timestamp 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 989 6 96 validafter2a.expiry3.test 16 target - expires in the future 0 0 0 5400 \N 0 2026-02-05 17:30:00-05 t t \N 990 6 97 validafter3a.expiry3.test 16 target - expires soon 0 0 0 5400 \N 0 2026-02-05 17:30:00-05 t t \N 991 6 98 validafter4a.expiry3.test 16 target - valid less soon 0 0 0 5400 \N 0 2026-02-05 17:30:00-05 f t \N 992 6 99 validafter5a.expiry3.test 16 target - valid soon 0 0 0 5400 \N 0 2026-02-05 17:30:00-05 f t \N 993 6 100 validafter1b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 994 6 101 validafter2b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 995 6 102 validafter3b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 996 6 103 validafter4b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 997 6 104 validafter5b.expiry3.test 16 to change 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 998 7 105 ns1.example.com:hostmaster.cname-blocks1.test 6 10800:3600:604800:5400 0 0 0 86400 \N 0 1969-12-31 19:00:00-05 f f \N 999 7 106 cname-blocks1.test 2 ns2.example.com 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 1000 7 107 cname-blocks1.test 2 ns1.example.com 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 1001 7 108 cname-blocks1.test 1 10.0.0.4 0 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 1002 7 109 cname-blocks1.test 15 mx1.example.com 10 0 0 7200 \N 0 1969-12-31 19:00:00-05 f f \N 1003 7 110 www.cname-blocks1.test 5 cname-blocks1.test 0 0 0 10800 \N 0 1969-12-31 19:00:00-05 f f \N 1004 7 111 cname-blocks1.test 16 "v=spf1 a mx -all" 0 0 0 10800 \N 0 1969-12-31 19:00:00-05 f f \N 1005 7 112 blocker01.cname-blocks1.test 16 I do not collide 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 1006 7 113 blocker02.cname-blocks1.test 5 target.example.com 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 1007 7 114 blocker03.cname-blocks1.test 5 target.example.com 0 0 0 5400 \N 0 2026-02-20 20:20:00-05 t t \N 1008 7 115 blocker04.cname-blocks1.test 5 target.example.com 0 0 0 5400 \N 0 2026-02-20 20:20:00-05 f t \N 1009 7 116 blocker05.cname-blocks1.test 5 target.example.com 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 1010 7 117 blocker06.cname-blocks1.test 5 target.example.com 0 0 0 5400 \N 0 2026-02-20 20:20:00-05 t t \N 1011 7 118 blocker07.cname-blocks1.test 5 target.example.com 0 0 0 5400 \N 0 2026-02-20 20:20:00-05 f t \N 1012 7 119 blocker08.cname-blocks1.test 5 target.example.com 0 0 0 5400 \N 0 2026-02-20 20:20:00-05 f t \N 1013 7 120 blocker09.cname-blocks1.test 5 target.example.com 0 0 0 5400 \N 0 1969-12-31 19:00:00-05 f f \N 1014 7 121 blocker10.cname-blocks1.test 5 target.example.com 0 0 0 5400 \N 0 2026-02-20 20:20:00-05 t t \N 1015 7 122 blocker11.cname-blocks1.test 5 target.example.com 0 0 0 5400 \N 0 2026-02-20 20:20:00-05 t t \N 1016 7 123 blocker12.cname-blocks1.test 5 target.example.com 0 0 0 5400 \N 0 2026-02-20 20:20:00-05 f t \N 857 1017 \. 858 1018 … … 862 1022 -- 863 1023 864 SELECT pg_catalog.setval('public.records_record_id_seq', 46, true);1024 SELECT pg_catalog.setval('public.records_record_id_seq', 123, true); 865 1025 866 1026
Note:
See TracChangeset
for help on using the changeset viewer.
