List,
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.
Thanks,
--
--
Steven G. Spencer, Network Administrator
KSC Corporate - The Kelly Supply Family of Companies
Office 308-382-8764 Ext. 1131
Mobile 402-765-8010
_______________________________________________
Pdns-users mailing list
Pdns-users@mailman.powerdns.com
http://mailman.powerdns.com/mailman/listinfo/pdns-users
