[SR-Users] error when creating scscf database in kamailio 5.1

Hi,

i am upgrading from kamailio 4.x to 5.1, and when i try to create the scscf databse, i get the below error

I tried correcting this by removing the indexes, but the ims did not work properly, with lots of inconsistency in registering, and cannot make calls.

what is the correct way to handle this error ?

root@olc-dd:/usr/local/src/kamailio-5.1/kamailio/utils/kamctl/mysql# mysql -uroot scscf < ims_usrloc_scscf-create.sql ERROR 1071 (42000) at line 2: Specified key was too long; max key length is 767 bytes

Thanks.

Abdelmuhaimen Seaudi, CCIE # 25265 Email: aseaudi@gmail.com Skype: aseaudi LinkedIn: www.linkedin.com/in/aseaudi Telephone: +2012 84644 733