On 2013-08-07 14:31, NetCetera Lists wrote:
I decided to give the master branch a try.
The configure and make went as expected but I ran into an error on the
sql script.
BTW, upgrade page
mysql -u piler -p piler < util/db-upgrade-0.23-vs-0.24.sql
should be
mysql -u piler -p piler < util/db-upgrade-0.1.23-vs-0.1.24.sql
you are right, I fixed it.
I ran the script and after a few seconds...
ERROR 1071 (42000) at line 11: Specified key was too long; max key
length is 3072 bytes
How to proceed ?
well, this requires some manual workaround. If you open
util/db-upgrade-0.1.23-vs-0.1.24.sql then you can see, it's a plain text
file with some sql commands.
I think that the execution has stopped at this line:
alter table archiving_rule add column domain varchar(255) default null;
you can verify it to run: describe archiving_rule. If I'm right then
there's no 'domain' column.
In this case please run the following (copy-paste it):
alter table archiving_rule add column domain varchar(128) default null;
alter table retention_rule add column domain varchar(128) default null;
alter table retention_rule drop index `from`;
create unique index `entry` on retention_rule
(`domain`,`from`,`to`,`subject`,`_size`,`size`,`attachment_type`,`_attachment_size`,`attachment_size`,`spam`);
drop view if exists `v_messages`;
create view `v_messages` AS select `metadata`.`id` AS
`id`,`metadata`.`piler_id` AS `piler_id`,`metadata`.`from` AS
`from`,`metadata`.`fromdomain` AS `fromdomain`,`rcpt`.`to` AS
`to`,`rcpt`.`todomain` AS `todomain`,`metadata`.`subject` AS `subject`,
`metadata`.`size` AS `size`, `metadata`.`direction` AS `direction`,
`metadata`.`sent` AS `sent`, `metadata`.`retained` AS `retained`,
`metadata`.`arrived` AS `arrived`, `metadata`.`digest` AS `digest`,
`metadata`.`bodydigest` AS `bodydigest` from (`metadata` join `rcpt`)
where (`metadata`.`id` = `rcpt`.`id`);
update user_settings set theme='mobile' where theme='orig';
create table if not exists `ldap` (
`id` int not null auto_increment primary key,
`description` varchar(255) not null,
`ldap_type` varchar(255) not null,
`ldap_host` varchar(255) not null,
`ldap_base_dn` varchar(255) not null,
`ldap_bind_dn` varchar(255) not null,
`ldap_bind_pw` varchar(255) not null,
`ldap_auditor_member_dn` varchar(255) default null
) Engine=InnoDB;
create table if not exists `customer_settings` (
`id` int not null auto_increment primary key,
`domain` varchar(255) not null unique,
`branding_text` varchar(255) default null,
`branding_url` varchar(255) default null,
`branding_logo` varchar(255) default null,
`support_link` varchar(255) default null,
`colour` varchar(255) default null
) Engine=InnoDB;
create table if not exists `online` (
`username` varchar(255) not null,
`ts` int default 0,
`last_activity` int default 0,
`ipaddr` varchar(255) default null,
unique(`username`,`ipaddr`)
) Engine=InnoDB;
Anyway I'll doublecheck the upgrade script.
Janos
