[Freeswitch-users] odbc FLAG_MULTI_STATMENTS

[mayamatakeshi]

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 <frank at impactfax.com>wrote:

>  Yes. I am using version 5.1  I am using Fedora 12.
>
>
>
> -----Original Message-----
> *From:* freeswitch-users-bounces at lists.freeswitch.org [mailto:
> freeswitch-users-bounces at lists.freeswitch.org] *On Behalf Of *Leon de
> Rooij
> *Sent:* Friday, November 27, 2009 10:19 AM
> *To:* freeswitch-users at lists.freeswitch.org
> *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:* freeswitch-users-bounces at lists.freeswitch.org [
> mailto:freeswitch-users-bounces at lists.freeswitch.org<freeswitch-users-bounces at lists.freeswitch.org>
> ] *On Behalf Of *Leon de Rooij
> *Sent:* Friday, November 27, 2009 3:37 AM
> *To:* freeswitch-users at lists.freeswitch.org
> *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 <mike at jerris.com> 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
> 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
>
>
>
> _______________________________________________
> 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
>
>
>
> _______________________________________________
> 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091205/0fe3022d/attachment-0002.html