Hi!
Seems like I am blind. There is a stored procedure which generates CDRs from acc table entries - but how/when does this stored procedure gets triggered?
Thanks Klaus
Hi,
On 7/12/11 2:36 PM, Klaus Darilion wrote:
Hi!
Seems like I am blind. There is a stored procedure which generates CDRs from acc table entries - but how/when does this stored procedure gets triggered?
you can call it periodically from a cron.d job or from kamailio config file by using rtimer module.
Regards, Ramona
Am 12.07.2011 19:13, schrieb Elena-Ramona Modroiu:
Hi,
On 7/12/11 2:36 PM, Klaus Darilion wrote:
Hi!
Seems like I am blind. There is a stored procedure which generates CDRs from acc table entries - but how/when does this stored procedure gets triggered?
you can call it periodically from a cron.d job or from kamailio config file by using rtimer module.
It would be great if you could add config examples to http://kb.asipto.com/siremis:install20:charts
klaus
Am 13.07.2011 09:54, schrieb Klaus Darilion:
Am 12.07.2011 19:13, schrieb Elena-Ramona Modroiu:
Hi,
On 7/12/11 2:36 PM, Klaus Darilion wrote:
Hi!
Seems like I am blind. There is a stored procedure which generates CDRs from acc table entries - but how/when does this stored procedure gets triggered?
you can call it periodically from a cron.d job or from kamailio config file by using rtimer module.
It would be great if you could add config examples to http://kb.asipto.com/siremis:install20:charts
Sorry, the correct URI is: http://kb.asipto.com/siremis:install20:accounting
Am 13.07.2011 09:59, schrieb Klaus Darilion:
Am 13.07.2011 09:54, schrieb Klaus Darilion:
Am 12.07.2011 19:13, schrieb Elena-Ramona Modroiu:
Hi,
On 7/12/11 2:36 PM, Klaus Darilion wrote:
Hi!
Seems like I am blind. There is a stored procedure which generates CDRs from acc table entries - but how/when does this stored procedure gets triggered?
you can call it periodically from a cron.d job or from kamailio config file by using rtimer module.
It would be great if you could add config examples to http://kb.asipto.com/siremis:install20:charts
Sorry, the correct URI is: http://kb.asipto.com/siremis:install20:accounting
You can add the following example of how to populate CDRs from within kamailio.
regards Klaus
# -- for siremis CDRs -------------- modparam("rtimer", "timer", "name=cdr;interval=300;mode=1;") modparam("rtimer", "exec", "timer=cdr;route=CDRS") modparam("sqlops", "sqlcon", "cb=>mysql://openser:passw@localhost/openser")
# ====================================================== # Populate CDRs Table of Siremis # ====================================================== route[CDRS] { sql_query("cb","call kamailio_cdrs()","rb"); }
Hi Klaus,
added to the wiki, thanks,
Ramona
On 7/13/11 11:27 AM, Klaus Darilion wrote:
Am 13.07.2011 09:59, schrieb Klaus Darilion:
Am 13.07.2011 09:54, schrieb Klaus Darilion:
Am 12.07.2011 19:13, schrieb Elena-Ramona Modroiu:
Hi,
On 7/12/11 2:36 PM, Klaus Darilion wrote:
Hi!
Seems like I am blind. There is a stored procedure which generates CDRs from acc table entries - but how/when does this stored procedure gets triggered?
you can call it periodically from a cron.d job or from kamailio config file by using rtimer module.
It would be great if you could add config examples to http://kb.asipto.com/siremis:install20:charts
Sorry, the correct URI is: http://kb.asipto.com/siremis:install20:accounting
You can add the following example of how to populate CDRs from within kamailio.
regards Klaus
# -- for siremis CDRs -------------- modparam("rtimer", "timer", "name=cdr;interval=300;mode=1;") modparam("rtimer", "exec", "timer=cdr;route=CDRS") modparam("sqlops", "sqlcon", "cb=>mysql://openser:passw@localhost/openser")
# ====================================================== # Populate CDRs Table of Siremis # ====================================================== route[CDRS] { sql_query("cb","call kamailio_cdrs()","rb"); }
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list sr-users@lists.sip-router.org http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-
Elena-Ramona Modroiu -
Klaus Darilion