Subject: pdns-backend-pgsql: Default query for ANY contains error Package: pdns-backend-pgsql Version: 2.9.22-5 Severity: minor
I see it in daemon.log: May 25 20:17:53 s0 pdns[18047]: gpgsql Connection succesful May 25 20:17:53 s0 pdns[18047]: Lookup for 'ANY' of '*.srv.hostarium.com' May 25 20:17:53 s0 pdns[18047]: Found a zone 'hostarium.com' (with id 4) that might contain data May 25 20:17:53 s0 pdns[18047]: End of answers May 25 20:17:53 s0 pdns[18047]: Query: select content,ttl,prio,type,domain_id,name from records where name='*.srv.hostarium.com' This query always returns nothing because it does not use LIKE %. Manual http://doc.powerdns.com/generic-mypgsql-backends.html says that the request should be different: > wildcard-any-query > For doing wildcard ANY queries. Default: select > content,ttl,prio,type,domain_id,name from records where name like '%s' My config is just one file: # cat /etc/powerdns/pdns.d/100-dhcs.conf # Here come the local changes the user made, like configuration of # the several backends that exist. launch=bind,gpgsql bind-config=/etc/bind/named.conf gpgsql-host=13.39.14.61 gpgsql-dbname=dhcs gpgsql-password=*** local-address= local-ipv6=:: disable-axfr=no query-logging=yes -- System Information: Debian Release: 5.0.4 APT prefers stable APT policy: (660, 'stable'), (640, 'testing'), (630, 'unstable') Architecture: amd64 (x86_64) Kernel: Linux 2.6.32-4-openvz-amd64 (SMP w/1 CPU core) Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages pdns-backend-pgsql depends on: ii libc6 2.10.2-6 Embedded GNU C Library: Shared lib ii libgcc1 1:4.3.2-1.1 GCC support library ii libpq5 8.4.3-1 PostgreSQL C client library ii libssl0.9.8 0.9.8n-1 SSL shared libraries ii libstdc++6 4.4.4-1 The GNU Standard C++ Library v3 ii pdns-server 2.9.22-5 extremely powerful and versatile n ii zlib1g 1:1.2.3.3.dfsg-12 compression library - runtime pdns-backend-pgsql recommends no packages. pdns-backend-pgsql suggests no packages. -- no debconf information -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org