dlz ignores connection to postgres database
data tanger <[email protected]> Wed, 21 Mar 2012 19:39:33 +0100
| Newsgroups | gmane.network.dns.bind9.dlz |
|---|---|
| Message-ID | <[email protected]> |
--===============8060605582174725914==
Content-Type: multipart/alternative;
boundary="_3e6d1d9e-3707-434f-aa39-edc332bd2a17_"
--_3e6d1d9e-3707-434f-aa39-edc332bd2a17_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi everyone=2C
I tried to use the Bind Dlz driver but I can't get it to connect to the=20
database.When I start Bind=2C I don't see any error but I think it=20
ignores the connection to=20
the database.=20
I tried both Postgresql and Mysql with no success.
Here's what I added to the named.conf file:
dlz "PostgresZone" {=20
database "postgres
{host=3Dlocalhost port=3D5432 dbname=3Ddnsdb user=3Ddnsuser}
{SELECT id FROM zones WHERE zone =3D lower('%zone%') LIMIT 1}
{SELECT ttl=2C ttype=2C mx_priority=2C ddata FROM zones z=2C rrset r WHERE =
z.id=3Dr.zid
AND zone =3D lower('%zone%') AND host =3D lower('%record%') AND type NOT=20
IN('SOA'=2C'NS')}
{SELECT ttl=2C ttype=2C mx_priority=2C ddata=2C resp_person=2C serial=2C re=
fresh=2C=20
retry=2C expire=2C minimum FROM zones z=2C rrset r WHERE z.id =3D r.zid AND=
zone =3D=20
lower('%zone%') AND type IN('SOA'=2C'NS')}
{SELECT ttl=2C ttype=2C host=2C mx_priority=2C ddata=2C resp_person=2C seri=
al=2C=20
refresh=2C retry=2C expire=2C minimum FROM zones z=2C rrset r WHERE z.id =
=3D r.zid=09
AND zone =3D lower('%zone%'}
{SELECT id FROM axfr WHERE zone =3D lower('%zone%' AND ip =3D '%client%'}"=
=3B
}=3B
Any help please?
Thank you in advance =
--_3e6d1d9e-3707-434f-aa39-edc332bd2a17_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<style><!--
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Tahoma
}
--></style></head>
<body class=3D'hmmessage'><div dir=3D'ltr'>
<pre style=3D"line-height: 17px=3B white-space: normal=3B color: rgb(42=2C =
42=2C 42)=3B background-color: rgb(255=2C 255=2C 255)=3B ">Hi everyone=2C<b=
r><br>I tried to use the Bind Dlz driver but I can't get it to connect to t=
he =3B<br>database.When I start Bind=2C I don't see any error but I thi=
nk it =3B<br>ignores the connection to =3B<br>the database. =3B=
<br>I tried both Postgresql and Mysql with no success.<br>Here's what I add=
ed to the named.conf file:<br><br>dlz "PostgresZone" { =3B<br>database =
"postgres<br>{host=3Dlocalhost port=3D5432 dbname=3Ddnsdb user=3Ddnsuser}<b=
r>{SELECT id FROM zones WHERE zone =3D lower('%zone%') LIMIT 1}<br>{SELECT =
ttl=2C ttype=2C mx_priority=2C ddata FROM zones z=2C rrset r WHERE z.id=3Dr=
.zid<br>AND zone =3D lower('%zone%') AND host =3D lower('%record%') AND typ=
e NOT =3B<br>IN('SOA'=2C'NS')}<br>{SELECT ttl=2C ttype=2C mx_priority=
=2C ddata=2C resp_person=2C serial=2C refresh=2C =3B<br>retry=2C expire=
=2C minimum FROM zones z=2C rrset r WHERE z.id =3D r.zid AND zone =3D =
=3B<br>lower('%zone%') AND type IN('SOA'=2C'NS')}<br>{SELECT ttl=2C ttype=
=2C host=2C mx_priority=2C ddata=2C resp_person=2C serial=2C =3B<br>ref=
resh=2C retry=2C expire=2C minimum FROM zones z=2C rrset r WHERE z.id =3D r=
.zid <br>AND zone =3D lower('%zone%'}<br>{SELECT id FROM axfr WHERE zone =
=3D lower('%zone%' AND ip =3D '%client%'}"=3B<br>}=3B<br><br>Any help pleas=
e?<br><br>Thank you in advance</pre> </div></body>
</html>=
--_3e6d1d9e-3707-434f-aa39-edc332bd2a17_--
--===============8060605582174725914==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
------------------------------------------------------------------------------
This SF email is sponsosred by:
Try Windows Azure free for 90 days Click Here
http://p.sf.net/sfu/sfd2d-msazure
--===============8060605582174725914==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Bind-dlz-testers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers
--===============8060605582174725914==--