Hi Nandini, Try the following steps:
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. 2. Try to run the proc manually in the database. SQL>call opensips_cdrs_1_6(); This proc should be run each 3 minutes from cron daemon. 3. Check now if you have data in cdrs (select * from cdrs). If you still don't have any data in cdrs, please check the opensips logs for errors inserting data in the database. Best regards, Flavio E. Goncalves 2013/6/28 Nandini madhu <sermj2...@gmail.com> > Dear Flavio E. Goncalves, > > I have loaded opensips_cdrs.mysql and cdrs.mysql into mysql database. > And i rechecked the installation instructions as per opensips control > panel documentation. > Please have a glance on the list available in opensips database: > > mysql> show tables; (in opensips database) > +----------------------+ > | Tables_in_opensips | > +----------------------+ > | acc | > | active_watchers | > | address | > | aliases | > | carrierfailureroute | > | carrierroute | > | cdrs | > | cpl | > | dbaliases | > | dialog | > | dialplan | > | dispatcher | > | domain | > | domainpolicy | > | dr_carriers | > | dr_gateways | > | dr_groups | > | dr_rules | > | globalblacklist | > | grp | > | imc_members | > | imc_rooms | > | load_balancer | > | location | > | missed_calls | > | monitored_stats | > | monitoring_stats | > | ocp_admin_privileges | > | pdt | > | presentity | > | pua | > | re_grp | > | registrant | > | rls_presentity | > | rls_watchers | > | route_tree | > | rtpproxy_sockets | > | silo | > | sip_trace | > | speed_dial | > | subscriber | > | uri | > | userblacklist | > | usr_preferences | > | version | > | watchers | > | xcap | > +----------------------+ > 47 rows in set (0.00 sec) > > Tables from cdrs table from opensips database; > > mysql> show columns from cdrs; > > +-----------------+------------------+------+-----+---------------------+----------------+ > | Field | Type | Null | Key | Default | > Extra | > > +-----------------+------------------+------+-----+---------------------+----------------+ > | cdr_id | bigint(20) | NO | PRI | NULL | > auto_increment | > | call_start_time | datetime | NO | | 0000-00-00 00:00:00 > | | > | duration | int(10) unsigned | NO | | 0 > | | > | sip_call_id | varchar(128) | NO | | > | | > | sip_from_tag | varchar(128) | NO | | > | | > | sip_to_tag | varchar(128) | NO | | > | | > | created | datetime | NO | | 0000-00-00 00:00:00 > | | > > +-----------------+------------------+------+-----+---------------------+----------------+ > 7 rows in set (0.00 sec) > > Kindly please help me. > > > On Thu, Jun 27, 2013 at 3:53 PM, Flavio Goncalves > <fla...@voffice.com.br>wrote: > >> Hi Nandini, >> >> 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. >> >> Flavio E. Goncalves >> >> >> >> 2013/6/27 Nandini madhu <sermj2...@gmail.com> >> >>> Dear all. >>> >>> i have installed opensips server and open-sips control panel on my pc >>> successfully. >>> In user management ,i can see the clients listed,but when the clients >>> are registered,when we click on line users,its showing no data found. >>> In CDRviewer also its showing no data. >>> >>> please help me, >>> Thanks in advance >>> >>> _______________________________________________ >>> Users mailing list >>> Users@lists.opensips.org >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> >>> >> >> _______________________________________________ >> Users mailing list >> Users@lists.opensips.org >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > > _______________________________________________ > Users mailing list > Users@lists.opensips.org > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
