Re: [Pdns-users] TCP Connection Thread died because of STL error: Reading data: Connection reset by peer

2010-05-26 Thread David J Craigon
So what goes in the change_date field? I tried putting 20100526 as a numerical representation of now, but it was still putting out 0 as a serial number. David On 26 May 2010 12:21, David J Craigon wrote: > DB schema is exactly as here: > > http://doc.powerdns.com/generic-mypgsql-backends.html

Re: [Pdns-users] TCP Connection Thread died because of STL error: Reading data: Connection reset by peer

2010-05-26 Thread David J Craigon
me like '%s' and domain_id=%d gpgsql-wildcard-any-query=select content,ttl,prio,type,domain_id,name from dns.records where name like '%s' gpgsql-wildcard-any-id-query=select content,ttl,prio,type,domain_id,name from dns.records where name='%s' and domain_id=

Re: [Pdns-users] TCP Connection Thread died because of STL error: Reading data: Connection reset by peer

2010-05-26 Thread David J Craigon
Adding a TTL doesn't help. Without one, ordinary queries are responded to with the default TTL. David On 26 May 2010 11:07, bert hubert wrote: > On Wed, May 26, 2010 at 10:43:04AM +0100, David J Craigon wrote: >> isp=# select * from dns.records; >>  id | domain

[Pdns-users] TCP Connection Thread died because of STL error: Reading data: Connection reset by peer

2010-05-26 Thread David J Craigon
Hello, I'm trying to use zone transfers but they are not working. With the logging turned up high, I am getting "TCP Connection Thread died because of STL error: Reading data: Connection reset by peer" in /var/log/messages. I only get one record sent. This is even when doing dig -t AXFR @localhos