17 Jan
2013
17 Jan
'13
7:38 p.m.
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
28 Jan
28 Jan
2:32 p.m.
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;
...
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) );
the idea is to update the INVITE record not to select it in future
executions.
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.
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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
- http://conference.kamailio.com -
4 Feb
4 Feb
9:17 p.m.
On 28.01.2013 10:32, Daniel-Constantin Mierla wrote:
Hello,
On 1/17/13 3:38 PM, Klaus Darilion wrote:
I do not get that. AFAIS it will only UPDATE the INVITE, but not the BYE.
regards
Klaus
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) );
the idea is to update the INVITE record not to select it in future
executions.
12 Feb
12 Feb
2:32 p.m.
On 2/4/13 5:17 PM, Klaus Darilion wrote:
On 28.01.2013 10:32, Daniel-Constantin Mierla wrote:
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
Hello,
On 1/17/13 3:38 PM, Klaus Darilion wrote:
I do not get that. AFAIS it will only UPDATE the INVITE, but not the BYE. 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) );
the idea is to update the INVITE record not to select it in future
executions.
regards
Klaus
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
- http://conference.kamailio.com -
18 Feb
18 Feb
10:35 p.m.
On 12.02.2013 10:32, Daniel-Constantin Mierla wrote:
On 2/4/13 5:17 PM, Klaus Darilion wrote:
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 28.01.2013 10:32, Daniel-Constantin Mierla wrote:
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? Hello,
On 1/17/13 3:38 PM, Klaus Darilion wrote:
I do not get that. AFAIS it will only UPDATE the INVITE, but not the BYE. 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) );
the idea is to update the INVITE record not to select it in future
executions.
19 Feb
19 Feb
12:56 p.m.
On 2/18/13 6:35 PM, Klaus Darilion wrote:
[...]
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
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
- http://conference.kamailio.com -
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.
27 Feb
27 Feb
11:44 a.m.
On 19.02.2013 08:56, Daniel-Constantin Mierla wrote:
On 2/18/13 6:35 PM, Klaus Darilion wrote:
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
[...]
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. 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. 
30 Jan
30 Jan
12:28 a.m.
New subject: siremis CDR problem
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
2:17 p.m.
New subject: 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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
- http://conference.kamailio.com -
10:57 p.m.
New subject: siremis CDR problem
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(a)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(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
- http://conference.kamailio.com -
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users(a)lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
12 Feb
12 Feb
2:35 p.m.
New subject: 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(a)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(a)lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
- http://conference.kamailio.com -
14 Feb
14 Feb
3:24 a.m.
New subject: siremis CDR problem
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(a)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(a)lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
- http://conference.kamailio.com -
10:42 p.m.
New subject: 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:
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
- http://conference.kamailio.com -
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(a)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(a)lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
23 Feb
23 Feb
6:21 a.m.
New subject: siremis CDR problem
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:
--
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
- http://conference.kamailio.com -
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(a)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(a)lists.sip-router.org
>> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
4078
days inactive
4119
days old
13 comments
3 participants
participants (3)
-
Daniel-Constantin Mierla -
Klaus Darilion -
Scott, Matt