Display live calls in web pages
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?
On 30.07.2015 09:34, John Nash 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?
Hello. If using LUA, then you can hook a lua script to start-up of FS which will hook itself to events for new incomming, but not yet established call, or established bridges. Third option is to periodically call cli command: `show calls` -- Mimiko desu.
Why not query core.db? You can use pdo or whatever. Command line is; Sqlite3 /usr/local/freeswitch/db/core.db Select * from channels Or select * from calls
On 30 Jul 2015, at 07:57, Mimiko <vbvbrj@gmail.com> wrote:
On 30.07.2015 09:34, John Nash 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?
Hello.
If using LUA, then you can hook a lua script to start-up of FS which will hook itself to events for new incomming, but not yet established call, or established bridges. Third option is to periodically call cli command: `show calls`
-- Mimiko desu.
_________________________________________________________________________ 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
To implement startup-script and store channel variables, is there any example where I can start from? On Thu, Jul 30, 2015 at 12:27 PM, Mimiko <vbvbrj@gmail.com> wrote:
On 30.07.2015 09:34, John Nash 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?
Hello.
If using LUA, then you can hook a lua script to start-up of FS which will hook itself to events for new incomming, but not yet established call, or established bridges. Third option is to periodically call cli command: `show calls`
-- Mimiko desu.
_________________________________________________________________________ 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
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
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
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
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
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
Not to a specific table, but you can use an ODBC database for the core DB. You'll then be able to query the calls and channels tables. 'show calls' is just a SQL query that database, which is sqlite by default. Make sure you only read though, and don't lock any tables/rows. Alternatively you can connect into FS using ESL from the web server. On 30 July 2015 at 07:34, 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
participants (6)
-
Giovanni Maruzzelli
-
John Nash
-
Mimiko
-
Oz Mortimer
-
Sergey Safarov
-
Steven Ayre