Yes. I am using version 5.1  I am using Fedora 12.

 

-----Original Message-----
From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Leon de Rooij
Sent: Friday, November 27, 2009 10:19 AM
To: freeswitch-users@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@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Leon de Rooij
Sent: Friday, November 27, 2009 3:37 AM
To: freeswitch-users@lists.freeswitch.org
Subject: Re: [Freeswitch-users] odbc FLAG_MULTI_STATMENTS

 

There's a little info here on how to enable it with odbc:

 

 

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@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)

 


so, is this the right patch ?

http://bugs.mysql.com/file.php?id=6994


T.

 

_______________________________________________
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