where to put perl code to add cdr info
I would like to insert the cdr information when the call hangsup, rather than some kron job or something -- is there a way I can use hangup_api_hook to execute the perl code, or is this too early for cdr_csv to have populated the variables? Thanks. -- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici covici@ccs.covici.com
On 23 Sep 2010, at 12:29, covici@ccs.covici.com wrote:
I would like to insert the cdr information when the call hangsup, rather than some kron job or something -- is there a way I can use hangup_api_hook to execute the perl code, or is this too early for cdr_csv to have populated the variables?
Have you considered mod_xml_cdr and having it call a perl script that inserts the CDR immediately into your database (this is what I do, but with PHP) Ross
Too early, the call hangs up then enters the reporting stage where it will write CDRs. 3 approaches I can think of: - Write a perl daemon that monitors the file for filesize/mtime changes and runs if it sees the file change. You could look at either a periodic stat with a sleep smaller than cron allows or using inotify. - Make the CSV a FIFO with your perl daemon at the other end (I'd be wary of that - there's no other copy for backup and if your daemon isn't running the FIFO can fill up and lose CDRs) - Move to mod_xml_cdr which is actually designed for that. You can either use your perl code as a CGI or under apache+mod_perl so you don't have to do a complete rewrite. I'd say mod_xml_cdr is the best approach. -Steve On 23 September 2010 12:29, <covici@ccs.covici.com> wrote:
I would like to insert the cdr information when the call hangsup, rather than some kron job or something -- is there a way I can use hangup_api_hook to execute the perl code, or is this too early for cdr_csv to have populated the variables?
Thanks.
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it?
John Covici covici@ccs.covici.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
OK, thanks for that -- so am I correct that the XML will appear as standard input to the script? And I guess I will have to write out the .csv myself which will be a pain, but its really convenient to have that. Thanks again. Steven Ayre <steveayre@gmail.com> wrote:
Too early, the call hangs up then enters the reporting stage where it will write CDRs.
3 approaches I can think of:
- Write a perl daemon that monitors the file for filesize/mtime changes and runs if it sees the file change. You could look at either a periodic stat with a sleep smaller than cron allows or using inotify. - Make the CSV a FIFO with your perl daemon at the other end (I'd be wary of that - there's no other copy for backup and if your daemon isn't running the FIFO can fill up and lose CDRs) - Move to mod_xml_cdr which is actually designed for that. You can either use your perl code as a CGI or under apache+mod_perl so you don't have to do a complete rewrite.
I'd say mod_xml_cdr is the best approach.
-Steve
On 23 September 2010 12:29, <covici@ccs.covici.com> wrote:
I would like to insert the cdr information when the call hangsup, rather than some kron job or something -- is there a way I can use hangup_api_hook to execute the perl code, or is this too early for cdr_csv to have populated the variables?
Thanks.
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it?
John Covici covici@ccs.covici.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
---------------------------------------------------- Alternatives:
---------------------------------------------------- _______________________________________________ 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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici covici@ccs.covici.com
On Fri, Sep 24, 2010 at 1:29 AM, <covici@ccs.covici.com> wrote:
OK, thanks for that -- so am I correct that the XML will appear as standard input to the script? And I guess I will have to write out the .csv myself which will be a pain, but its really convenient to have that.
I think it depends on your environment but yes, usually it comes in via STDIN. You are probably better off using CGI.pm than manually hacking the input. Since this question has come up more than once I created a simple Perl CGI script that gets called from a Web server. More info here: http://wiki.freeswitch.org/wiki/Mod_xml_cdr#Example_CGI_Script Tinker with that and see if it helps you with handling your CDRs. -MC
Thanks I will look at that -- nice to have an example. Michael Collins <msc@freeswitch.org> wrote:
On Fri, Sep 24, 2010 at 1:29 AM, <covici@ccs.covici.com> wrote:
OK, thanks for that -- so am I correct that the XML will appear as standard input to the script? And I guess I will have to write out the .csv myself which will be a pain, but its really convenient to have that.
I think it depends on your environment but yes, usually it comes in via STDIN. You are probably better off using CGI.pm than manually hacking the input. Since this question has come up more than once I created a simple Perl CGI script that gets called from a Web server. More info here: http://wiki.freeswitch.org/wiki/Mod_xml_cdr#Example_CGI_Script
Tinker with that and see if it helps you with handling your CDRs. -MC
---------------------------------------------------- Alternatives:
---------------------------------------------------- _______________________________________________ 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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici covici@ccs.covici.com
Just load both mod_xml_cdr and mod_cdr_csv at the same time. Both modules will generate a cdr for each call, mod_xml_cdr submitting to the webserver or writing to a .xml file and mod_cdr_csv writing a CDR for the same call to the .csv -Steve On 24 September 2010 09:29, <covici@ccs.covici.com> wrote:
OK, thanks for that -- so am I correct that the XML will appear as standard input to the script? And I guess I will have to write out the .csv myself which will be a pain, but its really convenient to have that.
Thanks again.
Steven Ayre <steveayre@gmail.com> wrote:
Too early, the call hangs up then enters the reporting stage where it will write CDRs.
3 approaches I can think of:
- Write a perl daemon that monitors the file for filesize/mtime changes and runs if it sees the file change. You could look at either a periodic stat with a sleep smaller than cron allows or using inotify. - Make the CSV a FIFO with your perl daemon at the other end (I'd be wary of that - there's no other copy for backup and if your daemon isn't running the FIFO can fill up and lose CDRs) - Move to mod_xml_cdr which is actually designed for that. You can either use your perl code as a CGI or under apache+mod_perl so you don't have to do a complete rewrite.
I'd say mod_xml_cdr is the best approach.
-Steve
On 23 September 2010 12:29, <covici@ccs.covici.com> wrote:
I would like to insert the cdr information when the call hangsup, rather than some kron job or something -- is there a way I can use hangup_api_hook to execute the perl code, or is this too early for cdr_csv to have populated the variables?
Thanks.
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it?
John Covici covici@ccs.covici.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
---------------------------------------------------- Alternatives:
---------------------------------------------------- _______________________________________________ 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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it?
John Covici covici@ccs.covici.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
OK, sounds like a goodidea. Steven Ayre <steveayre@gmail.com> wrote:
Just load both mod_xml_cdr and mod_cdr_csv at the same time.
Both modules will generate a cdr for each call, mod_xml_cdr submitting to the webserver or writing to a .xml file and mod_cdr_csv writing a CDR for the same call to the .csv
-Steve
On 24 September 2010 09:29, <covici@ccs.covici.com> wrote:
OK, thanks for that -- so am I correct that the XML will appear as standard input to the script? And I guess I will have to write out the .csv myself which will be a pain, but its really convenient to have that.
Thanks again.
Steven Ayre <steveayre@gmail.com> wrote:
Too early, the call hangs up then enters the reporting stage where it will write CDRs.
3 approaches I can think of:
- Write a perl daemon that monitors the file for filesize/mtime changes and runs if it sees the file change. You could look at either a periodic stat with a sleep smaller than cron allows or using inotify. - Make the CSV a FIFO with your perl daemon at the other end (I'd be wary of that - there's no other copy for backup and if your daemon isn't running the FIFO can fill up and lose CDRs) - Move to mod_xml_cdr which is actually designed for that. You can either use your perl code as a CGI or under apache+mod_perl so you don't have to do a complete rewrite.
I'd say mod_xml_cdr is the best approach.
-Steve
On 23 September 2010 12:29, <covici@ccs.covici.com> wrote:
I would like to insert the cdr information when the call hangsup, rather than some kron job or something -- is there a way I can use hangup_api_hook to execute the perl code, or is this too early for cdr_csv to have populated the variables?
Thanks.
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it?
John Covici covici@ccs.covici.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
---------------------------------------------------- Alternatives:
---------------------------------------------------- _______________________________________________ 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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it?
John Covici covici@ccs.covici.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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici covici@ccs.covici.com
Why not do it using mod_xml_cdr and posting to a cgi script. That sure makes it flexible. -- Darren Wiebe Sent from my Palm Pre On 23 Sep 2010 5:36 a.m., covici@ccs.covici.com <covici@ccs.covici.com> wrote: I would like to insert the cdr information when the call hangsup, rather than some kron job or something -- is there a way I can use hangup_api_hook to execute the perl code, or is this too early for cdr_csv to have populated the variables? Thanks. -- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici covici@ccs.covici.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
Because I do not have a cgi script and have not looked at mod_xml_cdr yet, and I found this nice simple perl program. Also, I do want to keep the plain text csv file, it comes in handy. Darren Wiebe <darren@aleph-com.net> wrote:
Why not do it using mod_xml_cdr and posting to a cgi script. That sure makes it flexible.
-- Darren Wiebe Sent from my Palm Pre On 23 Sep 2010 5:36 a.m., covici@ccs.covici.com <covici@ccs.covici.com> wrote:
I would like to insert the cdr information when the call hangsup,
rather than some kron job or something -- is there a way I can use
hangup_api_hook to execute the perl code, or is this too early for
cdr_csv to have populated the variables?
Thanks.
--
Your life is like a penny. You're going to lose it. The question is:
How do
you spend it?
John Covici
covici@ccs.covici.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
---------------------------------------------------- Alternatives:
---------------------------------------------------- _______________________________________________ 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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici covici@ccs.covici.com
You can have both mod_xml_cdr and mod_cdr_csv loaded. On Thursday 23 September 2010, covici@ccs.covici.com wrote:
Because I do not have a cgi script and have not looked at mod_xml_cdr yet, and I found this nice simple perl program. Also, I do want to keep the plain text csv file, it comes in handy.
Darren Wiebe <darren@aleph-com.net> wrote:
Why not do it using mod_xml_cdr and posting to a cgi script. That sure makes it flexible.
-- Darren Wiebe Sent from my Palm Pre On 23 Sep 2010 5:36 a.m., covici@ccs.covici.com <covici@ccs.covici.com> wrote:
I would like to insert the cdr information when the call hangsup,
rather than some kron job or something -- is there a way I can use
hangup_api_hook to execute the perl code, or is this too early for
cdr_csv to have populated the variables?
Thanks.
And mod_xml_cdr is by far the most flexible CDR module on any switching platform I have seen to date. It has complete record of what went in the call, including details of applications that ran, the arguments that were passed, and the SDP headers. FreeSWITCH rocks! Regards HASSAN On 2010-09-23, Sergey Okhapkin <sos@sokhapkin.dyndns.org> wrote:
You can have both mod_xml_cdr and mod_cdr_csv loaded.
On Thursday 23 September 2010, covici@ccs.covici.com wrote:
Because I do not have a cgi script and have not looked at mod_xml_cdr yet, and I found this nice simple perl program. Also, I do want to keep the plain text csv file, it comes in handy.
Darren Wiebe <darren@aleph-com.net> wrote:
Why not do it using mod_xml_cdr and posting to a cgi script. That sure makes it flexible.
-- Darren Wiebe Sent from my Palm Pre On 23 Sep 2010 5:36 a.m., covici@ccs.covici.com <covici@ccs.covici.com> wrote:
I would like to insert the cdr information when the call hangsup,
rather than some kron job or something -- is there a way I can use
hangup_api_hook to execute the perl code, or is this too early for
cdr_csv to have populated the variables?
Thanks.
_______________________________________________ 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
-- Sent from my mobile device
i used mod_xml_cdr and keep the whole XML in a db and just pull out only data i need into fields. Its easy to dump sql into a CSV if you need it later. Thanks, Stephen C -All of my email addresses go to the same place -Save Paper, think before you print On Thu, Sep 23, 2010 at 1:54 PM, Nyamul Hassan <mnhassan@usa.net> wrote:
And mod_xml_cdr is by far the most flexible CDR module on any switching platform I have seen to date. It has complete record of what went in the call, including details of applications that ran, the arguments that were passed, and the SDP headers.
FreeSWITCH rocks!
Regards HASSAN
On 2010-09-23, Sergey Okhapkin <sos@sokhapkin.dyndns.org> wrote:
You can have both mod_xml_cdr and mod_cdr_csv loaded.
On Thursday 23 September 2010, covici@ccs.covici.com wrote:
Because I do not have a cgi script and have not looked at mod_xml_cdr yet, and I found this nice simple perl program. Also, I do want to keep the plain text csv file, it comes in handy.
Darren Wiebe <darren@aleph-com.net> wrote:
Why not do it using mod_xml_cdr and posting to a cgi script. That sure makes it flexible.
-- Darren Wiebe Sent from my Palm Pre On 23 Sep 2010 5:36 a.m., covici@ccs.covici.com <covici@ccs.covici.com <lt%3Bcovici@ccs.covici.com>> wrote:
I would like to insert the cdr information when the call hangsup,
rather than some kron job or something -- is there a way I can use
hangup_api_hook to execute the perl code, or is this too early for
cdr_csv to have populated the variables?
Thanks.
_______________________________________________ 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
-- Sent from my mobile device
_______________________________________________ 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
I think that would be an awesome cookbook recipe if not already on the wiki (I have not checked so forgive me if it is). Can you post what you did? Thanks, Anthony C On Thu, 2010-09-23 at 14:00 -0400, stephen at stephenjc wrote:
i used mod_xml_cdr and keep the whole XML in a db and just pull out only data i need into fields. Its easy to dump sql into a CSV if you need it later.
Thanks, Stephen C -All of my email addresses go to the same place -Save Paper, think before you print
That's a neat idea! Would you like to share the SQL Schema of your database? Regards HASSAN On 2010-09-24, stephen at stephenjc <stephen@stephenjc.com> wrote:
i used mod_xml_cdr and keep the whole XML in a db and just pull out only data i need into fields. Its easy to dump sql into a CSV if you need it later.
Thanks, Stephen C -All of my email addresses go to the same place -Save Paper, think before you print
On Thu, Sep 23, 2010 at 1:54 PM, Nyamul Hassan <mnhassan@usa.net> wrote:
And mod_xml_cdr is by far the most flexible CDR module on any switching platform I have seen to date. It has complete record of what went in the call, including details of applications that ran, the arguments that were passed, and the SDP headers.
FreeSWITCH rocks!
Regards HASSAN
On 2010-09-23, Sergey Okhapkin <sos@sokhapkin.dyndns.org> wrote:
You can have both mod_xml_cdr and mod_cdr_csv loaded.
On Thursday 23 September 2010, covici@ccs.covici.com wrote:
Because I do not have a cgi script and have not looked at mod_xml_cdr yet, and I found this nice simple perl program. Also, I do want to keep the plain text csv file, it comes in handy.
Darren Wiebe <darren@aleph-com.net> wrote:
Why not do it using mod_xml_cdr and posting to a cgi script. That sure makes it flexible.
-- Darren Wiebe Sent from my Palm Pre On 23 Sep 2010 5:36 a.m., covici@ccs.covici.com <covici@ccs.covici.com <lt%3Bcovici@ccs.covici.com>> wrote:
I would like to insert the cdr information when the call hangsup,
rather than some kron job or something -- is there a way I can use
hangup_api_hook to execute the perl code, or is this too early for
cdr_csv to have populated the variables?
Thanks.
_______________________________________________ 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
-- Sent from my mobile device
_______________________________________________ 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
-- Sent from my mobile device
Here is my php code and sql. I tried to cut out code that does other things. http://wiki.freeswitch.org/wiki/User:Stephen_c01 Thanks, Stephen C -All of my email addresses go to the same place -Save Paper, think before you print On Thu, Sep 23, 2010 at 3:06 PM, Nyamul Hassan <mnhassan@usa.net> wrote:
That's a neat idea! Would you like to share the SQL Schema of your database?
Regards HASSAN
On 2010-09-24, stephen at stephenjc <stephen@stephenjc.com> wrote:
i used mod_xml_cdr and keep the whole XML in a db and just pull out only data i need into fields. Its easy to dump sql into a CSV if you need it later.
Thanks, Stephen C -All of my email addresses go to the same place -Save Paper, think before you print
On Thu, Sep 23, 2010 at 1:54 PM, Nyamul Hassan <mnhassan@usa.net> wrote:
And mod_xml_cdr is by far the most flexible CDR module on any switching platform I have seen to date. It has complete record of what went in the call, including details of applications that ran, the arguments that were passed, and the SDP headers.
FreeSWITCH rocks!
Regards HASSAN
On 2010-09-23, Sergey Okhapkin <sos@sokhapkin.dyndns.org> wrote:
You can have both mod_xml_cdr and mod_cdr_csv loaded.
On Thursday 23 September 2010, covici@ccs.covici.com wrote:
Because I do not have a cgi script and have not looked at mod_xml_cdr yet, and I found this nice simple perl program. Also, I do want to keep the plain text csv file, it comes in handy.
Darren Wiebe <darren@aleph-com.net> wrote:
Why not do it using mod_xml_cdr and posting to a cgi script. That sure makes it flexible.
-- Darren Wiebe Sent from my Palm Pre On 23 Sep 2010 5:36 a.m., covici@ccs.covici.com <covici@ccs.covici.com <lt%3Bcovici@ccs.covici.com> < lt%3Bcovici@ccs.covici.com <lt%253Bcovici@ccs.covici.com>>> wrote:
I would like to insert the cdr information when the call hangsup,
rather than some kron job or something -- is there a way I can use
hangup_api_hook to execute the perl code, or is this too early for
cdr_csv to have populated the variables?
Thanks.
_______________________________________________ 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
-- Sent from my mobile device
_______________________________________________ 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
-- Sent from my mobile device
_______________________________________________ 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
I am sure you are correct, but I don't need to keep track of all that and I don't have a way to insert into a database using that module -- or at least I am not sure how to do this, whereas I have this nice Perl code which works fine. Nyamul Hassan <mnhassan@usa.net> wrote:
And mod_xml_cdr is by far the most flexible CDR module on any switching platform I have seen to date. It has complete record of what went in the call, including details of applications that ran, the arguments that were passed, and the SDP headers.
FreeSWITCH rocks!
Regards HASSAN
On 2010-09-23, Sergey Okhapkin <sos@sokhapkin.dyndns.org> wrote:
You can have both mod_xml_cdr and mod_cdr_csv loaded.
On Thursday 23 September 2010, covici@ccs.covici.com wrote:
Because I do not have a cgi script and have not looked at mod_xml_cdr yet, and I found this nice simple perl program. Also, I do want to keep the plain text csv file, it comes in handy.
Darren Wiebe <darren@aleph-com.net> wrote:
Why not do it using mod_xml_cdr and posting to a cgi script. That sure makes it flexible.
-- Darren Wiebe Sent from my Palm Pre On 23 Sep 2010 5:36 a.m., covici@ccs.covici.com <covici@ccs.covici.com> wrote:
I would like to insert the cdr information when the call hangsup,
rather than some kron job or something -- is there a way I can use
hangup_api_hook to execute the perl code, or is this too early for
cdr_csv to have populated the variables?
Thanks.
_______________________________________________ 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
-- Sent from my mobile device
_______________________________________________ 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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici covici@ccs.covici.com
When I get back in the office I'll get a link to the script I use for that if you're interested. Darren Wiebe On 23/09/2010 1:04 PM, covici@ccs.covici.com wrote:
I am sure you are correct, but I don't need to keep track of all that and I don't have a way to insert into a database using that module -- or at least I am not sure how to do this, whereas I have this nice Perl code which works fine.
Nyamul Hassan<mnhassan@usa.net> wrote:
And mod_xml_cdr is by far the most flexible CDR module on any switching platform I have seen to date. It has complete record of what went in the call, including details of applications that ran, the arguments that were passed, and the SDP headers.
FreeSWITCH rocks!
Regards HASSAN
On 2010-09-23, Sergey Okhapkin<sos@sokhapkin.dyndns.org> wrote:
You can have both mod_xml_cdr and mod_cdr_csv loaded.
On Thursday 23 September 2010, covici@ccs.covici.com wrote:
Because I do not have a cgi script and have not looked at mod_xml_cdr yet, and I found this nice simple perl program. Also, I do want to keep the plain text csv file, it comes in handy.
Darren Wiebe<darren@aleph-com.net> wrote:
Why not do it using mod_xml_cdr and posting to a cgi script. That sure makes it flexible.
-- Darren Wiebe Sent from my Palm Pre On 23 Sep 2010 5:36 a.m., covici@ccs.covici.com <covici@ccs.covici.com> wrote:
I would like to insert the cdr information when the call hangsup,
rather than some kron job or something -- is there a way I can use
hangup_api_hook to execute the perl code, or is this too early for
cdr_csv to have populated the variables?
Thanks.
_______________________________________________ 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
-- Sent from my mobile device
_______________________________________________ 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
OK, that would be nice because I have not done much with cgi either. Darren Wiebe <darren@aleph-com.net> wrote:
When I get back in the office I'll get a link to the script I use for that if you're interested.
Darren Wiebe
On 23/09/2010 1:04 PM, covici@ccs.covici.com wrote:
I am sure you are correct, but I don't need to keep track of all that and I don't have a way to insert into a database using that module -- or at least I am not sure how to do this, whereas I have this nice Perl code which works fine.
Nyamul Hassan<mnhassan@usa.net> wrote:
And mod_xml_cdr is by far the most flexible CDR module on any switching platform I have seen to date. It has complete record of what went in the call, including details of applications that ran, the arguments that were passed, and the SDP headers.
FreeSWITCH rocks!
Regards HASSAN
On 2010-09-23, Sergey Okhapkin<sos@sokhapkin.dyndns.org> wrote:
You can have both mod_xml_cdr and mod_cdr_csv loaded.
On Thursday 23 September 2010, covici@ccs.covici.com wrote:
Because I do not have a cgi script and have not looked at mod_xml_cdr yet, and I found this nice simple perl program. Also, I do want to keep the plain text csv file, it comes in handy.
Darren Wiebe<darren@aleph-com.net> wrote:
Why not do it using mod_xml_cdr and posting to a cgi script. That sure makes it flexible.
-- Darren Wiebe Sent from my Palm Pre On 23 Sep 2010 5:36 a.m., covici@ccs.covici.com <covici@ccs.covici.com> wrote:
I would like to insert the cdr information when the call hangsup,
rather than some kron job or something -- is there a way I can use
hangup_api_hook to execute the perl code, or is this too early for
cdr_csv to have populated the variables?
Thanks.
_______________________________________________ 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
-- Sent from my mobile device
_______________________________________________ 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
-- Your life is like a penny. You're going to lose it. The question is: How do you spend it? John Covici covici@ccs.covici.com
participants (9)
-
Anthony Cosgrove
-
covici＠ccs.covici.com
-
Darren Wiebe
-
Michael Collins
-
Nyamul Hassan
-
Ross McKillop
-
Sergey Okhapkin
-
stephen at stephenjc
-
Steven Ayre