pdnssec rectify-all-zones fails when using custom queries

[anon]

Hi there,

My PowerDNS gmysql setup uses custom queries in that my records table is named dns_record, the domains table dns_domain and so on.

A pdnssec rectify-zone <zone> works fine, rectify-all-zones however fails even so i added a custom get-all-domains-query statement to my config.

 root@taito:~# pdnssec rectify-all-zones
 Error: Database error trying to retrieve all domains:Failed to execute mysql_query, perhaps connection died? Err=1: Table 'more_power.records' doesn't exist
 root@taito:~# tail -n 1 /etc/powerdns/pdns.conf
 get-all-domains-query=select dns_record.domain_id, dns_record.name, dns_record.content, dns_domain.type, dns_domain.master, dns_domain.notified_serial, dns_domain.last_check from dns_record, dns_domain where records.domain_id=domains.id and records.type='SOA'

best regards,

Stefan Schmidt

[anon]

And actually it does seem like that is exactly where the problem lies:

Jul 10 15:04:12 taito pdns[28434]: Fatal error: Trying to set unexisting parameter 'get-all-domains-query'

[anon]

Sorry please disregard. I did not set the launchname prefix for the variable and had an error in the sql statement. It works now. Resolving ticket as invalid.