Perhaps a misunderstanding?<br><br>We do not suffer from any problem at all regarding "show channels".<br><br>The reason for the link was to demonstrate the issue we are familiar with from our asterisk days (3-4 years ago) and to help explain<br>
how we solved it by storing the calls states in a separate table to avoid locking the channels.<br><br>You can type show channel in FS all you want and all you are doing is selecting from the SQLite db.<br><br>The Original question by the poster was if we can find a way to turn off SQL and still allow show channels to work and the<br>
answer is, sorry no.<br><br><br><br><div class="gmail_quote">On Sun, Mar 15, 2009 at 7:01 PM, Nik Middleton <span dir="ltr"><<a href="mailto:nik.middleton@noblesolutions.co.uk">nik.middleton@noblesolutions.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="blue" lang="EN-US">
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">To be fair, most of these messages are 4-5
years old. That said to date, I can crash * by repeatedly doing a ‘show
channels’. All the same FS should be robust enough to suffer this
abuse. If it’s not,. the issue needs to be investigated.</span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">Regards,</span></font></p>
<div>
<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;">
<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a> [mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank">freeswitch-users-bounces@lists.freeswitch.org</a>]
<b><span style="font-weight: bold;">On Behalf Of </span></b>Anthony Minessale<br>
<b><span style="font-weight: bold;">Sent:</span></b> 15 March 2009 13:30<br>
<b><span style="font-weight: bold;">To:</span></b>
<a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank">freeswitch-users@lists.freeswitch.org</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> Re: [Freeswitch-users]
Start FreeSWITCH without any SQL but at thesame time have all info available on
realtime/runtime</span></font></p>
</div><div><div></div><div class="h5">
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<p style="margin-bottom: 12pt;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">search google for bugs
related to crash and show channels <br>
<a href="http://www.google.com/search?q=asterisk+crash+show+channels&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a" target="_blank">http://www.google.com/search?q=asterisk+crash+show+channels&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a</a><br>
<br>
</span></font></p>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">On Sat, Mar 14, 2009 at 7:29 PM, Diego Viola <<a href="mailto:diego.viola@gmail.com" target="_blank">diego.viola@gmail.com</a>> wrote:</span></font></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">So how Asterisk does that "show channels" without SQL? I
don't think<br>
they use SQLite internally.<br>
<br>
Just being curious.<br>
<font color="#888888"><span style="color: rgb(136, 136, 136);"><br>
Diego</span></font></span></font></p>
<div>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><br>
On Sat, Mar 14, 2009 at 9:20 AM, Michael Jerris <<a href="mailto:mike@jerris.com" target="_blank">mike@jerris.com</a>> wrote:<br>
> To clarify, -nosql turns on and off only the collecting of data for<br>
> the show commands, and can now handle higher load than the sip stack<br>
> can. The only thing your doing by saying -nosql is turning off the<br>
> exact functionality you say you want. Its similar to saying I would<br>
> like to support sip but don't want to load mod_sofia. There should
be<br>
> no reasons to use that command anymore, if you encounter any I would<br>
> be interested in knowing what is going on.<br>
><br>
> Mike<br>
><br>
><br>
> On Mar 14, 2009, at 12:12 AM, Diego Viola wrote:<br>
><br>
>> Yeah, but still, it would be nice to see the channels with -nosql :)<br>
>><br>
>> I don't want to be a pain in the ass, just giving some user feedback.<br>
>><br>
>> Regards,<br>
>><br>
>> Diego<br>
>><br>
>> On Fri, Mar 13, 2009 at 3:02 PM, Brian West <<a href="mailto:brian@freeswitch.org" target="_blank">brian@freeswitch.org</a>><br>
>> wrote:<br>
>>> Since we added indexes to the SQLite DB its not so bad.<br>
>>> /b<br>
>>> On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:<br>
>>><br>
>>> Oh, I thought that SQLite wasn't that great on performance and
that<br>
>>> people wanted to replace/remove it from the core.<br>
>>><br>
>>> "On of the most interesting things about FreeSWITCH to me has
been<br>
>>> the<br>
>>> fact that most data in the system such as registrations are kept
in a<br>
>>> SQL database. The default installation uses SQLite internally
though<br>
>>> you can easily point FreeSWITCH at one of a number of other SQL<br>
>>> servers such as PostgreSQL or MySQL via UnixODBC. Sadly, SQLite
has<br>
>>> become somewhat of a bottleneck in the core so future versions of<br>
>>> FreeSWITCH will use less of it. For example, doing a "show
channels"<br>
>>> with over 500 channels in use starts to show issues. While I'm sad
to<br>
>>> see SQLite go in these cases, I am anxious to see how Minessale<br>
>>> replaces it."<br>
>>><br>
>>> <a href="http://www.anders.com/cms/275/FreeSWITCH/ClueCon/Anthony.Minessale" target="_blank">http://www.anders.com/cms/275/FreeSWITCH/ClueCon/Anthony.Minessale</a><br>
>>><br>
>>> I was just being curious about it :-)<br>
>>><br>
>>> Regards,<br>
>>><br>
>>> Diego<br>
>>><br>
><br>
> _______________________________________________<br>
> Freeswitch-users mailing list<br>
> <a href="mailto: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>
Freeswitch-users mailing list<br>
<a href="mailto: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></font></p>
</div>
</div>
</div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><br>
<br clear="all">
<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>
<br>
AIM: anthm<br>
<a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank">MSN:anthony_minessale@hotmail.com</a><br>
GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
<br>
FreeSWITCH Developer Conference<br>
<a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank">sip:888@conference.freeswitch.org</a><br>
<a href="http://iax:guest@conference.freeswitch.org/888" target="_blank">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:213-799-1400</span></font></p>
</div></div></div>
</div>
<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><br clear="all"><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>
<br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br><a href="http://iax:guest@conference.freeswitch.org/888">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>pstn:213-799-1400<br>