Re: Problems in compiling bind

--===============6981502087898667705==
Content-Type: multipart/alternative; boundary=f46d040169c77b813204b9b6c3c8

--f46d040169c77b813204b9b6c3c8
Content-Type: text/plain; charset=ISO-8859-1

My apologies for the formatting, but I wanted to keep the long lines from
wrapping.  If you don't like rich text, feel free to delete this email.

2012/2/23 Nitish Bangera <[email protected]>:
> Hey Todd,
>
> Thanks for the advice. Changing the path name from /usr/lib to /usr/lib64
in
> configure worked like a gem. Now i am wondering where exactly the configs
to
> connect to the mysql database should be put in.

In your named.conf.

You can also mix regular zones with DLZ zones if you choose to.  For
example:
/etc/named.conf:
logging {
       channel default_debug {
               file "/var/log/named.debug";
               severity info;
       };
};

zone "." IN {
       type hint;
       file "named.ca";
};

include "/etc/named.rfc1912.zones";
include "/etc/named.dlz";
============================

/etc/named.dlz:
dlz "Mysql zone" {
  database "mysql
  {host=db-master user=domains pass=******************** dbname=live_sites
ssl=false}
  {SELECT name FROM domain WHERE name = '$zone$' AND active=1}
  {SELECT '7200' AS ttl,domain_record_type.type,
       case when lower(domain_record_type.type) = 'mx' then
domain_record.mx_priority end,
       case when lower(domain_record_type.type) = 'txt' then concat('\"',
domain_record.value, '\"') else domain_record.value end AS data
       FROM domain_record,domain,domain_record_type
       WHERE domain_record_type.id=domain_record.type_id AND
domain_record.active=1
           AND domain.id=domain_record.domain_id
           AND domain.name='$zone$'
           AND domain_record.name='$record$'}";
};

# I use the short form of database lookups since I don't do transfers and
such.
# That's a personal choice, it's up to you how you configure your system.

============================

/etc/named.rfc1912.zones:
zone "localhost.localdomain" IN {
       type master;
       file "named.localhost";
       allow-update { none; };
};

zone "localhost" IN {
       type master;
       file "named.localhost";
       allow-update { none; };
};

zone
"1.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa"
IN {
       type master;
       file "named.loopback";
       allow-update { none; };
};

zone "1.0.0.127.in-addr.arpa" IN {
       type master;
       file "named.loopback";
       allow-update { none; };
};

zone "0.in-addr.arpa" IN {
       type master;
       file "named.empty";
       allow-update { none; };
};

etc...

Regards...    Todd

-- 
SOPA: Any attempt to [use legal means to] reverse technological advances is
doomed.  --Leo Leporte

--f46d040169c77b813204b9b6c3c8
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

My apologies for the formatting, but I wanted to keep the long lines from w=
rapping.=A0 If you don&#39;t like rich text, feel free to delete this email=
.<br><br>2012/2/23 Nitish Bangera &lt;<a href=3D"mailto:bangera.nitish@gmai=
l.com">[email protected]</a>&gt;:<br>
&gt; Hey Todd,<br>&gt;<br>&gt; Thanks for the advice. Changing the path nam=
e from /usr/lib to /usr/lib64 in<br>&gt; configure worked like a gem. Now i=
 am wondering where exactly the configs to<br>&gt; connect to the mysql dat=
abase should be put in.<br>
<br>In your named.conf.<br><br>You can also mix regular zones with DLZ zone=
s if you choose to. =A0For example:<br>/etc/named.conf:<br>logging {<br> =
=A0 =A0 =A0 =A0channel default_debug {<br> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0f=
ile &quot;/var/log/named.debug&quot;;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0severity info;<br> =A0 =A0 =A0 =A0};<br>};<=
br><br>zone &quot;.&quot; IN {<br> =A0 =A0 =A0 =A0type hint;<br> =A0 =A0 =
=A0 =A0file &quot;<a href=3D"http://named.ca">named.ca</a>&quot;;<br>};<br>=
<br>include &quot;/etc/named.rfc1912.zones&quot;;<br>
include &quot;/etc/named.dlz&quot;;<br>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<br><br>/etc/named.dlz:<br>=
dlz &quot;Mysql zone&quot; {<br> =A0 database &quot;mysql<br> =A0 {host=3Dd=
b-master user=3Ddomains pass=3D******************** dbname=3Dlive_sites ssl=
=3Dfalse}<br>
 =A0 {SELECT name FROM domain WHERE name =3D &#39;$zone$&#39; AND active=3D=
1}<br> =A0 {SELECT &#39;7200&#39; AS ttl,domain_record_type.type,<br> =A0 =
=A0 =A0 =A0case when lower(domain_record_type.type) =3D &#39;mx&#39; then d=
omain_record.mx_priority end,<br>
 =A0 =A0 =A0 =A0case when lower(domain_record_type.type) =3D &#39;txt&#39; =
then concat(&#39;\&quot;&#39;, domain_record.value, &#39;\&quot;&#39;) else=
 domain_record.value end AS data<br> =A0 =A0 =A0 =A0FROM domain_record,doma=
in,domain_record_type<br>
 =A0 =A0 =A0 =A0WHERE <a href=3D"http://domain_record_type.id">domain_recor=
d_type.id</a>=3Ddomain_record.type_id AND domain_record.active=3D1<br> =A0 =
=A0 =A0 =A0 =A0 =A0AND <a href=3D"http://domain.id">domain.id</a>=3Ddomain_=
record.domain_id<br> =A0 =A0 =A0 =A0 =A0 =A0AND <a href=3D"http://domain.na=
me">domain.name</a>=3D&#39;$zone$&#39;<br>
 =A0 =A0 =A0 =A0 =A0=A0 AND <a href=3D"http://domain_record.name">domain_re=
cord.name</a>=3D&#39;$record$&#39;}&quot;;<br>};<br><br># I use the short f=
orm of database lookups since I don&#39;t do transfers and such.<br># That&=
#39;s a personal choice, it&#39;s up to you how you configure your system.<=
br>
<br>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D<br><br>/etc/named.rfc1912.zones:<br>zone &quot;localhost.lo=
caldomain&quot; IN {<br> =A0 =A0 =A0 =A0type master;<br> =A0 =A0 =A0 =A0fil=
e &quot;named.localhost&quot;;<br> =A0 =A0 =A0 =A0allow-update { none; };<b=
r>};<br>
<br>zone &quot;localhost&quot; IN {<br> =A0 =A0 =A0 =A0type master;<br> =A0=
 =A0 =A0 =A0file &quot;named.localhost&quot;;<br> =A0 =A0 =A0 =A0allow-upda=
te { none; };<br>};<br><br>zone &quot;1.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0.0=
.0.0.0.0.0.0.0.0.0.0.0.0.0.ip6.arpa&quot; IN {<br>
 =A0 =A0 =A0 =A0type master;<br> =A0 =A0 =A0 =A0file &quot;named.loopback&q=
uot;;<br> =A0 =A0 =A0 =A0allow-update { none; };<br>};<br><br>zone &quot;1.=
0.0.127.in-addr.arpa&quot; IN {<br> =A0 =A0 =A0 =A0type master;<br> =A0 =A0=
 =A0 =A0file &quot;named.loopback&quot;;<br>
 =A0 =A0 =A0 =A0allow-update { none; };<br>};<br><br>zone &quot;0.in-addr.a=
rpa&quot; IN {<br> =A0 =A0 =A0 =A0type master;<br> =A0 =A0 =A0 =A0file &quo=
t;named.empty&quot;;<br> =A0 =A0 =A0 =A0allow-update { none; };<br>};<br><b=
r>etc...<br><br>Regards... =A0 =A0Todd<br>
<br>-- <br>SOPA: Any attempt to [use legal means to] reverse technological =
advances is doomed. =A0--Leo Leporte<br><br>

--f46d040169c77b813204b9b6c3c8--


--===============6981502087898667705==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
--===============6981502087898667705==
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

--===============6981502087898667705==--