<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
List,<br>
<br>
I need to preface this that we are not using DNSSEC. <br>
<br>
In doing the schema changes, I've run into problems, or what appear
to be a problems:<br>
<br>
Schema changes required (according to the upgrade notes) for 2.9.x
to 3.1:<br>
<br>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<pre style="box-sizing: border-box; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; white-space: pre-wrap; display: block; padding: 10px; margin: 0px 0px 10.5px; line-height: 1.428571429; color: rgb(51, 51, 51); word-break: break-all; word-wrap: break-word; border: 1px solid rgb(204, 204, 204); border-radius: 0px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(245, 245, 245);"><code style="box-sizing: border-box; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; color: inherit; white-space: pre-wrap; border-radius: 0px; background-color: transparent;">mysql> ALTER TABLE records MODIFY content VARCHAR(64000);
mysql> ALTER TABLE tsigkeys MODIFY algorithm VARCHAR(50);</code></pre>
<br>
The first one (above) works as expected, second one gives this
error:<br>
<br>
ERROR 1146 (42S02): Table 'powerdns.tsigkeys' doesn't exist<br>
<br>
In reading, it says that this change is required for DNSSEC, so I
went on:<br>
<br>
Changes required for 3.1 to 3.2:<br>
<br>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<pre style="box-sizing: border-box; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; white-space: pre-wrap; display: block; padding: 10px; margin: 0px 0px 10.5px; line-height: 1.428571429; color: rgb(51, 51, 51); word-break: break-all; word-wrap: break-word; border: 1px solid rgb(204, 204, 204); border-radius: 0px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(245, 245, 245);"><code style="box-sizing: border-box; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; color: inherit; white-space: pre-wrap; border-radius: 0px; background-color: transparent;">alter table records modify ordername VARCHAR(255) BINARY;
drop index orderindex on records;
create index recordorder on records (domain_id, ordername);</code></pre>
<br>
All of these generate errors<br>
<br>
ERROR 1054 (42S22): Unknown column 'ordername' in 'records'<br>
ERROR 1091 (42000): Can't DROP 'orderindex'; check that column/key
exist<br>
ERROR 1072 (42000): Key column 'ordername' doesn't exist in table<br>
<br>
Last error is obvious, since it already argued on the first command
as an unknown column<br>
<br>
Changes required for 3.2 to 3.3:<br>
<br>
alter table supermasters modify ip VARCHAR(64);<br>
<br>
This works as expected.<br>
<br>
Am I missing earlier schema changes?ÃÂ This is the second time
through this.<br>
<br>
Thanks,<br>
<pre class="moz-signature" cols="72">--
--
Steven G. Spencer, Network Administrator
KSC Corporate - The Kelly Supply Family of Companies
Office 308-382-8764 Ext. 1131
Mobile 402-765-8010
</pre>
</body>
</html>