<div dir="ltr"><div>Hello Bogdan,<br><br></div>I'm using below script for opensips.<br><div><br><span style="color:rgb(0,0,255)">#### ACCounting module<br>loadmodule "acc.so"<br>modparam("acc", "db_table_acc", "acc")<br>/* what special events should be accounted ? */<br>modparam("acc", "early_media", 0)<br>modparam("acc", "report_cancels", 0)<br><br>/* by default we do not adjust the direct of the sequential requests.<br>   if you enable this parameter, be sure the enable "append_fromtag"<br>   in "rr" module */<br>modparam("acc", "detect_direction", 0)<br>modparam("acc", "db_url", "mysql://root:W7nS0kdbd4@localhost/opensips") # CUSTOMIZE ME<br>modparam("acc", "acc_method_column", "method")<br><br><br><br>#### UDP protocol<br>loadmodule "proto_udp.so"<br><br>####### Routing Logic ########<br><br># main request routing logic<br><br>route{<br>    if (!mf_process_maxfwd_header("10")) {<br>        sl_send_reply("483","Too Many Hops");<br>        exit;<br>    }<br>force_rport();<br>       <br>    if (has_totag()) {<br>        # sequential requests within a dialog should<br>        # take the path determined by record-routing<br>        if (loose_route()) {<br>            <br>            if (is_method("BYE")) {<br>                # do accunting, even if the transaction fails<br>                do_accounting("log","failed");<br>                 do_accounting("db","missed","acc");<br>            } else if (is_method("INVITE")) {<br>                do_accounting("db","cdr","acc");<br>                # even if in most of the cases is useless, do RR for<br>                # re-INVITEs alos, as some buggy clients do change route set<br>                # during the dialog.<br>                record_route();<br><br>            } else if ( is_method("ACK") ) {<br><br>do_accounting("db","missed","acc");<br>}<br><br><br>            # route it out to whatever destination was set by loose_route()<br>            # in $du (destination URI).<br>            route(relay);<br>        } else {<br>            <br>            if ( is_method("ACK") ) { <br>do_accounting("db","missed","acc");<br>                if ( t_check_trans() ) {<br>                    # non loose-route, but stateful ACK; must be an ACK after <br>                    # a 487 or e.g. 404 from upstream server<br>                    t_relay();<br>                    exit;<br>                } else {<br>                    # ACK without matching transaction -><br>                    # ignore and discard<br>                    exit;<br>                }<br>            }<br>            sl_send_reply("404","Not here");<br>        }<br>        exit;<br>    }</span><br><br></div><div>Please correct me if there is any issue  in script.</div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Sep 26, 2017 at 10:14 PM, Bogdan-Andrei Iancu <span dir="ltr"><<a href="mailto:bogdan@opensips.org" target="_blank">bogdan@opensips.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
  
    
  
  <div bgcolor="#FFFFFF" text="#000000">
    <tt>Hi,<br>
      <br>
      If you do not have any records in DB, it means OpenSIPS is not
      generating any acc data. Assuming you have ongoing calls, what is
      the way you trigger the accounting in your OpenSIPS script ?<br>
      <br>
      Best regards,<br>
    </tt>
    <pre class="m_8041286673913526759moz-signature" cols="72">Bogdan-Andrei Iancu
  OpenSIPS Founder and Developer
  <a class="m_8041286673913526759moz-txt-link-freetext" href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<wbr>com</a>
</pre><div><div class="h5">
    <div class="m_8041286673913526759moz-cite-prefix">On 09/26/2017 12:53 PM, Ketan Kothari
      wrote:<br>
    </div>
    <blockquote type="cite">
      <div dir="ltr">
        <div>
          <div>
            <div>
              <div>Hello Khalil,<br>
                <br>
              </div>
              Thanks for your response.<br>
              <br>
            </div>
            I have checked in database there no records of calls.<br>
          </div>
          I'm using opensips 2.3.1 is there any document or sample of
          opensips.cfg for accounting.<br>
          <br>
           <a href="http://www.opensips.org/Documentation/Tutorials-Advanced-Accounting" target="_blank">http://www.opensips.org/Docum<wbr>entation/Tutorials-Advanced-<wbr>Accounting</a>
          i have checked this link is last modified at November 03, 2016
          before opensips 2.3.1 release.<br>
          <br>
        </div>
        So please suggest me if any doc available for newly version.<br>
        <div><br>
          <br>
        </div>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">On Tue, Sep 26, 2017 at 3:11 PM, Khalil
          Khamlichi <span dir="ltr"><<a href="mailto:khamlichi.khalil@gmail.com" target="_blank">khamlichi.khalil@gmail.com</a>></span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <div dir="ltr">Hi,
              <div><br>
              </div>
              <div>honestly, I never used the opensips GUI, but I think
                you need first check the database tables ; acc and
                missed_calls and and see if there are any records in
                there. then you could activate logging on mysql and see
                what queries are being run when you click that button,
                then third step you need to check apache/php logs there
                must be an error or an indication in there. if no luck
                you surely just need to re-read this <a href="http://www.opensips.org/Documentation/Tutorials-Advanced-Accounting" target="_blank">http://www.opensips.org/D<wbr>ocumentation/Tutorials-Advance<wbr>d-Accounting</a>
                , it explains everything, you have noway to get lost if
                you just read carefully.</div>
              <div><br>
              </div>
              <div>hope this helps.</div>
              <div><br>
              </div>
              <div>kkh</div>
              <div><br>
              </div>
            </div>
            <div class="gmail_extra"><br>
              <div class="gmail_quote">
                <div>
                  <div class="m_8041286673913526759h5">On Tue, Sep 26, 2017 at 11:26 AM,
                    Ketan Kothari <span dir="ltr"><<a href="mailto:kkothari157@gmail.com" target="_blank">kkothari157@gmail.com</a>></span>
                    wrote:<br>
                  </div>
                </div>
                <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                  <div>
                    <div class="m_8041286673913526759h5">
                      <div dir="ltr">
                        <div>Hello Guys,<br>
                          <br>
                        </div>
                        Is there any suggestion on this issue?<br>
                      </div>
                      <div class="m_8041286673913526759m_444678084409667863HOEnZb">
                        <div class="m_8041286673913526759m_444678084409667863h5">
                          <div class="gmail_extra"><br>
                            <div class="gmail_quote">On Fri, Sep 22,
                              2017 at 3:21 PM, Ketan Kothari <span dir="ltr"><<a href="mailto:kkothari157@gmail.com" target="_blank">kkothari157@gmail.com</a>></span>
                              wrote:<br>
                              <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
                                <div dir="ltr">
                                  <div>
                                    <div>Hello Guy,<br>
                                      <br>
                                    </div>
                                    I'm using opensips 2.3.1 and when i
                                    click on system --> <b>CDRviewer</b>
                                    its showing <b>"no data found</b>".<br>
                                  </div>
                                  Is there any suggestion to resolve
                                  this issue?<br>
                                  <div>
                                    <div>
                                      <div>
                                        <div><br>
                                          <img src="cid:part6.DEAC7F09.C9539B9D@opensips.org" alt="Inline image 1" width="478" height="192"></div>
                                        <div><br>
                                        </div>
                                        <div>my <b>opensips.cfg</b>
                                          file :<a href="https://pastebin.com/jFP8xxRF" target="_blank">https://pastebin.com/jFP8xxRF</a><br>
                                        </div>
                                      </div>
                                    </div>
                                  </div>
                                </div>
                              </blockquote>
                            </div>
                            <br>
                          </div>
                        </div>
                      </div>
                      <br>
                    </div>
                  </div>
                  ______________________________<wbr>_________________<br>
                  Users mailing list<br>
                  <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
                  <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-<wbr>bin/mailman/listinfo/users</a><br>
                  <br>
                </blockquote>
              </div>
              <br>
            </div>
            <br>
            ______________________________<wbr>_________________<br>
            Users mailing list<br>
            <a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
            <a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-<wbr>bin/mailman/listinfo/users</a><br>
            <br>
          </blockquote>
        </div>
        <br>
      </div>
      <br>
      <fieldset class="m_8041286673913526759mimeAttachmentHeader"></fieldset>
      <br>
      <pre>______________________________<wbr>_________________
Users mailing list
<a class="m_8041286673913526759moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a class="m_8041286673913526759moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-<wbr>bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <br>
  </div></div></div>

</blockquote></div><br></div>