<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 12pt; color: #000000'><p class="MsoNormal"><font class="Apple-style-span" color="#1f497d" face="Calibri, sans-serif"><span class="Apple-style-span" style="font-size: 15px;">I added following line odbc.ini and it fixed the problem:</span></font></p><p class="MsoNormal"><font class="Apple-style-span" color="#1f497d" face="Calibri, sans-serif"><span class="Apple-style-span" style="font-size: 15px;">OPTION = 67108864</span></font></p><p class="MsoNormal"><font class="Apple-style-span" color="#1f497d" face="Calibri, sans-serif"><span class="Apple-style-span" style="font-size: 15px;"><br></span></font></p><p class="MsoNormal"><font class="Apple-style-span" color="#1f497d" face="Calibri, sans-serif"><span class="Apple-style-span" style="font-size: 15px;">But I got another error:</span></font></p><p class="MsoNormal"><font class="Apple-style-span" color="#1f497d" face="Calibri, sans-serif"><span class="Apple-style-span" style="font-size: 15px;"><p class="MsoNormal"><br></p><p class="MsoNormal">2011-12-13 16:22:23.150436 [INFO] switch_core_sqldb.c:1762 Opening DB</p><p class="MsoNormal">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)]</p><p class="MsoNormal">[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</p><p class="MsoNormal">]</p><p class="MsoNormal">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</p><p class="MsoNormal">]</p><p class="MsoNormal">create index complete11 on complete (a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,hostname)</p><p class="MsoNormal">2011-12-13 16:22:23.275285 [DEBUG] switch_scheduler.c:214 Added task 1 heartbeat (core) to run at 1323811343</p><p class="MsoNormal">2011-12-13 16:22:23.275660 [DEBUG] switch_scheduler.c:214 Added task 2 check_ip (core) to run at 1323811343</p><p class="MsoNormal">2011-12-13 16:22:23.276173 [CONSOLE] switch_core.c:1817 Bringing up environment.</p><p class="MsoNormal">2011-12-13 16:22:23.276275 [CONSOLE] switch_core.c:1818 Loading Modules.</p><p class="MsoNormal">2011-12-13 16:22:23.280654 [INFO] switch_time.c:1020 Timezone loaded 530 definitions</p><p class="MsoNormal">2011-12-13 16:22:23.280833 [CONSOLE] switch_time.c:1147 Clock calibration disabled.</p><p class="MsoNormal">2011-12-13 16:22:23.280920 [CONSOLE] switch_loadable_module.c:946 Successfully Loaded [CORE_SOFTTIMER_MODULE]</p><p class="MsoNormal">2011-12-13 16:22:23.281046 [NOTICE] switch_loadable_module.c:232 Adding Timer 'soft'</p><p class="MsoNormal">2011-12-13 16:22:23.281656 [CONSOLE] switch_loadable_module.c:946 Successfully Loaded [CORE_PCM_MODULE]</p><p class="MsoNormal">2</p></span></font></p><p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; "><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";
mso-ascii-theme-font:minor-latin;mso-hansi-theme-font:minor-latin;mso-bidi-font-family:
"Times New Roman";mso-bidi-theme-font:minor-bidi;color:#1F497D;mso-themecolor:
dark2"><o:p> </o:p></span></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; "><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";
mso-fareast-font-family:"Times New Roman"">From:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-font-family:
"Times New Roman""> freeswitch-users-bounces@lists.freeswitch.org
[mailto:freeswitch-users-bounces@lists.freeswitch.org] <b>On Behalf Of </b>curriegrad2004<br>
<b>Sent:</b> Tuesday, December 13, 2011 4:24 PM<br>
<b>To:</b> FreeSWITCH Users Help<br>
<b>Subject:</b> Re: [Freeswitch-users] Nee help with error on using ODBC<o:p></o:p></span></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; "><o:p> </o:p></p>
<p style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">It's testing out your SQL server's capabilities<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">On 2011-12-13 12:26 PM, "Gary Chen" <<a href="mailto:gchen00@insightbb.com">gchen00@insightbb.com</a>> wrote:<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">Just download the nightly snapshot
and installed.<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">When I tried to start it with
ODBC, it has following error:<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; "><o:p> </o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">root@lyvt100-2:/usr/local/freeswitch/bin#
./freeswitch<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:30.167564 [INFO]
switch_event.c:637 Activate Eventing Engine.<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:30.183610 [DEBUG]
switch_event.c:616 Create event dispatch thread 0<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:31.737119 [INFO]
switch_nat.c:419 Scanning for NAT<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:31.738025 [DEBUG]
switch_nat.c:169 Checking for PMP 1/5<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:31.738330 [ERR]
switch_nat.c:200 Error checking for PMP [general error]<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:31.738414 [DEBUG]
switch_nat.c:424 Checking for UPnP<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:43.926445 [DEBUG]
switch_nat.c:117 No InternetGatewayDevice, using first entry as default (<a href="http://204.126.120.212:80/bmlinks/ddf.xml" target="_blank">http://204.126.120.212:80/bmlinks/ddf.xml</a>).<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:44.039464 [INFO]
switch_nat.c:440 No PMP or UPnP NAT devices detected!<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:44.082799 [INFO]
switch_core_sqldb.c:1762 Opening DB<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">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;]<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">[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<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">]<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">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<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">]<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">begin;delete from channels where
hostname='';delete from channels where hostname='';commit;<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:44.109539 [ERR]
switch_core_sqldb.c:1827 Transactions not supported on your DB, disabling ODBC<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:44.119269 [INFO]
switch_core_sqldb.c:1762 Opening DB<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:44.272449 [DEBUG]
switch_scheduler.c:214 Added task 1 heartbeat (core) to run at 1323807404<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:44.272795 [DEBUG]
switch_scheduler.c:214 Added task 2 check_ip (core) to run at 1323807404<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:44.273273
[CONSOLE] switch_core.c:1817 Bringing up environment.<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; ">2011-12-13 15:16:44.273372
[CONSOLE] switch_core.c:1818 Loading Modules.<o:p></o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; "><o:p> </o:p></p>
<p class="MsoNormal" style="color: rgb(0, 0, 0); font-family: 'Times New Roman'; font-size: 12pt; margin-bottom: 12pt; "><br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><o:p></o:p></p></div></body></html>