[Pdns-users] Need help after the upgrade
Peter Zoltan Keresztes (zozo)
zozo6015 at gmail.com
Thu Feb 27 20:27:58 UTC 2025
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) <zozo6015 at 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, frank at 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) <zozo6015 at gmail.com> wrote:
>>>
>>> Just did that increased it to 128M no change whatsoever.
>>>
>>> Peter
>>>
>>>> On 27 Feb 2025, at 16:22, frank at 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 at 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) <zozo6015 at 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 at 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 at mailman.powerdns.com
>>>>> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>>>>
>>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20250227/ca589494/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 228 bytes
Desc: Message signed with OpenPGP
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20250227/ca589494/attachment.sig>
More information about the Pdns-users
mailing list