<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.18.3">
<TITLE>Datanet Email</TITLE>
</HEAD>
<BODY>
<BR>
Hi folks,<BR>
<BR>
I'm trying to integrate powerdns with our legacy mysql database here. I have to create a union of three tables to get something that powerdns will use. This takes about 0.4 seconds per query, and hammers the cpu. due to needing to use the %s replacements in the config file in multiple places in a more optimised version of my queries I've had to use stored procedures that take 0.14 seconds to run (still not good enough, but getting better). The problem is I can run the query just fine by hand, but powerdns times out with the valid entry below, and gives and error for anything that should go to the recursor? <BR>
<BR>
I previously had very similar but slow queries in the config file that worked fine?<BR>
<BR>
has anyone come across anything similar to this before?<BR>
<BR>
pdns.local:<BR>
<BR>
gmysql-any-query=call pdns_any_query('%s');<BR>
<BR>
<BR>
mysql cli:<BR>
<BR>
mysql> call pdns_any_query('<A HREF="http://www.datanet.co.uk">www.datanet.co.uk</A>');<BR>
+------------+-------------+------+------+-----------+-------------------+<BR>
| content | ttl | prio | type | domain_id | name |<BR>
+------------+-------------+------+------+-----------+-------------------+<BR>
| 80.68.34.9 | 14400 | 0 | A | 281 | www.datanet.co.uk | <BR>
+------------+-------------+------+------+-----------+-------------------+<BR>
1 row in set (0.14 sec)<BR>
<BR>
<BR>
bash host lookup:<BR>
<BR>
max@ns3:/etc/powerdns/pdns.d# host www.datanet.co.uk 77.241.177.2<BR>
;; connection timed out; no servers could be reached<BR>
<BR>
<BR>
syslog entry for non-local record:<BR>
<BR>
Aug 18 15:51:04 ns3 pdns[12231]: Query: call pdns_any_query('2.177.241.77.in-addr.arpa');<BR>
Aug 18 15:51:04 ns3 pdns[12231]: Backend error: Failed to execute mysql_query, perhaps connection died? Err=1: PROCEDURE dns.pdns_any_query can't return a result set in the given context<BR>
<BR>
<BR>
Thanks for any pointers :)<BR>
<BR>
-Cheers Max
</BODY>
</HTML>