Nee help with error on using ODBC
Just download the nightly snapshot and installed. When I tried to start it with ODBC, it has following error: root@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.
It's testing out your SQL server's capabilities On 2011-12-13 12:26 PM, "Gary Chen" <gchen00@insightbb.com> wrote:
Just download the nightly snapshot and installed. When I tried to start it with ODBC, it has following error:
root@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@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 http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
lookup how to enable transaction or multi-line statements for your db On Tue, Dec 13, 2011 at 2:25 PM, Gary Chen <gchen00@insightbb.com> wrote:
Just download the nightly snapshot and installed. When I tried to start it with ODBC, it has following error:
root@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@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 http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
participants (3)
-
Anthony Minessale
-
curriegrad2004
-
Gary Chen