Re: [Pdns-users] Need help after the upgrade

2025-02-27 Thread Peter Zoltan Keresztes (zozo) via Pdns-users
Deployed a new mysql server and everything works as expected. Thank you for your patience and all the answers. Based on the configuration file posted if you see ways to improve feel free to to post your suggestions. Regards, Peter > On 27 Feb 2025, at 17:12, Peter Zoltan Keresztes (zozo) > wr

Re: [Pdns-users] Need help after the upgrade

2025-02-27 Thread Peter Zoltan Keresztes (zozo) via Pdns-users
8bit-dns=yes api=yes api-key=changeme cache-ttl=20 config-dir=/etc/pdns daemon=yes default-api-rectify=yes default-ksk-algorithm=ecdsa256 default-ksk-size=0 default-ttl=3600 direct-dnskey=yes disable-axfr=yes distributor-threads=3 dname-processing=yes dnssec-key-cache-ttl=30 dnsupdate=yes domain-me

Re: [Pdns-users] Need help after the upgrade

2025-02-27 Thread Curtis Maurand via Pdns-users
sorry for the bandwidth: pdnsutil rectify-zone On 2/27/25 09:47, Curtis Maurand via Pdns-users wrote: I can't type: pdnsutil rectify Cheers, Curtis On 2/27/25 09:46, Curtis Maurand via Pdns-users wrote: Is the domain signed? Did you run pdnsutil rectivy ? On 2/27/25 06:58, Peter Zol

Re: [Pdns-users] Need help after the upgrade

2025-02-27 Thread Curtis Maurand via Pdns-users
I can't type: pdnsutil rectify Cheers, Curtis On 2/27/25 09:46, Curtis Maurand via Pdns-users wrote: Is the domain signed? Did you run pdnsutil rectivy ? On 2/27/25 06:58, Peter Zoltan Keresztes (zozo) via Pdns-users wrote: I have reinstalled the pdns exported the zones to csv files and

Re: [Pdns-users] Need help after the upgrade

2025-02-27 Thread Curtis Maurand via Pdns-users
Is the domain signed? Did you run pdnsutil rectivy ? On 2/27/25 06:58, Peter Zoltan Keresztes (zozo) via Pdns-users wrote: I have reinstalled the pdns exported the zones to csv files and readied the used one using pdnsutil however when I try to save sometimes I am getting the same errors.

Re: [Pdns-users] Need help after the upgrade

2025-02-27 Thread frank--- via Pdns-users
I just noticed something wierd in your query. > SELECT content,ttl,prio,type,domain_id,disabled,name,auth,ordername FROM > records WHERE (disabled=0 OR ?) and domain_id=? order by name, type That "disabled=0 or ?" construct seems off to me. Can you please post your full and unedited (only mask

Re: [Pdns-users] Need help after the upgrade

2025-02-27 Thread Peter Zoltan Keresztes (zozo) via Pdns-users
Just did that increased it to 128M no change whatsoever. Peter > On 27 Feb 2025, at 16:22, fr...@kiwazo.be wrote: > > Try increasing max_allowed_packet in your mysqld config, see if that helps... > > > Frank > >> On 27 Feb 2025, at 15:10, Peter Zoltan Keresztes (zozo) via Pdns-users >> wrot

Re: [Pdns-users] Need help after the upgrade

2025-02-27 Thread frank--- via Pdns-users
Try increasing max_allowed_packet in your mysqld config, see if that helps... Frank > On 27 Feb 2025, at 15:10, Peter Zoltan Keresztes (zozo) via Pdns-users > wrote: > > This is really strange situation. > I have the list of records added to the domain. I can check pdnsutil > check-zone zoz

Re: [Pdns-users] Need help after the upgrade

2025-02-27 Thread Peter Zoltan Keresztes (zozo) via Pdns-users
This is really strange situation. I have the list of records added to the domain. I can check pdnsutil check-zone zozoo.io works with no issue. I edit the zone with pdnsutil edit-zone zozoo.io I add yet another boring A record nothing strange, when to apply

Re: [Pdns-users] Need help after the upgrade

2025-02-27 Thread Peter Zoltan Keresztes (zozo) via Pdns-users
I have reinstalled the pdns exported the zones to csv files and readied the used one using pdnsutil however when I try to save sometimes I am getting the same errors. mysql> explain select domains.id, domains.name, records.content, domains.type, domains.master, domains.notified_serial, domains.

Re: [Pdns-users] Need help after the upgrade

2025-02-27 Thread frank--- via Pdns-users
> > Forgot to mention: it also might be your DB schema is missing an > index, making the zone cache query slow. Posting the result of the following db query might help: explain select domains.id , domains.name, records.content, domains.type, domains.master, domains.notified

Re: [Pdns-users] [DNSSEC] exception Default beforeAndAfterAbsolute called! - pdns.service: Main process exited, code=killed, status=6/ABRT

2025-02-27 Thread Alessandro Lota via Pdns-users
I reply to me: i trigger the problem: if you insert the same "domain/zone" in two backend, pdns crash and exit with message "Default beforeAndAfterAbsolute called!" anyway multiple mix backend in PDNS works fine (tested ldap+mariadb or ldap+postgresql) but domains should exists only in one o