Hi all

I am trying to build a new win32 from Bind 9.4.2 with MySQL support,
but till now i was not successful :)

I have some old build you can download it from here:
http://web.t-online.hu/marcz/dlz-bind-win32.html

On the page you will find some info about the source, what i used (version number of bind patch openssl ...) for the build.

I am using a visual c++ 6.0, and i set these option to build bind with DLZ support:

Project -> Settings (ALT + F7)
for named on the C/C++ tab you have to set in "Poject Options"
/D "DLZ"
and some from  these other options which you want to use:
/D "DLZ_FILESYSTEM" /D "DLZ_BDB" /D "DLZ_POSTGRES" /D "DLZ_MYSQL" /D "DLZ_ODBC"


Regards Gábor

Gilles Buisson <gilles.buisson <at> namebay.com> írta:

Ok, thank you for the answer, I've made some try and no problem to build
Bind standard with Visual studio 2005
but I'm novice with this tool and so how or where can I put the option like
"--with-dlz-odbc" as in the ./configure script in Linux ?
is it somewhere in the "BuildSetup.bat" or after directly in the Visual
Studio solution ?

Many thanks for nay help

Gilles

De : bind-dlz-testers-bounces <at> lists.sourceforge.net
[bind-dlz-testers-bounces <at> lists.sourceforge.net] De la part de Mark
Strother
Envoyé : mardi 18 mars 2008 20:59
ŕ154 : bind-dlz-testers <at> lists.sourceforge.net
Objet : Re: [Bind-dlz-testers] DLZ database drivers for Bind win32

Hi Gilles,

You have to compile Bind yourself with the right options. ItďFFDs relatively
easy to do though. We had Bind up and running with a MS SQL database backend
in about half a day and itďFFDs been quite solid.
 Mark Strother
 Pacific Online
 Phone: 604-638-6010 ext. 222
 Fax: 604-638-6020
 Toll Free: 1-877-503-9870
 http://www.pacificonline.com

From: bind-dlz-testers-bounces <at> lists.sourceforge.net
[bind-dlz-testers-bounces <at> lists.sourceforge.net] On Behalf Of Gilles
Buisson
Sent: Friday, March 14, 2008 7:53 AM
To: bind-dlz-testers <at> lists.sourceforge.net
Subject: [Bind-dlz-testers] DLZ database drivers for Bind win32

Hello

Does anyone know if recent Bind win32 binaries with DLZ database drivers
(odbc, mysql, ďFFD) already exist ?
I know that DLZ core is inside Bind since version 9.4 but it seems that the
driver are not include
Maybe IďFFDm wrong and in this case happy to know how to
activate/include/configure Bind to use them
Or have I to compiling myself Bind with the right option ?

Regards

Gilles Buisson
Administrateur Systŕ10Dme
NAMEBAY
27 Bd des Moulins
98000 Monaco
Phone : +377 97 70 61 64
Fax    : +377 97 97 21 13
http://www.namebay.com




-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Bind-dlz-testers mailing list
Bind-dlz-testers <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bind-dlz-testers

I have made some modifications to your interface to support reverse zones and custom per entry TTL's.  I can forward all this stuff to you if you would like.

Michael

Hey all,

I am using bind-dlz with mysql and am having issues with ttls.  My SOA has a default ttl of 86400 for my primary domain.  Unless I am incorrect, all other entries in the domain should default to that ttl when queried.  However, when I query the DNS, the SOA ttl shows up properly, but if i am looking up something like www.example.com, which would have a null ttl value in the database, it comes back with a ttl of zero.  How would I get it to accept the default ttl for the entire domain as opposed to having to enter a ttl for EVERY entry in my zone (which would be really really tedious).

Thanks

--
Michael J. Ayers
Senior Systems Engineer

I am trying to get a DNS server here answering queries for our domain, but it is not working in the way I was hoping.  I have set up the server to answer for our domain as if it is the Authoritative DNS server.  Unfortunately, it seems that whenever I do a lookup against it, the server goes out to the root servers, finds the ACTUAL authoritative server for the domain, then retrieves information from that server.  I want it to not do that so that I can test that my database is working properly and that the server is querying it.  Any ideas?  I have attached my named.conf below.  It seems it is not even trying to query the database from what I can see in the debug log I created.


acl "all" { 0.0.0.0/0; };
options {
       directory "/var/named";
       /* forward first; */
       /* forwarders { */
       /*      4.2.2.1; */
       /*      4.2.2.4; */
       /* }; */
       allow-query { "all"; };
};

logging {
       channel test.debug {
               file "/tmp/satest.debug.log";
               severity debug;
               print-time yes;
               print-severity yes;
               print-category yes;
       };
       category "default" { test.debug; };
       category "security" { test.debug; };
       category "config" { test.debug; };
       category "queries" { test.debug; };
       category "parser" { test.debug; };
       category "eventlib" { test.debug; };
};

view "internal" {
       match-clients { localnets; 10.0.0.0/8; };

       zone "." {
               type hint;
               file "root.hints";
       };

       dlz "Mysql zone" {
               database "mysql
               {host=localhost dbname=dns_internal user=dns pass=password}
               {select zone from records where zone = '%zone%'}
               {select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') when lower(type) = 'soa'
                 then concat_ws(' ', data, resp_person, serial, refresh, retry, expire, minimum) else data end from records
                 where zone = '%zone%' and host = '%record%'}
               {}
               {select ttl, type, host, mx_priority, case when lower(type)='txt' then
                 concat('\"', data, '\"') else data end, resp_person, serial, refresh, retry, expire,
                 minimum from records where zone = '%zone%'}
               {select zone from xfr where zone = '%zone%' and client = '%client%'}";
       };
};

view "external" {
       match-clients { any; };

       zone "." {
            type hint;
            file "root.hints";
       };

       dlz "Mysql zone" {
               database "mysql
               {host=localhost dbname=dns_external user=dns pass=password}
               {select zone from records where zone = '%zone%'}
               {select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') when lower(type) = 'soa'
                 then concat_ws(' ', data, resp_person, serial, refresh, retry, expire, minimum) else data end from records
                 where zone = '%zone%' and host = '%record%'}
               {}
               {select ttl, type, host, mx_priority, case when lower(type)='txt' then
                 concat('\"', data, '\"') else data end, resp_person, serial, refresh, retry, expire,
                 minimum from records where zone = '%zone%'}
               {select zone from xfr where zone = '%zone%' and client = '%client%'}";
       };
};

Thanks for any and all help.


--
Michael J. Ayers
Senior Systems Engineer

Hey all,

In the DB xfr table, are we allowed to use slash notation in the client field to match a whole bunch of clients?  I have to be able to axfr to a bunch of Windows domain servers so I added 10.0.0.0/8 in there, but I am not sure if that will work.

Thoughts?


--
Michael J. Ayers
Senior Systems Engineer