Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

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

[Freeswitch-users] getting statistics from core db through esl interface


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





PostPosted: Tue Apr 21, 2009 8:42 am    Post subject: [Freeswitch-users] getting statistics from core db through e Reply with quote

show channels count
show calls count

Mathieu

On 21-Apr-09, at 9:27 AM, Leon de Rooij wrote:

Quote:
Hi,

I'm making a c plugin for collectd ( http://collectd.org ) to get some
basic statistics from FS. Right now it uses ESL to connect, but doing
an "api show channels" and after that parsing the csv to get the
amount of channels per profile seems a bit of a detour.. Is it
possible to do some sql selects on the core db through ESL to get this
info ?

thanks & regards,

Leon

_______________________________________________
Freeswitch-users mailing list
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
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
Back to top
leon at scarlet-intern...
Guest





PostPosted: Tue Apr 21, 2009 8:43 am    Post subject: [Freeswitch-users] getting statistics from core db through e Reply with quote

Hi,

I'm making a c plugin for collectd ( http://collectd.org ) to get some
basic statistics from FS. Right now it uses ESL to connect, but doing
an "api show channels" and after that parsing the csv to get the
amount of channels per profile seems a bit of a detour.. Is it
possible to do some sql selects on the core db through ESL to get this
info ?

thanks & regards,

Leon

_______________________________________________
Freeswitch-users mailing list
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
brian at freeswitch.org
Guest





PostPosted: Tue Apr 21, 2009 9:02 am    Post subject: [Freeswitch-users] getting statistics from core db through e Reply with quote

You forgot the "as xml" versions

show channels as xml
show calls count as xml
show channels count as xml


Wink


/b



On Apr 21, 2009, at 8:41 AM, Mathieu Rene wrote:
Quote:
show channels count
show calls count

Mathieu


Brian West
brian@freeswitch.org (brian@freeswitch.org)



-- Meet us at ClueCon! http://www.cluecon.com
Back to top
leon at scarlet-intern...
Guest





PostPosted: Tue Apr 21, 2009 9:06 am    Post subject: [Freeswitch-users] getting statistics from core db through e Reply with quote

Thanks, I know that's possible, but I want to get the amount of
channels per profile (and even seperated inbound/outbound), not a
total of all channels on all profiles combined..

regards,

Leon

On Apr 21, 2009, at 3:41 PM, Mathieu Rene wrote:

Quote:
show channels count
show calls count

Mathieu

On 21-Apr-09, at 9:27 AM, Leon de Rooij wrote:

Quote:
Hi,

I'm making a c plugin for collectd ( http://collectd.org ) to get
some
basic statistics from FS. Right now it uses ESL to connect, but doing
an "api show channels" and after that parsing the csv to get the
amount of channels per profile seems a bit of a detour.. Is it
possible to do some sql selects on the core db through ESL to get
this
info ?

thanks & regards,

Leon

_______________________________________________
Freeswitch-users mailing list
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
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
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
Back to top
anthony.minessale at g...
Guest





PostPosted: Tue Apr 21, 2009 1:04 pm    Post subject: [Freeswitch-users] getting statistics from core db through e Reply with quote

latest trunk now has the stats you seek in "sofia status profile <profilename>"

On Tue, Apr 21, 2009 at 8:55 AM, Brian West <brian@freeswitch.org (brian@freeswitch.org)> wrote:
Quote:
You forgot the "as xml" versions

show channels as xml
show calls count as xml
show channels count as xml


Wink


/b



On Apr 21, 2009, at 8:41 AM, Mathieu Rene wrote:

Quote:
show channels count
show calls count

Mathieu



Brian West
brian@freeswitch.org (brian@freeswitch.org)



-- Meet us at ClueCon!  http://www.cluecon.com











_______________________________________________
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
brian at freeswitch.org
Guest





PostPosted: Tue Apr 21, 2009 4:00 pm    Post subject: [Freeswitch-users] getting statistics from core db through e Reply with quote

Are you going to donate the complete module to the collectd project?

/b

On Apr 21, 2009, at 8:52 AM, Leon de Rooij wrote:
Quote:
Thanks, I know that's possible, but I want to get the amount of
channels per profile (and even seperated inbound/outbound), not a
total of all channels on all profiles combined..

regards,

Leon


Brian West
brian@freeswitch.org (brian@freeswitch.org)



-- Meet us at ClueCon! http://www.cluecon.com
Back to top
leon at scarlet-intern...
Guest





PostPosted: Wed Apr 22, 2009 4:47 am    Post subject: [Freeswitch-users] getting statistics from core db through e Reply with quote

Definitely!

I have a question about licensing, lib_esl is not MPL, right ?


So it can be freely used in a Collectd (GPL) plugin ?


thanks,


Leon



On Apr 21, 2009, at 10:59 PM, Brian West wrote:
Quote:
Are you going to donate the complete module to the collectd project?

/b

On Apr 21, 2009, at 8:52 AM, Leon de Rooij wrote:
Quote:
Thanks, I know that's possible, but I want to get the amount of
channels per profile (and even seperated inbound/outbound), not a
total of all channels on all profiles combined..

regards,

Leon


Brian West
brian@freeswitch.org (brian@freeswitch.org)



-- Meet us at ClueCon! http://www.cluecon.com








_______________________________________________
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
leon at scarlet-intern...
Guest





PostPosted: Wed Apr 22, 2009 5:43 am    Post subject: [Freeswitch-users] getting statistics from core db through e Reply with quote

wow, thanks, that's very useful !
On Apr 21, 2009, at 7:51 PM, Anthony Minessale wrote:
Quote:
latest trunk now has the stats you seek in "sofia status profile <profilename>"

On Tue, Apr 21, 2009 at 8:55 AM, Brian West <brian@freeswitch.org (brian@freeswitch.org)> wrote:
Quote:
You forgot the "as xml" versions

show channels as xml
show calls count as xml
show channels count as xml


Wink


/b



On Apr 21, 2009, at 8:41 AM, Mathieu Rene wrote:

Quote:
show channels count
show calls count

Mathieu



Brian West
brian@freeswitch.org (brian@freeswitch.org)



-- Meet us at ClueCon! http://www.cluecon.com











_______________________________________________
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
anthony.minessale at g...
Guest





PostPosted: Wed Apr 22, 2009 8:10 am    Post subject: [Freeswitch-users] getting statistics from core db through e Reply with quote

ESL is BSD licensed so it will be actually made more restrictive by mixing it with GPL in this case but that was to be expected.
That's why I picked BSD for the lib so it could actually be used everywhere with no license concerns.



On Wed, Apr 22, 2009 at 4:38 AM, Leon de Rooij <leon@scarlet-internet.nl (leon@scarlet-internet.nl)> wrote:
Quote:
Definitely!

I have a question about licensing, lib_esl is not MPL, right ?


So it can be freely used in a Collectd (GPL) plugin ? 


thanks,


Leon




On Apr 21, 2009, at 10:59 PM, Brian West wrote:



Quote:

Are you going to donate the complete module to the collectd project?

/b

On Apr 21, 2009, at 8:52 AM, Leon de Rooij wrote:

Quote:
Thanks, I know that's possible, but I want to get the amount of  
channels per profile (and even seperated inbound/outbound), not a  
total of all channels on all profiles combined..

regards,

Leon


Brian West
brian@freeswitch.org (brian@freeswitch.org)



-- Meet us at ClueCon!  http://www.cluecon.com












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