Re: Need help after the upgrade
Curtis Maurand via Pdns-users <[email protected]> Thu, 27 Feb 2025 09:48:36 -0500
| Newsgroups | gmane.network.dns.powerdns.user |
|---|---|
| Message-ID | <[email protected]> |
sorry for the bandwidth: pdnsutil rectify-zone <zone> On 2/27/25 09:47, Curtis Maurand via Pdns-users wrote: > > I can't type: pdnsutil rectify <zone> > > Cheers, > Curtis > > > On 2/27/25 09:46, Curtis Maurand via Pdns-users wrote: >> >> Is the domain signed? Did you run pdnsutil rectivy <zone>? >> >> >> >> >> 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. >>> >>> 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 > > > _______________________________________________ > 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