[Freeswitch-users] odbc FLAG_MULTI

Discussion:

[Freeswitch-users] odbc FLAG_MULTI_STATMENTS

Frank @ Impact

2009-11-26 19:22:52 UTC

"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?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091126/118b0a06/attachment.html

Michael Jerris

2009-11-26 20:53:21 UTC

Permalink

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)

?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 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/20091126/ec26c59d/attachment.html

Tihomir Culjaga

2009-11-26 21:48:22 UTC

Permalink

so, is this the right patch ?

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

T.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091126/a512b1d8/attachment.html

Leon de Rooij

2009-11-27 08:36:38 UTC

Permalink

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

Post by Michael Jerris
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 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/20091127/3b2fdda4/attachment.html

Tihomir Culjaga

2009-11-27 12:21:55 UTC

Permalink

Post by Leon de Rooij
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091127/c326afdc/attachment.html

Tihomir Culjaga

2009-11-27 12:21:55 UTC

Permalink

Post by Leon de Rooij
http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core#CentOS_5.2
regards,
Leon

Leon de Rooij

2009-11-27 08:36:38 UTC

Permalink

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091127/3b2fdda4/attachment-0002.html

Tihomir Culjaga

2009-11-26 21:48:22 UTC

Permalink

Frank @ Impact

2009-11-27 14:41:44 UTC

Permalink

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091127/78f2b0c3/attachment-0001.html

Leon de Rooij

2009-11-27 15:19:03 UTC

Permalink

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

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
] 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
http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core#CentOS_5.2
regards,
Leon
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 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/20091127/9c86b324/attachment-0001.html

Leon de Rooij

2009-11-27 15:19:03 UTC

Permalink

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091127/9c86b324/attachment-0002.html

Frank @ Impact

2009-11-27 15:36:55 UTC

Permalink

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091127/1bb30a5f/attachment-0001.html

mayamatakeshi

2009-12-04 22:45:17 UTC

Permalink

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

Post by Frank @ Impact
Yes. I am using version 5.1 I am using Fedora 12.
-----Original Message-----
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
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
http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core#CentOS_5.2
regards,
Leon
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-0001.html

mayamatakeshi

2009-12-04 22:45:17 UTC

Permalink

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091205/0fe3022d/attachment-0002.html

Frank @ Impact

2009-11-26 19:22:52 UTC

Permalink

Michael Jerris

2009-11-26 20:53:21 UTC

Permalink

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091126/ec26c59d/attachment-0002.html

Frank @ Impact

2009-11-27 14:41:44 UTC

Permalink

From /etc/odbcinst.ini

Frank @ Impact

2009-11-27 15:36:55 UTC

Permalink

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20091127/1bb30a5f/attachment-0002.html