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

Ken Rice krice at freeswitch.org
Mon Nov 5 05:21:12 MSK 2012


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>
>>>>> > GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
>>>>> <http://anthony.minessale@gmail.com>
>>>>> <mailto: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>
>>>>> > googletalk:conf+888 at conference.freeswitch.org
>>>>> <http://conf+888@conference.freeswitch.org>
>>>>> <mailto: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

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


Join us at ClueCon 2011 Aug 9-11, 2011
More information about the FreeSWITCH-users mailing list