[Pdns-users] Update from 2.9.21 to 3.3.1-1 - Color me confused

Steven Spencer steven.spencer at kdsi.com
Tue Feb 17 21:59:46 UTC 2015


I need to preface this that we are not using DNSSEC.

In doing the schema changes, I've run into problems, or what appear to 
be a problems:

Schema changes required (according to the upgrade notes) for 2.9.x to 3.1:

|mysql> ALTER TABLE records MODIFY content VARCHAR(64000);
mysql> ALTER TABLE tsigkeys MODIFY algorithm VARCHAR(50);|

The first one (above) works as expected, second one gives this error:

ERROR 1146 (42S02): Table 'powerdns.tsigkeys' doesn't exist

In reading, it says that this change is required for DNSSEC, so I went on:

Changes required for 3.1 to 3.2:

|alter table records modify ordername    VARCHAR(255) BINARY;
drop index orderindex on records;
create index recordorder on records (domain_id, ordername);|

All of these generate errors

ERROR 1054 (42S22): Unknown column 'ordername' in 'records'
ERROR 1091 (42000): Can't DROP 'orderindex'; check that column/key exist
ERROR 1072 (42000): Key column 'ordername' doesn't exist in table

Last error is obvious, since it already argued on the first command as 
an unknown column

Changes required for 3.2 to 3.3:

alter table supermasters modify ip VARCHAR(64);

This works as expected.

Am I missing earlier schema changes?  This is the second time through this.


Steven G. Spencer, Network Administrator
KSC Corporate - The Kelly Supply Family of Companies
Office 308-382-8764 Ext. 1131
Mobile 402-765-8010

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.powerdns.com/pipermail/pdns-users/attachments/20150217/725acef1/attachment.html>

More information about the Pdns-users mailing list