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) <zozo6...@gmail.com> > wrote: > > 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-metadata-cache-ttl=60 > guardian=no > launch=gmysql > gmysql-user=powerdns > gmysql-password=Password > gmysql-dbname=powerdns > gmysql-host=10.100.2.9 > gmysql-dnssec=yes > local-address=0.0.0.0,:: > local-port=53 > log-dns-details=yes > log-dns-queries=yes > log-timestamp=yes > loglevel=9 > loglevel-show=yes > max-tcp-connection-duration=0 > max-tcp-connections=20 > max-tcp-connections-per-client=0 > max-tcp-transactions-per-conn=0 > query-cache-ttl=20 > query-local-address=0.0.0.0:: > queue-limit=1500 > receiver-threads=1 > rng=auto > server-id=dns2 > setgid=pdns > setuid=pdns > tcp-fast-open=0 > tcp-idle-timeout=5 > version-string=anonymous > webserver-address=0.0.0.0 > webserver-allow-from=0.0.0.0,:: > webserver-loglevel=detailed > webserver-max-bodysize=2 > webserver-port=8082 > webserver-print-arguments=no > write-pid=yes > >> On 27 Feb 2025, at 16:30, fr...@kiwazo.be wrote: >> >> 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 the passwords, nothing else) PowerDNS config >> file? >> >> Frank >> >>> On 27 Feb 2025, at 15:23, Peter Zoltan Keresztes (zozo) >>> <zozo6...@gmail.com> wrote: >>> >>> 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 >>>>> <pdns-users@mailman.powerdns.com> wrote: >>>>> >>>>> This is really strange situation. >>>>> I have the list of records added to the domain. I can check pdnsutil >>>>> check-zone zozoo.io <http://zozoo.io/> works with no issue. I edit the >>>>> zone with pdnsutil edit-zone zozoo.io <http://zozoo.io/> I add yet >>>>> another boring A record nothing strange, when to apply I get >>>>> Error: GSQLBackend unable to list domain 'zozoo.io': Could not execute >>>>> mysql statement: SELECT >>>>> content,ttl,prio,type,domain_id,disabled,name,auth,ordername FROM records >>>>> WHERE (disabled=0 OR ?) and domain_id=? order by name, type: Lost >>>>> connection to server during query >>>>> I added the record directly into the mysql database. Running a dnsutil >>>>> check-zone zozoo.io <http://zozoo.io/> same error. I removed the record >>>>> from the backend via mysql I can run dnsutil check-zone zozoo.io >>>>> <http://zozoo.io/> with no issues. >>>>> >>>>> Note I am running powerdns 4.9.4 >>>>> >>>>> >>>>>> On 27 Feb 2025, at 13:58, Peter Zoltan Keresztes (zozo) >>>>>> <zozo6...@gmail.com> 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. >>>>>> >>>>>> mysql> explain select domains.id, domains.name, records.content, >>>>>> domains.type, domains.master, domains.notified_serial, >>>>>> domains.last_check, domains.account, domains.catalog from domains LEFT >>>>>> JOIN records ON records.domain_id=domains.id AND records.type='SOA' AND >>>>>> records.name=domains.name WHERE records.disabled=0 >>>>>> -> ; >>>>>> +----+-------------+---------+------------+------+--------------------------+----------------+---------+-----------------------------+------+----------+-------------+ >>>>>> | id | select_type | table | partitions | type | possible_keys >>>>>> | key | key_len | ref | rows | >>>>>> filtered | Extra | >>>>>> +----+-------------+---------+------------+------+--------------------------+----------------+---------+-----------------------------+------+----------+-------------+ >>>>>> | 1 | SIMPLE | domains | NULL | ALL | PRIMARY,name_index >>>>>> | NULL | NULL | NULL | 1 | >>>>>> 100.00 | NULL | >>>>>> | 1 | SIMPLE | records | NULL | ref | >>>>>> nametype_index,domain_id | nametype_index | 271 | >>>>>> powerdns.domains.name,const | 1 | 10.00 | Using where | >>>>>> +----+-------------+---------+------------+------+--------------------------+----------------+---------+-----------------------------+------+----------+-------------+ >>>>>> 2 rows in set, 1 warning (0.01 sec) >>>>>> >>>>>> >>>>>> >>>>>>> On 27 Feb 2025, at 11:04, frank--- via Pdns-users >>>>>>> <pdns-users@mailman.powerdns.com> wrote: >>>>>>> >>>>>>> explain select domains.id <http://domains.id/>, domains.name, >>>>>>> records.content, domains.type, domains.master, domains.notified_serial, >>>>>>> domains.last_check, domains.account, domains.catalog from domains LEFT >>>>>>> JOIN records ON records.domain_id=domains.id <http://domains.id/> AND >>>>>>> records.type='SOA' AND records.name=domains.name WHERE >>>>>>> records.disabled=0 >>>>>>> >>>>>> >>>>> >>>>> _______________________________________________ >>>>> Pdns-users mailing list >>>>> Pdns-users@mailman.powerdns.com >>>>> https://mailman.powerdns.com/mailman/listinfo/pdns-users >>>> >>> >> >
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Pdns-users mailing list Pdns-users@mailman.powerdns.com https://mailman.powerdns.com/mailman/listinfo/pdns-users
