<p>It's testing out your SQL server's capabilities<br>
</p>
<div class="gmail_quote">On 2011-12-13 12:26 PM, "Gary Chen" <<a href="mailto:gchen00@insightbb.com">gchen00@insightbb.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="font-family:Times New Roman;font-size:12pt;color:#000000"><div>Just download the nightly snapshot and installed.</div><div>When I tried to start it with ODBC, it has following error:</div><div><br></div><div>
root@lyvt100-2:/usr/local/freeswitch/bin# ./freeswitch</div><div>2011-12-13 15:16:30.167564 [INFO] switch_event.c:637 Activate Eventing Engine.</div><div>2011-12-13 15:16:30.183610 [DEBUG] switch_event.c:616 Create event dispatch thread 0</div>
<div>2011-12-13 15:16:31.737119 [INFO] switch_nat.c:419 Scanning for NAT</div><div>2011-12-13 15:16:31.738025 [DEBUG] switch_nat.c:169 Checking for PMP 1/5</div><div>2011-12-13 15:16:31.738330 [ERR] switch_nat.c:200 Error checking for PMP [general error]</div>
<div>2011-12-13 15:16:31.738414 [DEBUG] switch_nat.c:424 Checking for UPnP</div><div>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>).</div>
<div>2011-12-13 15:16:44.039464 [INFO] switch_nat.c:440 No PMP or UPnP NAT devices detected!</div><div>2011-12-13 15:16:44.082799 [INFO] switch_core_sqldb.c:1762 Opening DB</div><div>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;]</div>
<div>[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</div>
<div>]</div><div>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</div>
<div>]</div><div>begin;delete from channels where hostname='';delete from channels where hostname='';commit;</div><div>2011-12-13 15:16:44.109539 [ERR] switch_core_sqldb.c:1827 Transactions not supported on your DB, disabling ODBC</div>
<div>2011-12-13 15:16:44.119269 [INFO] switch_core_sqldb.c:1762 Opening DB</div><div>2011-12-13 15:16:44.272449 [DEBUG] switch_scheduler.c:214 Added task 1 heartbeat (core) to run at 1323807404</div><div>2011-12-13 15:16:44.272795 [DEBUG] switch_scheduler.c:214 Added task 2 check_ip (core) to run at 1323807404</div>
<div>2011-12-13 15:16:44.273273 [CONSOLE] switch_core.c:1817 Bringing up environment.</div><div>2011-12-13 15:16:44.273372 [CONSOLE] switch_core.c:1818 Loading Modules.</div><div><br></div></div></div><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><br>
<br></blockquote></div>