The query must return the appropriate data types in the correct order. Decided to move my windows based DNS servers to linux. This allows a variety of database schemas to be used without modification to the driver’s code. The first field in the result set MUST be the ttl. We are not reinventing the wheel here.

Uploader: Kigazilkree
Date Added: 16 May 2011
File Size: 51.5 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 27279
Price: Free* [*Free Regsitration Required]

Bind9 and PostgreSQL

So you want to use dynamic loadable zones DLZ, http: I’ll investigate a few of these options. Jean Claveau jean-claveau-g wrote on In the “data” field, we only have NS1. Check out the new driver’s documentation for more information.

However, it can be used in a hidden master configuration, with slaves retrieving zone updates via AXFR. Bookmarks Bookmarks Digg del.

Knowledge Articles-Using DLZ in BIND

This is the third token discussed previously. The data string is “built” by concatenating fields 4 through 12 together, with a space added in between each.

This can be a bit difficult to understand, so be sure to read the posttres section of the documentation thoroughly and carefully! What does matter is the number of rows that are returned. If the result set for a lookup or authority query only has two fields, the driver will use the default value of for ttl. I now run into this error: The driver then appends a space to the end of postvres string and continues to the next field. What does matter is the number of rows or tuples in PostgreSQL terms that are returned.


None, the status of the bug is updated manually. To summarize, the allnodes query MUST have at least 4 fields in the result set, and those fields must be ttl, type, host and data.

Using DLZ in BIND

Some of these DNS servers don’t seem to be available anymore, and most don’t support all the postgfes records and capabilities of BIND.

For example, if the authoritative name server for this zone isn’t “ns1. Sign up or log in Sign up using Google. DLZ allows you to store your zone data in a database.

Server Fault works best with JavaScript enabled. Most “drivers” tend to require a specific database schema for the driver to be able to interact with the database. We are telling the driver not to use an SQL query there. The word “postgres” is located at argv[0]. October 22nd, 1. The first one was to compile bind xlz the source code changes for mysql support http: The example below defines a DLZ named “example” that is referenced by the zone statement for example.


July 10th, 2. That could solve the problem for me as I plan on having a php webservice that’s responsible for updating dns.

This bug affects 2 people. It’s a bit late, but I ppostgres made a tutorial here. Like the findzone query, the results returned by the allowzonexfr query are not really used, so what you return and in what order doesn’t really matter. Additionally, single quotes were not used because they have special meaning in SQL queries.

The next piece is the word “postgres”.

The Postgres driver was built to be as flexible as possible.