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

Sun Nov 4 18:07:45 MSK 2012

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> 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>
> 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> 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> 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> wrote:
>>>> >>
>>>>> >> > On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004
>>>>> >> > <curriegrad2004 at 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://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
>>>> >>
>>>> >> --
>>>> >> 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 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
>>> >
>>> >
>>> >
>>> >
>>> > --
>>> > 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
>>> <mailto:MSN%3Aanthony_minessale at hotmail.com>
>>> > GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
>>> <mailto:PAYPAL%3Aanthony.minessale at gmail.com>
>>> > IRC: irc.freenode.net <http://irc.freenode.net>  #freeswitch
>>> >
>>> > FreeSWITCH Developer Conference
>>> > sip:888 at conference.freeswitch.org
>>> <mailto:sip%3A888 at conference.freeswitch.org>
>>> > googletalk:conf+888 at conference.freeswitch.org
>>> <mailto:googletalk%3Aconf%2B888 at conference.freeswitch.org>
>>> > pstn:+19193869900 <tel:%2B19193869900>
>>> >
>>> > _________________________________________________________________________
>>> > 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
>>> >
>> 
>> _________________________________________________________________________
>> 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
> 
> 
> 
> _________________________________________________________________________
> 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

-- 
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/2458aa4c/attachment-0001.html 