· 10 years ago · Jun 07, 2016, 12:30 PM
1config
2launch=gmysql
3# MySQL Configuration
4#
5# Launch gmysql backend
6launch+=gmysql
7
8# gmysql parameters
9gmysql-host=localhost
10gmysql-port=
11gmysql-dbname=pdns
12gmysql-user=pdns
13gmysql-password=(password)
14gmysql-dnssec=yes
15# gmysql-socket=
16
17
18MYSQL
19
20-- MySQL dump 10.13 Distrib 5.7.12, for Linux (x86_64)
21--
22-- Host: localhost Database: pdns
23-- ------------------------------------------------------
24-- Server version 5.7.12-0ubuntu1
25
26/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
27/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
28/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
29/*!40101 SET NAMES utf8 */;
30/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
31/*!40103 SET TIME_ZONE='+00:00' */;
32/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
33/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
34/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
35/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
36
37--
38-- Table structure for table `comments`
39--
40
41DROP TABLE IF EXISTS `comments`;
42/*!40101 SET @saved_cs_client = @@character_set_client */;
43/*!40101 SET character_set_client = utf8 */;
44CREATE TABLE `comments` (
45 `id` int(11) NOT NULL AUTO_INCREMENT,
46 `domain_id` int(11) NOT NULL,
47 `name` varchar(255) NOT NULL,
48 `type` varchar(10) NOT NULL,
49 `modified_at` int(11) NOT NULL,
50 `account` varchar(40) NOT NULL,
51 `comment` varchar(64000) NOT NULL,
52 PRIMARY KEY (`id`),
53 KEY `comments_domain_id_idx` (`domain_id`),
54 KEY `comments_name_type_idx` (`name`,`type`),
55 KEY `comments_order_idx` (`domain_id`,`modified_at`)
56) ENGINE=InnoDB DEFAULT CHARSET=latin1;
57/*!40101 SET character_set_client = @saved_cs_client */;
58
59--
60-- Dumping data for table `comments`
61--
62
63LOCK TABLES `comments` WRITE;
64/*!40000 ALTER TABLE `comments` DISABLE KEYS */;
65/*!40000 ALTER TABLE `comments` ENABLE KEYS */;
66UNLOCK TABLES;
67
68--
69-- Table structure for table `cryptokeys`
70--
71
72DROP TABLE IF EXISTS `cryptokeys`;
73
74/*!40101 SET @saved_cs_client = @@character_set_client */;
75/*!40101 SET character_set_client = utf8 */;
76CREATE TABLE `cryptokeys` (
77 `id` int(11) NOT NULL AUTO_INCREMENT,
78 `domain_id` int(11) NOT NULL,
79 `flags` int(11) NOT NULL,
80 `active` tinyint(1) DEFAULT NULL,
81 `content` text,
82 PRIMARY KEY (`id`),
83 KEY `domainidindex` (`domain_id`)
84) ENGINE=InnoDB DEFAULT CHARSET=latin1;
85/*!40101 SET character_set_client = @saved_cs_client */;
86
87--
88-- Dumping data for table `cryptokeys`
89--
90
91LOCK TABLES `cryptokeys` WRITE;
92/*!40000 ALTER TABLE `cryptokeys` DISABLE KEYS */;
93/*!40000 ALTER TABLE `cryptokeys` ENABLE KEYS */;
94UNLOCK TABLES;
95
96--
97-- Table structure for table `domainmetadata`
98--
99
100DROP TABLE IF EXISTS `domainmetadata`;
101/*!40101 SET @saved_cs_client = @@character_set_client */;
102/*!40101 SET character_set_client = utf8 */;
103CREATE TABLE `domainmetadata` (
104 `id` int(11) NOT NULL AUTO_INCREMENT,
105 `domain_id` int(11) NOT NULL,
106 `kind` varchar(32) DEFAULT NULL,
107 `content` text,
108 PRIMARY KEY (`id`),
109 KEY `domainmetadata_idx` (`domain_id`,`kind`)
110) ENGINE=InnoDB DEFAULT CHARSET=latin1;
111/*!40101 SET character_set_client = @saved_cs_client */;
112
113--
114-- Dumping data for table `domainmetadata`
115--
116
117LOCK TABLES `domainmetadata` WRITE;
118/*!40000 ALTER TABLE `domainmetadata` DISABLE KEYS */;
119/*!40000 ALTER TABLE `domainmetadata` ENABLE KEYS */;
120UNLOCK TABLES;
121
122--
123-- Table structure for table `domains`
124--
125
126DROP TABLE IF EXISTS `domains`;
127/*!40101 SET @saved_cs_client = @@character_set_client */;
128/*!40101 SET character_set_client = utf8 */;
129CREATE TABLE `domains` (
130 `id` int(11) NOT NULL AUTO_INCREMENT,
131 `name` varchar(255) NOT NULL,
132 `master` varchar(128) DEFAULT NULL,
133 `last_check` int(11) DEFAULT NULL,
134 `type` varchar(6) NOT NULL,
135 `notified_serial` int(11) DEFAULT NULL,
136 `account` varchar(40) DEFAULT NULL,
137 PRIMARY KEY (`id`),
138 UNIQUE KEY `name_index` (`name`)
139) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
140/*!40101 SET character_set_client = @saved_cs_client */;
141
142--
143-- Dumping data for table `domains`
144--
145
146LOCK TABLES `domains` WRITE;
147/*!40000 ALTER TABLE `domains` DISABLE KEYS */;
148INSERT INTO `domains` VALUES (3,'com1.local','10.127.1.207',NULL,'NATIVE',NULL,NULL);
149/*!40000 ALTER TABLE `domains` ENABLE KEYS */;
150UNLOCK TABLES;
151
152--
153-- Table structure for table `records`
154--
155
156DROP TABLE IF EXISTS `records`;
157/*!40101 SET @saved_cs_client = @@character_set_client */;
158/*!40101 SET character_set_client = utf8 */;
159CREATE TABLE `records` (
160 `id` int(11) NOT NULL AUTO_INCREMENT,
161 `domain_id` int(11) DEFAULT NULL,
162 `name` varchar(255) DEFAULT NULL,
163 `type` varchar(10) DEFAULT NULL,
164 `content` varchar(64000) DEFAULT NULL,
165 `ttl` int(11) DEFAULT NULL,
166 `prio` int(11) DEFAULT NULL,
167 `change_date` int(11) DEFAULT NULL,
168 `disabled` tinyint(1) DEFAULT '0',
169 `ordername` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL,
170 `auth` tinyint(1) DEFAULT '1',
171 PRIMARY KEY (`id`),
172 KEY `nametype_index` (`name`,`type`),
173 KEY `domain_id` (`domain_id`),
174 KEY `recordorder` (`domain_id`,`ordername`)
175) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;LOCK TABLES `records` WRITE;
176/*!40000 ALTER TABLE `records` DISABLE KEYS */;
177INSERT INTO `records` VALUES (3,3,'test.com1.local','A','1.1.1.1',3600,10,2016060700,0,NULL,1);
178/*!40000 ALTER TABLE `records` ENABLE KEYS */;
179UNLOCK TABLES;
180
181--
182-- Table structure for table `supermasters`
183--
184
185DROP TABLE IF EXISTS `supermasters`;
186/*!40101 SET @saved_cs_client = @@character_set_client */;
187/*!40101 SET character_set_client = utf8 */;
188CREATE TABLE `supermasters` (
189 `ip` varchar(64) NOT NULL,
190 `nameserver` varchar(255) NOT NULL,
191 `account` varchar(40) NOT NULL,
192 PRIMARY KEY (`ip`,`nameserver`)
193) ENGINE=InnoDB DEFAULT CHARSET=latin1;
194/*!40101 SET character_set_client = @saved_cs_client */;
195
196--
197-- Dumping data for table `supermasters`
198--
199
200LOCK TABLES `supermasters` WRITE;
201/*!40000 ALTER TABLE `supermasters` DISABLE KEYS */;
202/*!40000 ALTER TABLE `supermasters` ENABLE KEYS */;
203UNLOCK TABLES;
204
205--
206-- Table structure for table `tsigkeys`
207--
208
209DROP TABLE IF EXISTS `tsigkeys`;
210/*!40101 SET @saved_cs_client = @@character_set_client */;
211/*!40101 SET character_set_client = utf8 */;
212CREATE TABLE `tsigkeys` (
213 `id` int(11) NOT NULL AUTO_INCREMENT,
214 `name` varchar(255) DEFAULT NULL,
215 `algorithm` varchar(50) DEFAULT NULL,
216 `secret` varchar(255) DEFAULT NULL,
217 PRIMARY KEY (`id`),
218 UNIQUE KEY `namealgoindex` (`name`,`algorithm`)
219) ENGINE=InnoDB DEFAULT CHARSET=latin1;
220/*!40101 SET character_set_client = @saved_cs_client */;
221
222--
223-- Dumping data for table `tsigkeys`
224--
225
226LOCK TABLES `tsigkeys` WRITE;
227/*!40000 ALTER TABLE `tsigkeys` DISABLE KEYS */;
228/*!40000 ALTER TABLE `tsigkeys` ENABLE KEYS */;
229UNLOCK TABLES;
230/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
231
232/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
233/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
234/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
235/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
236/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
237/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
238/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
239
240-- Dump completed on 2016-06-07 14:25:15
241
242
243
244/*!40101 SET character_set_client = @saved_cs_client */;
245
246--
247-- Dumping data for table `records`
248--
249
250
251DIG OUTPUT
252dig @10.127.1.207 test.com1.local
253
254; <<>> DiG 9.9.5-3ubuntu0.8-Ubuntu <<>> @10.127.1.207 test.com1.local
255; (1 server found)
256;; global options: +cmd
257;; Got answer:
258;; ->>HEADER<<- opcode: QUERY, status: REFUSED, id: 28655
259;; flags: qr rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 1
260;; WARNING: recursion requested but not available
261
262;; OPT PSEUDOSECTION:
263; EDNS: version: 0, flags:; udp: 1680
264;; QUESTION SECTION:
265;test.com1.local. IN A
266
267;; Query time: 5 msec
268;; SERVER: 10.127.1.207#53(10.127.1.207)
269;; WHEN: Tue Jun 07 14:18:43 CEST 2016
270;; MSG SIZE rcvd: 44