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

Dumb down your named.conf dlz "postgres zone" section to the first two  
required queries removing the other queries.

The dlz driver will take bind down if your queries are not constructed  
properly.

And try starting named-sdb like so and query from another terminal:

named-sdb -g -d 1


//Brad


On May 12, 2009, at 1:00 PM, Mike Toler wrote:

> I saw the srpms on atkacs page, but the el5 version was 9.3.4.  I just
> went out and grabbed the 9.5 binaries from pbone.net.  Not sure what  
> the
> "pp" stands for.  Honestly hadn't noticed it till you pointed it out.
>
>>
>> And it's also tempting to assume that you are calling the named-sdb
>> binary and not a script named named_sdb like you pasted.  Is that
>> true?	
>
> Ok, you've confused me there.   I'm calling the named_sdb executable
> directly.  Am I suppose to have some script setup to start it?  I'll  
> get
> the init.d stuff working once I'm past this hurdle, so for now, I'm  
> just
> running directly.
>   [root@vm-nfs-01 ~]# which named_sdb
>   /usr/sbin/named_sdb
>
> My named.conf:
>  options {
>            directory "/var/named/" ;
>            allow-transfer {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 "1.1.1.";
>            zone-statistics yes;
>             };
>              logging {
>             channel named_info {
>                 // log to syslog instead of a file
>                 syslog;
>                 // include the category of the event in the log
>                 print-category yes;
>                 // include the severity of the event in the log
>                 print-severity yes;
>                 // include the time of the event in the log
>                 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" {
>        <snipped>
> 	
> };
>
> 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%'}
>   {}
>   {select ttl, type, host, mx_priority, case when lower(type)='txt'
> then '\"'
>         || data || '\"' else data end, resp_person, serial, refresh,
> retry, expire,
>        minimum from dns_records where zone = '%zone%'}
>   {select zone from xfr_table where zone = '%zone%' and client =
> '%client%'}";
> };
>
> 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
> _______________________________________________
> Bind-dlz-testers mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers


------------------------------------------------------------------------------
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