Hi, Any recommendations for apps that can I use ontop of freeswitch as a GUI manager, to manage extensions, queues, ivr, and dialplans? Thanks Sam On 27 Nov,2009, at 5:19 PM, freeswitch-users-request@lists.freeswitch.org wrote:
Send FreeSWITCH-users mailing list submissions to freeswitch-users@lists.freeswitch.org
To subscribe or unsubscribe via the World Wide Web, visit http://lists.freeswitch.org/mailman/listinfo/freeswitch-users or, via email, send a message with subject or body 'help' to freeswitch-users-request@lists.freeswitch.org
You can reach the person managing the list at freeswitch-users-owner@lists.freeswitch.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of FreeSWITCH-users digest..."
Today's Topics:
1. Re: odbc FLAG_MULTI_STATMENTS (Leon de Rooij)
----------------------------------------------------------------------
Message: 1 Date: Fri, 27 Nov 2009 16:19:03 +0100 From: Leon de Rooij <leon@scarlet-internet.nl> Subject: Re: [Freeswitch-users] odbc FLAG_MULTI_STATMENTS To: freeswitch-users@lists.freeswitch.org Message-ID: <A8D9107A-F8C9-4705-9CF5-B72FE908358F@scarlet-internet.nl> Content-Type: text/plain; charset="windows-1252"
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