headers
Dave | 21 Sep 22:14

SQL query clarification

Hi,

I need to modify the queries used by PDNS on a gmysql backed. I want to 
confirm whether the 'update-lastcheck-query' documentation is correct on:

http://doc.powerdns.com/generic-mypgsql-backends.html#MASTER-SLAVE-QUERIES

The page says:

update-lastcheck-query
     Called to update the last time a slave domain was checked for 
freshness. Default: update domains set notified_serial=%d where id=%d

Shouldn't it be "update domains set last_check=%d where id=%d"?

Thanks,

Dave
Permalink | Reply |
headers
Christian Hofstaedtler | 21 Sep 23:37
Picon
Gravatar

Re: SQL query clarification

Dave,

* Dave <dave-pdns <at> dubkat.com> [100921 22:14]:
> I need to modify the queries used by PDNS on a gmysql backed. I want
> to confirm whether the 'update-lastcheck-query' documentation is
> correct on:
> 
> http://doc.powerdns.com/generic-mypgsql-backends.html#MASTER-SLAVE-QUERIES
> 
> The page says:
> 
> update-lastcheck-query
>     Called to update the last time a slave domain was checked for
> freshness. Default: update domains set notified_serial=%d where
> id=%d
> 
> Shouldn't it be "update domains set last_check=%d where id=%d"?

This is probably a bug in the documentation. The code holds the
truth:

update-lastcheck-query:
  update domains set last_check=%d where id=%d

--

-- 
christian hofstaedtler
Permalink | Reply |

Gmane