[Pdns-users] SOA and ANY problem gmysql

[Adam Long]

I had this same problem with pdns-2.9.17

I wrote a small patch that adds this functionality.

All you have to do is set your serial numbers in the TEXT field in the
SOA record equal to 0 and pdns will them return the highest last_modified
value stored in a column called change_date from all the records associated
with that domain as the serial number.

I found this much more user friendly, updating a INT column rather than
modifying a TEXT or CHAR column with a serial number inside it. Also
You could use a TIMESTAMP column and anytime you make a change the serial
would be auto updated for that zone.

I'm pretty sure the same patch will work for 2.9.18 as the patch does still
apply successfully.

Bert do you think this patch could be incorporated into a future release?
I'm not exactly a C++ expert but the actually code patch was really only 
one or two added lines of code in gsqlbackend.c and it has been running
great for us for the past 6 months.  And it still falls back to the normal
functionality if a serial exists in the SOA record or the change_date column
does not have a >0 last_modified value.  I believe the original pdns code
went right to a Unix timestamp (which is probably the values line5 is
seeing)

Hope this helps anyway line5.

Regards,
-Adam Long

-----Original Message-----
From: pdns-users-bounces at mailman.powerdns.com
[mailto:pdns-users-bounces at mailman.powerdns.com] On Behalf Of mail at line5.tv
Sent: Sunday, July 17, 2005 10:31 AM
To: pdns-users at mailman.powerdns.com
Subject: [Pdns-users] SOA and ANY problem gmysql

Hello List,

neither in PowerDNS 2.9.17 nor in 2.9.18 I managed to set up the 
serials. PDNS set them up, but I am not able to influence them in any 
way :-(
My Backend is (g)MySQL. I copied the SQL-tables from the PDNS-Homepage, 
inserted my domains and set the last_changed date to 2005071701. A 
dig-command on that server results in a:
SOA: 1121610240
ANY: 1121610245
(timestamp).

It seems as if pdns does not read whatever I write into that 
last_changed field. Does anyone know what I am doing wrong?

regards
line5
_______________________________________________
Pdns-users mailing list
Pdns-users at mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pdns-gsql-change_date_eq_serial-1.0.patch
Type: application/octet-stream
Size: 8800 bytes
Desc: not available
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20050717/412cac1d/attachment-0001.obj>