Dear Steven, I would really want to use core DB query as it makes sense to use information which is saved by freeswitch anyway, but the extra variables I need I cannt find in "show channels" (They are automatically set by X- headers).... Is there any other way to store these extra columns in sql table? As suggested by some people I would finally have to store my own calls data on event hooks. If it comes to that can i use execute_on_originate execute_on_pre_answer execute_on_answer execute_on_hangup On dialplan and fire lua scripts?...Will I be able to read extra SIP headers on these events .. Extra headers will be there in Invite message, then 180 or 183 200 OK messages. John On Thu, Jul 30, 2015 at 1:59 PM, Steven Ayre <steveayre@gmail.com> wrote:
If you need extra channel variables then your best bet would be ESL, where you can 'show calls' / 'show channels' and then uuid_getvar to get the extra variables.
On 30 July 2015 at 09:25, John Nash <john.nash778@gmail.com> wrote:
Thank you everyone. I also need to fetch some extra channel variables (Which are set in dial plans and some message headers) as columns, SQLLite stores only fixed number of columns right?
On Thu, Jul 30, 2015 at 1:48 PM, Giovanni Maruzzelli <gmaruzz@gmail.com> wrote:
Mod-rpc-xml has an embedded http server, you can post and get "show calls" to it, and it will return a nice formatted html table :)
sent from my mobile, Giovanni Maruzzelli cell: +39 347 266 56 18 On Jul 30, 2015 9:09 AM, "Sergey Safarov" <s.safarov@gmail.com> wrote:
You can call "show calls" via ESL or mod_erlang and parse output.
Sergey
On Thu, Jul 30, 2015 at 9:34 AM, John Nash <john.nash778@gmail.com> wrote:
Is there any way of storing "live" calls (Ongoing calls) in DB to a specific table? where we can fetch these records and display in web page?
I planned to store calls using some lua script hooks but cli command show calls already shows calls which we can use?
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org 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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org 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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org 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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org 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
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org 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