Date: Wed, 26 Oct 2022 13:04:20 +0000 From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 267363] dns/powerdns broken after upgrade, mandatory schema changes not included or hinted Message-ID: <bug-267363-7788-jqG335VLuY@https.bugs.freebsd.org/bugzilla/> In-Reply-To: <bug-267363-7788@https.bugs.freebsd.org/bugzilla/> References: <bug-267363-7788@https.bugs.freebsd.org/bugzilla/>
next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D267363 --- 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'. --=20 You are receiving this mail because: You are the assignee for the bug.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-267363-7788-jqG335VLuY>