[Pdns-users] MySQL backend serial update but no notify

[Craig Ward]

Thanks for the prompt reply


----- "bert hubert" <bert.hubert at netherlabs.nl> wrote:

> 
> Do you have 'master' enabled in the configuration?
> 

Yep:

$ grep master /etc/powerdns/pdns.conf
# master        Act as a master
master=yes


> > Whilst writing this email I've actually noticed that the serial
> number is
> > updating on the zone file very often, as in 2 or 3 times every
> minute!
> 
> This usually means PowerDNS is calculating the serial number on the
> fly
> because none was defined in the database.
> 
> Can you show: "select * from records where name='example.com' and
> type='SOA'"?

mysql> select * from records where name = 'example.com' and type = 'SOA';
+-----+-----------+-----------+------+------------------------------------+------+------+-------------+----------+
| id  | domain_id | name      | type | content                            | ttl  | prio | change_date | username |
+-----+-----------+-----------+------+------------------------------------+------+------+-------------+----------+
| 594 |         7 | example.com | SOA  | ns1.example.com hostmaster.example.com |  120 | NULL |  1206390635 | example    |
+-----+-----------+-----------+------+------------------------------------+------+------+-------------+----------+



Craig.