[OpenSER-Users] ERROR 1071 (42000) at line 2: Specified key was too long; max key length is 1000 bytes

[Patrick Miccio]

hi,

I tried it quickly under gentoo.

in the install folder:

share/openser/mysql/

alias_db-create.sql -> dbaliases
registrar-create.sql -> aliases
usrloc-create.sql -> location

those 3 tables have the problem.

changing type from myisam to innodb solves the problem, though I don't know what consequences this has ;)


cheers,

Patrick.

> Hi,
> When I try to create openser database (openserdbctl create) on Gentoo, I
> have the message:
> 
> INFO: creating database openser ...
> ERROR 1071 (42000) at line 2: Specified key was too long; max key length is
> 1000 bytes
> ERROR: Creating core tables failed!
> 
> I search when i can modify TABLE_TYPE but i not found.
> 
> Regards,
> Yazid