Yes, but I have checked and double checked all custom queries, and all fields in the SELECT clauses are in the correct order (correct = order of fields as in the Powerdns source code queries). I have no idea where that malformed type is coming from. When I disable the backend with the custom queries everything is ok with this domain, but like I said, I cannot figure out why Powerdns does what it does when both backends are active.

Martijn


On 30-10-2015 17:41, Aki Tuomi wrote:
That, again, means that you have dns name in type column.

On Thu, Oct 29, 2015 at 09:32:48PM +0100, Martin wrote:
No, except for the aforementioned ' unknown dns type
'hoofdluis.hoofdluis.nl' ' message which is probably why the queries
fail but I am unable to track down where this error is coming from.
I'm guessing Powerdns tries to build a query and decided something
is wrong, but since it is never actually executed in the database it
doesn't show up in the MySQL query logs.

Martijn


On 29-10-2015 21:22, Aki Tuomi wrote:
>When you get SERVFAIL, do you see anything in
>
>/var/log/syslog or /var/log/messages
>
>Aki
>
>On Thu, Oct 29, 2015 at 09:11:16PM +0100, Martin wrote:
>>
>>
>>Hi,
>>
>>Sure, one of the domains that is giving me trouble is hoofdluis.nl
>>
>>- dnssec is disabled for this backend in Powerdns config
>>
>>- here's a few lines from the 'records' table:
>>
>>| id | domain_id | name | type | content | ttl | prio | change_date |
>>disabled | ordername | auth |
>>+-----+-----------+------------------------+------+------------------------------------------------------------------------+-------+------+-------------+----------+-----------+------+
>>| 349 | 38 | hoofdluis.nl | SOA | ns1.sonexo.eu info.sonexo.nl
>>2015102902 10800 3600 604800 3600 | 86400 | 0 | 1446148124 | 0 |
>>NULL |
>>1 |
>>| 350 | 38 | hoofdluis.nl | NS | ns1.sonexo.eu | 86400 | 0 |
>>1446122706
>>| 0 | NULL | 1 |
>>| 351 | 38 | hoofdluis.nl | NS | ns2.sonexo.com | 86400 | 0 |
>>1446122706
>>| 0 | NULL | 1 |
>>| 352 | 38 | www.hoofdluis.nl | A | 185.27.174.120 | 86400 | 0 |
>>1446122706 | 0 | NULL | 1 |
>>| 353 | 38 | hoofdluis.nl | A | 185.27.174.120 | 86400 | 0 |
>>1446122706
>>| 0 | NULL | 1 |
>>| 355 | 38 | localhost.hoofdluis.nl | A | 127.0.0.1 | 86400 | 0 |
>>1446122706 | 0 | NULL | 1 |
>>
>>- root@ns1:/etc/powerdns/pdns.d# pdnssec check-zone hoofdluis.nl
>>Checked 12 records of 'hoofdluis.nl', 0 errors, 0 warnings.
>>
>>I should probably add that we are running two backends, both MySQL on
>>the same server, spread out over two different databases. One
>>backend is
>>more advanced and uses custom queries and dnssec but has no records
>>whatsoever for any of the domains in the second backend, and
>>vice versa.
>>Advanced backend is queried first, regular one next. It'd be easy to
>>point to this as the source of the problem but I cannot find any clue
>>that it is causing problems since MySQL queries are ok and the first
>>(more advanced) backend does not return any data at all for the domain
>>hoofdluis.nl so the second backend is definitely in control.
>>
>>Martin
>>
>>On 29-10-2015 20:39, Aki Tuomi wrote:
>>
>>> Is it possible for you to provide actual data? Also,
>>> - have you turned on dnssec support? gmysql-dnssec=yes
>>> - can you provide the actual line(s) from mysql database
>>> - can you run pdnssec check-zone zone
>>>
>>> Aki
>>>
>>> On Thu, Oct 29, 2015 at 08:18:29PM +0100, Martin wrote:
>>> Hi, Thanks for your reply. I'm using Poweradmin and everything seems to be ok 
in the database, no mixup of types and content or anything. I forgot to add that if I query 
the authoritative nameserver for the domain directly, dig works as expected: dig a 
abc.example.com @ns1.mynsserver gives me the expected NXDOMAIN result. I have enabled MySQL 
query log and it appears that some queries are fired but somehow the requesting client is 
unable to determine who is authoritative or something. You see, when I use nslookup in debug 
mode this happens: ------------ QUESTIONS: abc.example.com, type = A, class = IN ANSWERS: 
AUTHORITY RECORDS: ADDITIONAL RECORDS: ------------ ** server can't find abc.example.com: 
SERVFAIL I would expect to at least get some authority records. Again, www.example.com [1]is 
working fine in nslookup & dig. Martin On 29-10-2015 18:12, bert hubert wrote: Hi 
Martin, You appear to have put domain names in the type field! The error messages say the 
type is
>>example.example.com. Bert On Oct 29, 2015 17:10, Martin
>><[email protected]> wrote: Hi, I have setup a simple MySQL
>>backend for a domain with a few MX records, a couple of A
>>records, two NS records and a SOA record for the domain. All dig
>>commands are run from a completely unrelated server: dig a
>>www.example.com [1] [1] is working: it returns the right A
>>record dig a example.com is working: it returns the right A
>>record Now this is where things go wrong: dig a abc.example.com
>>returns a SERVFAIL but I am expecting a NXDOMAIN response
>>because there is no A record for abc.example.com I checked the
>>PowerDNS logs and this is there: Oct 29 16:44:45 ns1
>>pdns[27687]: Exception building answer packet (Unknown DNS type
>>'example.example.com') sending out servfail Oct 29 16:44:45 ns1
>>pdns[27687]: Exception building answer packet (Unknown DNS type
>>'example.example.com') sending out servfail Oct 29 16:44:45 ns1
>>pdns[27687]: Exception building answer packet (Unknown DNS type
>>'example.example.com') sending out servfail Oct 29 16:44:45 ns1
>>pdns[27687]: Exception building answ
>> er packet (Unknown DNS type 'example.example.com') sending out
>>servfail
>>Oct 29 16:44:45 ns1 pdns[27687]: Exception building answer packet
>>(Unknown DNS type 'example.example.com') sending out servfail Five
>>messages with unknow dns type 'domain.domain.tld'. I have tried an
>>online tool like http://www.kloth.net/services/dig.php [3] [2] as well
>>and it generates the same error in the logs but only once instead of
>>five times. Can anyone point me in the right direction? I'm
>>stumped. I'm
>>running the latest version on Debian. Thanks, Martin Links: ------ [1]
>>http://www.example.com [1] [2]
>>http://www.kloth.net/services/dig.php [3]
>>
>>
>>> _______________________________________________ Pdns-users mailing list 
[email protected] http://mailman.powerdns.com/mailman/listinfo/pdns-users 
[2]
>>
>>
>>Links:
>>------
>>[1] http://www.example.com
>>[2] http://mailman.powerdns.com/mailman/listinfo/pdns-users
>>[3] http://www.kloth.net/services/dig.php
>
>>_______________________________________________
>>Pdns-users mailing list
>>[email protected]
>>http://mailman.powerdns.com/mailman/listinfo/pdns-users

_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users


_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users

Reply via email to