1/*
2 * Copyright (C) Internet Systems Consortium, Inc. ("ISC")
3 *
4 * SPDX-License-Identifier: MPL-2.0
5 *
6 * This Source Code Form is subject to the terms of the Mozilla Public
7 * License, v. 2.0.  If a copy of the MPL was not distributed with this
8 * file, you can obtain one at https://mozilla.org/MPL/2.0/.
9 *
10 * See the COPYRIGHT file distributed with this work for additional
11 * information regarding copyright ownership.
12 */
13
14controls { };
15
16options {
17	directory ".";
18	port 5300;
19	pid-file "named.pid";
20	session-keyfile "session.key";
21	listen-on { any; };
22	listen-on-v6 { none; };
23	recursion no;
24};
25
26key rndc_key {
27	secret "1234abcd8765";
28	algorithm hmac-md5;
29};
30
31controls {
32	inet 127.0.0.1 port 9953 allow { any; } keys { rndc_key; };
33};
34
35dlz "test" {
36	database "dlopen ../dlz_mysql_dynamic.so
37           {
38             host=127.0.0.1 port=3306 socket=/tmp/mysql.sock
39             dbname=BindDB user=USER pass=PASSWORD threads=2
40           }
41           {SELECT zone FROM records WHERE zone = '$zone$'}
42           {SELECT ttl, type, mx_priority, IF(type = 'TXT', CONCAT('\"',data,'\"'), data) AS data FROM records WHERE zone = '$zone$' AND host = '$record$' AND type <> 'SOA' AND type <> 'NS'}
43           {SELECT ttl, type, data, primary_ns, resp_contact, serial, refresh, retry, expire, minimum FROM records WHERE zone = '$zone$' AND (type = 'SOA' OR type='NS')}
44           {SELECT ttl, type, host, mx_priority, IF(type = 'TXT', CONCAT('\"',data,'\"'), data) AS data, resp_contact, serial, refresh, retry, expire, minimum FROM records WHERE zone = '$zone$' AND type <> 'SOA' AND type <> 'NS'}
45           {SELECT zone FROM xfr where zone='$zone$' AND client = '$client$'}";
46};
47