FS Core ODBC Support - Specified key was too long; max key length is 1000 bytes
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-m... 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@hotmail.com Email: shaheryarkh@googlemail.com
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-m...
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@hotmail.com (mailto:shari_786pk@hotmail.com) Email: shaheryarkh@googlemail.com (mailto:shaheryarkh@googlemail.com) _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org (mailto:consulting@freeswitch.org) http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org (mailto:FreeSWITCH-users@lists.freeswitch.org) http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (2)
-
Muhammad Shahzad
-
Seven Du