[Bug 267363] dns/powerdns broken after upgrade, mandatory schema changes not included or hinted

From: <bugzilla-noreply_at_freebsd.org>
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.