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

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

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

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

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

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

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

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

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

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

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

> > 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] Need help after the upgrade

On Thu, Feb 27, 2025 at 08:04:05AM +0100, Otto Moerbeek via Pdns-users wrote: > On Thu, Feb 27, 2025 at 12:22:07AM +0200, Peter Zoltan Keresztes (zozo) via > Pdns-users wrote: > > > I don’t see any issue with the database. I is working fine while the pdns > > constantly throws those errors I am

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

On Thu, Feb 27, 2025 at 12:22:07AM +0200, Peter Zoltan Keresztes (zozo) via Pdns-users wrote: > I don’t see any issue with the database. I is working fine while the pdns > constantly throws those errors I am connected to the database and running > queries on it. > > > > > On 27 Feb 2025, at

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

I don’t see any issue with the database. I is working fine while the pdns constantly throws those errors I am connected to the database and running queries on it. > On 27 Feb 2025, at 00:19, Kevin P. Fleming via Pdns-users > wrote: > > "Lost connection to server during query" means the data

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

"Lost connection to server during query" means the database server shut down, or crashed, or soemthing. On Wed, Feb 26, 2025, at 16:48, Peter Zoltan Keresztes (zozo) via Pdns-users wrote: > Hello > > I had a powerdns server and the server died for some hardware issues > during the day. Since I

[Pdns-users] Need help after the upgrade

Hello I had a powerdns server and the server died for some hardware issues during the day. Since I did not remember what version of powerdns it was running at I deployed a new server and deployed the latest stable version on it. Then because of mismatches in the database I have found out that