Re: [Pdns-users] please help with strange insert sql query during zone-transfer

2014-04-28 Thread Daniel Funke
Thank you, Peter, now I understand and the command to list all queries is really useful for me! Best regards Daniel Am 28.04.2014 18:29, schrieb Peter van Dijk: Hello Daniel, On 28 Apr 2014, at 16:11 , Daniel Funke wrote: thank you for your quick response. I know I could change my shema

Re: [Pdns-users] please help with strange insert sql query during zone-transfer

2014-04-28 Thread Peter van Dijk
Hello Daniel, On 28 Apr 2014, at 16:11 , Daniel Funke wrote: > thank you for your quick response. I know I could change my shema to allow > null in the type column, but I'm interested to find out, what kind of zone > data in the source zone could cause this entry and why I cant find the used

Re: [Pdns-users] please help with strange insert sql query during zone-transfer

2014-04-28 Thread Daniel Funke
Hi Peter, thank you for your quick response. I know I could change my shema to allow null in the type column, but I'm interested to find out, what kind of zone data in the source zone could cause this entry and why I cant find the used query statement in any documentation. Am 28.04.2014 15:3

Re: [Pdns-users] please help with strange insert sql query during zone-transfer

2014-04-28 Thread Peter van Dijk
Hello Daniel, On 28 Apr 2014, at 15:08 , Daniel Funke wrote: > Apr 28 14:36:39 Command: insert into records (type,domain_id,name) values > (null,'6',E'000.003.example.com') > Apr 28 14:36:39 Unable to AXFR zone 'example.com' from remote '172.16.101.10' > (AhuException): GSQLBackend unable to f

[Pdns-users] please help with strange insert sql query during zone-transfer

2014-04-28 Thread Daniel Funke
Hi all, I'm just experimenting with an own database schema. all works fine, but during a zone-transfer it stops with these log messages. The normal insert-record-query is "insert into records (content,ttl,prio,type,domain_id,name) values ('%s',%d,%d,'%s',%d,'%s') *"* But what query shou

Re: [Pdns-users] Building PDNS Debian Package from Source

2014-04-28 Thread Klaus Darilion
This is how we build our Debian packages: git clone https://github.com/PowerDNS/pdns cd pdns rm -rf debian ln -s debian-pdns debian vi debian/rules ---> remove all backends and debs except pgsql (backends and debs on top of the file) ---> replace line 7

Re: [Pdns-users] Transfer zone with lower serial from master to slave

2014-04-28 Thread Klaus Darilion
On 27.04.2014 00:36, Nowaker wrote: If anyone wants this feature and is OK with patching PowerDNS, Aki provided a patch in the issue I reported. Thanks! https://github.com/PowerDNS/pdns/issues/1380 I think this might be a nice feature for some custom setups. But of course it should not be h

Re: [Pdns-users] Building PDNS Debian Package from Source

2014-04-28 Thread Wijatmoko U. Prayitno
I'm not familiar with debian packaging.. ask Google. On Mon, 28 Apr 2014 14:00:46 +0530 Dharmesh wrote: > It worked for me. Thanks for your help. > > After this i am stuck with one more thing. The init.d script is made > at pdns/pdns and is not automatically copied to the /etc/init.d/ > > also

Re: [Pdns-users] Building PDNS Debian Package from Source

2014-04-28 Thread Dharmesh
Hi, It worked for me. Thanks for your help. After this i am stuck with one more thing. The init.d script is made at pdns/pdns and is not automatically copied to the /etc/init.d/ also there is a folder in source tarbal named as debian-pdns. What is the use of that folder. How to create a deb packa

Re: [Pdns-users] Building PDNS Debian Package from Source

2014-04-28 Thread Wijatmoko U. Prayitno
On Mon, 28 Apr 2014 09:33:13 +0530 Dharmesh wrote: > Hi all, > > I was trying to build pdns deb package from source code of powerdns > but i am not able to build the deb package properly. > > Following Steps are used by my for creation of deb package :- > 1. ./configure --with-modules="gpgsql"