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
Hi I am no sure but read up on fusionpbx. I asked the same question and someone pointed me to that. check web site <http://fusionpbx.com> Regards Samuel Mukoti wrote:
<div class="moz-text-flowed" style="font-family: -moz-fixed">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
_______________________________________________ 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
FusionPBX, FreePBX v3, and wikiPBX are the three that I have found in the past. However they all seem to be in the early stages of development, and not 100% stable. I can say this for sure about FreePBX and FusionPBX, but I have not actually tried wikiPBX. -AF -----Original Message----- From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Otis Sent: Friday, November 27, 2009 11:49 AM To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Freeswitch admin GUI Hi I am no sure but read up on fusionpbx. I asked the same question and someone pointed me to that. check web site <http://fusionpbx.com> Regards Samuel Mukoti wrote:
<div class="moz-text-flowed" style="font-family: -moz-fixed">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
_______________________________________________ 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
Well now might be a good time to give wikipbx a spin, because about 15 minutes ago we just released the second major release .. version 0.8 Here are the official release notes: --- WikiPBX has been converted from being based on Twisted.web2, a somewhat exotic webserver, to running as a mod_wsgi app within Apache2. Actually it can run under any webserver that support mod_wsgi. Additionally, the multi-tenancy has been changed from sip profile based multi-tenancy, which is not really "the normal way" to do this .. to the standard approach of domain based multi-tenancy. Along with that comes the ability to manage sip profiles from the GUI. A lot of security enhancements have been added, it is possible to force sip profile wide authorization, as well as per-extension dialplan security -- checking a flag in the dialplan will make it public (for anyone to access) or private (only registered users). The dialplan security is overlayed on top of the sip profile security .. and sip profile security takes precedence. (sip profile security is done by freeswitch whereas per-extension dialplan security is done by wikipbx) Gateways can now be per-tenant or shared among all tenants, and can be assigned to any sip profile on the system. Mod_voicemail now works with wikipbx, and is easy to configure. No GUI support yet in terms of visual voicemail. A really simple XML export / import has been added for existing users using version 0.5 to upgrade to version 0.8. Documentation has been completely re-written to reflect all changes in this release. What's still missing? The configuration XML that is served up to FreeSWITCH is really, really old. The only upshot is that they are served from static template files, so you can hack stuff in without having to look at any code. We are planning to fix this by the 1.0 release, slated for November of 2018. See http://wikipbx.subwiki.com/release-notes-0-8 for more details on this release and how to install it. On Fri, Nov 27, 2009 at 5:10 PM, Adam Ford <lists@redbonez.net> wrote:
FusionPBX, FreePBX v3, and wikiPBX are the three that I have found in the past. However they all seem to be in the early stages of development, and not 100% stable. I can say this for sure about FreePBX and FusionPBX, but I have not actually tried wikiPBX.
-AF
-----Original Message----- From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Otis Sent: Friday, November 27, 2009 11:49 AM To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Freeswitch admin GUI
Hi
I am no sure but read up on fusionpbx. I asked the same question and someone pointed me to that. check web site <http://fusionpbx.com>
Regards
Samuel Mukoti wrote:
<div class="moz-text-flowed" style="font-family: -moz-fixed">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
_______________________________________________ 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
On Sat, Nov 28, 2009 at 8:20 AM, Traun Leyden <tleyden@branchcut.com> wrote:
Well now might be a good time to give wikipbx a spin, because about 15 minutes ago we just released the second major release .. version 0.8
Here are the official release notes:
---
WikiPBX has been converted from being based on Twisted.web2, a somewhat exotic webserver, to running as a mod_wsgi app within Apache2. Actually it can run under any webserver that support mod_wsgi.
Additionally, the multi-tenancy has been changed from sip profile based multi-tenancy, which is not really "the normal way" to do this .. to the standard approach of domain based multi-tenancy. Along with that comes the ability to manage sip profiles from the GUI.
A lot of security enhancements have been added, it is possible to force sip profile wide authorization, as well as per-extension dialplan security -- checking a flag in the dialplan will make it public (for anyone to access) or private (only registered users). The dialplan security is overlayed on top of the sip profile security .. and sip profile security takes precedence. (sip profile security is done by freeswitch whereas per-extension dialplan security is done by wikipbx)
Gateways can now be per-tenant or shared among all tenants, and can be assigned to any sip profile on the system.
Mod_voicemail now works with wikipbx, and is easy to configure. No GUI support yet in terms of visual voicemail.
A really simple XML export / import has been added for existing users using version 0.5 to upgrade to version 0.8.
Documentation has been completely re-written to reflect all changes in this release.
What's still missing? The configuration XML that is served up to FreeSWITCH is really, really old. The only upshot is that they are served from static template files, so you can hack stuff in without having to look at any code. We are planning to fix this by the 1.0 release, slated for November of 2018.
See http://wikipbx.subwiki.com/release-notes-0-8 for more details on this release and how to install it.
Hi does wikipbx have any IRC channel Ram
On 28. nov. 2009, at 03.50, Traun Leyden wrote:
What's still missing? The configuration XML that is served up to FreeSWITCH is really, really old. The only upshot is that they are served from static template files, so you can hack stuff in without having to look at any code. We are planning to fix this by the 1.0 release, slated for November of 2018.
Oh boy, I really DO hope FreeSWITCH will still be alive and well in 2018!! Best regards, Even André
FusionPBX is very close to a release. FusionPBX is on the last release candidate 5 before a 1.0 release. Most of the work in the past couple weeks has been to make the install easier. ISO versions will be available in the future. I have multiple businesses already running live on FusionPBX. The project will advance faster the more it is used and the more feedback that is given. Mark J Crane http://www.fusionpbx.com --- On Fri, 11/27/09, Adam Ford <lists@redbonez.net> wrote: From: Adam Ford <lists@redbonez.net> Subject: Re: [Freeswitch-users] Freeswitch admin GUI To: freeswitch-users@lists.freeswitch.org Date: Friday, November 27, 2009, 6:10 PM FusionPBX, FreePBX v3, and wikiPBX are the three that I have found in the past. However they all seem to be in the early stages of development, and not 100% stable. I can say this for sure about FreePBX and FusionPBX, but I have not actually tried wikiPBX. -AF -----Original Message----- From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Otis Sent: Friday, November 27, 2009 11:49 AM To: freeswitch-users@lists.freeswitch.org Subject: Re: [Freeswitch-users] Freeswitch admin GUI Hi I am no sure but read up on fusionpbx. I asked the same question and someone pointed me to that. check web site <http://fusionpbx.com> Regards Samuel Mukoti wrote:
<div class="moz-text-flowed" style="font-family: -moz-fixed">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
_______________________________________________ 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
participants (7)
-
Adam Ford
-
Even André Fiskvik
-
Mark Crane
-
Otis
-
ram
-
Samuel Mukoti
-
Traun Leyden