[Pdns-users] Help with serial number modification

[Ton van Rosmalen]

Christian Gregoire schreef:
> Hello,
>
> I run PDNS 2.9.21 and I need help with SOA serial number modification.
>
> mysql> select * from domains where name = "mydom.fr";
> +------+-----------+--------+------------+--------+-----------------+---------+
> | id   | name      | master | last_check | type   | notified_serial | account |
> +------+-----------+--------+------------+--------+-----------------+---------+
> | 4185 | mydom.fr | NULL   |       NULL | NATIVE |      NULL | NULL    | 
> +------+-----------+--------+------------+--------+-----------------+---------+
>
> mysql> select * from records where domain_id = 4185;
> +-------+-----------+------------------------------+------+---------------------------------------------------------------+-------+------+-------------+
> | id    | domain_id | name                         | type | content                                                       | ttl   | prio | change_date |
> +-------+-----------+------------------------------+------+---------------------------------------------------------------+-------+------+-------------+
> | 37426 |      4185 | mydom.fr                    | SOA  | ns1.mydom.fr postmaster.mydom.fr 2008010101 21600 3600 3600000 86400 | 86400 |    0 |        NULL | 
> ............
>
> Changing it by updating the 'content' column is not very handy. I thought that playing with the 'notified_serial' column would do the trick but it doesn't seem to be used.
>
> Is there any alternative method ?
>
>   
Not AFAIK. In our system we change the content to update the serial and 
execute "pdns_control notify <domain>" to propagate the changes to the 
authorative servers.

> Thanks in advance.
>
> Christian.
>
>   
Regard,

Ton