[SR-Users] too long mysql table key

[Daniel-Constantin Mierla]

Hello,

On 14.04.17 17:04, Juha Heinanen wrote:
> 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?
>
I haven't trying for UNIQUE, but it may be the same as for usual INDEX
where one can provide the length for column (prefix size to be taken in
consideration).

Cheers,
Daniel

-- 
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - May 22-24 (USA) - www.asipto.com
Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com