<HTML>
<HEAD>
<TITLE>Re: [Freeswitch-users] Changes to how ODBC, SQL, etc works</TITLE>
</HEAD>
<BODY>
<FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>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...<BR>
<BR>
As far as OpenSIPs, they support PostgreSQL via the db_postgres engine...<BR>
<BR>
<BR>
<BR>
On 11/4/12 9:37 PM, "Yiftach Golan" <<a href="yiftah@choochee.com">yiftah@choochee.com</a>> wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>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 <BR>
It is just that OpenSIPs goes very well with FreeSWITCH (at least for us) and OpenSIPs use mysql as its primary db <BR>
Therefore using one DB for both makes a lot of sense for us<BR>
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?<BR>
<BR>
Thanks,<BR>
Yiftach.<BR>
<BR>
<BR>
On Sun, Nov 4, 2012 at 7:07 AM, Ken Rice <<a href="krice@freeswitch.org">krice@freeswitch.org</a>> wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>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<BR>
<BR>
<BR>
<BR>
On 11/3/12 10:59 PM, "Yiftach Golan" <<a href="yiftah@choochee.com">yiftah@choochee.com</a> <<a href="http://yiftah@choochee.com">http://yiftah@choochee.com</a>> > wrote:<BR>
<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>Also for what ken wrote we used the non thread safe version and protected the call to the database with mutex <BR>
<BR>
<BR>
On Sat, Nov 3, 2012 at 1:25 PM, curriegrad2004 <<a href="curriegrad2004@gmail.com">curriegrad2004@gmail.com</a> <<a href="http://curriegrad2004@gmail.com">http://curriegrad2004@gmail.com</a>> > wrote:<BR>
</SPAN></FONT><BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>ODBC's there for this reason. Why invent more wheels when we already<BR>
have that wheel sitting around?<BR>
<BR>
On Sat, Nov 3, 2012 at 11:36 AM, Anthony Minessale<BR>
<<a href="anthony.minessale@gmail.com">anthony.minessale@gmail.com</a> <<a href="http://anthony.minessale@gmail.com">http://anthony.minessale@gmail.com</a>> > wrote:<BR>
> Plus as a friend of mine used to say: "It's not MY sql its YOUR sql!"<BR>
><BR>
> It is a fact that we have an incredible amount of bugs come up that end up<BR>
> being mysql+odbc memory errors and thread safety issues.<BR>
> I would be concerned with more blame falling on us of we had the code deeper<BR>
> into our core.<BR>
><BR>
> I would not condone adding any more db support unless we we architected it<BR>
> to use db modules so we could still properly blame it on mysql when it was<BR>
> not working.<BR>
><BR>
><BR>
><BR>
><BR>
> On Sat, Nov 3, 2012 at 12:32 PM, Ken Rice <<a href="krice@freeswitch.org">krice@freeswitch.org</a> <<a href="http://krice@freeswitch.org">http://krice@freeswitch.org</a>> > wrote:<BR>
>><BR>
>> While this may solve the issue... This does not address a number of other<BR>
>> issues<BR>
>><BR>
>> A) 90+% of the primary FreeSWITCH developers use PostgreSQL primarily...<BR>
>><BR>
>> B) There is that whole threadsafe vs non-threadsafe mysql client lib<BR>
>> issue,<BR>
>> so we would have to come up with a way in the build system to detect which<BR>
>> we have, and never use the non-thread safe one... (if we don't do this,<BR>
>> the<BR>
>> code would never be stable as we could never know for sure which one<BR>
>> actually got detected and linked against)<BR>
>><BR>
>><BR>
>><BR>
>><BR>
>><BR>
>> On 11/3/12 1:40 AM, "Gabriel Gunderson" <<a href="gabe@gundy.org">gabe@gundy.org</a> <<a href="http://gabe@gundy.org">http://gabe@gundy.org</a>> > wrote:<BR>
>><BR>
>> > On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004<BR>
>> > <<a href="curriegrad2004@gmail.com">curriegrad2004@gmail.com</a> <<a href="http://curriegrad2004@gmail.com">http://curriegrad2004@gmail.com</a>> > wrote:<BR>
>> >> Quite impossible. The reason is because of the license that the MySQL<BR>
>> >> libs are licensed under. iirc, they are GPL licensed and they are not<BR>
>> >> compatible with the MPL that FreeSWITCH uses.<BR>
>> ><BR>
>> > I've got PostgreSQL, so I've got all I need :) But, it seems like this<BR>
>> > legal issue is easily resolved:<BR>
>> ><BR>
>> > <a href="http://www.mysql.com/about/legal/licensing/foss-exception/">http://www.mysql.com/about/legal/licensing/foss-exception/</a><BR>
>> ><BR>
>> > Anyway, I'm not a lawyer or even a very thorough reader ;)<BR>
>> ><BR>
>> ><BR>
>> > Best,<BR>
>> > Gabe<BR>
>> ><BR>
>> ><BR>
>> > _________________________________________________________________________<BR>
>> > Professional FreeSWITCH Consulting Services:<BR>
>> > <a href="consulting@freeswitch.org">consulting@freeswitch.org</a> <<a href="http://consulting@freeswitch.org">http://consulting@freeswitch.org</a>> <BR>
>> > <a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><BR>
>> ><BR>
>> > FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR>
>> > <a href="http://www.cudatel.com">http://www.cudatel.com</a><BR>
>> ><BR>
>> > Official FreeSWITCH Sites<BR>
>> > <a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
>> > <a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><BR>
>> > <a href="http://www.cluecon.com">http://www.cluecon.com</a><BR>
>> ><BR>
>> > FreeSWITCH-users mailing list<BR>
>> > <a href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a> <<a href="http://FreeSWITCH-users@lists.freeswitch.org">http://FreeSWITCH-users@lists.freeswitch.org</a>> <BR>
>> > <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
>> > UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
>> > <a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
>><BR>
>> --<BR>
>> Ken<BR>
>> <a href="http://www.FreeSWITCH.org">http://www.FreeSWITCH.org</a><BR>
>> <a href="http://www.ClueCon.com">http://www.ClueCon.com</a><BR>
>> <a href="http://www.OSTAG.org">http://www.OSTAG.org</a><BR>
>> irc.freenode.net <<a href="http://irc.freenode.net">http://irc.freenode.net</a>> <<a href="http://irc.freenode.net">http://irc.freenode.net</a>> #freeswitch<BR>
>><BR>
>><BR>
>><BR>
>> _________________________________________________________________________<BR>
>> Professional FreeSWITCH Consulting Services:<BR>
>> <a href="consulting@freeswitch.org">consulting@freeswitch.org</a> <<a href="http://consulting@freeswitch.org">http://consulting@freeswitch.org</a>> <BR>
>> <a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><BR>
>><BR>
>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR>
>> <a href="http://www.cudatel.com">http://www.cudatel.com</a><BR>
>><BR>
>> Official FreeSWITCH Sites<BR>
>> <a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
>> <a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><BR>
>> <a href="http://www.cluecon.com">http://www.cluecon.com</a><BR>
>><BR>
>> FreeSWITCH-users mailing list<BR>
>> <a href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a> <<a href="http://FreeSWITCH-users@lists.freeswitch.org">http://FreeSWITCH-users@lists.freeswitch.org</a>> <BR>
>> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
>> <a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
><BR>
><BR>
><BR>
><BR>
> --<BR>
> Anthony Minessale II<BR>
><BR>
> FreeSWITCH <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><BR>
> ClueCon <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><BR>
> Twitter: <a href="http://twitter.com/FreeSWITCH_wire">http://twitter.com/FreeSWITCH_wire</a><BR>
><BR>
> AIM: anthm<BR>
> MSN:<a href="anthony_minessale@hotmail.com">anthony_minessale@hotmail.com</a> <<a href="http://anthony_minessale@hotmail.com">http://anthony_minessale@hotmail.com</a>> <<a href="mailto:MSN%3Aanthony_minessale@hotmail.com">mailto:MSN%3Aanthony_minessale@hotmail.com</a>> <BR>
> GTALK/JABBER/PAYPAL:<a href="anthony.minessale@gmail.com">anthony.minessale@gmail.com</a> <<a href="http://anthony.minessale@gmail.com">http://anthony.minessale@gmail.com</a>> <<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">mailto:PAYPAL%3Aanthony.minessale@gmail.com</a>> <BR>
> IRC: irc.freenode.net <<a href="http://irc.freenode.net">http://irc.freenode.net</a>> <<a href="http://irc.freenode.net">http://irc.freenode.net</a>> #freeswitch<BR>
><BR>
> FreeSWITCH Developer Conference<BR>
> sip:<a href="888@conference.freeswitch.org">888@conference.freeswitch.org</a> <<a href="http://888@conference.freeswitch.org">http://888@conference.freeswitch.org</a>> <<a href="mailto:sip%3A888@conference.freeswitch.org">mailto:sip%3A888@conference.freeswitch.org</a>> <BR>
> googletalk:<a href="conf+888@conference.freeswitch.org">conf+888@conference.freeswitch.org</a> <<a href="http://conf+888@conference.freeswitch.org">http://conf+888@conference.freeswitch.org</a>> <<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">mailto:googletalk%3Aconf%2B888@conference.freeswitch.org</a>> <BR>
> pstn:+19193869900 <tel:%2B19193869900> <tel:%2B19193869900> <BR>
><BR>
> _________________________________________________________________________<BR>
> Professional FreeSWITCH Consulting Services:<BR>
> <a href="consulting@freeswitch.org">consulting@freeswitch.org</a> <<a href="http://consulting@freeswitch.org">http://consulting@freeswitch.org</a>> <BR>
> <a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><BR>
><BR>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR>
> <a href="http://www.cudatel.com">http://www.cudatel.com</a><BR>
><BR>
> Official FreeSWITCH Sites<BR>
> <a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
> <a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><BR>
> <a href="http://www.cluecon.com">http://www.cluecon.com</a><BR>
><BR>
> FreeSWITCH-users mailing list<BR>
> <a href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a> <<a href="http://FreeSWITCH-users@lists.freeswitch.org">http://FreeSWITCH-users@lists.freeswitch.org</a>> <BR>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
> <a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
><BR>
<BR>
_________________________________________________________________________<BR>
Professional FreeSWITCH Consulting Services:<BR>
<a href="consulting@freeswitch.org">consulting@freeswitch.org</a> <<a href="http://consulting@freeswitch.org">http://consulting@freeswitch.org</a>> <BR>
<a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><BR>
<BR>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR>
<a href="http://www.cudatel.com">http://www.cudatel.com</a><BR>
<BR>
Official FreeSWITCH Sites<BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
<a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><BR>
<a href="http://www.cluecon.com">http://www.cluecon.com</a><BR>
<BR>
FreeSWITCH-users mailing list<BR>
<a href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a> <<a href="http://FreeSWITCH-users@lists.freeswitch.org">http://FreeSWITCH-users@lists.freeswitch.org</a>> <BR>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
</SPAN></FONT></BLOCKQUOTE><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'><BR>
<BR>
<HR ALIGN=CENTER SIZE="3" WIDTH="95%"></SPAN></FONT><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'>_________________________________________________________________________<BR>
Professional FreeSWITCH Consulting Services:<BR>
<a href="consulting@freeswitch.org">consulting@freeswitch.org</a> <<a href="http://consulting@freeswitch.org">http://consulting@freeswitch.org</a>> <BR>
<a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><BR>
<BR>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<BR>
<a href="http://www.cudatel.com">http://www.cudatel.com</a><BR>
<BR>
Official FreeSWITCH Sites<BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
<a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><BR>
<a href="http://www.cluecon.com">http://www.cluecon.com</a><BR>
<BR>
FreeSWITCH-users mailing list<BR>
<a href="FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a> <<a href="http://FreeSWITCH-users@lists.freeswitch.org">http://FreeSWITCH-users@lists.freeswitch.org</a>> <BR>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><BR>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><BR>
<a href="http://www.freeswitch.org">http://www.freeswitch.org</a><BR>
</SPAN></FONT></FONT></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE><FONT SIZE="2"><FONT FACE="Consolas, Courier New, Courier"><SPAN STYLE='font-size:10pt'><FONT COLOR="#888888"><BR>
</FONT></SPAN></FONT></FONT><FONT FACE="Monaco, Courier New"><SPAN STYLE='font-size:11pt'>-- <BR>
Ken<BR>
<FONT COLOR="#0000FF"><U><a href="http://www.FreeSWITCH.org">http://www.FreeSWITCH.org</a><BR>
<a href="http://www.ClueCon.com">http://www.ClueCon.com</a><BR>
<a href="http://www.OSTAG.org">http://www.OSTAG.org</a><BR>
</U></FONT>irc.freenode.net #freeswitch<BR>
</SPAN></FONT>
</BODY>
</HTML>