[Bug 267363] dns/powerdns broken after upgrade, mandatory schema changes not included or hinted
Date: Wed, 26 Oct 2022 13:04:20 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=267363 --- Comment #2 from freebsd@bengrimm.net --- For those who ended up here and are using the MySQL backend: https://github.com/PowerDNS/pdns/blob/master/modules/gmysqlbackend/4.3.0_to_4.7.0_schema.mysql.sql ALTER TABLE domains ADD options VARCHAR(64000) DEFAULT NULL; ALTER TABLE domains ADD catalog VARCHAR(255) DEFAULT NULL; ALTER TABLE domains MODIFY type VARCHAR(8) NOT NULL; CREATE INDEX catalog_idx ON domains(catalog); These should be run on database 'powerdns'. -- You are receiving this mail because: You are the assignee for the bug.