Hi folks,
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?
I previously had very similar but slow queries in the config file that
worked fine?
has anyone come across anything similar to this before?
pdns.local:
gmysql-any-query=call pdns_any_query('%s');
mysql cli:
mysql> call pdns_any_query('www.datanet.co.uk');
+------------+-------------+------+------+-----------+-------------------+
| content | ttl | prio | type | domain_id | name
|
+------------+-------------+------+------+-----------+-------------------+
| 80.68.34.9 | 14400 | 0 | A | 281 | www.datanet.co.uk
|
+------------+-------------+------+------+-----------+-------------------+
1 row in set (0.14 sec)
bash host lookup:
[EMAIL PROTECTED]:/etc/powerdns/pdns.d# host www.datanet.co.uk 77.241.177.2
;; connection timed out; no servers could be reached
syslog entry for non-local record:
Aug 18 15:51:04 ns3 pdns[12231]: Query: call
pdns_any_query('2.177.241.77.in-addr.arpa');
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
Thanks for any pointers :)
-Cheers Max
_______________________________________________
Pdns-users mailing list
[email protected]
http://mailman.powerdns.com/mailman/listinfo/pdns-users
