[Pdns-users] Update from 2.9.21 to 3.3.1-1 - Color me confused
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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Pdns-users