VoIP Mailing List Archives :: View topic - [Freeswitch-users] Start FreeSWITCH without any SQL but at thesame time have all info available on realtime/runtime

Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community

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

VoIP Mailing List Archives Forum Index -> freeSWITCH Users

View previous topic :: View next topic

Author

Message

nik.middleton at noble...
Guest

Posted: Sun Mar 15, 2009 7:12 pm Post subject: [Freeswitch-users] Start FreeSWITCH without any SQL but at t

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 [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Anthony Minessale
Sent: 15 March 2009 13:30
To: 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

--
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

anthony.minessale at g...
Guest

Posted: Sun Mar 15, 2009 7:27 pm Post subject: [Freeswitch-users] Start FreeSWITCH without any SQL but at t

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:

Quote:

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:

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:

Regards,

Diego

--
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

Display posts from previous:

	VoIP Mailing List Archives Forum Index -> freeSWITCH Users	All times are GMT - 5 Hours
Page 1 of 1

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