Re: [Pdns-users] (PDNSException): Database failed to start transaction: Could not execute mysql statement

uery", "remove all empty non-terminals from zone", "delete from records where domain_id=$1 and type is null"); declare(suffix,"delete-empty-non-terminal-query", "delete empty non-terminal from zone", "delete from records where domain_id=$1 and na

[Pdns-users] (PDNSException): Database failed to start transaction: Could not execute mysql statement

Hi, Our PDNS environment is setup on Centos 7 + PDNS Authoritative 4.0.5 + mysql-community 5.7 It is noticed that there are regular PowerDNS failure logs below: 2018-02-04T04:29:07.193742+01:00 mpdns.example.com pdns_server[40761]: Feb 04 04:29:07 Unable to AXFR zone ‘lom.example.com' from rem

Re: [Pdns-users] [External] Notification for domains to ip1:53 failed after retries

Brian and Pieter, great information. I will check it out. Thanks, Steve > On Jan 25, 2018, at 2:16 AM, Brian Candler wrote: > > On 25/01/2018 10:08, Tom Ivar Helbekkmo wrote: >> I found these two blog postings useful: >> >> https://blog.powerdns.com/2016/01/19/efficient-optional-filtering-of

Re: [Pdns-users] [External] Re: Notification for domains to ip1:53 failed after retries

Klaus, Sorry for replying late. > On Jan 17, 2018, at 7:32 AM, Klaus Darilion > wrote: > > > > Am 17.01.2018 um 11:31 schrieb Steve Zeng: >> I came across this post and was concerned if the high number of NOTIFY/AXFR >> overloaded PowerDNS, given that we h

Re: [Pdns-users] Notification for domains to ip1:53 failed after retries

may be a firewall problem > between Bind and PowerDNS. > I tend to believe you and Pieter that this indicates some temporary network or firewall blips within our network. since most of the time it is working quite well. Thanks, Steve > regards > Klaus > > > > Am 17.01

Re: [Pdns-users] Notification for domains to ip1:53 failed after retries

. > > cheers, > -arsen > > * Steve Zeng [2018-01-17 15:43 (+0100)]: >> Klaus, >> >> Good to know. when would BIND do a SOA query to the configured master to >> check the serial? Is it immediately right after it get NOTIFY from master? >> >> Th

Re: [Pdns-users] [External] Notification for domains to ip1:53 failed after retries

Klaus, Good to know. when would BIND do a SOA query to the configured master to check the serial? Is it immediately right after it get NOTIFY from master? Thanks, Steve > On Jan 17, 2018, at 3:32 PM, Klaus Darilion > wrote: > > > > Am 17.01.2018 um 15:13 schrieb Ste

[Pdns-users] Notification for domains to ip1:53 failed after retries

name: example.com master: 10.187.125.2:53,10.187.125.2:53 last_check: 1516197871 type: SLAVE notified_serial: 2016918645 is “no serial” the cause of notification failure? Thanks, Steve > On Jan 17, 2018, at 11:31 AM, Steve Zeng wrote: > > Pieter, > > Tha

Re: [Pdns-users] [External] Re: Notification for domains to ip1:53 failed after retries

instead of native replication. Thanks, Steve > On Jan 17, 2018, at 10:23 AM, Pieter Lexis wrote: > > Hi Steve, > > On Mon, 15 Jan 2018 14:41:51 +0100 > Steve Zeng wrote: > >> we are migrating our DNS master from BIND to PowerDNS. The approach we take >> is to p

[Pdns-users] Notification for domains to ip1:53 failed after retries

Hi, we are migrating our DNS master from BIND to PowerDNS. The approach we take is to put PowerDNS in the middle of an current replication chain as below: BIND DNS master -> PowerDNS -> BIND DNS slaves It works most of the time. However, from time to time we experienced long delay when making

[Pdns-users] AXFR from PowerDNS 4.0.4 to PowerDNS 3.4.11

Hi, We have a DNS chain as below: BIND 9.8.2 (master) -> PowerDNS 4.0.4 + MySQL backend (slave) -> PowerDNS 3.4.11 + bind backend (slave) The initial AXFR working as expected. both PowerDNS slaves got zone transfer successfully. However, when I did further testing by increasing serial number

Re: [Pdns-users] [External] /api/v1/servers/localhost/zones api call very slow

Peter, I added my comment at that issue, though it looks a different issue since I do see DNSSEC info in the result. Thanks, Steve > On Aug 8, 2017, at 9:41 AM, Peter van Dijk > wrote: > > Hello Steve, > > On 5 Aug 2017, at 0:22, Steve Zeng wrote: > >> We hav

[Pdns-users] /api/v1/servers/localhost/zones api call very slow

Hi, We have a few thousands zones (in the table ‘domains') hosted in PowerDNS database (MySQL). it looks very slow (10-12 minutes) to get a list of all domains with API call below: curl -H 'X-API-Key: mykey' 'http://127.0.0.1:8080/api/v1/servers/localhost/zones/' Is this a noticed performance

[Pdns-users] how to filter zones by type in API

Hi, There is a basic API to list all zones below in PowerDNS 4: /api/v1/servers/localhost/zones we have zone types such as Native, Slave, etc. How can I narrow it down to list only Slave zones? is it possible at all? I appreciate it. Thanks, Steve ___

Re: [Pdns-users] [External] need recommendations of PowerDNS web based GUI tool

SRV. NS and PTR records will be > handled with PowerAdmin by our support team and not available to customers. > Dave > > From: Pdns-users on behalf of Steve > Zeng > Sent: Wednesday, February 8, 2017 11:09 AM > To: Pdns-users@mailman.powerdns.com > Subject: [Pdns-users] need

[Pdns-users] need recommendations of PowerDNS web based GUI tool

Hi, We came across https://github.com/PowerDNS/pdns/wiki/WebFrontends with regard to PowerDNS web frontends. They are all third party tools. I am wondering if anybody in this mail list would have recommendations for production environment, or

Re: [Pdns-users] [External] pdns 4.0.x with geo support

Peter, I installed GeoIP-devel and the problem is solved. Thanks, Steve > On Jan 27, 2017, at 2:04 AM, Peter van Dijk > wrote: > > Hello Steve, > > On 27 Jan 2017, at 0:02, Steve Zeng wrote: > >> I was trying to build rpm package for pdns-4.0.3 >> >

[Pdns-users] pdns 4.0.x with geo support

Hi, I was trying to build rpm package for pdns-4.0.3 %configure \ --with-modules="" \ --with-dynmodules="bind gmysql gsqlite3 geoip ldap lua mydns pipe remote" \ But got an compiling error with geo. checking for GEOIP... no configure: error: Could not find libGeoIP Does it mean PowerD