<html>
  <head>
    <meta content="text/html; charset=windows-1252"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Hello,<br>
    <br>
    with latest version you can get the cdrs at once via dialog+acc
    module.<br>
    <br>
    If you want to use the classic acc, then add either
    event_route[dialog:end] or event_route[tm:local-request]. There you
    can get actions when the dialog is ended  (including the time out),
    and for the second you get the BYE sent out. Perhaps SQLOPS with
    sql_query() or acc_db_requests() should be used to record the event
    in db table.<br>
    <br>
    Cheers,<br>
    Daniel<br>
    <br>
    <div class="moz-cite-prefix">On 04/08/14 15:19,
      <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:77E158044B904C63AFC5CE848AA59B58@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 want to limit call duration according to the credit of
        the user.To accomplish this I use timeout_avp .When the limit is
        reached call ends but no record associated with BYE method is
        inserted to the acc table and that makes impossible to bill that
        call.What can I do to solve this problem or is there an
        alternative way to limit call duration?My configuration and logs
        are as follows.
        <d iv="">
          <d iv="">BEST REGARDS.
            <d iv="">
              <d iv="">#---------------- dialog params -------------
                <d iv="">#!ifdef WITH_DIALOG
                  <d iv="">modparam("dialog", "enable_stats", 1)
                    <d iv="">modparam("dialog", "hash_size", 8192)
                      <d iv="">modparam("dialog", "rr_param", "did")
                        <d iv="">modparam("dialog", "dlg_flag",4)
                          <d iv="">modparam("dialog", "timeout_avp",
                            "$avp(i:10)")
                            <d iv="">modparam("dialog",
                              "dlg_match_mode", 1)
                              <d iv="">modparam("dialog",
                                "default_timeout", 3600)
                                <d iv="">modparam("dialog",
                                  "detect_spirals", 1)
                                  <d iv="">modparam("dialog",
                                    "profiles_with_value", "userid ;
                                    opkodu")
                                    <d iv="">modparam("dialog",
                                      "dlg_extra_hdrs", "Hint: Hell
                                      Yeah\r\n")
                                      <d iv="">modparam("dialog",
                                        "send_bye", 1)
                                        <d iv="">#endif
                                          <d iv="">
                                            <d iv="">--------------------------------------------------------------------------------
                                              <d iv="">
                                                <d iv="">route[SW]{
                                                  <d iv="">xlog("L_INFO","Dialog:h_id:$dlg(h_id):h_entry:$dlg(h_entry):timeout:$dlg_ctx(timeout_route):bye:$dlg_ctx(timeout_bye):$avp(i:10)");
                                                    <d iv="">               
$dlg_ctx(timeout_bye)=1;
                                                      <d iv="">               
                                                        $avp(i:10)=15;
                                                        <d iv="">               
$dlg_ctx(timeout_route)=33;
                                                          <d iv="">
                                                          <d iv="">                
                                                          dlg_manage();
                                                          <d iv="">                
set_dlg_profile("userid","$avp(userid)");
                                                          <d iv="">               
if(get_profile_size("userid","$avp(s_userid)")){
                                                          <d iv="">                       
xlog("L_INFO","Userid_Size:$avp(s_userid)");
                                                          <d iv="">               
                                                          }
                                                          <d iv="">xlog("L_INFO","Dialog:h_id:$dlg(h_id):h_entry:$dlg(h_entry):timeout:$dlg_ctx(timeout_route):bye:$dlg_ctx(timeout_bye):$avp(i:10)");
                                                          <d iv="">       
                                                          if(!t_relay())
                                                          {
                                                          <d iv="">                
                                                          send_reply("408",
                                                          "Servis
                                                          Disi");
                                                          <d iv="">       
                                                          }else{
                                                          <d iv="">                
                                                          exit;
                                                          <d iv="">       
                                                          }
                                                          <d iv="">       
                                                          return;
                                                          <d iv="">}
                                                          <d iv="">event_route[dialog:start]{
                                                          <d iv="">       
xlog("L_ALERT","START:ci:$ci:method:$rm:start");
                                                          <d iv="">}
                                                          <d iv="">event_route[dialog:end]{
                                                          <d iv="">       
xlog("L_ALERT","END");
                                                          <d iv="">       
xlog("L_ALERT","END:$fU:$fd:$si:$rU:$rd:$avp(poparty):$avp(networkdatetime):$avp(ptparty):$avp(pprovider):$avp(maliyet_id):$avp(tibtip)");
                                                          <d iv="">       
xlog("L_ALERT","END:$rm:$rr:$rs:");
                                                          <d iv="">}
                                                          <d iv="">event_route[dialog:failed]{
                                                          <d iv="">
                                                          <d iv="">       
xlog("L_INFO","FAILED:ci:$ci:method:$rm:end");
                                                          <d iv="">}
                                                          <d iv="">route[33]{
                                                          <d iv="">       
xlog("L_INFO","route:33:$fU:$fd:$si:$rU:$rd:$avp(poparty):$avp(networkdatetime):$avp(ptparty):$avp(pprovider):$avp(maliyet_id):$avp(tibtip)");
                                                          <d iv="">       
xlog("L_INFO","route:33:$rm:$rr:$rs:");
                                                          <d iv="">}
                                                          <d iv="">#
                                                          Handle
                                                          requests
                                                          within SIP
                                                          dialogs
                                                          <d iv="">route[WITHINDLG]
                                                          {
                                                          <d iv="">       
                                                          if
                                                          (has_totag())
                                                          {
                                                          <d iv="">               
                                                          # sequential
                                                          request
                                                          withing a
                                                          dialog should
                                                          <d iv="">               
                                                          # take the
                                                          path
                                                          determined by
                                                          record-routing
                                                          <d iv="">               
                                                          if
                                                          (loose_route())
                                                          {
                                                          <d iv="">                       
                                                          route(DLGURI);
                                                          <d iv="">                       
                                                          if
                                                          (is_method("BYE"))
                                                          {
                                                          <d iv="">                               
                                                          setflag(FLT_ACC);
                                                          # do
                                                          accounting ...
                                                          <d iv="">                               
                                                          setflag(FLT_ACCFAILED);
                                                          # ... even if
                                                          the
                                                          transaction
                                                          fails
                                                          <d iv="">                       
                                                          }
                                                          <d iv="">                       
                                                          else if (
                                                          is_method("ACK")
                                                          ) {
                                                          <d iv="">                               
                                                          # ACK is
                                                          forwarded
                                                          statelessy
                                                          <d iv="">                               
route(NATMANAGE);
                                                          <d iv="">                       
                                                          }
                                                          <d iv="">                       
                                                          else if (
                                                          is_method("NOTIFY")
                                                          ) {
                                                          <d iv="">                               
                                                          # Add
                                                          Record-Route
                                                          for in-dialog
                                                          NOTIFY as per
                                                          RFC 6665.
                                                          <d iv="">                               
record_route();
                                                          <d iv="">                       
                                                          }
                                                          <d iv="">                       
                                                          route(RELAY);
                                                          <d iv="">               
                                                          } else {
                                                          <d iv="">                       
                                                          if
                                                          (is_method("SUBSCRIBE")
                                                          && uri
                                                          == myself) {
                                                          <d iv="">                               
                                                          # in-dialog
                                                          subscribe
                                                          requests
                                                          <d iv="">                               
route(PRESENCE);
                                                          <d iv="">                               
                                                          exit;
                                                          <d iv="">                       
                                                          }
                                                          <d iv="">                       
                                                          if (
                                                          is_method("ACK")
                                                          ) {
                                                          <d iv="">                               
                                                          if (
                                                          t_check_trans()
                                                          ) {
                                                          <d iv="">                                       
                                                          # no
                                                          loose-route,
                                                          but stateful
                                                          ACK;
                                                          <d iv="">                                       
                                                          # must be an
                                                          ACK after a
                                                          487
                                                          <d iv="">                                       
                                                          # or e.g. 404
                                                          from upstream
                                                          server
                                                          <d iv="">                                       
                                                          route(RELAY);
                                                          <d iv="">                                       
                                                          exit;
                                                          <d iv="">                               
                                                          } else {
                                                          <d iv="">                                       
                                                          # ACK without
                                                          matching
                                                          transaction
                                                          ... ignore and
                                                          discard
                                                          <d iv="">                                       
                                                          exit;
                                                          <d iv="">                               
                                                          }
                                                          <d iv="">                       
                                                          }
                                                          <d iv="">        
                                                          sl_send_reply("404","Not
                                                          here");
                                                          <d iv="">               
                                                          }
                                                          <d iv="">               
                                                          exit;
                                                          <d iv="">       
                                                          }
                                                          <d iv="">}
                                                          <d iv="">
                                                          <d iv="">
                                                          <d iv="">--------------------------------------------------------------------------------
                                                          <d iv="">Aug 
                                                          1 16:51:52
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6111]:
                                                          ALERT:
                                                          <script>:
                                                          USERID:456123
                                                          <d iv="">Aug 
                                                          1 16:51:52
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6111]:
                                                          ALERT:
                                                          <script>:
arayan:XXXX:aranan:XXXXX
                                                          <d iv="">Aug 
                                                          1 16:51:52
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6111]:
                                                          INFO:
                                                          carrierroute
                                                          [cr_func.c:710]:
                                                          cr_do_route():
                                                          uri XXXX was
                                                          rewritten to
                                                          <a class="moz-txt-link-freetext" href="sip:YYYYYYYYYYYYYYY@XXXXXXX5:5060">sip:YYYYYYYYYYYYYYY@XXXXXXX5:5060</a>,
                                                          carrier 3,
                                                          domain 1
                                                          <d iv="">Aug 
                                                          1 16:51:52
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6111]:
                                                          INFO:
                                                          <script>:
                                                          vardesc: 40
                                                          <d iv="">Aug 
                                                          1 16:51:52
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6111]:
                                                          INFO:
                                                          <script>:
Dialog:h_id:<null>:h_entry:<null>:timeout:0:bye:0:<null>
                                                          <d iv="">Aug 
                                                          1 16:51:52
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6111]:
                                                          INFO:
                                                          <script>:
                                                          Userid_Size:1
                                                          <d iv="">Aug 
                                                          1 16:51:52
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6111]:
                                                          INFO:
                                                          <script>:
Dialog:h_id:3953:h_entry:3170:timeout:14:bye:1:15
                                                          <d iv="">Aug 
                                                          1 16:51:55
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6114]:
                                                          ALERT:
                                                          <script>:
START:ci:2c5695c1644fa2b135f57ea72c590cc7@XXXXXXX:5060:method:INVITE:start
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          ERROR:
                                                          <core>
                                                          [parser/parse_from.c:113]:
                                                          parse_from_uri():
                                                          failed to
                                                          parse From uri
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          ERROR: pv
                                                          [pv_core.c:397]:
                                                          pv_get_xto_attr():
                                                          cannot parse
                                                          From URI
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          ERROR:
                                                          <core>
                                                          [parser/parse_from.c:113]:
                                                          parse_from_uri():
                                                          failed to
                                                          parse From uri
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          ERROR: pv
                                                          [pv_core.c:397]:
                                                          pv_get_xto_attr():
                                                          cannot parse
                                                          From URI
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          INFO:
                                                          <script>:
route:33:<null>:<null>:1.0.0.127:you:kamailio.org:<null>:<null>:<null>:<null>:<null>:<null>
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          INFO:
                                                          <script>:
route:33:OPTIONS:<null>:<null>:
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          ALERT:
                                                          <script>:
                                                          END
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          ERROR:
                                                          <core>
                                                          [parser/parse_from.c:113]:
                                                          parse_from_uri():
                                                          failed to
                                                          parse From uri
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          ERROR: pv
                                                          [pv_core.c:397]:
                                                          pv_get_xto_attr():
                                                          cannot parse
                                                          From URI
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          ERROR:
                                                          <core>
                                                          [parser/parse_from.c:113]:
                                                          parse_from_uri():
                                                          failed to
                                                          parse From uri
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          ERROR: pv
                                                          [pv_core.c:397]:
                                                          pv_get_xto_attr():
                                                          cannot parse
                                                          From URI
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          ALERT:
                                                          <script>:
END:<null>:<null>:1.0.0.127:you:kamailio.org:<null>:<null>:<null>:<null>:<null>:<null>
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6145]:
                                                          ALERT:
                                                          <script>:
END:OPTIONS:<null>:<null>:
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6121]:
                                                          WARNING:
                                                          dialog
                                                          [dlg_req_within.c:212]:
                                                          bye_reply_cb():
                                                          inconsitent
                                                          dlg timer data
                                                          on dlg
                                                          0x7feb2115d918
                                                          [3170:3953]
                                                          with clid
                                                          '<a class="moz-txt-link-abbreviated" href="mailto:2c5695c1644fa2b135f57ea72c590cc7@95.0.154.92:5060">2c5695c1644fa2b135f57ea72c590cc7@95.0.154.92:5060</a>'
                                                          and tags
                                                          'as3c7c5aa4'
                                                          'as0b640624'
                                                          <d iv="">Aug 
                                                          1 16:52:11
                                                          kamailio
                                                          /usr/local/sbin/kamailio[6121]:
                                                          ERROR: acc
                                                          [acc_cdr.c:574]:
                                                          cdr_on_end():
                                                          invalid
                                                          values#012!
                                                          <d iv="">
                                                          <d iv="">
                                                          <d iv="">
                                                          <d iv="">
                                                          <d iv="">
                                                          <d
                                                          style="FONT-SIZE:
                                                          12pt;
                                                          FONT-FAMILY:
                                                          'Calibri';
                                                          COLOR:
                                                          #000000" iv=""><img
                                                          title="BTLCRT"
                                                          style="BORDER-TOP:
                                                          0px;
                                                          BORDER-RIGHT:
                                                          0px;
                                                          BACKGROUND-IMAGE:
                                                          none;
                                                          BORDER-BOTTOM:
                                                          0px;
                                                          PADDING-TOP:
                                                          0px;
                                                          PADDING-LEFT:
                                                          0px;
                                                          BORDER-LEFT:
                                                          0px; DISPLAY:
                                                          inline;
                                                          PADDING-RIGHT:
                                                          0px"
                                                          alt="BTLCRT"
                                                          src="cid:part1.01020807.01050304@gmail.com"
                                                          border="0"
                                                          height="117"
                                                          width="302">
                                                          <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></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></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></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></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></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></pre>
  </body>
</html>