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><div class="gmail_quote">On Sun, Nov 4, 2012 at 7:07 AM, Ken Rice <span dir="ltr"><<a href="mailto:krice@freeswitch.org" target="_blank">krice@freeswitch.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<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="http://yiftah@choochee.com" target="_blank">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="http://curriegrad2004@gmail.com" target="_blank">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="http://anthony.minessale@gmail.com" target="_blank">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="http://krice@freeswitch.org" target="_blank">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="http://gabe@gundy.org" target="_blank">gabe@gundy.org</a>> wrote:<br>
>><br>
>> > On Fri, Nov 2, 2012 at 11:55 PM, curriegrad2004<br>
>> > <<a href="http://curriegrad2004@gmail.com" target="_blank">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/" target="_blank">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="http://consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
>> > <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
>> ><br>
>> > FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
>> > <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
>> ><br>
>> > Official FreeSWITCH Sites<br>
>> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> > <a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
>> > <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
>> ><br>
>> > FreeSWITCH-users mailing list<br>
>> > <a href="http://FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> > <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> > UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> > <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>><br>
>> --<br>
>> Ken<br>
>> <a href="http://www.FreeSWITCH.org" target="_blank">http://www.FreeSWITCH.org</a><br>
>> <a href="http://www.ClueCon.com" target="_blank">http://www.ClueCon.com</a><br>
>> <a href="http://www.OSTAG.org" target="_blank">http://www.OSTAG.org</a><br>
>> <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> <<a href="http://irc.freenode.net" target="_blank">http://irc.freenode.net</a>> #freeswitch<br>
>><br>
>><br>
>><br>
>> _________________________________________________________________________<br>
>> Professional FreeSWITCH Consulting Services:<br>
>> <a href="http://consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
>> <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
>><br>
>> FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
>> <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
>><br>
>> Official FreeSWITCH Sites<br>
>> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
>> <a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
>> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
>><br>
>> FreeSWITCH-users mailing list<br>
>> <a href="http://FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
>> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
>> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
><br>
><br>
><br>
> --<br>
> Anthony Minessale II<br>
><br>
> FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
> ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
> Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br>
><br>
> AIM: anthm<br>
> MSN:<a href="http://anthony_minessale@hotmail.com" target="_blank">anthony_minessale@hotmail.com</a> <<a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank">mailto:MSN%3Aanthony_minessale@hotmail.com</a>> <br>
> GTALK/JABBER/PAYPAL:<a href="http://anthony.minessale@gmail.com" target="_blank">anthony.minessale@gmail.com</a> <<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">mailto:PAYPAL%3Aanthony.minessale@gmail.com</a>> <br>
> IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> <<a href="http://irc.freenode.net" target="_blank">http://irc.freenode.net</a>> #freeswitch<br>
><br>
> FreeSWITCH Developer Conference<br>
> sip:<a href="http://888@conference.freeswitch.org" target="_blank">888@conference.freeswitch.org</a> <<a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank">mailto:sip%3A888@conference.freeswitch.org</a>> <br>
> googletalk:<a href="http://conf+888@conference.freeswitch.org" target="_blank">conf+888@conference.freeswitch.org</a> <<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">mailto:googletalk%3Aconf%2B888@conference.freeswitch.org</a>> <br>
> pstn:<a href="tel:%2B19193869900" value="+19193869900" target="_blank">+19193869900</a> <tel:%2B19193869900> <br>
><br>
> _________________________________________________________________________<br>
> Professional FreeSWITCH Consulting Services:<br>
> <a href="http://consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
> <a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
><br>
> FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
> <a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
><br>
> Official FreeSWITCH Sites<br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
> <a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
> <a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
><br>
> FreeSWITCH-users mailing list<br>
> <a href="http://FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
> <a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
> <a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
><br>
<br>
_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="http://consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="http://FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">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><font face="Consolas, Courier New, Courier"><span style="font-size:10pt">_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="http://consulting@freeswitch.org" target="_blank">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="http://FreeSWITCH-users@lists.freeswitch.org" target="_blank">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><span class="HOEnZb"><font color="#888888"><br>
</font></span></span></font></font></blockquote><span class="HOEnZb"><font color="#888888"><font><font face="Consolas, Courier New, Courier"><span style="font-size:10pt"><br>
</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" target="_blank">http://www.FreeSWITCH.org</a><br>
<a href="http://www.ClueCon.com" target="_blank">http://www.ClueCon.com</a><br>
<a href="http://www.OSTAG.org" target="_blank">http://www.OSTAG.org</a><br>
</u></font><a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
</span></font>
</font></span></div>
<br>_________________________________________________________________________<br>
Professional FreeSWITCH Consulting Services:<br>
<a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br>
<a href="http://www.freeswitchsolutions.com" target="_blank">http://www.freeswitchsolutions.com</a><br>
<br>
FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br>
<a href="http://www.cudatel.com" target="_blank">http://www.cudatel.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<a href="http://wiki.freeswitch.org" target="_blank">http://wiki.freeswitch.org</a><br>
<a href="http://www.cluecon.com" target="_blank">http://www.cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br></blockquote></div><br>