MariaDB [powerdns]> select * from records;
+----+-----------+--------------+------+---------------------------------------------------------------------+------+------+-------------+----------+-----------+------+
| id | domain_id | name | type | content
| ttl | prio | change_date | disabled | ordername
| auth |
+----+-----------+--------------+------+---------------------------------------------------------------------+------+------+-------------+----------+-----------+------+
| 1 | 1 | test.org | SOA | ops-tmp-app-2 hostmaster.test.org
2019031205 10800 3600 604800 3600 | 3600 | 0 | NULL | 0 | NULL
| 1 |
| 2 | 1 | test.org | NS | ops-tmp-app-2
| 3600 | 0 | NULL | 0 | NULL
| 1 |
| 3 | 1 | test.org | NS | test-ops-dns-1
| 3600 | 0 | NULL | 0 | NULL
| 1 |
| 4 | 1 | www.test.org | A | 10.3.2.5
| 3600 | 0 | NULL | 0 | NULL
| 1 |
+----+-----------+--------------+------+---------------------------------------------------------------------+------+------+-------------+----------+-----------+------+
4 rows in set (0.00 sec)
MariaDB [powerdns]> select * from domains;
+----+----------+-----------+------------+-------+-----------------+---------+
| id | name | master | last_check | type | notified_serial | account |
+----+----------+-----------+------------+-------+-----------------+---------+
| 1 | test.org | 10.3.2.15 | 1552381768 | SLAVE | NULL | |
+----+----------+-----------+------------+-------+-----------------+---------+
1 row in set (0.00 sec)
MariaDB [powerdns]> select * from supermasters;
+----------------+---------------+---------+
| ip | nameserver | account |
+----------------+---------------+---------+
| 10.3.2.15:5300 | ops-tmp-app-2 | |
+----------------+---------------+---------+
1 row in set (0.00 sec)
[root@test-ops-redis-mha-1 ~]# dig AXFR test.org @10.3.2.15 -p 5300
; <<>> DiG 9.9.4-RedHat-9.9.4-73.el7_6 <<>> AXFR test.org @10.3.2.15 -p 5300
;; global options: +cmd
test.org. 3600 IN SOA ops-tmp-app-2.
hostmaster.test.org. 2019031209 10800 3600 604800 3600
test.org. 3600 IN NS ops-tmp-app-2.
test.org. 3600 IN NS test-ops-dns-1.
aaa.test.org. 3600 IN A 10.3.3.3
bbb.test.org. 3600 IN A 10.3.2.15
www.test.org. 3600 IN A 10.3.2.5
test.org. 3600 IN SOA ops-tmp-app-2.
hostmaster.test.org. 2019031209 10800 3600 604800 3600
;; Query time: 8 msec
;; SERVER: 10.3.2.15#5300(10.3.2.15)
;; WHEN: Wed Mar 13 20:09:51 CST 2019
;; XFR size: 7 records (messages 3, bytes 346)
>Hi,
>
>As I asked you yesterday:
>
>Could you do a "dig AXFR test.org <http://test.org/> @10.3.2.15 -p 5300” and
>also show us the record from the `domains` table on your slave for test.org
><http://test.org/>?
>
>Frank Louwers
>PowerDNS Consultant
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
