getting statistics from core db through esl interface
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
show channels count show calls count Mathieu On 21-Apr-09, at 9:27 AM, Leon de Rooij wrote:
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
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:
show channels count show calls count
Mathieu
On 21-Apr-09, at 9:27 AM, Leon de Rooij wrote:
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
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:
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 -- Meet us at ClueCon! http://www.cluecon.com
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:
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:
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
-- Meet us at ClueCon! http://www.cluecon.com
_______________________________________________ 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
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>wrote:
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:
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:
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
-- Meet us at ClueCon! http://www.cluecon.com
_______________________________________________ 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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
You forgot the "as xml" versions show channels as xml show calls count as xml show channels count as xml ;) /b On Apr 21, 2009, at 8:41 AM, Mathieu Rene wrote:
show channels count show calls count
Mathieu
Brian West brian@freeswitch.org -- Meet us at ClueCon! http://www.cluecon.com
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> wrote:
You forgot the "as xml" versions show channels as xml show calls count as xml show channels count as xml
;)
/b
On Apr 21, 2009, at 8:41 AM, Mathieu Rene wrote:
show channels count show calls count
Mathieu
Brian West brian@freeswitch.org
-- Meet us at ClueCon! http://www.cluecon.com
_______________________________________________ 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
-- Anthony Minessale II FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/ AIM: anthm MSN:anthony_minessale@hotmail.com <MSN%3Aanthony_minessale@hotmail.com> GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com<PAYPAL%3Aanthony.minessale@gmail.com> IRC: irc.freenode.net #freeswitch FreeSWITCH Developer Conference sip:888@conference.freeswitch.org <sip%3A888@conference.freeswitch.org> iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org<googletalk%3Aconf%2B888@conference.freeswitch.org> pstn:213-799-1400
wow, thanks, that's very useful ! On Apr 21, 2009, at 7:51 PM, Anthony Minessale wrote:
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> wrote: You forgot the "as xml" versions
show channels as xml show calls count as xml show channels count as xml
;)
/b
On Apr 21, 2009, at 8:41 AM, Mathieu Rene wrote:
show channels count show calls count
Mathieu
Brian West brian@freeswitch.org
-- Meet us at ClueCon! http://www.cluecon.com
_______________________________________________ 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
-- Anthony Minessale II
FreeSWITCH http://www.freeswitch.org/ ClueCon http://www.cluecon.com/
AIM: anthm MSN:anthony_minessale@hotmail.com GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com IRC: irc.freenode.net #freeswitch
FreeSWITCH Developer Conference sip:888@conference.freeswitch.org iax:guest@conference.freeswitch.org/888 googletalk:conf+888@conference.freeswitch.org pstn:213-799-1400 _______________________________________________ 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
participants (4)
-
Anthony Minessale
-
Brian West
-
Leon de Rooij
-
Mathieu Rene