Changes to how ODBC, SQL, etc works
Hey Guys, There¹s some new Database Goodness in the core of FreeSWITCH that can lead to some unexpected things for you guys updating existing installations using ODBC. We now have Native PostgreSQL support in the core, and along with this comes some changes to the various ³odbc-dsn² settings around the tree. If you are using the format ³dsn:username:password² you wont be affected, however if you are just specifying a DSN as ³dsn² you will need to listen up The settings for this field have changed. pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE for postgresql (the stuff after pgsql:// is a standard libpq connect string for you programmer types) odbc://dns:username:password for ODBC ( dsn:: should also work or dns:username: ) sqlite://filename for sqlite different SQLite Databases I think we still need to doc this up good, but its there and its coming strong... -- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch
WOW this is awesome news Thx On Nov 2, 2012 3:02 PM, "Ken Rice" <krice@freeswitch.org> wrote:
Hey Guys,
There’s some new Database Goodness in the core of FreeSWITCH that can lead to some unexpected things for you guys updating existing installations using ODBC.
We now have Native PostgreSQL support in the core, and along with this comes some changes to the various “odbc-dsn” settings around the tree.
If you are using the format “dsn:username:password” you wont be affected, however if you are just specifying a DSN as “dsn” you will need to listen up
The settings for this field have changed.
pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE for postgresql (the stuff after pgsql:// is a standard libpq connect string for you programmer types) odbc://dns:username:password for ODBC ( dsn:: should also work or dns:username: ) sqlite://filename for sqlite different SQLite Databases
I think we still need to doc this up good, but its there and its coming strong...
-- Ken *http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org *irc.freenode.net #freeswitch
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
+1 for this adding db for core FreeSWITCH would be a good news for us as well On Fri, Nov 2, 2012 at 12:05 PM, David J <david@styleflare.com> wrote:
WOW this is awesome news
Thx On Nov 2, 2012 3:02 PM, "Ken Rice" <krice@freeswitch.org> wrote:
Hey Guys,
There’s some new Database Goodness in the core of FreeSWITCH that can lead to some unexpected things for you guys updating existing installations using ODBC.
We now have Native PostgreSQL support in the core, and along with this comes some changes to the various “odbc-dsn” settings around the tree.
If you are using the format “dsn:username:password” you wont be affected, however if you are just specifying a DSN as “dsn” you will need to listen up
The settings for this field have changed.
pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE for postgresql (the stuff after pgsql:// is a standard libpq connect string for you programmer types) odbc://dns:username:password for ODBC ( dsn:: should also work or dns:username: ) sqlite://filename for sqlite different SQLite Databases
I think we still need to doc this up good, but its there and its coming strong...
-- Ken *http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org *irc.freenode.net #freeswitch
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
What Jerris said.... On 11/2/12 5:08 PM, "Michael Jerris" <mike@jerris.com> wrote:
No.
On Nov 2, 2012, at 4:54 PM, Vik Killa <vipkilla@gmail.com> wrote:
Can we do the same for MySQL? :)
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch
+1000000 to this On Fri, Nov 2, 2012 at 1:54 PM, Vik Killa <vipkilla@gmail.com> wrote:
Can we do the same for MySQL? :)
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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 Ken, Excellent news for Postgres and FreeSWITCH. I'll ask this as I am sure there are a lot of people wondering, are there plans to support MySQL natively as well? A. On 03/11/2012, at 4:25 AM, Ken Rice wrote:
Hey Guys,
There’s some new Database Goodness in the core of FreeSWITCH that can lead to some unexpected things for you guys updating existing installations using ODBC.
We now have Native PostgreSQL support in the core, and along with this comes some changes to the various “odbc-dsn” settings around the tree.
If you are using the format “dsn:username:password” you wont be affected, however if you are just specifying a DSN as “dsn” you will need to listen up
The settings for this field have changed.
pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE for postgresql (the stuff after pgsql:// is a standard libpq connect string for you programmer types) odbc://dns:username:password for ODBC ( dsn:: should also work or dns:username: ) sqlite://filename for sqlite different SQLite Databases
I think we still need to doc this up good, but its there and its coming strong...
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
+1 for mysql support On Sat, Nov 3, 2012 at 3:06 AM, Ashley Breeden <ash@url.net.au> wrote:
Hi Ken,
Excellent news for Postgres and FreeSWITCH.
I'll ask this as I am sure there are a lot of people wondering, are there plans to support MySQL natively as well?
A.
On 03/11/2012, at 4:25 AM, Ken Rice wrote:
Hey Guys,
There’s some new Database Goodness in the core of FreeSWITCH that can lead to some unexpected things for you guys updating existing installations using ODBC.
We now have Native PostgreSQL support in the core, and along with this comes some changes to the various “odbc-dsn” settings around the tree.
If you are using the format “dsn:username:password” you wont be affected, however if you are just specifying a DSN as “dsn” you will need to listen up
The settings for this field have changed.
pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE for postgresql (the stuff after pgsql:// is a standard libpq connect string for you programmer types) odbc://dns:username:password for ODBC ( dsn:: should also work or dns:username: ) sqlite://filename for sqlite different SQLite Databases
I think we still need to doc this up good, but its there and its coming strong...
-- Ken *http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org *irc.freenode.net #freeswitch _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Regards, Abdul Basit | P: +92 32 1416 4196 | O: +92 30 0841 1445 | UK: +447937421194
Quite impossible. The reason is because of the license that the MySQL libs are licensed under. iirc, they are GPL licensed and they are not compatible with the MPL that FreeSWITCH uses. On Fri, Nov 2, 2012 at 6:56 PM, Abdul Basit <basit.engg@gmail.com> wrote:
+1 for mysql support
On Sat, Nov 3, 2012 at 3:06 AM, Ashley Breeden <ash@url.net.au> wrote:
Hi Ken,
Excellent news for Postgres and FreeSWITCH.
I'll ask this as I am sure there are a lot of people wondering, are there plans to support MySQL natively as well?
A.
On 03/11/2012, at 4:25 AM, Ken Rice wrote:
Hey Guys,
There’s some new Database Goodness in the core of FreeSWITCH that can lead to some unexpected things for you guys updating existing installations using ODBC.
We now have Native PostgreSQL support in the core, and along with this comes some changes to the various “odbc-dsn” settings around the tree.
If you are using the format “dsn:username:password” you wont be affected, however if you are just specifying a DSN as “dsn” you will need to listen up
The settings for this field have changed.
pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE for postgresql (the stuff after pgsql:// is a standard libpq connect string for you programmer types) odbc://dns:username:password for ODBC ( dsn:: should also work or dns:username: ) sqlite://filename for sqlite different SQLite Databases
I think we still need to doc this up good, but its there and its coming strong...
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Regards,
Abdul Basit | P: +92 32 1416 4196 | O: +92 30 0841 1445 | UK: +447937421194
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004 <curriegrad2004@gmail.com> wrote:
Quite impossible. The reason is because of the license that the MySQL libs are licensed under. iirc, they are GPL licensed and they are not compatible with the MPL that FreeSWITCH uses.
I've got PostgreSQL, so I've got all I need :) But, it seems like this legal issue is easily resolved: http://www.mysql.com/about/legal/licensing/foss-exception/ Anyway, I'm not a lawyer or even a very thorough reader ;) Best, Gabe
While this may solve the issue... This does not address a number of other issues A) 90+% of the primary FreeSWITCH developers use PostgreSQL primarily... B) There is that whole threadsafe vs non-threadsafe mysql client lib issue, so we would have to come up with a way in the build system to detect which we have, and never use the non-thread safe one... (if we don't do this, the code would never be stable as we could never know for sure which one actually got detected and linked against) On 11/3/12 1:40 AM, "Gabriel Gunderson" <gabe@gundy.org> wrote:
On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004 <curriegrad2004@gmail.com> wrote:
Quite impossible. The reason is because of the license that the MySQL libs are licensed under. iirc, they are GPL licensed and they are not compatible with the MPL that FreeSWITCH uses.
I've got PostgreSQL, so I've got all I need :) But, it seems like this legal issue is easily resolved:
http://www.mysql.com/about/legal/licensing/foss-exception/
Anyway, I'm not a lawyer or even a very thorough reader ;)
Best, Gabe
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch
Plus as a friend of mine used to say: "It's not MY sql its YOUR sql!" It is a fact that we have an incredible amount of bugs come up that end up being mysql+odbc memory errors and thread safety issues. I would be concerned with more blame falling on us of we had the code deeper into our core. I would not condone adding any more db support unless we we architected it to use db modules so we could still properly blame it on mysql when it was not working. On Sat, Nov 3, 2012 at 12:32 PM, Ken Rice <krice@freeswitch.org> wrote:
While this may solve the issue... This does not address a number of other issues
A) 90+% of the primary FreeSWITCH developers use PostgreSQL primarily...
B) There is that whole threadsafe vs non-threadsafe mysql client lib issue, so we would have to come up with a way in the build system to detect which we have, and never use the non-thread safe one... (if we don't do this, the code would never be stable as we could never know for sure which one actually got detected and linked against)
On 11/3/12 1:40 AM, "Gabriel Gunderson" <gabe@gundy.org> wrote:
On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004 <curriegrad2004@gmail.com> wrote:
Quite impossible. The reason is because of the license that the MySQL libs are licensed under. iirc, they are GPL licensed and they are not compatible with the MPL that FreeSWITCH uses.
I've got PostgreSQL, so I've got all I need :) But, it seems like this legal issue is easily resolved:
http://www.mysql.com/about/legal/licensing/foss-exception/
Anyway, I'm not a lawyer or even a very thorough reader ;)
Best, Gabe
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
On Sat, 3 Nov 2012 13:36:29 -0500 Anthony Minessale <anthony.minessale@gmail.com> wrote:
I would not condone adding any more db support unless we we architected it to use db modules so we could still properly blame it on mysql when it was not working.
Support access, it's even easier to blame :) -- Peter : nonsense! look by the window, kids riding bikes outside... tom : they don't have a computer or what?
ODBC's there for this reason. Why invent more wheels when we already have that wheel sitting around? On Sat, Nov 3, 2012 at 11:36 AM, Anthony Minessale <anthony.minessale@gmail.com> wrote:
Plus as a friend of mine used to say: "It's not MY sql its YOUR sql!"
It is a fact that we have an incredible amount of bugs come up that end up being mysql+odbc memory errors and thread safety issues. I would be concerned with more blame falling on us of we had the code deeper into our core.
I would not condone adding any more db support unless we we architected it to use db modules so we could still properly blame it on mysql when it was not working.
On Sat, Nov 3, 2012 at 12:32 PM, Ken Rice <krice@freeswitch.org> wrote:
While this may solve the issue... This does not address a number of other issues
A) 90+% of the primary FreeSWITCH developers use PostgreSQL primarily...
B) There is that whole threadsafe vs non-threadsafe mysql client lib issue, so we would have to come up with a way in the build system to detect which we have, and never use the non-thread safe one... (if we don't do this, the code would never be stable as we could never know for sure which one actually got detected and linked against)
On 11/3/12 1:40 AM, "Gabriel Gunderson" <gabe@gundy.org> wrote:
On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004 <curriegrad2004@gmail.com> wrote:
Quite impossible. The reason is because of the license that the MySQL libs are licensed under. iirc, they are GPL licensed and they are not compatible with the MPL that FreeSWITCH uses.
I've got PostgreSQL, so I've got all I need :) But, it seems like this legal issue is easily resolved:
http://www.mysql.com/about/legal/licensing/foss-exception/
Anyway, I'm not a lawyer or even a very thorough reader ;)
Best, Gabe
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
It is just about how fast is ODBC compare to native mysql http://www.devtoolshed.com/content/performance-benchmarks-odbc-vs-oracle-mys... Also for what ken wrote we used the non thread safe version and protected the call to the database with mutex On Sat, Nov 3, 2012 at 1:25 PM, curriegrad2004 <curriegrad2004@gmail.com>wrote:
ODBC's there for this reason. Why invent more wheels when we already have that wheel sitting around?
On Sat, Nov 3, 2012 at 11:36 AM, Anthony Minessale <anthony.minessale@gmail.com> wrote:
Plus as a friend of mine used to say: "It's not MY sql its YOUR sql!"
It is a fact that we have an incredible amount of bugs come up that end up being mysql+odbc memory errors and thread safety issues. I would be concerned with more blame falling on us of we had the code deeper into our core.
I would not condone adding any more db support unless we we architected it to use db modules so we could still properly blame it on mysql when it was not working.
On Sat, Nov 3, 2012 at 12:32 PM, Ken Rice <krice@freeswitch.org> wrote:
While this may solve the issue... This does not address a number of
other
issues
A) 90+% of the primary FreeSWITCH developers use PostgreSQL primarily...
B) There is that whole threadsafe vs non-threadsafe mysql client lib issue, so we would have to come up with a way in the build system to detect which we have, and never use the non-thread safe one... (if we don't do this, the code would never be stable as we could never know for sure which one actually got detected and linked against)
On 11/3/12 1:40 AM, "Gabriel Gunderson" <gabe@gundy.org> wrote:
On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004 <curriegrad2004@gmail.com> wrote:
Quite impossible. The reason is because of the license that the MySQL libs are licensed under. iirc, they are GPL licensed and they are not compatible with the MPL that FreeSWITCH uses.
I've got PostgreSQL, so I've got all I need :) But, it seems like this legal issue is easily resolved:
http://www.mysql.com/about/legal/licensing/foss-exception/
Anyway, I'm not a lawyer or even a very thorough reader ;)
Best, Gabe
Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch
Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
Oh yeah, lets let 1 thread run at a time access the database... Mysql is the only one that shows this issue... So why should we cripple the DB interfaces for just mysql On 11/3/12 10:59 PM, "Yiftach Golan" <yiftah@choochee.com> wrote:
Also for what ken wrote we used the non thread safe version and protected the call to the database with mutex
On Sat, Nov 3, 2012 at 1:25 PM, curriegrad2004 <curriegrad2004@gmail.com> wrote:
ODBC's there for this reason. Why invent more wheels when we already have that wheel sitting around?
On Sat, Nov 3, 2012 at 11:36 AM, Anthony Minessale <anthony.minessale@gmail.com> wrote:
Plus as a friend of mine used to say: "It's not MY sql its YOUR sql!"
It is a fact that we have an incredible amount of bugs come up that end up being mysql+odbc memory errors and thread safety issues. I would be concerned with more blame falling on us of we had the code deeper into our core.
I would not condone adding any more db support unless we we architected it to use db modules so we could still properly blame it on mysql when it was not working.
On Sat, Nov 3, 2012 at 12:32 PM, Ken Rice <krice@freeswitch.org> wrote:
While this may solve the issue... This does not address a number of
other
issues
A) 90+% of the primary FreeSWITCH developers use PostgreSQL primarily...
B) There is that whole threadsafe vs non-threadsafe mysql client lib issue, so we would have to come up with a way in the build system to detect which we have, and never use the non-thread safe one... (if we don't do this, the code would never be stable as we could never know for sure which one actually got detected and linked against)
On 11/3/12 1:40 AM, "Gabriel Gunderson" <gabe@gundy.org> wrote:
> > On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004 > > <curriegrad2004@gmail.com> wrote: >> >> Quite impossible. The reason is because of the license that the MySQL >> >> libs are licensed under. iirc, they are GPL licensed and they are not >> >> compatible with the MPL that FreeSWITCH uses. > > > > I've got PostgreSQL, so I've got all I need :) But, it seems like this > > legal issue is easily resolved: > > > > http://www.mysql.com/about/legal/licensing/foss-exception/ > > > > Anyway, I'm not a lawyer or even a very thorough reader ;) > > > > > > Best, > > Gabe > > > > > >
> > Professional FreeSWITCH Consulting Services: > > consulting@freeswitch.org > > http://www.freeswitchsolutions.com > > > > FreeSWITCH-powered IP PBX: The CudaTel Communication Server > > http://www.cudatel.com > > > > Official FreeSWITCH Sites > > http://www.freeswitch.org > > http://wiki.freeswitch.org > > http://www.cluecon.com > > > > 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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net <http://irc.freenode.net> #freeswitch
Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com <mailto:MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com <mailto:PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net <http://irc.freenode.net> #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <mailto:sip%3A888@conference.freeswitch.org> googletalk:conf+888@conference.freeswitch.org <mailto:googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900 <tel:%2B19193869900>
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch
I do not know Postgres (and maybe it is a good chance to try it) but probably there is a penalty with Postgres as well It is just that OpenSIPs goes very well with FreeSWITCH (at least for us) and OpenSIPs use mysql as its primary db Therefore using one DB for both makes a lot of sense for us BTW, I did not get an answer for posting the Germany number that we added for the conference, do you want it or should I return it to our poll? Thanks, Yiftach. On Sun, Nov 4, 2012 at 7:07 AM, Ken Rice <krice@freeswitch.org> wrote:
Oh yeah, lets let 1 thread run at a time access the database... Mysql is the only one that shows this issue... So why should we cripple the DB interfaces for just mysql
On 11/3/12 10:59 PM, "Yiftach Golan" <yiftah@choochee.com> wrote:
Also for what ken wrote we used the non thread safe version and protected the call to the database with mutex
On Sat, Nov 3, 2012 at 1:25 PM, curriegrad2004 <curriegrad2004@gmail.com> wrote:
ODBC's there for this reason. Why invent more wheels when we already have that wheel sitting around?
On Sat, Nov 3, 2012 at 11:36 AM, Anthony Minessale <anthony.minessale@gmail.com> wrote:
Plus as a friend of mine used to say: "It's not MY sql its YOUR sql!"
It is a fact that we have an incredible amount of bugs come up that end up being mysql+odbc memory errors and thread safety issues. I would be concerned with more blame falling on us of we had the code deeper into our core.
I would not condone adding any more db support unless we we architected it to use db modules so we could still properly blame it on mysql when it was not working.
On Sat, Nov 3, 2012 at 12:32 PM, Ken Rice <krice@freeswitch.org> wrote:
While this may solve the issue... This does not address a number of
other
issues
A) 90+% of the primary FreeSWITCH developers use PostgreSQL primarily...
B) There is that whole threadsafe vs non-threadsafe mysql client lib issue, so we would have to come up with a way in the build system to detect which we have, and never use the non-thread safe one... (if we don't do this, the code would never be stable as we could never know for sure which one actually got detected and linked against)
On 11/3/12 1:40 AM, "Gabriel Gunderson" <gabe@gundy.org> wrote:
On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004 <curriegrad2004@gmail.com> wrote:
Quite impossible. The reason is because of the license that the MySQL libs are licensed under. iirc, they are GPL licensed and they are not compatible with the MPL that FreeSWITCH uses.
I've got PostgreSQL, so I've got all I need :) But, it seems like this legal issue is easily resolved:
http://www.mysql.com/about/legal/licensing/foss-exception/
Anyway, I'm not a lawyer or even a very thorough reader ;)
Best, Gabe
Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net <http://irc.freenode.net> #freeswitch
Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com < mailto:MSN%3Aanthony_minessale@hotmail.com<MSN%3Aanthony_minessale@hotmail.com>>
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com < mailto:PAYPAL%3Aanthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com>>
IRC: irc.freenode.net <http://irc.freenode.net> #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org < mailto:sip%3A888@conference.freeswitch.org<sip%3A888@conference.freeswitch.org>>
googletalk:conf+888@conference.freeswitch.org < mailto:googletalk%3Aconf%2B888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org>>
pstn:+19193869900 <tel:%2B19193869900>
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
------------------------------ _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Ken *http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org *irc.freenode.net #freeswitch
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
You are more then welcome to keep the number pointed to the Conference server... Don¹t expect a lot of action on things like that during the weekend... Most of us that work for the project do so full time and do take time for the family... As far as OpenSIPs, they support PostgreSQL via the db_postgres engine... On 11/4/12 9:37 PM, "Yiftach Golan" <yiftah@choochee.com> wrote:
I do not know Postgres (and maybe it is a good chance to try it) but probably there is a penalty with Postgres as well It is just that OpenSIPs goes very well with FreeSWITCH (at least for us) and OpenSIPs use mysql as its primary db Therefore using one DB for both makes a lot of sense for us BTW, I did not get an answer for posting the Germany number that we added for the conference, do you want it or should I return it to our poll?
Thanks, Yiftach.
On Sun, Nov 4, 2012 at 7:07 AM, Ken Rice <krice@freeswitch.org> wrote:
Oh yeah, lets let 1 thread run at a time access the database... Mysql is the only one that shows this issue... So why should we cripple the DB interfaces for just mysql
On 11/3/12 10:59 PM, "Yiftach Golan" <yiftah@choochee.com <http://yiftah@choochee.com> > wrote:
Also for what ken wrote we used the non thread safe version and protected the call to the database with mutex
On Sat, Nov 3, 2012 at 1:25 PM, curriegrad2004 <curriegrad2004@gmail.com <http://curriegrad2004@gmail.com> > wrote:
ODBC's there for this reason. Why invent more wheels when we already have that wheel sitting around?
On Sat, Nov 3, 2012 at 11:36 AM, Anthony Minessale <anthony.minessale@gmail.com <http://anthony.minessale@gmail.com> > wrote:
Plus as a friend of mine used to say: "It's not MY sql its YOUR sql!"
It is a fact that we have an incredible amount of bugs come up that end up being mysql+odbc memory errors and thread safety issues. I would be concerned with more blame falling on us of we had the code deeper into our core.
I would not condone adding any more db support unless we we architected it to use db modules so we could still properly blame it on mysql when it was not working.
On Sat, Nov 3, 2012 at 12:32 PM, Ken Rice <krice@freeswitch.org <http://krice@freeswitch.org> > wrote: >> >> While this may solve the issue... This does not address a number of other >> issues >> >> A) 90+% of the primary FreeSWITCH developers use PostgreSQL primarily... >> >> B) There is that whole threadsafe vs non-threadsafe mysql client lib >> issue, >> so we would have to come up with a way in the build system to detect which >> we have, and never use the non-thread safe one... (if we don't do this, >> the >> code would never be stable as we could never know for sure which one >> actually got detected and linked against) >> >> >> >> >> >> On 11/3/12 1:40 AM, "Gabriel Gunderson" <gabe@gundy.org <http://gabe@gundy.org> > wrote: >> > >> > On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004 > >> > <curriegrad2004@gmail.com <http://curriegrad2004@gmail.com> > > wrote: >> >> >> Quite impossible. The reason is because of the license that the MySQL >> >> >> libs are licensed under. iirc, they are GPL licensed and they are not >> >> >> compatible with the MPL that FreeSWITCH uses. > >> > > >> > I've got PostgreSQL, so I've got all I need :) But, it seems like this > >> > legal issue is easily resolved: > >> > > >> > http://www.mysql.com/about/legal/licensing/foss-exception/ > >> > > >> > Anyway, I'm not a lawyer or even a very thorough reader ;) > >> > > >> > > >> > Best, > >> > Gabe > >> > > >> > > >> > >
> >> > Professional FreeSWITCH Consulting Services: > >> > consulting@freeswitch.org <http://consulting@freeswitch.org> > >> > http://www.freeswitchsolutions.com > >> > > >> > FreeSWITCH-powered IP PBX: The CudaTel Communication Server > >> > http://www.cudatel.com > >> > > >> > Official FreeSWITCH Sites > >> > http://www.freeswitch.org > >> > http://wiki.freeswitch.org > >> > http://www.cluecon.com > >> > > >> > FreeSWITCH-users mailing list > >> > FreeSWITCH-users@lists.freeswitch.org > <http://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 >> >> -- >> Ken >> http://www.FreeSWITCH.org >> http://www.ClueCon.com >> http://www.OSTAG.org >> irc.freenode.net <http://irc.freenode.net> <http://irc.freenode.net> #freeswitch >> >> >> >> _________________________________________________________________________ >> Professional FreeSWITCH Consulting Services: >> consulting@freeswitch.org <http://consulting@freeswitch.org> >> http://www.freeswitchsolutions.com >> >> FreeSWITCH-powered IP PBX: The CudaTel Communication Server >> http://www.cudatel.com >> >> Official FreeSWITCH Sites >> http://www.freeswitch.org >> http://wiki.freeswitch.org >> http://www.cluecon.com >> >> FreeSWITCH-users mailing list >> FreeSWITCH-users@lists.freeswitch.org <http://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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com <http://anthony_minessale@hotmail.com> <mailto:MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com <http://anthony.minessale@gmail.com> <mailto:PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net <http://irc.freenode.net> <http://irc.freenode.net> #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <http://888@conference.freeswitch.org> <mailto:sip%3A888@conference.freeswitch.org> googletalk:conf+888@conference.freeswitch.org <http://conf+888@conference.freeswitch.org> <mailto:googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:+19193869900 <tel:%2B19193869900> <tel:%2B19193869900>
_________________________________________________________________________
Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <http://consulting@freeswitch.org> http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <http://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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <http://consulting@freeswitch.org> http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <http://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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <http://consulting@freeswitch.org> http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org <http://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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch
OK thanks On Sun, Nov 4, 2012 at 6:21 PM, Ken Rice <krice@freeswitch.org> wrote:
You are more then welcome to keep the number pointed to the Conference server... Don’t expect a lot of action on things like that during the weekend... Most of us that work for the project do so full time and do take time for the family...
As far as OpenSIPs, they support PostgreSQL via the db_postgres engine...
On 11/4/12 9:37 PM, "Yiftach Golan" <yiftah@choochee.com> wrote:
I do not know Postgres (and maybe it is a good chance to try it) but probably there is a penalty with Postgres as well It is just that OpenSIPs goes very well with FreeSWITCH (at least for us) and OpenSIPs use mysql as its primary db Therefore using one DB for both makes a lot of sense for us BTW, I did not get an answer for posting the Germany number that we added for the conference, do you want it or should I return it to our poll?
Thanks, Yiftach.
On Sun, Nov 4, 2012 at 7:07 AM, Ken Rice <krice@freeswitch.org> wrote:
Oh yeah, lets let 1 thread run at a time access the database... Mysql is the only one that shows this issue... So why should we cripple the DB interfaces for just mysql
On 11/3/12 10:59 PM, "Yiftach Golan" <yiftah@choochee.com < http://yiftah@choochee.com> > wrote:
Also for what ken wrote we used the non thread safe version and protected the call to the database with mutex
On Sat, Nov 3, 2012 at 1:25 PM, curriegrad2004 <curriegrad2004@gmail.com < http://curriegrad2004@gmail.com> > wrote:
ODBC's there for this reason. Why invent more wheels when we already have that wheel sitting around?
On Sat, Nov 3, 2012 at 11:36 AM, Anthony Minessale <anthony.minessale@gmail.com <http://anthony.minessale@gmail.com> > wrote:
Plus as a friend of mine used to say: "It's not MY sql its YOUR sql!"
It is a fact that we have an incredible amount of bugs come up that end up being mysql+odbc memory errors and thread safety issues. I would be concerned with more blame falling on us of we had the code deeper into our core.
I would not condone adding any more db support unless we we architected it to use db modules so we could still properly blame it on mysql when it was not working.
On Sat, Nov 3, 2012 at 12:32 PM, Ken Rice <krice@freeswitch.org < http://krice@freeswitch.org> > wrote:
While this may solve the issue... This does not address a number of
other
issues
A) 90+% of the primary FreeSWITCH developers use PostgreSQL primarily...
B) There is that whole threadsafe vs non-threadsafe mysql client lib issue, so we would have to come up with a way in the build system to detect which we have, and never use the non-thread safe one... (if we don't do this, the code would never be stable as we could never know for sure which one actually got detected and linked against)
On 11/3/12 1:40 AM, "Gabriel Gunderson" <gabe@gundy.org < http://gabe@gundy.org> > wrote:
On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004 <curriegrad2004@gmail.com <http://curriegrad2004@gmail.com> > wrote:
Quite impossible. The reason is because of the license that the MySQL libs are licensed under. iirc, they are GPL licensed and they are not compatible with the MPL that FreeSWITCH uses.
I've got PostgreSQL, so I've got all I need :) But, it seems like this legal issue is easily resolved:
http://www.mysql.com/about/legal/licensing/foss-exception/
Anyway, I'm not a lawyer or even a very thorough reader ;)
Best, Gabe
Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <http://consulting@freeswitch.org> http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org < http://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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net <http://irc.freenode.net> <http://irc.freenode.net> #freeswitch
Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <http://consulting@freeswitch.org> http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org < http://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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire
AIM: anthm MSN:anthony_minessale@hotmail.com <http://anthony_minessale@hotmail.com> <mailto:MSN%3Aanthony_minessale@hotmail.com<MSN%3Aanthony_minessale@hotmail.com>>
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com < http://anthony.minessale@gmail.com> < mailto:PAYPAL%3Aanthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com>>
IRC: irc.freenode.net <http://irc.freenode.net> < http://irc.freenode.net> #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <http://888@conference.freeswitch.org> <mailto:sip%3A888@conference.freeswitch.org<sip%3A888@conference.freeswitch.org>>
googletalk:conf+888@conference.freeswitch.org < http://conf+888@conference.freeswitch.org> < mailto:googletalk%3Aconf%2B888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org>>
pstn:+19193869900 <tel:%2B19193869900> <tel:%2B19193869900>
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <http://consulting@freeswitch.org> http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org < http://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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <http://consulting@freeswitch.org> http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org < http://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
------------------------------ _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org <http://consulting@freeswitch.org> http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org < http://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
-- Ken *http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org *irc.freenode.net #freeswitch
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
As I already said. I would not add any new db interface unless we re-factored it into pluggable modules. I am not planning on working on this so this any time soon so this is really a m00t discussion. I would prefer to focus attention on things we actually have the time and energy for that are on our roadmap. On Mon, Nov 5, 2012 at 12:39 AM, Gabriel Gunderson <gabe@gundy.org> wrote:
On Sun, Nov 4, 2012 at 7:37 PM, Yiftach Golan <yiftah@choochee.com> wrote:
OpenSIPs goes very well with FreeSWITCH (at least for us) and OpenSIPs use mysql as its primary db
OpenSIPS works great with PostgreSQL.
Gabe
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
Is there a public roadmap somewhere -- for your coding, and for the project as a whole (e.g. packaging, docs, books, etc) and who is doing each one? -Avi
That¹s something I thing we need to work on... On 11/5/12 10:25 AM, "Avi Marcus" <avi@avimarcus.net> wrote:
Is there a public roadmap somewhere -- for your coding, and for the project as a whole (e.g. packaging, docs, books, etc) and who is doing each one?
-Avi
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch
No but I can start one .... ROADMAP 1) Get someone to make a roadmap and organize it for us. On Mon, Nov 5, 2012 at 9:25 AM, Avi Marcus <avi@avimarcus.net> wrote:
Is there a public roadmap somewhere -- for your coding, and for the project as a whole (e.g. packaging, docs, books, etc) and who is doing each one?
-Avi
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ Twitter: http://twitter.com/FreeSWITCH_wire AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org googletalk:conf+888@conference.freeswitch.org pstn:+19193869900
On Mon, 5 Nov 2012 11:42:56 -0600 Anthony Minessale <anthony.minessale@gmail.com> wrote:
ROADMAP
1) Get someone to make a roadmap and organize it for us.
http://jira.freeswitch.org/browse/FS#selectedTab=com.atlassian.jira.plugin.s... That's 1a. Now 1b is to organize it. -- D'Arcy J.M. Cain System Administrator, Vex.Net http://www.Vex.Net/ IM:darcy@Vex.Net
Do you want jira access to assist in this job? -- Brian West brian@freeswitch.org FreeSWITCH Solutions, LLC PO BOX PO BOX 2531 Brookfield, WI 53008-2531 Twitter: @FreeSWITCH_Wire T: +1.918.420.9266 | F: +1.918.420.9267 | M: +1.918.424.WEST iNUM: +883 5100 1420 9266 UK: +44 20 3298 4900 ISN: 410*543 On Nov 5, 2012, at 12:37 PM, D'Arcy J.M. Cain <darcy@Vex.Net> wrote:
On Mon, 5 Nov 2012 11:42:56 -0600 Anthony Minessale <anthony.minessale@gmail.com> wrote:
ROADMAP
1) Get someone to make a roadmap and organize it for us.
http://jira.freeswitch.org/browse/FS#selectedTab=com.atlassian.jira.plugin.s...
That's 1a. Now 1b is to organize it.
-- D'Arcy J.M. Cain System Administrator, Vex.Net http://www.Vex.Net/ IM:darcy@Vex.Net
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
On Mon, 26 Nov 2012 08:34:36 -0600 Brian West <brian@freeswitch.org> wrote:
Do you want jira access to assist in this job?
I am not sure that I know enough about the project to be the best person for this but if you want I can make a start and ask lots of questions. Note that I do have basic jira access already. I assume that you are talking about another layer of access. -- D'Arcy J.M. Cain System Administrator, Vex.Net http://www.Vex.Net/ IM:darcy@Vex.Net
B) There is that whole threadsafe vs non-threadsafe mysql client lib issue,
In recent versions they're the same (ie it's all threadsafe now) so this should only be an issue on older systems.. libmysqlclient_r still exists for legacy code, but is now just a symlink to libmysqlclient. Possibly it'd disappear at some point. I can't remember if that change was in 5.5 or 5.1 though, and there would be plenty of 5.0/5.1 systems around still. But since libmysqlclient18 (5.5) is threadsafe and can connect to older servers a simple way to enforce it would be to require that as a minimum version perhaps. There's also the mysql_config binary, which has a --libs_r option. Only using that one should ensure on all versions that only the thread-safe library is used. -Steve On 3 November 2012 17:32, Ken Rice <krice@freeswitch.org> wrote:
While this may solve the issue... This does not address a number of other issues
A) 90+% of the primary FreeSWITCH developers use PostgreSQL primarily...
B) There is that whole threadsafe vs non-threadsafe mysql client lib issue, so we would have to come up with a way in the build system to detect which we have, and never use the non-thread safe one... (if we don't do this, the code would never be stable as we could never know for sure which one actually got detected and linked against)
On 11/3/12 1:40 AM, "Gabriel Gunderson" <gabe@gundy.org> wrote:
On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004 <curriegrad2004@gmail.com> wrote:
Quite impossible. The reason is because of the license that the MySQL libs are licensed under. iirc, they are GPL licensed and they are not compatible with the MPL that FreeSWITCH uses.
I've got PostgreSQL, so I've got all I need :) But, it seems like this legal issue is easily resolved:
http://www.mysql.com/about/legal/licensing/foss-exception/
Anyway, I'm not a lawyer or even a very thorough reader ;)
Best, Gabe
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
No one in his right mind should be using MySQL anyway :p On Nov 3, 2012 8:31 AM, "curriegrad2004" <curriegrad2004@gmail.com> wrote:
Quite impossible. The reason is because of the license that the MySQL libs are licensed under. iirc, they are GPL licensed and they are not compatible with the MPL that FreeSWITCH uses.
On Fri, Nov 2, 2012 at 6:56 PM, Abdul Basit <basit.engg@gmail.com> wrote:
+1 for mysql support
On Sat, Nov 3, 2012 at 3:06 AM, Ashley Breeden <ash@url.net.au> wrote:
Hi Ken,
Excellent news for Postgres and FreeSWITCH.
I'll ask this as I am sure there are a lot of people wondering, are
there
plans to support MySQL natively as well?
A.
On 03/11/2012, at 4:25 AM, Ken Rice wrote:
Hey Guys,
There’s some new Database Goodness in the core of FreeSWITCH that can lead to some unexpected things for you guys updating existing installations using ODBC.
We now have Native PostgreSQL support in the core, and along with this comes some changes to the various “odbc-dsn” settings around the tree.
If you are using the format “dsn:username:password” you wont be affected, however if you are just specifying a DSN as “dsn” you will need to listen up
The settings for this field have changed.
pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE for postgresql (the stuff after pgsql:// is a standard libpq connect string for you programmer types) odbc://dns:username:password for ODBC ( dsn:: should also work or dns:username: ) sqlite://filename for sqlite different SQLite Databases
I think we still need to doc this up good, but its there and its coming strong...
-- Ken http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org irc.freenode.net #freeswitch
Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Regards,
Abdul Basit | P: +92 32 1416 4196 | O: +92 30 0841 1445 | UK: +447937421194
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
This appears to have fixed the following issue that I never completely finished supplying the diagnostic info for (sorry). I noticed after a recent update that the problem appears to have completely disappeared. Now I know why. WooHoo! http://jira.freeswitch.org/browse/FS-4152 Nice work. -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Changes-to-how-ODBC-SQL-etc-wo... Sent from the freeswitch-users mailing list archive at Nabble.com.
Since I can see this becoming a popular question (it got me today), I've put some notes up on the Wiki. FAQ entry: http://wiki.freeswitch.org/wiki/FreeSwitch_FAQ#Q:_I.27ve_upgraded_and_my_ODB... New "Release Notes" page where we can stick notes on behaviour changing stuff for people to review when upgrading: http://wiki.freeswitch.org/wiki/Release_Notes Which is linked to from the Which_Version_Should_I_Use template: http://wiki.freeswitch.org/wiki/<http://wiki.freeswitch.org/wiki/Which_Version_Should_I_Use> Which_Version_Should_I_Use<http://wiki.freeswitch.org/wiki/Which_Version_Should_I_Use> Which puts it on the front page and Download/Installation pages. A note link is also at the top of the Download/Installation page to make it a little more prominent. -Steve On 2 November 2012 17:25, Ken Rice <krice@freeswitch.org> wrote:
Hey Guys,
There’s some new Database Goodness in the core of FreeSWITCH that can lead to some unexpected things for you guys updating existing installations using ODBC.
We now have Native PostgreSQL support in the core, and along with this comes some changes to the various “odbc-dsn” settings around the tree.
If you are using the format “dsn:username:password” you wont be affected, however if you are just specifying a DSN as “dsn” you will need to listen up
The settings for this field have changed.
pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE for postgresql (the stuff after pgsql:// is a standard libpq connect string for you programmer types) odbc://dns:username:password for ODBC ( dsn:: should also work or dns:username: ) sqlite://filename for sqlite different SQLite Databases
I think we still need to doc this up good, but its there and its coming strong...
-- Ken *http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org *irc.freenode.net #freeswitch
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
Mod_lua now is able to take advantage of pgsql native support. William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518 william.king@quentustech.com On 11/02/2012 10:25 AM, Ken Rice wrote:
Hey Guys,
There’s some new Database Goodness in the core of FreeSWITCH that can lead to some unexpected things for you guys updating existing installations using ODBC.
We now have Native PostgreSQL support in the core, and along with this comes some changes to the various “odbc-dsn” settings around the tree.
If you are using the format “dsn:username:password” you wont be affected, however if you are just specifying a DSN as “dsn” you will need to listen up
The settings for this field have changed.
pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE for postgresql (the stuff after pgsql:// is a standard libpq connect string for you programmer types) odbc://dns:username:password for ODBC ( dsn:: should also work or dns:username: ) sqlite://filename for sqlite different SQLite Databases
I think we still need to doc this up good, but its there and its coming strong...
-- Ken _http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org _irc.freenode.net #freeswitch
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
It should probably also be pointed out that I pushed some fixes for core_pgsql support over the past couple days for better handling reconnecting to the DB if it loses connectivity. You will definitely want those fixes in place before you lose connectivity on a real, production server. At this time, I have been able to bounce Postgres over and over about 30 times in my tests without any issues getting reconnected and resuming operations. On Wed, Nov 7, 2012 at 5:51 PM, William King <william.king@quentustech.com>wrote:
Mod_lua now is able to take advantage of pgsql native support.
William King Senior Engineer Quentus Technologies, INC 1037 NE 65th St Suite 273 Seattle, WA 98115 Main: (877) 211-9337 Office: (206) 388-4772 Cell: (253) 686-5518 william.king@quentustech.com
On 11/02/2012 10:25 AM, Ken Rice wrote:
Hey Guys,
There’s some new Database Goodness in the core of FreeSWITCH that can lead to some unexpected things for you guys updating existing installations using ODBC.
We now have Native PostgreSQL support in the core, and along with this comes some changes to the various “odbc-dsn” settings around the tree.
If you are using the format “dsn:username:password” you wont be affected, however if you are just specifying a DSN as “dsn” you will need to listen up
The settings for this field have changed.
pgsql://hostaddr=127.0.0.1 dbname=freeswitch user=freeswitch password='' options='-c client_min_messages=NOTICE for postgresql (the stuff after pgsql:// is a standard libpq connect string for you programmer types) odbc://dns:username:password for ODBC ( dsn:: should also work or dns:username: ) sqlite://filename for sqlite different SQLite Databases
I think we still need to doc this up good, but its there and its coming strong...
-- Ken _http://www.FreeSWITCH.org http://www.ClueCon.com http://www.OSTAG.org _irc.freenode.net #freeswitch
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
-- Eliot Gable "We do not inherit the Earth from our ancestors: we borrow it from our children." ~David Brower "I decided the words were too conservative for me. We're not borrowing from our children, we're stealing from them--and it's not even considered to be a crime." ~David Brower "Esse oportet ut vivas, non vivere ut edas." (Thou shouldst eat to live; not live to eat.) ~Marcus Tullius Cicero
It would be interesting to see some support for databases which have no native unixodbc support, like NoSQL solutions. Of particular interest in Apache Cassandra, the reason being it supports SQL-Like statements but has efficient and easy to configure support for multi-master replication, so a FreeSWITCH Cluster could use it to share registration and recovery data. It's also extremely fast and efficient. I currently use MySQL for this, as it has OK support for multi-master, but the overheads in binary logs on a busy box are pretty heavy. I'm not sure how easy it would be to implement Apache Cassandra support, but from my experiences in using it for other projects it would be very useful in FreeSWITCH for sharing data across multiple FreeSWITCH boxes. Neil. -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Changes-to-how-ODBC-SQL-etc-wo... Sent from the freeswitch-users mailing list archive at Nabble.com.
Hi thats good news.. can any one point me PGSQL schema for Freeswitch. On Sun, Nov 25, 2012 at 6:24 PM, peely <freeswitch@peely.com> wrote:
It would be interesting to see some support for databases which have no native unixodbc support, like NoSQL solutions.
Of particular interest in Apache Cassandra, the reason being it supports SQL-Like statements but has efficient and easy to configure support for multi-master replication, so a FreeSWITCH Cluster could use it to share registration and recovery data. It's also extremely fast and efficient.
I currently use MySQL for this, as it has OK support for multi-master, but the overheads in binary logs on a busy box are pretty heavy.
I'm not sure how easy it would be to implement Apache Cassandra support, but from my experiences in using it for other projects it would be very useful in FreeSWITCH for sharing data across multiple FreeSWITCH boxes.
Neil.
-- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/Changes-to-how-ODBC-SQL-etc-wo... Sent from the freeswitch-users mailing list archive at Nabble.com.
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
FreeSWITCH-powered IP PBX: The CudaTel Communication Server http://www.cudatel.com
Official FreeSWITCH Sites http://www.freeswitch.org http://wiki.freeswitch.org http://www.cluecon.com
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
participants (21)
-
Abdul Basit
-
Anthony Minessale
-
Ashley Breeden
-
Avi Marcus
-
Brian West
-
Bzzz
-
curriegrad2004
-
D'Arcy J.M. Cain
-
David J
-
Eliot Gable
-
Gabriel Gunderson
-
Ken Rice
-
Michael Jerris
-
Nelson Luiz Ferraz de Camargo Penteado
-
peely
-
PhilQ
-
ram
-
Steven Ayre
-
Vik Killa
-
William King
-
Yiftach Golan