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

[Nik Middleton]

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
<mailto:MSN%3Aanthony_minessale at hotmail.com> 
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
<mailto:PAYPAL%3Aanthony.minessale at gmail.com> 
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
<mailto:sip%3A888 at conference.freeswitch.org> 
iax:guest at conference.freeswitch.org/888
googletalk:conf+888 at conference.freeswitch.org
<mailto:googletalk%3Aconf%2B888 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
<mailto:MSN%3Aanthony_minessale at hotmail.com> 
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
<mailto:PAYPAL%3Aanthony.minessale at gmail.com> 
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
<mailto:sip%3A888 at conference.freeswitch.org> 
iax:guest at conference.freeswitch.org/888
googletalk:conf+888 at conference.freeswitch.org
<mailto:googletalk%3Aconf%2B888 at conference.freeswitch.org> 
pstn:213-799-1400

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