<div dir="ltr"><div>The CDR module from opensips-cp use the table cdrs, the acc module use the table acc , the opensips-cp use a procedure on mysql to get the information from acc and generate the data on cdrs, this happen through a cron script .<br>
<br></div>you need to generate the accounting to your INVITE too, becuase the procedore check the INVITE and BYE status on the acc table.<br><br><br><br><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">
2013/8/1 Nandini madhu <span dir="ltr"><<a href="mailto:sermj2012@gmail.com" target="_blank">sermj2012@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div><div><div>Dear Shahzad,<br></div>Greetings.<br><br></div>Thanks for the input i will try as per your suggestions and get back to you.<br><br></div>Regards,<br></div>sermj<br></div><div class="HOEnZb">
<div class="h5"><div class="gmail_extra">
<br><br><div class="gmail_quote">On Wed, Jul 31, 2013 at 8:55 PM, Muhammad Shahzad <span dir="ltr"><<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@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>The acc module params are missing flags for db, you only have flags for logging, which actually logs acc data to syslog, also note that flags MUST be quoted strings as integer flags have been deprecated in opensips 1.9.x. See below link for details,<br>
<br><a href="http://www.opensips.org/html/docs/modules/1.9.x/acc.html#id293425" target="_blank">http://www.opensips.org/html/docs/modules/1.9.x/acc.html#id293425</a><br><br></div><div>Thank you.<br><br></div><div><br><br>
</div></div><div><div><div class="gmail_extra">
<br><br><div class="gmail_quote">On Wed, Jul 31, 2013 at 12:07 PM, Nandini madhu <span dir="ltr"><<a href="mailto:sermj2012@gmail.com" target="_blank">sermj2012@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><div><div>Dear Shahzad,<br><br></div>I have tried the above options to know the status. But still i am facing the same problem.<br><br></div>I am giving my acc module configuration list please have a glance and advice me please.<br>
<br>loadmodule "acc.so"<br>modparam("acc", "failed_transaction_flag", 1)<br>modparam("acc", "report_cancels", 0)<br>##modparam("acc", "report_ack", 0)<br>
modparam("acc", "early_media", 0)<br>modparam("acc", "log_level", 1)<br>modparam("acc", "log_flag", 1)<br>modparam("acc", "log_missed_flag", 1)<br>
modparam("acc", "cdr_flag", 1)<br>modparam("acc", "db_url", "mysql://opensips:opensipsrw@opensips/opensips")<br>modparam("acc", "db_table_acc", "acc")<br>
modparam("acc", "acc_method_column", "method")<br>modparam("acc", "acc_from_tag_column", "from_tag")<br>modparam("acc", "acc_to_tag_column", "to_tag")<br>
modparam("acc", "acc_callid_column", "callid")<br>modparam("acc", "acc_sip_code_column", "sip_code")<br>modparam("acc", "acc_sip_reason_column", "sip_reason")<br>
modparam("acc", "acc_time_column", "time")<br><br></div><div>i have given super privileges to opensips user in mysql database<br></div><div><br></div><div>Please advice<br></div><div><br></div>
regards<br></div>sermj<br></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jul 31, 2013 at 1:09 PM, Nandini madhu <span dir="ltr"><<a href="mailto:sermj2012@gmail.com" target="_blank">sermj2012@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>Dear <span name="Muhammad Shahzad">Shahzad,<br><br></span></div><span name="Muhammad Shahzad">Thank you for your prompt response. i will follow your suggestions and let you know thank you.<br>
<br></span></div><span name="Muhammad Shahzad">regards <br>sermj<br></span></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Jul 31, 2013 at 11:48 AM, Muhammad Shahzad <span dir="ltr"><<a href="mailto:shaheryarkh@gmail.com" target="_blank">shaheryarkh@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><div>Check if,<br><br></div>1. you have set required module parameters for acc module as well, most importantly accounting flags.<br>
</div>2. you have set those accounting flags in appropriate routes in opensips.cfg.<br>
</div>3. you acc table is accessible and permitted for opensips (check connection string, the user used in it is allowed to insert rows in acc table etc).<br><div><div><div>4. you can connect to mysql or whatever backend you are using, and see acc table is being populated by opensips during / end of calls.<br>
</div><div>5. your opensips-cp has correct db connection string set to access acc table.<br></div><div><br></div><div>one of above should solve your problem.<br><br></div><div>Thank you.<br><br></div><div><br></div></div>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote"><div><div>On Wed, Jul 31, 2013 at 8:06 AM, Nandini madhu <span dir="ltr"><<a href="mailto:sermj2012@gmail.com" target="_blank">sermj2012@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><div dir="ltr"><div><div><div><div><div>Hi all,<br><br></div>I am using opensips-cp 5.0 . domain andrtpproxy modules are working fine on myserver (opensips-1.9.1-tls). But i am unable to see CDRviewer in my GUI.<br>
<br></div>
I hav loaded required acc module parameters in opensips.cfg file.<br><br></div>Please help me<br><br></div>Regards,<br></div>sermj<br></div>
<br></div></div>_______________________________________________<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" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><span><font color="#888888"><br><br clear="all"><br>-- <br><div><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Mit freundlichen Grüßen</span></div><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">------------------------------</span><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">-----</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Cell: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85</a></span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shaheryarkh@googlemail.com</a>
</font></span></div>
<br>_______________________________________________<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" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>
</div></div></blockquote></div><br></div>
</div></div><br>_______________________________________________<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" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Mit freundlichen Grüßen</span></div><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Muhammad Shahzad</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">------------------------------</span><span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">-----</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Rich Media Communication Specialist (CRMCS)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">CISCO Certified Network Associate (CCNA)</span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Cell: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85</a></span><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">MSN: </span><a href="mailto:shari_786pk@hotmail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shari_786pk@hotmail.com</a><br style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">
<span style="color:rgb(136,136,136);font-size:13px;font-family:arial,sans-serif">Email: </span><a href="mailto:shaheryarkh@googlemail.com" style="color:rgb(17,85,204);font-size:13px;font-family:arial,sans-serif" target="_blank">shaheryarkh@googlemail.com</a>
</div>
</div></div><br>_______________________________________________<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" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>