[Freeswitch-users] FS Core ODBC Support - Specified key was too long; max key length is 1000 bytes

[Seven Du]

jira.freeswitch.org is a better place for this


On Tuesday, October 9, 2012 at 7:56 AM, Muhammad Shahzad wrote:

> Hi,
> 
> I have compiled FS with core odbc support and get below error at start up,
> 
> =======================================================
> 2012-10-09 01:49:33.596802 [ERR] switch_odbc.c:494 ERR: [create index complete11 on complete (a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,hostname)]
> [STATE: HY000 CODE 1071 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1]Specified key was too long; max key length is 1000 bytes
> ]
> 2012-10-09 01:49:33.596864 [ERR] switch_core_sqldb.c:526 SQL ERR [STATE: HY000 CODE 1071 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1]Specified key was too long; max key length is 1000 bytes
> ]
> create index complete11 on complete (a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,hostname)
> =======================================================
> 
> I know its MySQL specific error as specified at, 
> 
> http://stackoverflow.com/questions/7846298/max-key-length-is-1000-bytes-in-mysql-workbench 
> 
> However, i was wondering if there is any work around for it? 
> 
> Can we ignore this error or it has to be fixed before putting FS in production?
> 
> Thank you. 
> 
> 
> -- 
> Muhammad Shahzad
> -----------------------------------
> CISCO Rich Media Communication Specialist (CRMCS)
> CISCO Certified Network Associate (CCNA)
> Cell: +49 176 99 83 10 85
> MSN: shari_786pk at hotmail.com (mailto:shari_786pk at hotmail.com)
> Email: shaheryarkh at googlemail.com (mailto:shaheryarkh at googlemail.com)
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org (mailto:consulting at freeswitch.org)
> http://www.freeswitchsolutions.com
> 
> 
> 
> 
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
> 
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org (mailto:FreeSWITCH-users at lists.freeswitch.org)
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
> 
> 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121009/e9da64e1/attachment.html