[Freeswitch-users] Display live calls in web pages

[John Nash]

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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20150810/6037671d/attachment-0001.html