odbc FLAG_MULTI_STATMENTS

older
Option to hang-up both legs in a...

Frank ＠ Impact

26 Nov 2009 26 Nov '09

7:22 p.m.

"GREAT SCOTT!!! Cannot execute batched statements! If you are using mysql, make sure you are using MYODBC 3.51.18 or higher and enable FLAG_MULTI_STATEMENTS" I realize a bit off of list topic. But I do have mysql 3.51.18 and higher but for the life of me , I cannot seem to get the DSN config setup so that the odbc connector seems to tell FS that it can do multi statements. Anyone have any insight on how and where to set this flag?

Attachments:

attachment.html (text/html — 4.9 KB)

Show replies by date

Michael Jerris

26 Nov 26 Nov

8:53 p.m.

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) On Nov 26, 2009, at 2:22 PM, Frank @ Impact wrote:

...

“GREAT SCOTT!!! Cannot execute batched statements! If you are using mysql, make sure you are using MYODBC 3.51.18 or higher and enable FLAG_MULTI_STATEMENTS”

I realize a bit off of list topic…

But I do have mysql 3.51.18 and higher but for the life of me , I cannot seem to get the DSN config setup so that the odbc connector seems to tell FS that it can do multi statements.

Anyone have any insight on how and where to set this flag?

_______________________________________________ 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

Tihomir Culjaga

9:48 p.m.

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 <http://bugs.mysql.com/7445>)

so, is this the right patch ? http://bugs.mysql.com/file.php?id=6994 T.

Leon de Rooij

27 Nov 27 Nov

8:36 a.m.

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

Tihomir Culjaga

12:21 p.m.

On Fri, Nov 27, 2009 at 9:36 AM, Leon de Rooij <leon@scarlet-internet.nl>wrote:

...

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

well i was centanly blind when i asked this :P [maxpowersoft_odbc] Driver = MySQL SERVER = localhost PORT = 3306 DATABASE = myDatabase *OPTIONS = 67108864* Socket = /var/lib/mysql/mysql.sock Thanks. T.

Frank ＠ Impact

2:41 p.m.

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: 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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org

Leon de Rooij

3:19 p.m.

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:

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

_______________________________________________ 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

Frank ＠ Impact

3:36 p.m.

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

mayamatakeshi

4 Dec 4 Dec

10:45 p.m.

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

...

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<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:

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@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@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@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@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org

6180

Age (days ago)

6188

Last active (days ago)

List overview

Download

8 comments

5 participants

participants (5)

Frank ＠ Impact
Leon de Rooij
mayamatakeshi
Michael Jerris
Tihomir Culjaga

odbc FLAG_MULTI_STATMENTS

tags

participants (5)