<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
if you defined WITH_ACCDB, then the records should be in the acc
table, provided that you created the extra columns. Look at your
syslog (/var/log/syslog or /var/log/messages) to see if there is any
error.<br>
<br>
To aggregate INVITE and BYE records for getting full CDRs, you need
to write a script for it. You can eventually reuse the stored
procedure from siremis, you can find it at:<br>
<br>
-
<a class="moz-txt-link-freetext" href="http://sourceforge.net/p/siremis/git/ci/master/tree/siremis/modules/ser/mod.install.siremis.sql">http://sourceforge.net/p/siremis/git/ci/master/tree/siremis/modules/ser/mod.install.siremis.sql</a><br>
<br>
The stored procedure can be called from kamailio.cfg, hints at:<br>
<br>
-
<a class="moz-txt-link-freetext" href="http://kb.asipto.com/siremis:install40x:accounting#kamailiocfg_for_generating_and_rating_cdrs">http://kb.asipto.com/siremis:install40x:accounting#kamailiocfg_for_generating_and_rating_cdrs</a><br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 14/03/14 14:42,
<a class="moz-txt-link-abbreviated" href="mailto:betul.cerit@netgsm.com.tr">betul.cerit@netgsm.com.tr</a> wrote:<br>
</div>
<blockquote cite="mid:4F1EC8F9190B44E1818936EF91471CE9@betulpc"
type="cite">
<div dir="ltr">
<div style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR:
#000000"><d iv="">Hi to all,</d></div>
<d iv=""></d></div>
<d iv="">I could hardly make kamailio log cdr to db but it just
logs successful calls.I need cdr of unsuccessful calls also.I
used to use asterisk so in cdr I need duration and billsec
separately.As far as I understand kamailio can give only one of
them.Is there a way to get them?
<d iv="">
<d iv="">Here is my acc configuration:
<d iv="">
<d iv="">
<d iv="">#!ifdef WITH_ACCDB
<d iv="">modparam("acc", "cdr_enable", 1)
<d iv="">modparam("acc", "early_media", 0)
<d iv="">modparam("acc", "report_ack", 1)
<d iv="">modparam("acc", "report_cancels", 1)
<d iv="">modparam("acc", "detect_direction",
0)
<d iv="">modparam("acc", "db_url",
"mysql://root: secret@localhost/mydb")
<d iv="">modparam("acc", "log_flag",
FLT_ACC)
<d iv="">modparam("acc",
"db_missed_flag", FLT_ACCMISSED)
<d iv="">modparam("acc",
"db_table_missed_calls",
"missed_calls")
<d iv="">modparam("acc", "db_flag",
1)
<d iv="">modparam("acc",
"db_missed_flag", 3)
<d iv="">modparam("acc",
"db_extra","src_user=$fU;src_domain=$fd;src_ip=$si;dst_user=$rU;dst_domain=$rd")<d
iv="">#!endif
<d iv="">
<d iv="">What should I
exactly do?Can someone
help?
<d iv="">
<d iv="">Thanks in
Advance.
<d iv="">
<d iv="">BETÜL
CERİT
<br>
<fieldset
class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</d></d></d></d></d></d></d></d></d></d></d></d></d></d></d></d></d></d></d></d></d></d></d></d></d></blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a>
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Kamailio World Conference - April 2-4, 2014, Berlin, Germany
<a class="moz-txt-link-freetext" href="http://www.kamailioworld.com">http://www.kamailioworld.com</a></pre>
</body>
</html>