[Freeswitch-users] Changes to how ODBC, SQL, etc works

Mon Nov 5 21:05:51 MSK 2012

OK thanks

On Sun, Nov 4, 2012 at 6:21 PM, Ken Rice <krice at 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 at 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 at 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 at 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 at 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 at 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 at 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 at gundy.org <
> http://gabe@gundy.org> > wrote:
> >>
> >> > On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004
> >> > <curriegrad2004 at 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 at freeswitch.org <http://consulting@freeswitch.org>
> >> > http://www.freeswitchsolutions.com
> >> >
> >> > 
> >> > 
> >> >
> >> > Official FreeSWITCH Sites
> >> > http://www.freeswitch.org
> >> > http://wiki.freeswitch.org
> >> > http://www.cluecon.com
> >> >
> >> > FreeSWITCH-users mailing list
> >> > FreeSWITCH-users at 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 at freeswitch.org <http://consulting@freeswitch.org>
> >> http://www.freeswitchsolutions.com
> >>
> >> 
> >> 
> >>
> >> Official FreeSWITCH Sites
> >> http://www.freeswitch.org
> >> http://wiki.freeswitch.org
> >> http://www.cluecon.com
> >>
> >> FreeSWITCH-users mailing list
> >> FreeSWITCH-users at 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 at hotmail.com <http://anthony_minessale@hotmail.com>
>  <mailto:MSN%3Aanthony_minessale at hotmail.com<MSN%3Aanthony_minessale at hotmail.com>>
>
> > GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com <
> http://anthony.minessale@gmail.com>  <
> mailto:PAYPAL%3Aanthony.minessale at gmail.com<PAYPAL%3Aanthony.minessale at gmail.com>>
>
> > IRC: irc.freenode.net <http://irc.freenode.net>  <
> http://irc.freenode.net>  #freeswitch
> >
> > FreeSWITCH Developer Conference
> > sip:888 at conference.freeswitch.org <http://888@conference.freeswitch.org>
>  <mailto:sip%3A888 at conference.freeswitch.org<sip%3A888 at conference.freeswitch.org>>
>
> > googletalk:conf+888 at conference.freeswitch.org <
> http://conf+888@conference.freeswitch.org>  <
> mailto:googletalk%3Aconf%2B888 at conference.freeswitch.org<googletalk%3Aconf%2B888 at conference.freeswitch.org>>
>
> > pstn:+19193869900 <tel:%2B19193869900>  <tel:%2B19193869900>
> >
> > _________________________________________________________________________
> > Professional FreeSWITCH Consulting Services:
> > consulting at freeswitch.org <http://consulting@freeswitch.org>
> > http://www.freeswitchsolutions.com
> >
> > 
> > 
> >
> > Official FreeSWITCH Sites
> > http://www.freeswitch.org
> > http://wiki.freeswitch.org
> > http://www.cluecon.com
> >
> > FreeSWITCH-users mailing list
> > FreeSWITCH-users at 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 at freeswitch.org <http://consulting@freeswitch.org>
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at 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 at freeswitch.org <http://consulting@freeswitch.org>
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at 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 at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121105/56f5efda/attachment-0001.html 