Re: Can't get named_sdb to load postgres modules?
"Mike Toler" <[email protected]> Tue, 12 May 2009 15:00:17 -0500
| Newsgroups | gmane.network.dns.bind9.dlz |
|---|---|
| Message-ID | <56DA5079467D1C48B857C6FE59D5D4FC029B2AB6@prodeaserve.prodea.local> |
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