Re: Can't get named_sdb to load postgres modules?

Two steps forward, one step back.

I went to the Redhat site and got the latest official compile from them
(9.3.4-10, pretty old) and installed it.

Step forward:  The logs show DLZ modules at least loading.
[root@vm-nfs-01 ~]# named_sdb -d 5 -g -c /etc/named.conf
13-May-2009 14:14:01.911 starting BIND 9.3.4-P1 -d 5 -g -c
/etc/named.conf
13-May-2009 14:14:01.912 found 1 CPU, using 1 worker thread
13-May-2009 14:14:01.912 SDB ldap zone database module loaded.
13-May-2009 14:14:01.913 SDB postgreSQL DB zone database module loaded.
13-May-2009 14:14:01.913 SDB directory DB zone database module loaded.
13-May-2009 14:14:01.917 loading configuration from '/etc/named.conf'

The step back, it doesn't like "dlz"???  wahuh??

13-May-2009 14:14:01.918 /etc/named.conf:188: unknown option 'dlz'
13-May-2009 14:14:01.919 load_configuration: failure
13-May-2009 14:14:01.919 loading configuration: failure
13-May-2009 14:14:01.919 exiting (due to fatal error)


I dumbed it down as much as I could.   Does this old a version of
named_sdb have some other format for the DLZ zones??


My config:


options {
            directory "/var/named/" ;
            allow-transfer { 172.24.2.0/24; 127.0.0.1/8;};
            check-names master warn;
            datasize 20M;
            max-journal-size 5M;
            dump-file "named_dump.db";
            interface-interval 0;
            max-cache-size 20M;
            memstatistics-file "/var/stats/named.memstats";
            pid-file "/var/run/named.pid";

            query-source address * port 53;
            transfer-source * port 53;
            notify-source * port 53;
            statistics-file "/var/stats/named.stats";
            version "This is not the port you're looking for.";
            zone-statistics yes;
             };
              logging {
             channel named_info {
                 syslog;
                 print-category yes;
                 print-severity yes;
                 print-time yes;
             };
             category client { null; };
             category config { null; };
             category database { null; };
             category default { null; };
             category general { null; };
             category notify { null; };
             category network { null; };
             category resolver { null; };
             category security { null; };
             category update { null; };
             category queries { null; };
             category xfer-in { null; };
             category xfer-out { null; };
             };

controls {
        inet 127.0.0.1 allow { localhost; } keys { rndc-key; };
};

key "rndc-key" {
<snip>
};

zone "prodea-int.net" {
            type master;
                file "pz/prodea-int.net";
};


### INSERT SUB DOMAINS HERE ###
zone "voice.prodea-int.net" {
  type master;
  file "pz/voice.prodea-int.net";13-May-2009 14:14:01.917 loading
configuration from '/etc/named.conf'
};

zone "voice1.prodea-int.net" {
  type master;
  file "pz/voice1.prodea-int.net";
};

dlz "postgres zone" {
   database "postgres 1
   {host=int-dbs port=5432 dbname=dns_data user=postgres}
   {select zone from dns_records where zone = '%zone%'}
   {select ttl, type, mx_priority, case when lower(type)='txt' then '\"'
         || data || '\"' when lower(type)='soa' then data || ' ' ||
resp_person || ' '
         || serial || ' ' || refresh || ' ' || retry || ' ' || expire ||
' ' || minimum
         else data end from dns_records where zone = '%zone%' and host =
'%record%'}";
};


zone "." {
   type hint;
   file "pz/named.root";
};


Michael




This message is confidential to Prodea Systems, Inc unless otherwise indicated 
or apparent from its nature. This message is directed to the intended recipient 
only, who may be readily determined by the sender of this message and its 
contents. If the reader of this message is not the intended recipient, or an 
employee or agent responsible for delivering this message to the intended 
recipient:(a)any dissemination or copying of this message is strictly 
prohibited; and(b)immediately notify the sender by return message and destroy 
any copies of this message in any form(electronic, paper or otherwise) that you 
have.The delivery of this message and its information is neither intended to be 
nor constitutes a disclosure or waiver of any trade secrets, intellectual 
property, attorney work product, or attorney-client communications. The 
authority of the individual sending this message to legally bind Prodea Systems  
is neither apparent nor implied,and must be independently verified.

------------------------------------------------------------------------------
The NEW KODAK i700 Series Scanners deliver under ANY circumstances! Your
production scanning environment may not be a perfect world - but thanks to
Kodak, there's a perfect scanner to get the job done! With the NEW KODAK i700
Series Scanner you'll get full speed at 300 dpi even with all image 
processing features enabled. http://p.sf.net/sfu/kodak-com