Hi!
IMO the siremis CDR generation procedure is buggy:
CREATE PROCEDURE `kamailio_cdrs`() DECLARE inv_cursor CURSOR FOR SELECT src_user, src_domain, dst_user, dst_domain, dst_ouser, time, callid,from_tag, to_tag, src_ip FROM acc where method='INVITE' and cdr_id='0'; ... REPEAT FETCH inv_cursor INTO v_src_user, v_src_domain, v_dst_user, v_dst_domain, v_dst_ouser, v_inv_time, v_callid, v_from_tag, v_to_tag, v_src_ip; IF NOT done THEN SET bye_record = 0; SELECT 1, time INTO bye_record, v_bye_time FROM acc WHERE method='BYE' AND callid=v_callid AND ((from_tag=v_from_tag AND to_tag=v_to_tag) OR (from_tag=v_to_tag AND to_tag=v_from_tag)) ORDER BY time ASC LIMIT 1; IF bye_record = 1 THEN INSERT INTO cdrs (src_username,src_domain,dst_username, dst_domain,dst_ousername,call_start_time, duration,sip_call_id, sip_from_tag,sip_to_tag,src_ip,created) VALUES (v_src_user, v_src_domain,v_dst_user, v_dst_domain,v_dst_ouser,v_inv_time, UNIX_TIMESTAMP(v_bye_time)-UNIX_TIMESTAMP(v_inv_time), v_callid,v_from_tag,v_to_tag,v_src_ip,NOW()); UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid AND from_tag=v_from_tag AND to_tag=v_to_tag; END IF; SET done = 0; END IF; UNTIL done END REPEAT; ...
1. The UPDATE query will not UPDATE BYE records which were sent from CALLEE to CALLER. This can be easily fixed with:
UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid AND ( (from_tag=v_from_tag AND to_tag=v_to_tag) OR (to_tag=v_from_tag AND from_tag=v_to_tag) );
2. (minor) It does not consider reINVITEs. I know the default Kamailio config does not account reINVITEs, but I think when reINVITEs are accounted too, this can mess up the CDR generation.
regards Klaus
Hello,
On 1/17/13 3:38 PM, Klaus Darilion wrote:
Hi!
IMO the siremis CDR generation procedure is buggy:
CREATE PROCEDURE `kamailio_cdrs`() DECLARE inv_cursor CURSOR FOR SELECT src_user, src_domain, dst_user, dst_domain, dst_ouser, time, callid,from_tag, to_tag, src_ip FROM acc where method='INVITE' and cdr_id='0'; ... REPEAT FETCH inv_cursor INTO v_src_user, v_src_domain, v_dst_user, v_dst_domain, v_dst_ouser, v_inv_time, v_callid, v_from_tag, v_to_tag, v_src_ip; IF NOT done THEN SET bye_record = 0; SELECT 1, time INTO bye_record, v_bye_time FROM acc WHERE method='BYE' AND callid=v_callid AND ((from_tag=v_from_tag AND to_tag=v_to_tag) OR (from_tag=v_to_tag AND to_tag=v_from_tag)) ORDER BY time ASC LIMIT 1; IF bye_record = 1 THEN INSERT INTO cdrs (src_username,src_domain,dst_username, dst_domain,dst_ousername,call_start_time, duration,sip_call_id, sip_from_tag,sip_to_tag,src_ip,created) VALUES (v_src_user, v_src_domain,v_dst_user, v_dst_domain,v_dst_ouser,v_inv_time, UNIX_TIMESTAMP(v_bye_time)-UNIX_TIMESTAMP(v_inv_time), v_callid,v_from_tag,v_to_tag,v_src_ip,NOW()); UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid AND from_tag=v_from_tag AND to_tag=v_to_tag; END IF; SET done = 0; END IF; UNTIL done END REPEAT; ...
- The UPDATE query will not UPDATE BYE records which were sent from
CALLEE to CALLER. This can be easily fixed with:
UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid AND ( (from_tag=v_from_tag AND to_tag=v_to_tag) OR (to_tag=v_from_tag AND from_tag=v_to_tag) );
the idea is to update the INVITE record not to select it in future executions.
- (minor) It does not consider reINVITEs. I know the default Kamailio
config does not account reINVITEs, but I think when reINVITEs are accounted too, this can mess up the CDR generation.
For re-invites, the accounting record has to be extended with an extra filed to mark the first one from the config. That should be the easiest, timestamp can be another one but will make the sql procedure more complex.
Cheers, Daniel
regards Klaus
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
On 28.01.2013 10:32, Daniel-Constantin Mierla wrote:
Hello,
On 1/17/13 3:38 PM, Klaus Darilion wrote:
Hi!
IMO the siremis CDR generation procedure is buggy:
CREATE PROCEDURE `kamailio_cdrs`() DECLARE inv_cursor CURSOR FOR SELECT src_user, src_domain, dst_user, dst_domain, dst_ouser, time, callid,from_tag, to_tag, src_ip FROM acc where method='INVITE' and cdr_id='0'; ... REPEAT FETCH inv_cursor INTO v_src_user, v_src_domain, v_dst_user, v_dst_domain, v_dst_ouser, v_inv_time, v_callid, v_from_tag, v_to_tag, v_src_ip; IF NOT done THEN SET bye_record = 0; SELECT 1, time INTO bye_record, v_bye_time FROM acc WHERE method='BYE' AND callid=v_callid AND ((from_tag=v_from_tag AND to_tag=v_to_tag) OR (from_tag=v_to_tag AND to_tag=v_from_tag)) ORDER BY time ASC LIMIT 1; IF bye_record = 1 THEN INSERT INTO cdrs (src_username,src_domain,dst_username, dst_domain,dst_ousername,call_start_time, duration,sip_call_id, sip_from_tag,sip_to_tag,src_ip,created) VALUES (v_src_user, v_src_domain,v_dst_user, v_dst_domain,v_dst_ouser,v_inv_time, UNIX_TIMESTAMP(v_bye_time)-UNIX_TIMESTAMP(v_inv_time), v_callid,v_from_tag,v_to_tag,v_src_ip,NOW()); UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid AND from_tag=v_from_tag AND to_tag=v_to_tag; END IF; SET done = 0; END IF; UNTIL done END REPEAT; ...
- The UPDATE query will not UPDATE BYE records which were sent from
CALLEE to CALLER. This can be easily fixed with:
UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid AND ( (from_tag=v_from_tag AND to_tag=v_to_tag) OR (to_tag=v_from_tag AND from_tag=v_to_tag) );the idea is to update the INVITE record not to select it in future executions.
I do not get that. AFAIS it will only UPDATE the INVITE, but not the BYE.
regards Klaus
On 2/4/13 5:17 PM, Klaus Darilion wrote:
On 28.01.2013 10:32, Daniel-Constantin Mierla wrote:
Hello,
On 1/17/13 3:38 PM, Klaus Darilion wrote:
Hi!
IMO the siremis CDR generation procedure is buggy:
CREATE PROCEDURE `kamailio_cdrs`() DECLARE inv_cursor CURSOR FOR SELECT src_user, src_domain, dst_user, dst_domain, dst_ouser, time, callid,from_tag, to_tag, src_ip FROM acc where method='INVITE' and cdr_id='0'; ... REPEAT FETCH inv_cursor INTO v_src_user, v_src_domain, v_dst_user, v_dst_domain, v_dst_ouser, v_inv_time, v_callid, v_from_tag, v_to_tag, v_src_ip; IF NOT done THEN SET bye_record = 0; SELECT 1, time INTO bye_record, v_bye_time FROM acc WHERE method='BYE' AND callid=v_callid AND ((from_tag=v_from_tag AND to_tag=v_to_tag) OR (from_tag=v_to_tag AND to_tag=v_from_tag)) ORDER BY time ASC LIMIT 1; IF bye_record = 1 THEN INSERT INTO cdrs (src_username,src_domain,dst_username, dst_domain,dst_ousername,call_start_time, duration,sip_call_id, sip_from_tag,sip_to_tag,src_ip,created) VALUES (v_src_user, v_src_domain,v_dst_user, v_dst_domain,v_dst_ouser,v_inv_time, UNIX_TIMESTAMP(v_bye_time)-UNIX_TIMESTAMP(v_inv_time), v_callid,v_from_tag,v_to_tag,v_src_ip,NOW()); UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid AND from_tag=v_from_tag AND to_tag=v_to_tag; END IF; SET done = 0; END IF; UNTIL done END REPEAT; ...
- The UPDATE query will not UPDATE BYE records which were sent from
CALLEE to CALLER. This can be easily fixed with:
UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid AND ( (from_tag=v_from_tag AND to_tag=v_to_tag) OR (to_tag=v_from_tag AND from_tag=v_to_tag) );the idea is to update the INVITE record not to select it in future executions.
I do not get that. AFAIS it will only UPDATE the INVITE, but not the BYE.
BYE does not need to be updated, because the cursor goes on INVITE records that have cdr_id=0, then will search for a matching BYE on callid and tags.
Putting cdr for all BYEs can be just for aesthetic purposes, but will not affect CDRs in a bad or good way.
Or do you see another reason why the BYE record needs the cdr_id?
Cheers, Daniel
regards Klaus
On 12.02.2013 10:32, Daniel-Constantin Mierla wrote:
On 2/4/13 5:17 PM, Klaus Darilion wrote:
On 28.01.2013 10:32, Daniel-Constantin Mierla wrote:
Hello,
On 1/17/13 3:38 PM, Klaus Darilion wrote:
Hi!
IMO the siremis CDR generation procedure is buggy:
CREATE PROCEDURE `kamailio_cdrs`() DECLARE inv_cursor CURSOR FOR SELECT src_user, src_domain, dst_user, dst_domain, dst_ouser, time, callid,from_tag, to_tag, src_ip FROM acc where method='INVITE' and cdr_id='0'; ... REPEAT FETCH inv_cursor INTO v_src_user, v_src_domain, v_dst_user, v_dst_domain, v_dst_ouser, v_inv_time, v_callid, v_from_tag, v_to_tag, v_src_ip; IF NOT done THEN SET bye_record = 0; SELECT 1, time INTO bye_record, v_bye_time FROM acc WHERE method='BYE' AND callid=v_callid AND ((from_tag=v_from_tag AND to_tag=v_to_tag) OR (from_tag=v_to_tag AND to_tag=v_from_tag)) ORDER BY time ASC LIMIT 1; IF bye_record = 1 THEN INSERT INTO cdrs (src_username,src_domain,dst_username, dst_domain,dst_ousername,call_start_time, duration,sip_call_id, sip_from_tag,sip_to_tag,src_ip,created) VALUES (v_src_user, v_src_domain,v_dst_user, v_dst_domain,v_dst_ouser,v_inv_time, UNIX_TIMESTAMP(v_bye_time)-UNIX_TIMESTAMP(v_inv_time), v_callid,v_from_tag,v_to_tag,v_src_ip,NOW()); UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid AND from_tag=v_from_tag AND to_tag=v_to_tag; END IF; SET done = 0; END IF; UNTIL done END REPEAT; ...
- The UPDATE query will not UPDATE BYE records which were sent from
CALLEE to CALLER. This can be easily fixed with:
UPDATE acc SET cdr_id=last_insert_id() WHERE callid=v_callid AND ( (from_tag=v_from_tag AND to_tag=v_to_tag) OR (to_tag=v_from_tag AND from_tag=v_to_tag) );the idea is to update the INVITE record not to select it in future executions.
I do not get that. AFAIS it will only UPDATE the INVITE, but not the BYE.
BYE does not need to be updated, because the cursor goes on INVITE records that have cdr_id=0, then will search for a matching BYE on callid and tags.
Putting cdr for all BYEs can be just for aesthetic purposes, but will not affect CDRs in a bad or good way.
Or do you see another reason why the BYE record needs the cdr_id?
I just found that it is strange that some BYEs have a cdr_id and others don't. IMO it would nice to set cdr_id in all transactions which were sucessfully used to generate a call-CDR.
regards Klaus
On 2/18/13 6:35 PM, Klaus Darilion wrote:
[...]
Or do you see another reason why the BYE record needs the cdr_id?
I just found that it is strange that some BYEs have a cdr_id and others don't. IMO it would nice to set cdr_id in all transactions which were sucessfully used to generate a call-CDR.
That can be added for aesthetic purposes, can be included in next version, but is not a bug in the current form. ANother option would enable detect direction in acc module.
Cheers, Daniel
On 19.02.2013 08:56, Daniel-Constantin Mierla wrote:
On 2/18/13 6:35 PM, Klaus Darilion wrote:
[...]
Or do you see another reason why the BYE record needs the cdr_id?
I just found that it is strange that some BYEs have a cdr_id and others don't. IMO it would nice to set cdr_id in all transactions which were sucessfully used to generate a call-CDR.
That can be added for aesthetic purposes, can be included in next version, but is not a bug in the current form. ANother option would enable detect direction in acc module.
Indeed. The main reason behind this feature-request was that I easily wanted to spot transactions which could not be processed by the CDR generation script, and I was using "WHERE cdr_id=0" to detect this transactions.
regards Klaus
Anybody have a working model?
I am following here, but I can't load kam with this code. http://kb.asipto.com/siremis:install32x:accounting
# ====================================================== # Populate CDRs Table of Siremis # ====================================================== route[CDRS] { sql_query("cb","call kamailio_cdrs()","rb"); sql_query("cb","call kamailio_rating('default')","rb");
Looking at my table they are empty.
Matt Scott
Have you enabled the acc db accounting in kamailio config file?
Cheers, Daniel
On 1/29/13 8:28 PM, Scott, Matt wrote:
Anybody have a working model?
I am following here, but I can't load kam with this code. http://kb.asipto.com/siremis:install32x:accounting
# ====================================================== # Populate CDRs Table of Siremis # ====================================================== route[CDRS] { sql_query("cb","call kamailio_cdrs()","rb"); sql_query("cb","call kamailio_rating('default')","rb");
Looking at my table they are empty.
Matt Scott
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
Thanks for responding, yes I think I have all that ready. Not sure if accdb_comment was needed, but I enabled. We deleted the tables, and re-created based on tutorial. MySql is running, as I'm using dispatcher in db mode.
Any other thoughts?
loadmodule "acc.so"
#### ---- enabling accountingdb here by matt --- #!define WITH_ACCDB #!define WITH_ACCDB_COMMENT
# ----- acc params ----- /* what special events should be accounted ? */ modparam("acc", "early_media", 0) modparam("acc", "report_ack", 0) modparam("acc", "report_cancels", 0) /* by default ww do not adjust the direct of the sequential requests. if you enable this parameter, be sure the enable "append_fromtag" in "rr" module */ modparam("acc", "detect_direction", 0) /* account triggers (flags) */ modparam("acc", "log_flag", FLT_ACC) modparam("acc", "log_missed_flag", FLT_ACCMISSED) modparam("acc", "log_extra", "src_user=$fU;src_domain=$fd;src_ip=$si;" "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd") modparam("acc", "failed_transaction_flag", FLT_ACCFAILED) /* enhanced DB accounting */ #!ifdef WITH_ACCDB modparam("acc", "db_flag", FLT_ACC) modparam("acc", "db_missed_flag", FLT_ACCMISSED) modparam("acc", "db_url", DBURL) modparam("acc", "db_extra", "src_user=$fU;src_domain=$fd;src_ip=$si;" "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd") #!endif
Matt Scott 303-963-2990 | Telephony Administrator
-----Original Message----- From: sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Daniel-Constantin Mierla Sent: Wednesday, January 30, 2013 2:18 AM To: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List Subject: Re: [SR-Users] siremis CDR problem
Have you enabled the acc db accounting in kamailio config file?
Cheers, Daniel
On 1/29/13 8:28 PM, Scott, Matt wrote:
Anybody have a working model?
I am following here, but I can't load kam with this code. http://kb.asipto.com/siremis:install32x:accounting
# ====================================================== # Populate CDRs Table of Siremis # ====================================================== route[CDRS] { sql_query("cb","call kamailio_cdrs()","rb"); sql_query("cb","call kamailio_rating('default')","rb");
Looking at my table they are empty.
Matt Scott
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
On 1/30/13 6:57 PM, Scott, Matt wrote:
Thanks for responding, yes I think I have all that ready. Not sure if accdb_comment was needed, but I enabled.
accdb_comment is not needed, but it is fine because it is defined after is used in an #!ifdef, because it would through errors.
We deleted the tables, and re-created based on tutorial. MySql is running, as I'm using dispatcher in db mode.
Any other thoughts?
Do you get records in acc table? Any error messages in the syslog?
Cheers, Daniel
loadmodule "acc.so"
#### ---- enabling accountingdb here by matt --- #!define WITH_ACCDB #!define WITH_ACCDB_COMMENT
# ----- acc params ----- /* what special events should be accounted ? */ modparam("acc", "early_media", 0) modparam("acc", "report_ack", 0) modparam("acc", "report_cancels", 0) /* by default ww do not adjust the direct of the sequential requests. if you enable this parameter, be sure the enable "append_fromtag" in "rr" module */ modparam("acc", "detect_direction", 0) /* account triggers (flags) */ modparam("acc", "log_flag", FLT_ACC) modparam("acc", "log_missed_flag", FLT_ACCMISSED) modparam("acc", "log_extra", "src_user=$fU;src_domain=$fd;src_ip=$si;" "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd") modparam("acc", "failed_transaction_flag", FLT_ACCFAILED) /* enhanced DB accounting */ #!ifdef WITH_ACCDB modparam("acc", "db_flag", FLT_ACC) modparam("acc", "db_missed_flag", FLT_ACCMISSED) modparam("acc", "db_url", DBURL) modparam("acc", "db_extra", "src_user=$fU;src_domain=$fd;src_ip=$si;" "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd") #!endif
Matt Scott 303-963-2990 | Telephony Administrator
-----Original Message----- From: sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Daniel-Constantin Mierla Sent: Wednesday, January 30, 2013 2:18 AM To: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List Subject: Re: [SR-Users] siremis CDR problem
Have you enabled the acc db accounting in kamailio config file?
Cheers, Daniel
On 1/29/13 8:28 PM, Scott, Matt wrote:
Anybody have a working model?
I am following here, but I can't load kam with this code. http://kb.asipto.com/siremis:install32x:accounting
# ====================================================== # Populate CDRs Table of Siremis # ====================================================== route[CDRS] { sql_query("cb","call kamailio_cdrs()","rb"); sql_query("cb","call kamailio_rating('default')","rb");
Looking at my table they are empty.
Matt Scott
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
No records in acc table. I usually grep logs, so I never noticed.
That's not good.
Feb 13 14:17:08 psbcpr002 kamailio: DEBUG: <core> [cfg.y:1772]: loading module acc.so Feb 13 14:17:08 psbcpr002 kamailio: DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/lib64/kamailio/modules_k/acc.so> Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4525]: DEBUG: <core> [sr_module.c:935]: DEBUG: init_mod: acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4531]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4532]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (2): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4534]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (3): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4536]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (4): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4537]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-1): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4539]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-1): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4546]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-4): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4545]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-2): acc
Matt Scott 303-963-2990 | Telephony Administrator
-----Original Message----- From: Daniel-Constantin Mierla [mailto:miconda@gmail.com] Sent: Tuesday, February 12, 2013 2:35 AM To: Scott, Matt; 'SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List' Subject: Re: [SR-Users] siremis CDR problem
On 1/30/13 6:57 PM, Scott, Matt wrote:
Thanks for responding, yes I think I have all that ready. Not sure if accdb_comment was needed, but I enabled.
accdb_comment is not needed, but it is fine because it is defined after is used in an #!ifdef, because it would through errors.
We deleted the tables, and re-created based on tutorial. MySql is running, as I'm using dispatcher in db mode.
Any other thoughts?
Do you get records in acc table? Any error messages in the syslog?
Cheers, Daniel
loadmodule "acc.so"
#### ---- enabling accountingdb here by matt --- #!define WITH_ACCDB #!define WITH_ACCDB_COMMENT
# ----- acc params ----- /* what special events should be accounted ? */ modparam("acc", "early_media", 0) modparam("acc", "report_ack", 0) modparam("acc", "report_cancels", 0) /* by default ww do not adjust the direct of the sequential requests. if you enable this parameter, be sure the enable "append_fromtag" in "rr" module */ modparam("acc", "detect_direction", 0) /* account triggers (flags) */ modparam("acc", "log_flag", FLT_ACC) modparam("acc", "log_missed_flag", FLT_ACCMISSED) modparam("acc", "log_extra", "src_user=$fU;src_domain=$fd;src_ip=$si;" "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd") modparam("acc", "failed_transaction_flag", FLT_ACCFAILED) /* enhanced DB accounting */ #!ifdef WITH_ACCDB modparam("acc", "db_flag", FLT_ACC) modparam("acc", "db_missed_flag", FLT_ACCMISSED) modparam("acc", "db_url", DBURL) modparam("acc", "db_extra", "src_user=$fU;src_domain=$fd;src_ip=$si;" "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd") #!endif
Matt Scott 303-963-2990 | Telephony Administrator
-----Original Message----- From: sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Daniel-Constantin Mierla Sent: Wednesday, January 30, 2013 2:18 AM To: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List Subject: Re: [SR-Users] siremis CDR problem
Have you enabled the acc db accounting in kamailio config file?
Cheers, Daniel
On 1/29/13 8:28 PM, Scott, Matt wrote:
Anybody have a working model?
I am following here, but I can't load kam with this code. http://kb.asipto.com/siremis:install32x:accounting
# ====================================================== # Populate CDRs Table of Siremis # ====================================================== route[CDRS] { sql_query("cb","call kamailio_cdrs()","rb"); sql_query("cb","call kamailio_rating('default')","rb");
Looking at my table they are empty.
Matt Scott
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
These are the logs for starting up kamailio. What the logs processing the invite and the 200 ok reply to it?
Cheers, Daniel
On 2/13/13 11:24 PM, Scott, Matt wrote:
No records in acc table. I usually grep logs, so I never noticed.
That's not good.
Feb 13 14:17:08 psbcpr002 kamailio: DEBUG: <core> [cfg.y:1772]: loading module acc.so Feb 13 14:17:08 psbcpr002 kamailio: DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/lib64/kamailio/modules_k/acc.so> Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4525]: DEBUG: <core> [sr_module.c:935]: DEBUG: init_mod: acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4531]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4532]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (2): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4534]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (3): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4536]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (4): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4537]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-1): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4539]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-1): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4546]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-4): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4545]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-2): acc
Matt Scott 303-963-2990 | Telephony Administrator
-----Original Message----- From: Daniel-Constantin Mierla [mailto:miconda@gmail.com] Sent: Tuesday, February 12, 2013 2:35 AM To: Scott, Matt; 'SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List' Subject: Re: [SR-Users] siremis CDR problem
On 1/30/13 6:57 PM, Scott, Matt wrote:
Thanks for responding, yes I think I have all that ready. Not sure if accdb_comment was needed, but I enabled.
accdb_comment is not needed, but it is fine because it is defined after is used in an #!ifdef, because it would through errors.
We deleted the tables, and re-created based on tutorial. MySql is running, as I'm using dispatcher in db mode.
Any other thoughts?
Do you get records in acc table? Any error messages in the syslog?
Cheers, Daniel
loadmodule "acc.so"
#### ---- enabling accountingdb here by matt --- #!define WITH_ACCDB #!define WITH_ACCDB_COMMENT
# ----- acc params ----- /* what special events should be accounted ? */ modparam("acc", "early_media", 0) modparam("acc", "report_ack", 0) modparam("acc", "report_cancels", 0) /* by default ww do not adjust the direct of the sequential requests. if you enable this parameter, be sure the enable "append_fromtag" in "rr" module */ modparam("acc", "detect_direction", 0) /* account triggers (flags) */ modparam("acc", "log_flag", FLT_ACC) modparam("acc", "log_missed_flag", FLT_ACCMISSED) modparam("acc", "log_extra", "src_user=$fU;src_domain=$fd;src_ip=$si;" "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd") modparam("acc", "failed_transaction_flag", FLT_ACCFAILED) /* enhanced DB accounting */ #!ifdef WITH_ACCDB modparam("acc", "db_flag", FLT_ACC) modparam("acc", "db_missed_flag", FLT_ACCMISSED) modparam("acc", "db_url", DBURL) modparam("acc", "db_extra", "src_user=$fU;src_domain=$fd;src_ip=$si;" "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd") #!endif
Matt Scott 303-963-2990 | Telephony Administrator
-----Original Message----- From: sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Daniel-Constantin Mierla Sent: Wednesday, January 30, 2013 2:18 AM To: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List Subject: Re: [SR-Users] siremis CDR problem
Have you enabled the acc db accounting in kamailio config file?
Cheers, Daniel
On 1/29/13 8:28 PM, Scott, Matt wrote:
Anybody have a working model?
I am following here, but I can't load kam with this code. http://kb.asipto.com/siremis:install32x:accounting
# ====================================================== # Populate CDRs Table of Siremis # ====================================================== route[CDRS] { sql_query("cb","call kamailio_cdrs()","rb"); sql_query("cb","call kamailio_rating('default')","rb");
Looking at my table they are empty.
Matt Scott
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
Yay, got it fixed. I grep'd my logs for ERROR, and finally noticed this. Added the missing dst_ouser in ACC and missed_calls.
Feb 22 17:02:45 pbr /usr/sbin/kamailio[16623]: ERROR: db_mysql [km_dbase.c:122]: driver error on query: Unknown column 'dst_ouser' in 'field list' Feb 22 17:02:45 pbr /usr/sbin/kamailio[16623]: ERROR: <core> [db_query.c:210]: error while submitting query Feb 22 17:02:45 pbr /usr/sbin/kamailio[16623]: ERROR: acc [acc.c:404]: failed to insert into database
Thanks for the help!
Matt Scott
-----Original Message----- From: Daniel-Constantin Mierla [mailto:miconda@gmail.com] Sent: Thursday, February 14, 2013 10:43 AM To: Scott, Matt; 'SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List' Subject: Re: [SR-Users] siremis CDR problem
These are the logs for starting up kamailio. What the logs processing the invite and the 200 ok reply to it?
Cheers, Daniel
On 2/13/13 11:24 PM, Scott, Matt wrote:
No records in acc table. I usually grep logs, so I never noticed.
That's not good.
Feb 13 14:17:08 psbcpr002 kamailio: DEBUG: <core> [cfg.y:1772]: loading module acc.so Feb 13 14:17:08 psbcpr002 kamailio: DEBUG: <core> [sr_module.c:564]: load_module: trying to load </usr/lib64/kamailio/modules_k/acc.so> Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4525]: DEBUG: <core> [sr_module.c:935]: DEBUG: init_mod: acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4531]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (1): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4532]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (2): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4534]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (3): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4536]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (4): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4537]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-1): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4539]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-1): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4546]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-4): acc Feb 13 14:17:08 psbcpr002 /usr/sbin/kamailio[4545]: DEBUG: <core> [sr_module.c:892]: DEBUG: init_mod_child (-2): acc
Matt Scott 303-963-2990 | Telephony Administrator
-----Original Message----- From: Daniel-Constantin Mierla [mailto:miconda@gmail.com] Sent: Tuesday, February 12, 2013 2:35 AM To: Scott, Matt; 'SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List' Subject: Re: [SR-Users] siremis CDR problem
On 1/30/13 6:57 PM, Scott, Matt wrote:
Thanks for responding, yes I think I have all that ready. Not sure if accdb_comment was needed, but I enabled.
accdb_comment is not needed, but it is fine because it is defined after is used in an #!ifdef, because it would through errors.
We deleted the tables, and re-created based on tutorial. MySql is running, as I'm using dispatcher in db mode.
Any other thoughts?
Do you get records in acc table? Any error messages in the syslog?
Cheers, Daniel
loadmodule "acc.so"
#### ---- enabling accountingdb here by matt --- #!define WITH_ACCDB #!define WITH_ACCDB_COMMENT
# ----- acc params ----- /* what special events should be accounted ? */ modparam("acc", "early_media", 0) modparam("acc", "report_ack", 0) modparam("acc", "report_cancels", 0) /* by default ww do not adjust the direct of the sequential requests. if you enable this parameter, be sure the enable "append_fromtag" in "rr" module */ modparam("acc", "detect_direction", 0) /* account triggers (flags) */ modparam("acc", "log_flag", FLT_ACC) modparam("acc", "log_missed_flag", FLT_ACCMISSED) modparam("acc", "log_extra", "src_user=$fU;src_domain=$fd;src_ip=$si;" "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd") modparam("acc", "failed_transaction_flag", FLT_ACCFAILED) /* enhanced DB accounting */ #!ifdef WITH_ACCDB modparam("acc", "db_flag", FLT_ACC) modparam("acc", "db_missed_flag", FLT_ACCMISSED) modparam("acc", "db_url", DBURL) modparam("acc", "db_extra", "src_user=$fU;src_domain=$fd;src_ip=$si;" "dst_ouser=$tU;dst_user=$rU;dst_domain=$rd") #!endif
Matt Scott 303-963-2990 | Telephony Administrator
-----Original Message----- From: sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Daniel-Constantin Mierla Sent: Wednesday, January 30, 2013 2:18 AM To: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List Subject: Re: [SR-Users] siremis CDR problem
Have you enabled the acc db accounting in kamailio config file?
Cheers, Daniel
On 1/29/13 8:28 PM, Scott, Matt wrote:
Anybody have a working model?
I am following here, but I can't load kam with this code. http://kb.asipto.com/siremis:install32x:accounting
# ====================================================== # Populate CDRs Table of Siremis # ====================================================== route[CDRS] { sql_query("cb","call kamailio_cdrs()","rb"); sql_query("cb","call kamailio_rating('default')","rb");
Looking at my table they are empty.
Matt Scott
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
-
Daniel-Constantin Mierla -
Klaus Darilion -
Scott, Matt