lookup how to enable transaction or multi-line statements for your db<br><br><div class="gmail_quote">On Tue, Dec 13, 2011 at 2:25 PM, Gary Chen <span dir="ltr"><<a href="mailto:gchen00@insightbb.com">gchen00@insightbb.com</a>></span> wrote:<br>
<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><br><br clear="all"><div><br></div>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><br>ClueCon <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire">http://twitter.com/FreeSWITCH_wire</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br><a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:+19193869900<br>