<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Depending on the API you're calling, of course<div>show channels as xml</div><div>show calls as xml</div><div>uuid_dump [uuid] xml</div><div>sofia xmlstatus</div><div><br></div><div>and probably more than that.</div><div><br></div><div>Math</div><div><br></div><div><div><div>On 16-Mar-09, at 7:52 AM, Nik Middleton wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div lang="EN-US" link="blue" vlink="blue"><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"><div class="Section1"><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy; ">Yup, my mistake, got the wrong end of the stick.<o:p></o:p></span></font></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy; "><o:p> </o:p></span></font></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy; ">However while we’re on the subject of show channels, is it possible to get a formatted response back from the event socket? It would be nice to interrogate an event style response. Perhaps even including some other goodies such as load etc.<o:p></o:p></span></font></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy; "><o:p> </o:p></span></font></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy; ">Regards,<o:p></o:p></span></font></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy; "><o:p> </o:p></span></font></div><div><div class="MsoNormal" align="center" style="text-align: center; margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "><hr size="2" width="100%" align="center" tabindex="-1"></span></font></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><b><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold; ">From:</span></font></b><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma; "><span class="Apple-converted-space"> </span><a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" style="color: blue; text-decoration: underline; ">freeswitch-users-bounces@lists.freeswitch.org</a><span class="Apple-converted-space"> </span>[<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" style="color: blue; text-decoration: underline; ">mailto:freeswitch-users-bounces@lists.freeswitch.org</a>]<span class="Apple-converted-space"> </span><b><span style="font-weight: bold; ">On Behalf Of<span class="Apple-converted-space"> </span></span></b>Anthony Minessale<br><b><span style="font-weight: bold; ">Sent:</span></b><span class="Apple-converted-space"> </span>16 March 2009 00:16<br><b><span style="font-weight: bold; ">To:</span></b><span class="Apple-converted-space"> </span><st1:personname w:st="on"><a href="mailto:freeswitch-users@lists.freeswitch.org" style="color: blue; text-decoration: underline; ">freeswitch-users@lists.freeswitch.org</a></st1:personname><br><b><span style="font-weight: bold; ">Subject:</span></b><span class="Apple-converted-space"> </span>Re: [Freeswitch-users] Start FreeSWITCH without any SQL but atthesame time have all info available on realtime/runtime</span></font><o:p></o:p></div></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "><o:p> </o:p></span></font></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; ">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><o:p></o:p></span></font></div><div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; ">On Sun, Mar 15, 2009 at 7:01 PM,<span class="Apple-converted-space"> </span><st1:personname w:st="on">Nik Middleton</st1:personname><span class="Apple-converted-space"> </span><<a href="mailto:nik.middleton@noblesolutions.co.uk" style="color: blue; text-decoration: underline; ">nik.middleton@noblesolutions.co.uk</a>> wrote:<o:p></o:p></span></font></div><div link="blue" vlink="blue"><div><p style="margin-right: 0in; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" color="navy" face="Arial"><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><o:p></o:p></p><p style="margin-right: 0in; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy; "> </span></font><o:p></o:p></p><p style="margin-right: 0in; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy; "> </span></font><o:p></o:p></p><p style="margin-right: 0in; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman'; "><font size="2" color="navy" face="Arial"><span style="font-size: 10pt; font-family: Arial; color: navy; ">Regards,</span></font><o:p></o:p></p><div><div class="MsoNormal" align="center" style="text-align: center; margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "><hr size="2" width="100%" align="center"></span></font></div><p style="margin-right: 0in; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman'; "><b><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold; ">From:</span></font></b><font size="2" face="Tahoma"><span style="font-size: 10pt; font-family: Tahoma; "><span class="Apple-converted-space"> </span><a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank" style="color: blue; text-decoration: underline; ">freeswitch-users-bounces@lists.freeswitch.org</a><span class="Apple-converted-space"> </span>[mailto:<a href="mailto:freeswitch-users-bounces@lists.freeswitch.org" target="_blank" style="color: blue; text-decoration: underline; ">freeswitch-users-bounces@lists.freeswitch.org</a>]<span class="Apple-converted-space"> </span><b><span style="font-weight: bold; ">On Behalf Of<span class="Apple-converted-space"> </span></span></b>Anthony Minessale<br><b><span style="font-weight: bold; ">Sent:</span></b><span class="Apple-converted-space"> </span>15 March 2009 13:30<br><b><span style="font-weight: bold; ">To:</span></b><span class="Apple-converted-space"> </span><a href="mailto:freeswitch-users@lists.freeswitch.org" target="_blank" style="color: blue; text-decoration: underline; ">freeswitch-users@lists.freeswitch.org</a><br><b><span style="font-weight: bold; ">Subject:</span></b><span class="Apple-converted-space"> </span>Re: [Freeswitch-users] Start FreeSWITCH without any SQL but at thesame time have all info available on realtime/runtime</span></font><o:p></o:p></p></div><div><div><p style="margin-right: 0in; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "> <o:p></o:p></span></font></p><p style="margin-bottom: 12pt; margin-right: 0in; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; ">search google for bugs related to crash and show channels<span class="Apple-converted-space"> </span><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" style="color: blue; text-decoration: underline; ">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><o:p></o:p></span></font></p><div><p style="margin-right: 0in; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><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" style="color: blue; text-decoration: underline; ">diego.viola@gmail.com</a>> wrote:<o:p></o:p></span></font></p><p style="margin-right: 0in; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><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><o:p></o:p></span></font></p><div><div><p style="margin-right: 0in; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><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" style="color: blue; text-decoration: underline; ">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" style="color: blue; text-decoration: underline; ">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>>>><span class="Apple-converted-space"> </span><a href="http://www.anders.com/cms/275/FreeSWITCH/ClueCon/Anthony.Minessale" target="_blank" style="color: blue; text-decoration: underline; ">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>><span class="Apple-converted-space"> </span><a href="mailto:Freeswitch-users@lists.freeswitch.org" target="_blank" style="color: blue; text-decoration: underline; ">Freeswitch-users@lists.freeswitch.org</a><br>><span class="Apple-converted-space"> </span><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank" style="color: blue; text-decoration: underline; ">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>> UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank" style="color: blue; text-decoration: underline; ">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>><span class="Apple-converted-space"> </span><a href="http://www.freeswitch.org" target="_blank" style="color: blue; text-decoration: underline; ">http://www.freeswitch.org</a><br>><br><br>_______________________________________________<br>Freeswitch-users mailing list<br><a href="mailto:Freeswitch-users@lists.freeswitch.org" target="_blank" style="color: blue; text-decoration: underline; ">Freeswitch-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank" style="color: blue; text-decoration: underline; ">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank" style="color: blue; text-decoration: underline; ">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br><a href="http://www.freeswitch.org" target="_blank" style="color: blue; text-decoration: underline; ">http://www.freeswitch.org</a><o:p></o:p></span></font></p></div></div></div><p style="margin-right: 0in; margin-left: 0in; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "><br><br clear="all"><br>--<span class="Apple-converted-space"> </span><br>Anthony Minessale II<br><br>FreeSWITCH<span class="Apple-converted-space"> </span><a href="http://www.freeswitch.org/" target="_blank" style="color: blue; text-decoration: underline; ">http://www.freeswitch.org/</a><br>ClueCon<span class="Apple-converted-space"> </span><a href="http://www.cluecon.com/" target="_blank" style="color: blue; text-decoration: underline; ">http://www.cluecon.com/</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com" target="_blank" style="color: blue; text-decoration: underline; ">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" target="_blank" style="color: blue; text-decoration: underline; ">PAYPAL:anthony.minessale@gmail.com</a><br>IRC:<span class="Apple-converted-space"> </span><a href="http://irc.freenode.net" target="_blank" style="color: blue; text-decoration: underline; ">irc.freenode.net</a><span class="Apple-converted-space"> </span>#freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org" target="_blank" style="color: blue; text-decoration: underline; ">sip:888@conference.freeswitch.org</a><br><a href="http://iax:guest@conference.freeswitch.org/888" target="_blank" style="color: blue; text-decoration: underline; ">iax:guest@conference.freeswitch.org/888</a><br><a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" target="_blank" style="color: blue; text-decoration: underline; ">googletalk:conf+888@conference.freeswitch.org</a><br>pstn:213-799-1400<o:p></o:p></span></font></p></div></div></div></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "><br>_______________________________________________<br>Freeswitch-users mailing list<br><a href="mailto:Freeswitch-users@lists.freeswitch.org" style="color: blue; text-decoration: underline; ">Freeswitch-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank" style="color: blue; text-decoration: underline; ">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank" style="color: blue; text-decoration: underline; ">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br><a href="http://www.freeswitch.org" target="_blank" style="color: blue; text-decoration: underline; ">http://www.freeswitch.org</a><o:p></o:p></span></font></div></div><div style="margin-top: 0in; margin-right: 0in; margin-left: 0in; margin-bottom: 0.0001pt; font-size: 12pt; font-family: 'Times New Roman'; "><font size="3" face="Times New Roman"><span style="font-size: 12pt; "><br><br clear="all"><br>--<span class="Apple-converted-space"> </span><br>Anthony Minessale II<br><br>FreeSWITCH<span class="Apple-converted-space"> </span><a href="http://www.freeswitch.org/" style="color: blue; text-decoration: underline; ">http://www.freeswitch.org/</a><br>ClueCon<span class="Apple-converted-space"> </span><a href="http://www.cluecon.com/" style="color: blue; text-decoration: underline; ">http://www.cluecon.com/</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com" style="color: blue; text-decoration: underline; ">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com" style="color: blue; text-decoration: underline; ">PAYPAL:anthony.minessale@gmail.com</a><br>IRC:<span class="Apple-converted-space"> </span><a href="http://irc.freenode.net" style="color: blue; text-decoration: underline; ">irc.freenode.net</a><span class="Apple-converted-space"> </span>#freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org" style="color: blue; text-decoration: underline; ">sip:888@conference.freeswitch.org</a><br><a href="http://iax:guest@conference.freeswitch.org/888" style="color: blue; text-decoration: underline; ">iax:guest@conference.freeswitch.org/888</a><br><a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org" style="color: blue; text-decoration: underline; ">googletalk:conf+888@conference.freeswitch.org</a><br>pstn:213-799-1400<o:p></o:p></span></font></div></div>_______________________________________________<br>Freeswitch-users mailing list<br><a href="mailto:Freeswitch-users@lists.freeswitch.org" style="color: blue; text-decoration: underline; ">Freeswitch-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" style="color: blue; text-decoration: underline; ">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" style="color: blue; text-decoration: underline; ">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br><a href="http://www.freeswitch.org" style="color: blue; text-decoration: underline; ">http://www.freeswitch.org</a><br></o:smarttagtype></div></span></blockquote></div><br></div></body></html>