Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

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


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users
View previous topic :: View next topic  
Author Message
nik.middleton at noble...
Guest





PostPosted: Mon Mar 16, 2009 7:08 am    Post subject: [Freeswitch-users] Start FreeSWITCH without any SQL but atth Reply with quote

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@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Anthony Minessale
Sent: 16 March 2009 00:16
To: freeswitch-users@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@noblesolutions.co.uk (nik.middleton@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@lists.freeswitch.org (freeswitch-users-bounces@lists.freeswitch.org) [mailto:freeswitch-users-bounces@lists.freeswitch.org (freeswitch-users-bounces@lists.freeswitch.org)] On Behalf Of Anthony Minessale
Sent: 15 March 2009 13:30
To: freeswitch-users@lists.freeswitch.org (freeswitch-users@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@gmail.com (diego.viola@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@jerris.com (mike@jerris.com)> wrote:
Quote:
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:

Quote:
Yeah, but still, it would be nice to see the channels with -nosql Smile

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@freeswitch.org (brian@freeswitch.org)>
wrote:
Quote:
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 Smile

Regards,

Diego


_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400





_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400
Back to top
mrene_lists at avgs.ca
Guest





PostPosted: Mon Mar 16, 2009 7:09 am    Post subject: [Freeswitch-users] Start FreeSWITCH without any SQL but atth Reply with quote

Depending on the API you're calling, of courseshow 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:
Quote:
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@lists.freeswitch.org (freeswitch-users-bounces@lists.freeswitch.org) [mailto:freeswitch-users-bounces@lists.freeswitch.org (freeswitch-users-bounces@lists.freeswitch.org)] On Behalf Of Anthony Minessale
Sent: 16 March 2009 00:16
To: freeswitch-users@lists.freeswitch.org (freeswitch-users@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@noblesolutions.co.uk (nik.middleton@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@lists.freeswitch.org (freeswitch-users-bounces@lists.freeswitch.org) [mailto:freeswitch-users-bounces@lists.freeswitch.org (freeswitch-users-bounces@lists.freeswitch.org)] On Behalf Of Anthony Minessale
Sent: 15 March 2009 13:30
To: freeswitch-users@lists.freeswitch.org (freeswitch-users@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@gmail.com (diego.viola@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@jerris.com (mike@jerris.com)> wrote:
Quote:
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:

Quote:
Yeah, but still, it would be nice to see the channels with -nosql Smile

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@freeswitch.org (brian@freeswitch.org)>
wrote:
Quote:
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 Smile

Regards,

Diego


_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400




_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@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@hotmail.com ([email]MSN%3Aanthony_minessale@hotmail.com[/email])
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com ([email]PAYPAL%3Aanthony.minessale@gmail.com[/email])
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888@conference.freeswitch.org ([email]sip%3A888@conference.freeswitch.org[/email])
iax:guest@conference.freeswitch.org/888
googletalk:conf+888@conference.freeswitch.org ([email]googletalk%3Aconf%2B888@conference.freeswitch.org[/email])
pstn:213-799-1400

_______________________________________________
Freeswitch-users mailing list
Freeswitch-users@lists.freeswitch.org (Freeswitch-users@lists.freeswitch.org)
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> freeSWITCH Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services