Re: [Pdns-users] API Bug(?) with Postgres backend when inserting rr containg dots
Hello Ferdinand, On Tue, 2021-03-16 at 16:40 +0100, Ferdinand Goldmann via Pdns-users wrote: > Mar 16 15:48:10 pdns[67880]: [webserver] > 759b42ae-4c22-42be-a961-6b27805d9171 HTTP ISE for > "/api/v1/servers/localhost/zones/ferdl.test.": Exception: GSQLBackend unable > to insert empty non-terminal rr 'name.ferdl.test' in domain_id 86: Fatal > error during query: insert into records > (type,domain_id,disabled,name,ordername,auth,ttl,prio,content) values > (null,$1,false,$2,$3,$4,null,null,null): ERROR: null value in column "type" > violates not-null constraint DETAIL: Failing row contains (4835479, 86, > name.ferdl.test, null, null, null, null, f, null, t). There is no NOT NULL constraint on records.type in the pgsql schema we ship and document. Can you see if you somehow got a constraint into your schema some other way? Kind regards, -- Peter van Dijk PowerDNS.COM BV - https://www.powerdns.com/ ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] PDNS notify zones different in cPanel Server
Thanks! Understood now. However it doesn't work below: pdnsutil set-kind domain.com master Error: Could not find backend willing to accept new zone configuration I think I will just restart pdns service to effect the change, which achieve the same purpose as well some how (eg. Moving a zone from native to master). Warmest Regards, Jackson Yap -Original Message- From: Pdns-users On Behalf Of Pieter Lexis via Pdns-users Sent: Wednesday, 17 March 2021 3:40 PM To: pdns-users@mailman.powerdns.com Subject: Re: [Pdns-users] PDNS notify zones different in cPanel Server Hi Jackson, On 3/17/21 7:52 AM, Jackson Yap via Pdns-users wrote: > Anyone knows what is the difference between native and master zone? This is in the documentation[1]. Native means that PowerDNS does not do the replication, but the backend is responsible for this (e.g. database replication or rsync in the case of the BIND backend). > And > how to force make a native zone into a master zone, without having to > restart pdns service? It depends on the backend. For any database backend you can change this using pdnsutil: pdnsutil set-kind example.com MASTER If you're using the BIND backend, you'll need to edit the bind config file and run pdns_control rediscover 1 - https://docs.powerdns.com/authoritative/modes-of-operation.html#native-rep lication Best regards, Pieter -- Pieter Lexis PowerDNS.COM BV -- https://www.powerdns.com ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] PDNS notify zones different in cPanel Server
Hi Jackson, On 3/17/21 7:52 AM, Jackson Yap via Pdns-users wrote: > Anyone knows what is the difference between native and master zone? This is in the documentation[1]. Native means that PowerDNS does not do the replication, but the backend is responsible for this (e.g. database replication or rsync in the case of the BIND backend). > And > how to force make a native zone into a master zone, without having to > restart pdns service? It depends on the backend. For any database backend you can change this using pdnsutil: pdnsutil set-kind example.com MASTER If you're using the BIND backend, you'll need to edit the bind config file and run pdns_control rediscover 1 - https://docs.powerdns.com/authoritative/modes-of-operation.html#native-replication Best regards, Pieter -- Pieter Lexis PowerDNS.COM BV -- https://www.powerdns.com ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
Re: [Pdns-users] PDNS notify zones different in cPanel Server
Hi PDNS Users, I seem to find the cause. I noticed the new zones is as “native” and not “master”, and therefore pdns notify do not send out “native” zones. Anyone knows what is the difference between native and master zone? And how to force make a native zone into a master zone, without having to restart pdns service? Warmest Regards, Jackson Yap *From:* Jackson Yap *Sent:* Wednesday, 17 March 2021 12:03 PM *To:* 'pdns-users@mailman.powerdns.com' *Subject:* PDNS notify zones different in cPanel Server Hi PDNS Users, We have a cPanel server which is using built-in PDNS service. The problem is after adding new cPanel account/zone, these new zones are not included in pdns_control notify list. As you can see below, only after pdns is restarted, then the notify list of zones are correct. Anyone is aware what could be the cause and how we can resolve this without restarting pdns all the time when new account/zones are added in cPanel? [~]# pdns_control notify '*' Added 442 MASTER/SLAVE zones to queue [~]# service pdns restart Restarting PowerDNS authoritative nameserver: stopping and waiting..done Starting PowerDNS authoritative nameserver: Mar 17 10:44:25 Loading '/usr/lib64/pdns/libbindbackend.so' started [~]# pdns_control notify '*' Added 444 MASTER/SLAVE zones to queue Warmest Regards, Jackson Yap ___ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users