<div dir="ltr">***UPDATE***<div><br></div><div>Looking at the logs I can see this error. If I google for it I see is a known bug that should be fixed. I am running 4.0.3-1pdns.jessie</div><div><br></div><div><div>Feb 15 17:17:56 UKLNDLABDMZ pdns_server[6709]: Feb 15 17:17:56 Backend reported permanent error which prevented lookup (GSQLBackend lookup query:Could not prepare statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?: Unknown column 'disabled' in 'field list'), aborting</div><div>Feb 15 17:17:56 UKLNDLABDMZ pdns_server[6709]: Feb 15 17:17:56 Backend error (retry once): GSQLBackend lookup query:Could not prepare statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?: Unknown column 'disabled' in 'field list'</div><div>Feb 15 17:17:56 UKLNDLABDMZ pdns_server[6709]: Feb 15 17:17:56 Backend reported permanent error which prevented lookup (GSQLBackend lookup query:Could not prepare statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?: Unknown column 'disabled' in 'field list'), aborting</div><div>Feb 15 17:17:56 UKLNDLABDMZ pdns_server[6709]: Feb 15 17:17:56 Backend error: GSQLBackend lookup query:Could not prepare statement: SELECT content,ttl,prio,type,domain_id,disabled,name,auth FROM records WHERE disabled=0 and type=? and name=?: Unknown column 'disabled' in 'field list'</div><div><br></div><div>Federico</div><div><br></div><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Federico Olivieri</b> <span dir="ltr"><<a href="mailto:lvrfrc87@gmail.com">lvrfrc87@gmail.com</a>></span><br>Date: 2017-02-15 15:16 GMT+00:00<br>Subject: pdns authoritative SERVERFAIL<br>To: <a href="mailto:pdns-users@mailman.powerdns.com">pdns-users@mailman.powerdns.com</a><br><br><br><div dir="ltr">Hi everybody,<div><br></div><div>I have started to look into PDNS Authoritative and i have manage to install it with MYSQL support. </div><div>My actual set-up is the following</div><div><br></div><div>dnsdist:53 --> authoritative:5353 --> recursor:5300</div><div><br></div><div>As you can imagine, dnsdist is the fronted that handles the queries to the authoritative and, in case of recursion required the query is handled to recursor.</div><div><br></div><div>So, let's forget for a second about the front-end balance and be focused on authoritative. I have few test records created on MYSQL and pdns authoritative and recursor running. The authoritative looks like is connected to mysql and the authoritative is allowed to do recursion</div><div><br></div><div>However if I dig the authoritative for the record created into mysql, as well as for a recursive query, I get SERVFAIL. If i query the recursor directly everything is fine</div><div><br></div><div>Any idea why? If this set-up is gonna work I am gonna have a lot for pdns installation in the coming month :)</div><div><br></div><div>Please, be aware, I am just a poor network engineer with crappy sysadmin skills, so please have mercy of me!</div><div><br></div><div>Thanks for your time</div><div><br></div><div>Federico</div><div><i><br></i></div><div><div><i>mysql> SHOW TABLES;<br></i></div><div><i>+--------------------+</i></div><div><i>| Tables_in_powerdns |</i></div><div><i>+--------------------+</i></div><div><i>| domains |</i></div><div><i>| migrations |</i></div><div><i>| perm_items |</i></div><div><i>| perm_templ |</i></div><div><i>| perm_templ_items |</i></div><div><i>| records |</i></div><div><i>| records_zone_templ |</i></div><div><i>| supermasters |</i></div><div><i>| users |</i></div><div><i>| zone_templ |</i></div><div><i>| zone_templ_records |</i></div><div><i>| zones |</i></div><div><i>+--------------------+</i></div><div><i>12 rows in set (0.00 sec)</i></div><div><i><br></i></div><div><i>mysql> select * from records;</i></div><div><i>+----+-----------+------------<wbr>-----------+------+-----------<wbr>---------------------------+--<wbr>-----+------+-------------+</i></div><div><i>| id | domain_id | name | type | content | ttl | prio | change_date |</i></div><div><i>+----+-----------+------------<wbr>-----------+------+-----------<wbr>---------------------------+--<wbr>-----+------+-------------+</i></div><div><i>| 1 | 1 | <a href="http://example.com" target="_blank">example.com</a> | SOA | <a href="tel:(201)%20702-1507" value="+12017021507" target="_blank">2017021507</a> 28800 7200 604800 86400 | 86400 | 0 | 1487169093 |</i></div><div><i>| 2 | 1 | <a href="http://example.com" target="_blank">example.com</a> | NS | <a href="http://ns1.example.com" target="_blank">ns1.example.com</a> | 86400 | 0 | 1487169202 |</i></div><div><i>| 3 | 1 | <a href="http://example.com" target="_blank">example.com</a> | NS | <a href="http://ns2.example.com" target="_blank">ns2.example.com</a> | 86400 | 0 | 1487169292 |</i></div><div><i>| 4 | 1 | <a href="http://www.example.com" target="_blank">www.example.com</a> | A | 1.2.3.4 | 86400 | 0 | 1487169355 |</i></div><div><i>| 5 | 1 | <a href="http://example.com" target="_blank">example.com</a> | MX | <a href="http://mail.example.com" target="_blank">mail.example.com</a> | 86400 | 10 | 1487169386 |</i></div><div><i>| 6 | 1 | <a href="http://localhost.example.com" target="_blank">localhost.example.com</a> | A | 127.0.0.1 | 86400 | 0 | 1487169399 |</i></div><div><i>| 7 | 1 | <a href="http://mail.example.com" target="_blank">mail.example.com</a> | A | 1.2.3.4 | 86400 | 0 | 1487169412 |</i></div><div><i>| 8 | 1 | <a href="http://example.com" target="_blank">example.com</a> | A | 1.2.3.4 | 86400 | 0 | 1487169448 |</i></div><div><i>| 9 | 2 | in-addr.arpa | SOA | <a href="tel:(201)%20702-1501" value="+12017021501" target="_blank">2017021501</a> 28800 7200 604800 86400 | 86400 | 0 | 1487169517 |</i></div><div><i>| 10 | 2 | 4.3.2.1.in-addr.arpa | PTR | <a href="http://server1.example.com" target="_blank">server1.example.com</a> | 86400 | 0 | 1487169570 |</i></div><div><i>+----+-----------+------------<wbr>-----------+------+-----------<wbr>---------------------------+--<wbr>-----+------+-------------+</i></div><div><i>10 rows in set (0.00 sec)</i></div><div><i><br></i></div><div><i>mysql> \q</i></div></div><div>##############################<wbr>##############################<wbr>##################</div><div><div><div><i>udp 0 0 <a href="http://192.168.1.11:5300" target="_blank">192.168.1.11:5300</a> 0.0.0.0:* 5563/pdns_recursor</i></div><div><i>udp 0 0 <a href="http://192.168.1.11:5353" target="_blank">192.168.1.11:5353</a> 0.0.0.0:* 5756/pdns_server</i></div></div></div><div><i><div>##############################<wbr>##############################<wbr>##################</div></i></div><div><div><i>Feb 15 14:57:19 UKLNDLABDMZ pdns_server[5756]: Feb 15 14:57:19 Using 64-bits mode. Built using gcc 4.9.2 on Jan 17 2017 09:06:50 by root@29066efb5693.</i></div><div><i>Feb 15 14:57:19 UKLNDLABDMZ pdns_server[5756]: Feb 15 14:57:19 PowerDNS comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to redistribute it according to the terms of...GPL version 2.</i></div><div><i>Feb 15 14:57:19 UKLNDLABDMZ pdns_server[5756]: Feb 15 14:57:19 DNS Proxy launched, local port 22717, remote <a href="http://192.168.1.11:5300" target="_blank">192.168.1.11:5300</a></i></div><div><i>Feb 15 14:57:19 UKLNDLABDMZ pdns_server[5756]: Feb 15 14:57:19 Polled security status of version 4.0.3 at startup, no known issues reported: OK</i></div><div><i>Feb 15 14:57:19 UKLNDLABDMZ pdns_server[5756]: Feb 15 14:57:19 Creating backend connection for TCP</i></div><div><i>Feb 15 14:57:19 UKLNDLABDMZ pdns_server[5756]: Feb 15 14:57:19 [bindbackend] Parsing 0 domain(s), will report when done</i></div><div><i>Feb 15 14:57:19 UKLNDLABDMZ pdns_server[5756]: Feb 15 14:57:19 [bindbackend] Done parsing domains, 0 rejected, 0 new, 0 removed</i></div><div><i>Feb 15 14:57:19 UKLNDLABDMZ pdns_server[5756]: Feb 15 14:57:19 About to create 3 backend threads for UDP</i></div><div><i>Feb 15 14:57:19 UKLNDLABDMZ systemd[1]: Started PowerDNS Authoritative Server.</i></div><div><i>Feb 15 14:57:19 UKLNDLABDMZ pdns_server[5756]: Feb 15 14:57:19 Done launching threads, ready to distribute questio</i></div></div><div><i>##############################<wbr>##############################<wbr>###############</i></div><div><i><div>root@UKLNDLABDMZ:~ # cat /etc/powerdns/pdns.conf | grep recurs</div><div># allow-recursion<span class="gmail-m_2529454903388243904gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>List of subnets that are allowed to recurse</div><div>allow-recursion=<a href="http://0.0.0.0/0" target="_blank">0.0.0.0/0</a></div><div># recursive-cache-ttl<span class="gmail-m_2529454903388243904gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>Seconds to store packets for recursive queries in the PacketCache</div><div># recursive-cache-ttl=10</div><div># recursor<span class="gmail-m_2529454903388243904gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>If recursion is desired, IP address of a recursing nameserver</div><div>recursor=<a href="http://192.168.1.11:5300" target="_blank">192.168.1.11:5300</a></div><div><div>##############################<wbr>##############################<wbr>###############</div></div><div><div>root@UKLNDLABDMZ:~ # dig @<a href="http://192.168.1.11" target="_blank">192.168.1.11</a> -p 5300 <a href="http://www.google.com" target="_blank">www.google.com</a></div><div><br></div><div>; <<>> DiG 9.9.5-9+deb8u9-Debian <<>> @<a href="http://192.168.1.11" target="_blank">192.168.1.11</a> -p 5300 <a href="http://www.google.com" target="_blank">www.google.com</a></div><div>; (1 server found)</div><div>;; global options: +cmd</div><div>;; Got answer:</div><div>;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 30877</div><div>;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1</div><div><br></div><div>;; OPT PSEUDOSECTION:</div><div>; EDNS: version: 0, flags:; udp: 4096</div><div>;; QUESTION SECTION:</div><div>;<a href="http://www.google.com" target="_blank">www.google.com</a>.<span class="gmail-m_2529454903388243904gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>IN<span class="gmail-m_2529454903388243904gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>A</div><div><br></div><div>;; ANSWER SECTION:</div><div><a href="http://www.google.com" target="_blank">www.google.com</a>.<span class="gmail-m_2529454903388243904gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>300<span class="gmail-m_2529454903388243904gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>IN<span class="gmail-m_2529454903388243904gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>A<span class="gmail-m_2529454903388243904gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>216.58.211.164</div><div><br></div><div>;; Query time: 16 msec</div><div>;; SERVER: 192.168.1.11#5300(192.168.1.<wbr>11)</div><div>;; WHEN: Wed Feb 15 15:14:41 GMT 2017</div><div>;; MSG SIZE rcvd: 59</div><div><br></div><div>root@UKLNDLABDMZ:~ # dig @<a href="http://192.168.1.11" target="_blank">192.168.1.11</a> -p 5353 <a href="http://www.example.com" target="_blank">www.example.com</a></div><div><br></div><div>; <<>> DiG 9.9.5-9+deb8u9-Debian <<>> @<a href="http://192.168.1.11" target="_blank">192.168.1.11</a> -p 5353 <a href="http://www.example.com" target="_blank">www.example.com</a></div><div>; (1 server found)</div><div>;; global options: +cmd</div><div>;; Got answer:</div><div>;; ->>HEADER<<- opcode: QUERY, status: SERVFAIL, id: 14867</div><div>;; flags: qr aa rd; QUERY: 1, ANSWER: 0, AUTHORITY: 0, ADDITIONAL: 1</div><div>;; WARNING: recursion requested but not available</div><div><br></div><div>;; OPT PSEUDOSECTION:</div><div>; EDNS: version: 0, flags:; udp: 1680</div><div>;; QUESTION SECTION:</div><div>;<a href="http://www.example.com" target="_blank">www.example.com</a>.<span class="gmail-m_2529454903388243904gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>IN<span class="gmail-m_2529454903388243904gmail-Apple-tab-span" style="white-space:pre-wrap"> </span>A</div><div><br></div><div>;; Query time: 3 msec</div><div>;; SERVER: 192.168.1.11#5353(192.168.1.<wbr>11)</div><div>;; WHEN: Wed Feb 15 15:14:51 GMT 2017</div><div>;; MSG SIZE rcvd: 44</div></div><div><br></div></i></div></div>
</div><br></div></div>