[OpenSIPS-Users] opensips control panel
Nandini madhu
sermj2012 at gmail.com
Thu Aug 8 07:19:41 CEST 2013
Dear Mike,
Greetings.
Thanks for the reply. i have checked the procedure and it is working fine
with bot acc and cdrs tables.
I am trying to look for the online users in opensips-cp 5.0. it is not
showing in user management while information is available by using
opensipsctl online command in terminal
Please help me
Regards
sermj
Thanks a lot. Can
On Wed, Aug 7, 2013 at 7:04 PM, Mike Tesliuk <mike at ultra.net.br> wrote:
> Nandini,
>
> If you have the INVITE and BYE on the acc table, the problem is just on
> the procedure, did you try to call the procedure manually as flavio suggest
> ? did you configure a cron job to run the procedure ?
>
>
> 2013/8/7 Nandini madhu <sermj2012 at gmail.com>
>
>> Hi Flavio,
>> Greetings.
>>
>> Hi Bodgan.
>> Greetings.
>>
>> I have seen some INVITES and BYES in my acc table. I have enabled
>> CDR_FLAG in my script and loaded the module too.
>>
>> But i am unable to get the data in cdrviewer.
>>
>> Please help me
>>
>> My script is as below:
>>
>> # main request routing logic
>>
>> route{
>> if (!mf_process_maxfwd_header("10")) {
>> sl_send_reply("483","Too Many Hops");
>> exit;
>> }
>>
>> if (has_totag()) {
>> # sequential requests within a dialog should
>> # take the path determined by record-routing
>> if (loose_route()) {
>> if (is_method("BYE")) {
>> *setflag(CDR_FLAG); # ... even if the transaction fails
>> create_dialog();
>> setflag(TRACE_FLAG);
>> setflag(DB_FLAG); # do accounting ...*
>> } else if (is_method("INVITE")) {
>> # even if in most of the cases is useless, do RR for
>> # re-INVITEs alos, as some buggy clients do change route
>> set
>> # during the dialog.
>> record_route();
>> }
>>
>> # route it out to whatever destination was set by
>> loose_route()
>> # in $du (destination URI).
>> route(relay);
>> } else {
>> if ( is_method("ACK") ) {
>> if ( t_check_trans() ) {
>> # non loose-route, but stateful ACK; must be an ACK
>> after
>> # a 487 or e.g. 404 from upstream server
>> t_relay();
>> exit;
>> } else {
>> # ACK without matching transaction ->
>> # ignore and discard
>> exit;
>> }
>> }
>> sl_send_reply("404","Not here");
>> }
>> exit;
>> }
>>
>> # CANCEL processing
>> if (is_method("CANCEL"))
>> {
>> if (t_check_trans())
>> t_relay();
>> exit;
>> }
>>
>> t_check_trans();
>>
>> if ( !(is_method("REGISTER") ) ) {
>> if (from_uri==myself)
>> {
>> } else {
>> # if caller is not local, then called number must be local
>> if (!uri==myself) {
>> send_reply("403","Rely forbidden");
>> exit;
>> }
>> }
>> }
>>
>> # preloaded route checking
>> if (loose_route()) {
>> xlog("L_ERR",
>> "Attempt to route with preloaded Route's [$fu/$tu/$ru/$ci]");
>> if (!is_method("ACK"))
>> sl_send_reply("403","Preload Route denied");
>> exit;
>> }
>>
>> # record routing
>> if (!is_method("REGISTER|MESSAGE"))
>> record_route();
>>
>> # account only INVITEs
>> if (is_method("INVITE")) {
>> *setflag(CDR_FLAG);
>> create_dialog();
>> setflag(TRACE_FLAG);
>> setflag(DB_FLAG); # do accounting ...
>> *
>> }
>>
>>
>> if (!uri==myself) {
>> append_hf("P-hint: outbound\r\n");
>> route(relay);
>> }
>>
>> # requests for my domain
>> if (is_method("PUBLISH|SUBSCRIBE"))
>> {
>> sl_send_reply("503", "Service Unavailable");
>> exit;
>> }
>>
>> if (is_method("REGISTER"))
>> {
>> if ( 0 ) setflag(TCP_PERSISTENT);
>>
>> if (!save("location"))
>> sl_reply_error();
>>
>> exit;
>> }
>>
>> if ($rU==NULL) {
>> # request with no Username in RURI
>> sl_send_reply("484","Address Incomplete");
>> exit;
>> }
>>
>> # do lookup with method filtering
>> if (!lookup("location","m")) {
>> t_newtran();
>>
>> t_reply("404", "Not Found");
>> exit;
>> }
>>
>> # when routing via usrloc, log the missed calls also
>> setflag(ACC_MISSED);
>> route(relay);
>> }
>>
>>
>> route[relay] {
>> # for INVITEs enable some additional helper routes
>> if (is_method("INVITE")) {
>> t_on_branch("per_branch_ops");
>> t_on_reply("handle_nat");
>> t_on_failure("missed_call");
>> }
>>
>> if (!t_relay()) {
>> send_reply("500","Internal Error");
>> };
>> exit;
>> }
>>
>>
>> branch_route[per_branch_ops] {
>> xlog("new branch at $ru\n");
>> }
>>
>>
>> onreply_route[handle_nat] {
>>
>> xlog("incoming reply\n");
>> }
>>
>>
>> failure_route[missed_call] {
>> if (t_was_cancelled()) {
>> exit;
>> }
>>
>> # uncomment the following lines if you want to block client
>> # redirect based on 3xx replies.
>> ##if (t_check_status("3[0-9][0-9]")) {
>> ##t_reply("404","Not found");
>> ## exit;
>> ##}
>>
>> }
>> Regards
>>
>> sermj
>>
>>
>> On Fri, Jun 28, 2013 at 4:59 PM, Flavio Goncalves <flavio at voffice.com.br>wrote:
>>
>>> 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 <sermj2012 at 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 <
>>>> flavio at 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 <sermj2012 at 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 at lists.opensips.org
>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>>
>>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Users mailing list
>>>>> Users at lists.opensips.org
>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>
>>>>>
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130808/d88e8ab7/attachment-0001.htm>
More information about the Users
mailing list