[Freeswitch-users] Start FreeSWITCH without any SQL but atthesame time have all info available on realtime/runtime

Mon Mar 16 04:55:14 PDT 2009

Depending on the API you're calling, of course
show channels as xml
show calls as xml
uuid_dump [uuid] xml
sofia xmlstatus

and probably more than that.

Math

On 16-Mar-09, at 7:52 AM, Nik Middleton wrote:

> Yup, my mistake, got the wrong end of the stick.
>
> 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.
>
> Regards,
>
> From: freeswitch-users-bounces at lists.freeswitch.org [mailto:freeswitch-users-bounces at lists.freeswitch.org 
> ] On Behalf Of Anthony Minessale
> Sent: 16 March 2009 00:16
> To: freeswitch-users at lists.freeswitch.org
> Subject: Re: [Freeswitch-users] Start FreeSWITCH without any SQL but  
> atthesame time have all info available on realtime/runtime
>
> Perhaps a misunderstanding?
>
> We do not suffer from any problem at all regarding "show channels".
>
> 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
> how we solved it by storing the calls states in a separate table to  
> avoid locking the channels.
>
> You can type show channel in FS all you want and all you are doing  
> is selecting from the SQLite db.
>
> 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
> answer is, sorry no.
>
>
> On Sun, Mar 15, 2009 at 7:01 PM, Nik Middleton <nik.middleton at noblesolutions.co.uk 
> > wrote:
> 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.
>
>
>
>
>
> Regards,
>
> From: freeswitch-users-bounces at lists.freeswitch.org [mailto:freeswitch-users-bounces at lists.freeswitch.org 
> ] On Behalf Of Anthony Minessale
> Sent: 15 March 2009 13:30
> To: freeswitch-users at lists.freeswitch.org
> Subject: Re: [Freeswitch-users] Start FreeSWITCH without any SQL but  
> at thesame time have all info available on realtime/runtime
>
>
>
> search google for bugs related to crash and show channels
> 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
>
> On Sat, Mar 14, 2009 at 7:29 PM, Diego Viola <diego.viola at gmail.com>  
> wrote:
>
> So how Asterisk does that "show channels" without SQL? I don't think
> they use SQLite internally.
>
> Just being curious.
>
> Diego
>
>
> On Sat, Mar 14, 2009 at 9:20 AM, Michael Jerris <mike at jerris.com>  
> wrote:
> > To clarify, -nosql turns on and off only the collecting of data for
> > the show commands, and can now handle higher load than the sip stack
> > can.  The only thing your doing by saying -nosql is turning off the
> > exact functionality you say you want.  Its similar to saying I would
> > like to support sip but don't want to load mod_sofia.  There  
> should be
> > no reasons to use that command anymore, if you encounter any I would
> > be interested in knowing what is going on.
> >
> > Mike
> >
> >
> > On Mar 14, 2009, at 12:12 AM, Diego Viola wrote:
> >
> >> Yeah, but still, it would be nice to see the channels with - 
> nosql :)
> >>
> >> I don't want to be a pain in the ass, just giving some user  
> feedback.
> >>
> >> Regards,
> >>
> >> Diego
> >>
> >> On Fri, Mar 13, 2009 at 3:02 PM, Brian West <brian at freeswitch.org>
> >> wrote:
> >>> Since we added indexes to the SQLite DB its not so bad.
> >>> /b
> >>> On Mar 13, 2009, at 9:36 AM, Diego Viola wrote:
> >>>
> >>> Oh, I thought that SQLite wasn't that great on performance and  
> that
> >>> people wanted to replace/remove it from the core.
> >>>
> >>> "On of the most interesting things about FreeSWITCH to me has been
> >>> the
> >>> fact that most data in the system such as registrations are kept  
> in a
> >>> SQL database. The default installation uses SQLite internally  
> though
> >>> you can easily point FreeSWITCH at one of a number of other SQL
> >>> servers such as PostgreSQL or MySQL via UnixODBC. Sadly, SQLite  
> has
> >>> become somewhat of a bottleneck in the core so future versions of
> >>> FreeSWITCH will use less of it. For example, doing a "show  
> channels"
> >>> with over 500 channels in use starts to show issues. While I'm  
> sad to
> >>> see SQLite go in these cases, I am anxious to see how Minessale
> >>> replaces it."
> >>>
> >>> http://www.anders.com/cms/275/FreeSWITCH/ClueCon/Anthony.Minessale
> >>>
> >>> I was just being curious about it :-)
> >>>
> >>> Regards,
> >>>
> >>> Diego
> >>>
> >
> > _______________________________________________
> > 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
> >
>
> _______________________________________________
> 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/
>
> AIM: anthm
> MSN:anthony_minessale at hotmail.com
> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
> IRC: irc.freenode.net #freeswitch
>
> FreeSWITCH Developer Conference
> sip:888 at conference.freeswitch.org
> iax:guest at conference.freeswitch.org/888
> googletalk:conf+888 at conference.freeswitch.org
> pstn:213-799-1400
>
>
> _______________________________________________
> 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/
>
> AIM: anthm
> MSN:anthony_minessale at hotmail.com
> GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
> IRC: irc.freenode.net #freeswitch
>
> FreeSWITCH Developer Conference
> sip:888 at conference.freeswitch.org
> iax:guest at conference.freeswitch.org/888
> googletalk:conf+888 at conference.freeswitch.org
> pstn:213-799-1400
> _______________________________________________
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20090316/701f2305/attachment-0002.html 