<div dir="ltr">Hi Nandini, <div><br></div><div>Try the following steps:</div><div><br></div><div>1. Make sure you have data in the ACC tables (select * from acc;). If you don't have data in your acc table you have problems in your opensips script.</div>
<div><br></div><div>2. Try to run the proc manually in the database. SQL>call opensips_cdrs_1_6();</div><div style>This proc should be run each 3 minutes from cron daemon. </div><div><br></div><div style>3. Check now if you have data in cdrs (select * from cdrs). </div>
<div style><br></div><div style>If you still don't have any data in cdrs, please check the opensips logs for errors inserting data in the database. </div><div style><br></div><div style>Best regards, </div><div><br></div>
<div>Flavio E. Goncalves<br></div><div class="gmail_extra"><div><div dir="ltr"><div><br></div></div></div>
<br><br><div class="gmail_quote">2013/6/28 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>Dear Flavio E. Goncalves,<br><br></div>I have loaded opensips_cdrs.mysql and cdrs.mysql into mysql database. <br></div>And i rechecked the installation instructions as per opensips control panel documentation.<br>
</div>Please have a glance on the list available in opensips database:<br><div><br>mysql> show tables; (in opensips database)<br>+----------------------+<br>| Tables_in_opensips |<br>+----------------------+<br>| acc |<br>
| active_watchers |<br>| address |<br>| aliases |<br>| carrierfailureroute |<br>| carrierroute |<br>| cdrs |<br>| cpl |<br>| dbaliases |<br>
| dialog |<br>| dialplan |<br>| dispatcher |<br>| domain |<br>| domainpolicy |<br>| dr_carriers |<br>| dr_gateways |<br>| dr_groups |<br>
| dr_rules |<br>| globalblacklist |<br>| grp |<br>| imc_members |<br>| imc_rooms |<br>| load_balancer |<br>| location |<br>| missed_calls |<br>
| monitored_stats |<br>| monitoring_stats |<br>| ocp_admin_privileges |<br>| pdt |<br>| presentity |<br>| pua |<br>| re_grp |<br>| registrant |<br>
| rls_presentity |<br>| rls_watchers |<br>| route_tree |<br>| rtpproxy_sockets |<br>| silo |<br>| sip_trace |<br>| speed_dial |<br>| subscriber |<br>
| uri |<br>| userblacklist |<br>| usr_preferences |<br>| version |<br>| watchers |<br>| xcap |<br>+----------------------+<br>47 rows in set (0.00 sec)<br>
<br></div><div>Tables from cdrs table from opensips database;<br><br>mysql> show columns from cdrs;<br>+-----------------+------------------+------+-----+---------------------+----------------+<br>| Field | Type | Null | Key | Default | Extra |<br>
+-----------------+------------------+------+-----+---------------------+----------------+<br>| cdr_id | bigint(20) | NO | PRI | NULL | auto_increment |<br>| call_start_time | datetime | NO | | 0000-00-00 00:00:00 | |<br>
| duration | int(10) unsigned | NO | | 0 | |<br>| sip_call_id | varchar(128) | NO | | | |<br>| sip_from_tag | varchar(128) | NO | | | |<br>
| sip_to_tag | varchar(128) | NO | | | |<br>| created | datetime | NO | | 0000-00-00 00:00:00 | |<br>+-----------------+------------------+------+-----+---------------------+----------------+<br>
7 rows in set (0.00 sec)<br><br></div><div>Kindly please help me.<br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Jun 27, 2013 at 3:53 PM, Flavio Goncalves <span dir="ltr"><<a href="mailto:flavio@voffice.com.br" target="_blank">flavio@voffice.com.br</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 Nandini, <div><br></div><div>There is a mysql stored procedure call to calculate the duration of the calls. There are some files at the tool subdirectory. /var/www/opensips=cp/config/tools/system/cdr (if I'm remembering correctly). There is a sql file with a procedure to import to mysql (or postgresql) and a shell script to call the procedure from cron. Please, check again the installation instructions. </div>
<div><br></div><div>Flavio E. Goncalves</div><div class="gmail_extra"><div><div dir="ltr"><div><br></div></div></div>
<br><br><div class="gmail_quote">2013/6/27 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><div>
<div dir="ltr"><div><div><div><div><div><div>Dear all.<br><br></div> i have installed opensips server and open-sips control panel on my pc successfully.<br></div> In user management ,i can see the clients listed,but when the clients<br>
</div>are registered,when we click on line users,its showing no data found.<br></div>In CDRviewer also its showing no data.<br><br></div>please help me,<br></div>Thanks in advance</div>
<br></div></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></div></blockquote></div><br></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></div>