<HTML><HEAD>
<META content="text/html; charset=UTF-8" http-equiv=Content-Type></HEAD>
<BODY dir=ltr bgColor=#ffffff text=#000000>
<DIV dir=ltr>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000"><D
IV>Thanks for your reply.My problem was solved after I use
setflag(FTL_ACCFAILED) in failure route.</DIV><D IV></DIV><D IV>Best Regards.
<DIV></DIV><D
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'
IV><D style="FONT: 10pt Tahoma" IV><D IV><FONT size=3 face=Calibri></FONT>
<DIV></DIV><D style="BACKGROUND: #f5f5f5" IV><D style="font-color: black"
IV><B>From:</B> <A title=miconda@gmail.com
href="mailto:miconda@gmail.com">Daniel-Constantin Mierla</A>
<DIV></DIV><D IV><B>Sent:</B> Friday, March 14, 2014 10:19 PM
<DIV></DIV><D IV><B>To:</B> <A title=sr-users@lists.sip-router.org
href="mailto:sr-users@lists.sip-router.org">Kamailio (SER) - Users Mailing
List</A>
<DIV></DIV><D IV><B>Subject:</B> Re: [SR-Users] db logging for unsuccessful
calls
<DIV></DIV>
<DIV></DIV>
<DIV></DIV><D IV>
<DIV></DIV>
<DIV></DIV><D
style='FONT-SIZE: small; TEXT-DECORATION: none; FONT-FAMILY: "Calibri"; FONT-WEIGHT: normal; COLOR: #000000; FONT-STYLE: normal; DISPLAY: inline'
IV>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><D
class=moz-cite-prefix IV>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></DIV>
<BLOCKQUOTE cite=mid:4F1EC8F9190B44E1818936EF91471CE9@betulpc type="cite"><D
dir=ltr IV><D style="FONT-SIZE: 12pt; FONT-FAMILY: 'Calibri'; COLOR: #000000"
IV><D iv="">Hi to all,</D>
<DIV></DIV><D iv=""></D>
<DIV></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><F
class=mimeAttachmentHeader IELDSET>
<FIELDSET></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>
<P>
<HR>
_______________________________________________<BR>SIP Express Router (SER) and
Kamailio (OpenSER) - sr-users mailing
list<BR>sr-users@lists.sip-router.org<BR>http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users<BR>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV></BODY></HTML>