[Freeswitch-users] Need help with error on using ODBC

[Peter Olsson]

MySQL with InnoDB supports key lengths up to 3072 bytes, when using MySQL version 5.0.17 or later (64-bit versions), so you might give that a try.

/Peter


Från: freeswitch-users-bounces at lists.freeswitch.org [mailto:freeswitch-users-bounces at lists.freeswitch.org] För Gary Chen
Skickat: den 13 december 2011 22:34
Till: Freeswitch-user
Ämne: Re: [Freeswitch-users] Need help with error on using ODBC

I added following line odbc.ini and it fixed the problem:
OPTION  = 67108864

But I got another error:

2011-12-13 16:22:23.150436 [INFO] switch_core_sqldb.c:1762 Opening DB
2011-12-13 16:22:23.244872 [ERR] switch_odbc.c:489 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.0.77]Specified key was too long; max key length is 1000 bytes
]
2011-12-13 16:22:23.245184 [ERR] switch_core_sqldb.c:474 SQL ERR [STATE: HY000 CODE 1071 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.0.77]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)
2011-12-13 16:22:23.275285 [DEBUG] switch_scheduler.c:214 Added task 1 heartbeat (core) to run at 1323811343
2011-12-13 16:22:23.275660 [DEBUG] switch_scheduler.c:214 Added task 2 check_ip (core) to run at 1323811343
2011-12-13 16:22:23.276173 [CONSOLE] switch_core.c:1817 Bringing up environment.
2011-12-13 16:22:23.276275 [CONSOLE] switch_core.c:1818 Loading Modules.
2011-12-13 16:22:23.280654 [INFO] switch_time.c:1020 Timezone loaded 530 definitions
2011-12-13 16:22:23.280833 [CONSOLE] switch_time.c:1147 Clock calibration disabled.
2011-12-13 16:22:23.280920 [CONSOLE] switch_loadable_module.c:946 Successfully Loaded [CORE_SOFTTIMER_MODULE]
2011-12-13 16:22:23.281046 [NOTICE] switch_loadable_module.c:232 Adding Timer 'soft'
2011-12-13 16:22:23.281656 [CONSOLE] switch_loadable_module.c:946 Successfully Loaded [CORE_PCM_MODULE]
2

From: freeswitch-users-bounces at lists.freeswitch.org<mailto:freeswitch-users-bounces at lists.freeswitch.org> [mailto:freeswitch-users-bounces at lists.freeswitch.org] On Behalf Of curriegrad2004
Sent: Tuesday, December 13, 2011 4:24 PM
To: FreeSWITCH Users Help
Subject: Re: [Freeswitch-users] Nee help with error on using ODBC


It's testing out your SQL server's capabilities
On 2011-12-13 12:26 PM, "Gary Chen" <gchen00 at insightbb.com<mailto:gchen00 at insightbb.com>> wrote:
Just download the nightly snapshot and installed.
When I tried to start it with ODBC, it has following error:

root at lyvt100-2:/usr/local/freeswitch/bin# ./freeswitch
2011-12-13 15:16:30.167564 [INFO] switch_event.c:637 Activate Eventing Engine.
2011-12-13 15:16:30.183610 [DEBUG] switch_event.c:616 Create event dispatch thread 0
2011-12-13 15:16:31.737119 [INFO] switch_nat.c:419 Scanning for NAT
2011-12-13 15:16:31.738025 [DEBUG] switch_nat.c:169 Checking for PMP 1/5
2011-12-13 15:16:31.738330 [ERR] switch_nat.c:200 Error checking for PMP [general error]
2011-12-13 15:16:31.738414 [DEBUG] switch_nat.c:424 Checking for UPnP
2011-12-13 15:16:43.926445 [DEBUG] switch_nat.c:117 No InternetGatewayDevice, using first entry as default (http://204.126.120.212:80/bmlinks/ddf.xml).
2011-12-13 15:16:44.039464 [INFO] switch_nat.c:440 No PMP or UPnP NAT devices detected!
2011-12-13 15:16:44.082799 [INFO] switch_core_sqldb.c:1762 Opening DB
2011-12-13 15:16:44.109064 [ERR] switch_odbc.c:489 ERR: [begin;delete from channels where hostname='';delete from channels where hostname='';commit;]
[STATE: 42000 CODE 1064 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.0.77]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete from channels where hostname='';delete from channels where hostname='';co' at line 1
]
2011-12-13 15:16:44.109426 [ERR] switch_core_sqldb.c:474 SQL ERR [STATE: 42000 CODE 1064 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.0.77]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delete from channels where hostname='';delete from channels where hostname='';co' at line 1
]
begin;delete from channels where hostname='';delete from channels where hostname='';commit;
2011-12-13 15:16:44.109539 [ERR] switch_core_sqldb.c:1827 Transactions not supported on your DB, disabling ODBC
2011-12-13 15:16:44.119269 [INFO] switch_core_sqldb.c:1762 Opening DB
2011-12-13 15:16:44.272449 [DEBUG] switch_scheduler.c:214 Added task 1 heartbeat (core) to run at 1323807404
2011-12-13 15:16:44.272795 [DEBUG] switch_scheduler.c:214 Added task 2 check_ip (core) to run at 1323807404
2011-12-13 15:16:44.273273 [CONSOLE] switch_core.c:1817 Bringing up environment.
2011-12-13 15:16:44.273372 [CONSOLE] switch_core.c:1818 Loading Modules.


_________________________________________________________________________
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
!DSPAM:4ee7c40632764810216920!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111214/1228529d/attachment-0001.html