<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>