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

[Anthony Minessale]

lookup how to enable transaction or multi-line statements for your db

On Tue, Dec 13, 2011 at 2:25 PM, Gary Chen <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
> 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
> 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 at hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
googletalk:conf+888 at conference.freeswitch.org
pstn:+19193869900
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20111213/e4928fa1/attachment.html