[SR-Users] too long mysql table key

Juha Heinanen jh at tutpro.com
Fri Apr 14 17:04:44 CEST 2017


I tried to install kamailio mysql db on Debian Stretch.  Create of
domain_attrs table failed with this kind of error message:

ERROR 1071 (42000) at line 26: Specified key was too long; max key length is 767 bytes

domain-create.sql contains this:

CREATE TABLE `domain_attrs` (
    `id` INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
    `did` VARCHAR(64) NOT NULL,
    `name` VARCHAR(32) NOT NULL,
    `type` INT UNSIGNED NOT NULL,
    `value` VARCHAR(255) NOT NULL,
    `last_modified` DATETIME DEFAULT '2000-01-01 00:00:01' NOT NULL,
    CONSTRAINT domain_attrs_idx UNIQUE (`did`, `name`, `value`)
);

Looks like default charset is something (e.g. utf8), where one char takes
more than 1 byte and 767 limit is exceeded.

Any suggestions on how to solve this?

-- Juha



More information about the sr-users mailing list