I had this same problem today. I solved it using OPTION = 67108864 instead of OPTIONS = 67108864
I'm using CentOS5.3 (x86_64) br, takeshi On Sat, Nov 28, 2009 at 12:36 AM, Frank @ Impact <[email protected]>wrote: > Yes. I am using version 5.1 I am using Fedora 12. > > > > -----Original Message----- > *From:* [email protected] [mailto: > [email protected]] *On Behalf Of *Leon de > Rooij > *Sent:* Friday, November 27, 2009 10:19 AM > *To:* [email protected] > *Subject:* Re: [Freeswitch-users] odbc FLAG_MULTI_STATMENTS > > > > Are you using the myodbc 3.51.18 version or higher ? > > > > I'm using 3.51.19 (ubuntu karmic) and it works properly. I also had to > upgrade from jaunty.. > > > > regards, > > > > Leon > > > > > > On Nov 27, 2009, at 3:41 PM, Frank @ Impact wrote: > > > > Thanks. But when I made these entries in /etc/odbc.ini and rebooted… > > > > [freeswitch] > > Driver = MySQL > > SERVER = 127.0.0.1 > > PORT = 4040 > > DATABASE = mydb > > OPTIONS = 67108864 > > > > …I still get FS complaining with this. > > > > Nov 27 08:45:57 P3 freeswitch[27933]: 2009-11-27 08:45:57.016744 [WARNING] > sofia_glue.c:3918 GREAT SCOTT!!! Cannot execute batched statements!#012If > you are using mysql, make sure you are using MYODBC 3.51.18 or higher and > enable FLAG_MULTI_STATEMENTS > > > > FreeSWITCH>version > > FreeSWITCH Version 1.0.trunk (15660) > > > > Linux P3.dom.com 2.6.30.9-96.fc11.x86_64 #1 SMP Wed Nov 4 00:02:04 EST > 2009 x86_64 x86_64 x86_64 GNU/Linux > > > > From /etc/odbcinst.ini > > DRIVER = /usr/lib64/libmyodbc5-5.1.5.so > > Setup = /usr/lib64/libodbcmyS.so > > > > Is this a FS issue ? or an issue with mysql odbc? Any insight would be > great. > > > > -----Original Message----- > *From:* [email protected] [ > mailto:[email protected]<[email protected]> > ] *On Behalf Of *Leon de Rooij > *Sent:* Friday, November 27, 2009 3:37 AM > *To:* [email protected] > *Subject:* Re: [Freeswitch-users] odbc FLAG_MULTI_STATMENTS > > > > There's a little info here on how to enable it with odbc: > > > > http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core#CentOS_5.2 > > > > regards, > > > > Leon > > > > > > On Nov 26, 2009, at 10:48 PM, Tihomir Culjaga wrote: > > > > > > > On Thu, Nov 26, 2009 at 9:53 PM, Michael Jerris <[email protected]> wrote: > > http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-news-3-51-18.html > > > > MySQL Connector/ODBC now supports batched statements. In order to enable > > cached statement support you must switch enable the batched > > statement option (FLAG_MULTI_STATEMENTS, > > 67108864, or Allow multiple statements > > within a GUI configuration). Be aware that batched statements > > create an increased chance of SQL injection attacks and you must > > ensure that your application protects against this scenario. > > (Bug#7445 <http://bugs.mysql.com/7445>) > > > > > so, is this the right patch ? > > http://bugs.mysql.com/file.php?id=6994 > > > T. > > > _______________________________________________ > FreeSWITCH-users mailing list > [email protected] > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users > http://www.freeswitch.org > > > > _______________________________________________ > FreeSWITCH-users mailing list > [email protected] > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users > http://www.freeswitch.org > > > > _______________________________________________ > FreeSWITCH-users mailing list > [email protected] > http://lists.freeswitch.org/mailman/listinfo/freeswitch-users > UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users > http://www.freeswitch.org > >
_______________________________________________ FreeSWITCH-users mailing list [email protected] http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
