DLZ, Bind 9.9, FreeBSD 9.2 postgresql 9.3, bind fails to start
Rod K <[email protected]> Fri, 23 Jan 2015 16:37:49 -0500
| Newsgroups | gmane.network.dns.bind9.dlz |
|---|---|
| Message-ID | <[email protected]> |
Under the above configuration Bind refuses to start but provides no
error messages.
this is my DLZ config from named.conf:
dlz "postgres zone" {
database "postgres 2
{host=(hostip) dbname=(dbname) user=(user) password='(password)'}
{select zone from dns.zones where zone='$zone$' and active='t'}
{select ttl, type, mx_priority, case when type = 'TXT' then
'\"; || data || '\"' else data end, resp_person, serial, refresh,
retry,expire, minimum from dns.v_dlz
_records where zone='$zone$' and host='$record$'}
";
};
If I comment out the DLZ config Bind starts normally.
Can anyone point to anything I'm doing wrong?
Thanks
------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet