Re: Need help after the upgrade

"Peter Zoltan Keresztes \(zozo\) via Pdns-users" <[email protected]> Thu, 27 Feb 2025 22:27:58 +0200
Newsgroups	gmane.network.dns.powerdns.user
Message-ID	<[email protected]>
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) <[email protected]> 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, [email protected] 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) <[email protected]> wrote:
>>> 
>>> Just did that increased it to 128M no change whatsoever.
>>> 
>>> Peter
>>> 
>>>> On 27 Feb 2025, at 16:22, [email protected] 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 <[email protected]> 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) <[email protected]> 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 <[email protected]> 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
>>>>> [email protected]
>>>>> https://mailman.powerdns.com/mailman/listinfo/pdns-users
>>>> 
>>> 
>> 
>

_______________________________________________
Pdns-users mailing list
[email protected]
https://mailman.powerdns.com/mailman/listinfo/pdns-users
signature.asc (application/pgp-signature, 228 B)