Hi All,
I'm a bit confused about my SOA record.
When I query it.
dig @server1.cyber-mage.com SOA cyber-mage.com
; <<>> DiG 9.9.4-RedHat-9.9.4-61.el7_5.1 <<>> @server1.cyber-mage.com SOA
cyber-mage.com
; (2 servers found)
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 5232
;; 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: 1680
;; QUESTION SECTION:
;cyber-mage.com. IN SOA
;; ANSWER SECTION:
cyber-mage.com. 86400 IN SOA ns1.linode.com.
hostmaster.cyber-mage.com. 2019033066 28800 7200 1209600 86400
;; Query time: 219 msec
;; SERVER: 72.14.187.43#53(72.14.187.43)
;; WHEN: Wed Mar 06 14:49:45 +08 2019
;; MSG SIZE rcvd: 101
But my mysql records are:
MariaDB [powerdns]> select * from records where type="SOA";
+----+-----------+------------------------+------+------------------------------------------------------------------------------+-------+------+-------------+----------+----------------------------------+------+
| id | domain_id | name | type | content
| ttl | prio | change_date |
disabled | ordername | auth |
+----+-----------+------------------------+------+------------------------------------------------------------------------------+-------+------+-------------+----------+----------------------------------+------+
| 1 | 1 | cyber-mage.com | SOA | ns1.linode.com
hostmaster.cyber-mage.com 2019030501 28800 7200 1209600 86400 | 86400 | 0 |
NULL | 0 | rvms80ecrvpfkr7n6a3ksp4tc5f2g9bk | 1 |
| 23 | 2 | 187.14.72.in-addr.arpa | SOA | ns1.linode.com
hostmaster.cyber-mage.com 2019022501 28800 7200 1209600 86400 | 86400 | 0 |
NULL | 0 | | 1 |
+----+-----------+------------------------+------+------------------------------------------------------------------------------+-------+------+-------------+----------+----------------------------------+------+
And
MariaDB [powerdns]> select * from domains;
+----+------------------------+--------+------------+--------+-----------------+---------+
| id | name | master | last_check | type | notified_serial
| account |
+----+------------------------+--------+------------+--------+-----------------+---------+
| 1 | cyber-mage.com | NULL | NULL | MASTER | 2019030501
| NULL |
| 2 | 187.14.72.in-addr.arpa | NULL | NULL | MASTER | 2019022501
| NULL |
+----+------------------------+--------+------------+--------+-----------------+---------+
How come the values are different? What am I doing wrong?
Regards,
Michael
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
https://mailman.powerdns.com/mailman/listinfo/pdns-users
