[Pdns-users] Question about PDNS SOA presentation.

[Michael Van Der Beek]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20190306/9eaa2378/attachment.html>