8N/ABIND 9 DLZ MySQL module with support for dynamic DNS (DDNS)

8N/A

380N/AAdapted from code contributed by Marty Lee, Maui Systems Ltd.

8N/A

8N/AThis is a dynamically loadable zone (DLZ) plugin that uses a fixed-

8N/Aschema MySQL database for back-end storage. It allows zone data

8N/Ato be updated via dynamic DNS updates, and sends DNS NOTIFY packets

8N/Ato other name servers when appropriate.

8N/A

8N/AThe database for this module uses the following schema:

8N/A

8N/A CREATE TABLE `Zones` (

8N/A `id` int(11) NOT NULL AUTO_INCREMENT,

8N/A `domain` varchar(128) NOT NULL DEFAULT '',

8N/A `host` varchar(128) NOT NULL DEFAULT '',

8N/A `admin` varchar(128) NOT NULL DEFAULT '',

8N/A `serial` int(11) NOT NULL DEFAULT '1',

8N/A `expire` int(11) NOT NULL DEFAULT '86400',

8N/A `refresh` int(11) NOT NULL DEFAULT '86400',

8N/A `retry` int(11) NOT NULL DEFAULT '86400',

8N/A `minimum` int(11) NOT NULL DEFAULT '86400',

8N/A `ttl` int(11) NOT NULL DEFAULT '86400',

8N/A `writeable` tinyint(1) NOT NULL DEFAULT '0',

8N/A PRIMARY KEY (`id`),

8N/A KEY `domain_idx` (`domain`)

8N/A );

8N/A

8N/A CREATE TABLE `ZoneData` (

8N/A `id` int(11) NOT NULL AUTO_INCREMENT,

8N/A `zone_id` int(11) NOT NULL,

414N/A `name` varchar(128) NOT NULL DEFAULT '',

8N/A `type` varchar(16) NOT NULL DEFAULT '',

8N/A `ttl` int(11) NOT NULL DEFAULT '86400',

8N/A `data` varchar(128) NOT NULL DEFAULT '',

253N/A PRIMARY KEY (`id`),

253N/A KEY `zone_idx` (`zone_id`),

414N/A KEY `name_idx` (`zone_id`, `name`),

253N/A KEY `type_idx` (`type`)

253N/A );

253N/A

258N/A'Zones' contains information about specific zones:

98N/A - domain: the zone name

156N/A - admin: the zone administrator

98N/A - serial, expire, reresh, retry, minimum: values in the SOA record

156N/A - ttl: default zone TTL

414N/A - writeable: set to true if the zone can be updated via DDNS

98N/A

156N/A'ZoneData' contains the individual records within the zone:

156N/A - zone_id: the 'id' from the corresponding record in Zones

8N/A - name: domain name, relative to the zone apex. (Data at the zone

8N/A apex itself may use a blank name or "@".)

8N/A - type: the RR type, expressed as text

8N/A - ttl: the record's TTL

8N/A - data: the records rdata, expressed as text.

8N/A

8N/ATo configure this module in named.conf:

8N/A

8N/Adlz "mysqldlz" {

8N/A database "dlopen <path to>/dlz_mysqldyn_mod.so <dbname> [dbhost [dbuser [dbpass]]]";

8N/A};

8N/A